Install Oracle9i Database on Red Hat Linux 9

This article is published on the Oracle website, which is called a descriptive discussion about the installation of Oracle9i database.

Author: Abhijeet Kulkarni

Database Version: oracle9i R2 (9.2.0.1.0)

1. Create users and groups:
-------------------------
Switch to the root user and execute the following commands

$ Su-

# Groupadd oinstall
# Groupadd DBA
# Useradd-G oinstall-g dba Oracle
# Passwd Oracle

2. Create a directory.
--------------------------
We will install everything in the/opt/ora9 directory:

# Mkdir-P/opt/ora9/product/9.2
# Mkdir/var/opt/Oracle
# Chown oracle. DBA/var/opt/Oracle
# Chown-r oracle. DBA/opt/ora9

3. Pre-installation (system configuration ):
---------------------------

3.1 install these compatibility libraries:

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

You can find these packages on the installation CD.
The first file is in the RedHat RPMs directory of cd1.
The other three files are in the RPMs directory of CD2.

3.2 set kernel parameters to enable successful startup:

Add these rows to/etc/sysctl. conf
If you have more RAM, you can also change these values:

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

Add these rows to/etc/security/limits. conf

Oracle soft nofile 65536
Oracle hard nofile 65536
Oracle soft nproc 16384
Hard nproc 16384

Restart the system to make these kernel changes take effect. If the restart is not allowed, you can run the following command to change the kernel parameters:

# Echo 250 32000 100 128>/proc/sys/kernel/SEM
# Echo 536870912>/proc/sys/kernel/shmmax
# Echo 4096>/proc/sys/kernel/shmmni
# Echo 2097152>/proc/sys/kernel/Shmall
# Echo 65536>/proc/sys/fs/file-max
# Echo 1024 65000>/proc/sys/NET/IPv4/ip_local_port_range

4. Pre-installation (Oracle environment ):
----------------------------
Log On As an oracle user:

Su-Oracle

Place the following rows in ~ /. Bashrc:

# Oracle 9i
Export oracle_base =/opt/ora9
Export ORACLE_HOME =/opt/ora9/product/9.2
Export Path = $ ORACLE_HOME/bin: $ ORACLE_HOME/Apache/bin: $ path
Export oracle_owner = Oracle
Export oracle_sid = ora9i
Export oracle_term = VT100
Export ld_assume_kernel = 2.4.1
Export threads_flag = native
Export LD_LIBRARY_PATH =/opt/ora9/product/9.2/lib: $ LD_LIBRARY_PATH
Export Path =/opt/ora9/product/9.2/bin: $ path
#
# Change the NLS settings based on your local conditions:
# Example:
# German_germany.we8iso8859p15, american_america.we8iso8859p2 etc.
#
Export nls_lang = 'croatian _ Croatia. ee8iso8859p2'

If you need other country settings (these are from Croatia), refer to the supported settings here and modify the nls_lang variable accordingly.

5. installation:
------------------------

Log on as a root user and allow the user to write data to the X Display in Oracle:

Su-
Xhost +

Log On As an oracle user:

Su-Oracle

Start installation. Do not switch to your CD-ROM installation directory because you will not be able to remove the first CD as needed to insert another CD.

/Mnt/CDROM/install/Linux/runinstaller

During installation, the system prompts you to insert another installation disk. Open a new console, run umount/dev/CDROM (as the root user) to detach the current disk and replace it. If redhat9 is not automatically installed, run the Mount/dev/CDROM command to install it.

Two installation errors are generated.

* First, you will see an error dialog box prompting questions about ins_oemagent.mk. If you select ignore, the error will be corrected after installation.
* In the second dialog box, you will be notified of "error in invoking target install of makefile $ ORACLE_HOME/CTX/lib/ins_ctx.mk ".
If this error occurs, open a new console and Log On As an oracle user. Run the following command:

$ CD $ ORACLE_HOME/install
$ Tail make. Log

You will see a line similar to the following:

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

Copy this row, add-LDL at the end of the row, and then run it in $ ORACLE_HOME/bin.

$ CD $ ORACLE_HOME/bin
$ 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

Now, click the ignore button in the dialog box to continue the installation.

Finally, Oracle installation may prompt you that the agent fails to start. Select ignore. We will change this error later.

6. Post-Installation
---------------------------
Open a console and Log On As an oracle user. Run these commands:

$ CD $ ORACLE_HOME/Network/lib
$ Make-F ins_net_client.mk install

Then edit the $ ORACLE_HOME/CTX/lib/ins_ctx.mk file and extract the Lines 13-14 from:

Ctxhx: $ (ctxhxobj)
$ (Link) $ (ctxhxobj) $ (inso_link)

Change

Ctxhx: $ (ctxhxobj)
$ (Link)-LDL $ (ctxhxobj) $ (inso_link)

Then execute

$ Make-F $ ORACLE_HOME/CTX/lib/ins_ctx.mk install

Now, you will be able to start your agent with the following command

$/Opt/ora9/product/9.2/bin/agentctl start

7. Start the database
------------------------------
Do not worry if your installer is suspended in the last step of section 5th. Wait for a while to see whether it responds. If it does not, terminate it.
Add the following lines in a shell script (such as setvar. Sh)
# Oracle 9i
Export oracle_base =/home1/orahome
Export ORACLE_HOME =/home1/orahome/ora92
Export Path = $ ORACLE_HOME/bin: $ ORACLE_HOME/Apache/bin: $ path
Export oracle_owner = Oracle
Export oracle_sid = ora9i
Export oracle_term = VT100
Export ld_assume_kernel = 2.4.1
Export threads_flag = native
Export LD_LIBRARY_PATH =/opt/ora9/product/9.2/lib: $ LD_LIBRARY_PATH
Export Path =/opt/ora9/product/9.2/bin: $ path
Export ora_nls33 = $ ORACLE_HOME/ocommon/NLS/admin/Data

Save the file and run it at the command prompt.
$ Source setvar. Sh

Go to $ ORACLE_HOME/bin
Use any editor to edit the dbca script
$ Kwrite dbca

Find the jre_home environment variable. It points to JDK 1.8, which is part of the installation CD. Change the variable and point it to jdk1.3 or 1.4 installed in your Linux system and go to the end of the file. This variable is used to call the Java program. Delete the bin directory from the path and rename the JRE executable file to a Java file. This is just like using our own JDK to call Java programs.
Start
$./Dbca

8. Start the database instance
Open a sqlplus session and log on as the system database administrator using sys/passwd.
SQL> Create spfile from pfile = 'full path of . Ora File Created by the dbca utility ';
EG/home1/orahome/admin/dl226b/pfile/initdl226b. ora

SQL> shutdown immediate;
SQL> startup;