Red Hat

Hi all,

I need to install Oracle on Linux. Presently, I am dumb about Oracle. I am just aware of basic sql queries.

I want to learn Oracle Administration. I am using RHEL 5.

I have few questions :--

1) Which Oracle version should I install and
and from where ?

2) Is there any difference in working of Oracle in Linux or Solaris.
If yes, which one should be better to learn focusing job prospects.

3) What is the difference between Oracle DBA and Oracle Application DBA ?

4) Which certification / course would be beneficial to go hand-in-hand with System Administration and Shell Scripts.

Pls HELP !!!

Thanks in adv.
VIKAS

Hi VIKAS,
just a few comments:

1. You can download the software from OTN (Oracle Technology Network). You can start learning with the latest release.

2. There are no important differences as far as beginner is concerned.

3. An Oracle Applications DBA is an Oracle DBA plus much more.

4. Oracle Database 10g: Managing Oracle on Linux for DBAs .

Hi radoulov,

Can I download Welcome to Oracle.com online services

for Intel machines. I am just confirming because it is 1.7 GB. I dont want to regret after downloading it.


Also, Is this the correct procedure

http://download.oracle.com/docs/cd/B...111/b32281.pdf


Pls suggest.


Thanks.

That's the correct one for 32bit architectures and the installation guide is the right one.

11gR1 is certified with Red Hat Enterprise AS/ES 5.

Thanks a lot Radoulov ,

Will get back to you once I download and install it.

Thanks again.

Hi Radoulov,

I followed all the steps exactly as mentioned in the pdf. I edited /etc/profile as given in Pg 13 of pdf, BUT when I am switching to user "oracle", it is giving some error But still I am able to login as oracle.
I could not understand this. Pls suggest.

These are the logs

Code:

[root@RHEL ~]# su - oracle
-bash: ulimit: pipe size: cannot modify limit: Invalid argument
[oracle@RHEL ~]$ id
uid=500(oracle) gid=500(oinstall) groups=500(oinstall),501(dba)
[oracle@RHEL ~]$

These are the lines which I added :

Code:

[root@RHEL ~]# tail -10 /etc/profile
if [ $USER = "oracle" ]; then
        if [ $SHELL = "/bin/bash" ]; then
                ulimit -p 16384
                ulimit -n 65536
        else
                ulimit -u 16384 -n 65536
        fi
fi
[root@RHEL ~]#

Thanks in adv.
VIKAS

Try changing:

Code:

ulimit -p 16384

to:

Code:

ulimit -u 16384