Installing Oracle 9iR2 on Redhat 9 Part I

**Tarry** · 12-28-2003, 07:22 PM

Part I

Ok people so here goes...

Pre-Installation Checks
_____________________

[1] OS : Redhat 9 (latest updated version from the RHN, _27.9)
[2] Software : Oracle 9iR2 database from otn.oracle.com. Go to downloads and download it.(to preferably /tmp directory, make sure you have enough space in it as you will be copying/and unzipping it to your local HDA)

[3] Make sure you have enough hard disk space. (I'll say keep it 5 G just in case, although 3.5G in ok).

[4] Powerful machine? I don't know about tht. I have a chevo laptop 40G diskspace(RH9 uses 10G), 1G mem, 600MB swap space. So I am way above the specs. but a min of 500mb swap space. Oracle recommends a swap partition of either 400 megabytes or twice the amount of your RAM, whichever is greater.
[5] Oracle is not certified to run on Redhat 9 so I assume you're doing all that for development/curiosity/learning(I'm doing it to learn linux better heh

)

So we're ready to go?

Step 1:(I've also carried out steps in different orders, yep I know, it ain't windoos, you can do things in varienty of ways)

Make users and Groups(These at a minimum, I've seen more groups being made)

Code:

[root@cc345772-a root]# groupadd dba
[root@cc345772-a root]# groupadd oinstall
[root@cc345772-a root]# useradd -g oinstall -G dba oracle
[root@cc345772-a root]# passwd oracle

here you'll be prompted for a pwd, punch it twice in and you're done with this part.

Step 2 : Creating directories, I want to go the OFA way so I made 6 directories, just doing it by the book

Code:

[root@cc345772-a root]# mkdir /u01 /u02 /u03 /u04 /u05 /u06
[root@cc345772-a root]# chown oracle.dba /u01 /u02 /u03 /u04 /u05 /u06
[root@cc345772-a root]# chmod 775 /u01 /u02 /u03 /u04 /u05 /u06
[root@cc345772-a root]#

Step 3 : Downloading/Unzipping etc

OK If you haven't downloaded oracle 9iR2 do so from the oracle website http://otn.oracle.com/software/produ...linuxsoft.html

[root@cc345772-a root]# cd /tmp/9i
[root@cc345772-a 9i]# -- Here I've created new directory and gave oracle user as well all the rights(you might encounter errors when you start installation while logged on as
user oracle , linking of files gave me errors at the end of it)

This way you avoid the gunzip/ then cpio command. in one go,

Code:

[root@cc345772-a 9i]# zcat lnx_920_disk1.cpio.gz | cpio -idmv
[root@cc345772-a 9i]# zcat lnx_920_disk2.cpio.gz | cpio -idmv
[root@cc345772-a 9i]# zcat lnx_920_disk3.cpio.gz | cpio -idmv

Or gunzip it,

Code:

gunzip lnx_920_disk1.cpio.gz lnx_920_disk2.cpio.gz lnx_920_disk3.cpio.gz 

# and then unpack it...

cpio -idmv < lnx_920_disk1.cpio
cpio -idmv < lnx_920_disk2.cpio 
cpio -idmv < lnx_920_disk3.cpio

Then you have Disk1, Disk2 and Disk3 respectively ready for you.(Which ever way you chose).

Step4: Tools and Libraries for backward compatibility?

Well I've seen people suggesting this for backward compatibility.

Code:

gcc-3.2.2-5
cpp-3.2.2-5
glibc-devel-2.3.2-11.9
binutils-2.13.90.0.18-9
compat-gcc-7.3-2.96.118.i386.rpm
compat-libgcj-7.3-2.96.118.i386.rpm
compat-libgcj-devel-7.3-2.96.118.i386.rpm
nss_db-compat-2.2-20.i386.rpm

I did this to check what I have on my hand...

Code:

[root@cc345772-a root]# rpm -q gcc cpp compat-libstdc++ glibc-devel kernel-headers binutils
gcc-3.2.2-5
cpp-3.2.2-5
compat-libstdc++-7.3-2.96.118
glibc-devel-2.3.2-27.9.7
package kernel-headers is not installed
binutils-2.13.90.0.18-9
[root@cc345772-a root]#

As you can see I don't have it all but it didn't make much of a difference with the installation.

Anyways check it up and you can always install them if you don't have it from your shrike disk3. With redhat 9 you can do it withthe GUI.

Start menu->System Settings->Add/Remove Applications, or from the command line, using:

rpm -Uvh

Step5: Tuning kernel parameters

Append these to the /etc/sysctl.conf...

Code:

kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.sem    = 250 32000 100 128
fs.file-max   = 65536
net.ipv4.ip_local_port_range = 1024 65000

And

append these lines to /etc/security/limits.conf

Code:

oracle soft nofile 65536
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384

Then you can reboot to let the changes take effect , If you can't then do this to change kernel parameters at runtime...

Code:

[root@cc345772-a root]# echo 250 32000 100 128 > /proc/sys/kernel/sem
[root@cc345772-a root]# echo 536870912 > /proc/sys/kernel/shmmax
[root@cc345772-a root]# echo 4096 > /proc/sys/kernel/shmmni
[root@cc345772-a root]# echo 2097152 > /proc/sys/kernel/shmall
[root@cc345772-a root]# echo 65536 > /proc/sys/fs/file-max
[root@cc345772-a root]# echo 1024 65000 > /proc/sys/net/ipv4/ip_local_port_range

Step6: Setting up env variables for user oracle

Now login as oracle user

su - oracle

append these lines to the .bash_profile

Code:

# oracle 9i
export ORACLE_BASE=/u01/ora92 -- your file locations
export ORACLE_HOME=/u01/ora92/product/9.2 
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH
# -- NO NEED TO DO ANY OF THE JRE/JDK(more on that later)
export ORACLE_OWNER=oracle
export ORACLE_SID=nick920 
# -- Your own sid
export ORACLE_TERM=xterm

# Use old Linuxthreads with floating stacks instead of
# the new Native POSIX Thread Library (NPTL)
export LD_ASSUME_KERNEL=2.4.1
export THREADS_FLAG=native

# Edit paths
export LD_LIBRARY_PATH=/opt/ora9/product/9.2/lib:$LD_LIBRARY_PATH
export PATH=/opt/ora9/product/9.2/bin:$PATH
export SQLPATH=$ORACLE_HOME/dbs

#
# change this NLS settings to suit your country:
# example:
# german_germany.we8iso8859p15, american_america.we8iso8859p2 etc.
# BTW you don't need to append it wth the .we8iso8859p2, if you're not sure, otherwise you may get trouble while creating the db or even logging into sqlplus etc.(if you
export NLS_LANG='american_america'

Step7: You can set up temporary swap space logged is as ROOT.

Code:

% dd if=/dev/zero of=tmp_swap bs=1k count=900000
% chmod 600 tmp_swap
% mkswap tmp_swap
% swapon tmp_swap

And then free it (I didn't need it as I had enough of it)

Code:

% swapoff tmp_swap
% rm tmp_swap

log off as oracle user to let the env variables take effect.

Check then after logging as...

Code:

[oracle@cc345772-a oracle]$ env | grep ORACLE
ORACLE_OWNER=oracle
ORACLE_SID=nick920
ORACLE_BASE=/u01/ora92
ORACLE_TERM=xterm
ORACLE_HOME=/u01/ora92/product/9.2
[oracle@cc345772-a oracle]$

PS: About the JDK/JRE , there is no need to install it seperately as oracle has it's own jre , unless you want to setup the startup of listener, database(s), agent, http server,
you might want to download a rpm from http://www.gurulabs.com/downloads.We'll come to that later. For dbca, oemapp(enterprize manager stuff like that), I'll say, NO NEED.

Oracle installer must run from X and in order to let oracle user to be able to write to X do...

Code:

$ xhost +127.0.0.1

(Again I didn't do it as I am doing it from X)

Continued on Part II...

**Tarry** · 12-29-2003, 02:01 AM

INSTALLATION
______________

Well it's not really a big deal.

[1] This command $ /tmp/9i/Disk1/runInstaller
will open up the OUI(Oracle Universal Installer)

[2] Next It will ask for orainvertory location, and that will be the one you chose in your .bash_profile.

[3] Next Unix group type in 'oinstall'

[4] Next you'll be prompted to run orainstRoot.sh from the terminal logged on as root. Do it.

PS: A small note/tip here, I always open two terminal sessions, one as oracle and other as root, this way I can carry out scripts as the user needed by the installer.
tick in exactly as the message says it, sometimes you end up doing a orainstroot.sh(watch out for case sensitivity)
for example : [root@cc345772-a root]# /tmp/orainstRoot.sh
Then after succesfully running the script, click continue to close hte dialog box.

[5] File location will be suggested by the installer, should be A OK. If you also choose for DBCA it's no problem ,some say don't do it. I've done it without problems. BUT before
you reach this stage of creating database you'll run into two errors.

Error 1: ins_oemagent.mk
click ignore(will be dealt with later)

Error 2: Error in invoking target install of makefile $ORACLE_HOME/ctx/lib/ins_ctx.mk -- Check out hte attachment below.
When this comes open up the terminal as user ORACLE

Code:

[oracle@cc345772-a oracle]$ cd $ORACLE_HOME/install
[oracle@cc345772-a install]$ tail make.log

And then copy this line...

Code:

gcc -o ctxhx -L/opt/ora9/product/9.2/ctx/lib/ -L/opt/ora9/product/9.2/lib/
-L/opt/ora9/product/9.2/lib/stubs/  /opt/ora9/product/9.2/ctx/lib/ctxhx.o
-L/opt/ora9/product/9.2/ctx/lib/ -lm -lsc_ca -lsc_fa -lsc_ex -lsc_da -lsc_ut
-lsc_ch -lsc_fi -lctxhx -lc -Wl,-rpath,/opt/ora9/product/9.2/ctx/lib -lnls9
-lcore9 -lnls9 -lcore9 -lnls9 -lxml9 -lcore9 -lunls9 -lnls9

and append -ldl to it, like this

Code:

gcc -o ctxhx -L/opt/ora9/product/9.2/ctx/lib/ -L/opt/ora9/product/9.2/lib/
-L/opt/ora9/product/9.2/lib/stubs/  /opt/ora9/product/9.2/ctx/lib/ctxhx.o
-L/opt/ora9/product/9.2/ctx/lib/ -lm -lsc_ca -lsc_fa -lsc_ex -lsc_da -lsc_ut
-lsc_ch -lsc_fi -lctxhx -lc -Wl,-rpath,/opt/ora9/product/9.2/ctx/lib -lnls9
-lcore9 -lnls9 -lcore9 -lnls9 -lxml9 -lcore9 -lunls9 -lnls9 -ldl

and run it in $ORACLE_HOME/bin

Code:

[oracle@cc345772-a install]$ cd
[oracle@cc345772-a oracle]$ cd $ORACLE_HOME/bin
[oracle@cc345772-a bin]$

then click ignore on the second error and carry on with the installation.

[6] You can like I said carry on with the DB creation.

POST INSTALLATION
____________________

[1] Fixing the ins_ctx.mk issue and starting the agent.

Code:

[oracle@cc345772-a oracle]$ cd $ORACLE_HOME/network/lib
[oracle@cc345772-a lib]$ make -f ins_net_client.mk install

Now go on and edit the $ORACLE_HOME/ctx/lib/ins_ctx.mk file. Change lines 13-14 from:

Code:

ctxhx: $(CTXHXOBJ)
$(LINK) $(CTXHXOBJ) $(INSO_LINK)

to

Code:

ctxhx: $(CTXHXOBJ)
$(LINK) -ldl $(CTXHXOBJ) $(INSO_LINK)

and then do

Code:

[oracle@cc345772-a lib]$ make -f $ORACLE_HOME/ctx/lib/ins_ctx.mk install

[2] Well that's just about it. You can go on and start your listener/database or create your database using dbca from command line.

To start EM do

[oracle@cc345772-a oracle]$ oemapp console

starting up listener/database...

Code:

[oracle@cc345772-a oracle]$ lsnrctl start
 
LSNRCTL for Linux: Version 9.2.0.1.0 - Production on 29-DEC-2003 00:14:19
 
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.
 
Starting /u01/ora92/product/9.2/bin/tnslsnr: please wait...
 
TNSLSNR for Linux: Version 9.2.0.1.0 - Production
System parameter file is /u01/ora92/product/9.2/network/admin/listener.ora
Log messages written to /u01/ora92/product/9.2/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cc345772-a)(PORT=1521)))
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 9.2.0.1.0 - Production
Start Date                29-DEC-2003 00:14:19
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /u01/ora92/product/9.2/network/admin/listener.ora
Listener Log File         /u01/ora92/product/9.2/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cc345772-a)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "nick920" has 1 instance(s).
  Instance "nick920", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully


[oracle@cc345772-a oracle]$ sqlplus
 
SQL*Plus: Release 9.2.0.1.0 - Production on Mon Dec 29 00:14:49 2003
 
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
 
Enter user-name: tarry as sysdba
Enter password:
Connected to an idle instance.
 
tarry
tarry> startup
ORACLE instance started.
 
Total System Global Area  235999352 bytes
Fixed Size                   450680 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Database mounted.
Database opened.
tarry>

[3] Automatically starting/shutting down db and other services simultaneosly, down load the Oracle 9i RHL run pkg from http://www.gurulabs.com/downloads.html
I haven't tried the one form the oracle doco's script. Some say it does not work wel but anyways you gotta try and then see for yourself.

Check these out as well...
[1] Installing Linux : http://www.redhat.com/docs/manuals/l...install-guide/
[2] Installing Oracle/Linux, Errors etc: http://www.puschitz.com/InstallingOracle9i.shtml
[3] http://metalink.oracle.com/oracleins...unix.html#Uoui
[4] http://www.gurulabs.com/

Cheers...

Tarry

**pando** · 12-31-2003, 10:07 AM

printed version

http://www.dizwell.com/pdfs/oracleonlinux.pdf

Thread: Installing Oracle 9iR2 on Redhat 9 Part I

Thread Tools

Display

Installing Oracle 9iR2 on Redhat 9

Part II

Posting Permissions