[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)
[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,
# 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.
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...
Last edited by Tarry; 12-30-2003 at 01:33 PM.
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
[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
[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.
)
Reply With Quote
Bookmarks