Download Oracle on Linux RHEL5 ??

Linux and Unix-Like Red Hat
1

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

2

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 .

3

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

Pls suggest.

Thanks.

4

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.

5

Thanks a lot Radoulov ,

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

Thanks again.

6

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

[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 :

[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

7

Try changing:

ulimit -p 16384

to:

ulimit -u 16384
8

Hey, it worked. Thanks mate.

Could you please explain a bit, so that I can take care of that in future.

Also, I hope this will not hamper functioning of Oracle Database.

Regards,
VIKAS

9

The documentations says:

if [ $USER = "oracle" ]; then
  if [ $SHELL = "/bin/ksh" ]; then
    ulimit -p 16384
    ulimit -n 65536
  else
    ulimit -u 16384 -n 65536
  fi
fi

It's ksh, not bash (I guess in some ksh implementations -p means number of processes). In bash it's the -u option.

10

Fine, got it. Thanks a million.