Installing Oracle 9iR2 on Redhat 9 Part I

[Tarry]

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

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

And then copy this line...

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

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

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

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

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

to

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

and then do

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

[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