Install Oracle9i in Linux

Source: Internet
Author: User




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:


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:


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:

Xhost +

Log On As an oracle user:


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.


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 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/ ".
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

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

$ Gcc-O ctxhx-L/opt/ora9/product/9.2/CTX/lib/
/Opt/ora9/product/9.2/CTX/lib/ctxhx. O-L/opt/ora9/product/9.2/CTX/lib/

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 install

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

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


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

Then execute

$ Make-F $ ORACLE_HOME/CTX/lib/ 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.

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 the. ora File Created by the dbca utility ';
EG/home1/orahome/admin/dl226b/pfile/initdl226b. ora

SQL> shutdown immediate;
SQL> startup;


Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.