Linux 8.0 Install Oracle 9i

Oracle Purpose:
Install Oracle 9i on Linux 8.0 to ensure database security and stability

Software Environment:
Linux 8.0 (three CDs)
Oracle 9.2.0.1.0 for Linux (three CDs)

Hardware environment:
P4 2.4, Memory 512M, hard disk 80G high RPM, 16x_dvd optical Drive

Problem Reason:
Linux runs Oracle's system environment configuration, which causes Oracle to not install correctly.

Problem Description:


Detailed resolution process
I. Configuration of system parameters
1. When installing linux8.0, note that the root directory (/) partition is about 10G, the swap partition is about 1G,/u01,/u02,/u03,/u04 each partition for the 15g,/var partition for 10G.
2. Log in as root after Linux starts
Configuring Kernel Parameters
Oracle9i uses Linux shared memory, swap areas, and other resources to work, if your kernel parameter settings do not meet Oracle requirements, the installation of oracel9i or use of the process will frequently occur
The configuration of kernel parameters is typically configured under the/proc folder:
1. The following commands are permitted by root user;
2). Enter the catalogue/proc/sys/kernel;
3. View the value of the semaphore current parameter with the cat command or the more command:
[Root@otest root]# Cat SEM
The following results will appear when the command is run:
250 32000 32 128
Where 250 is the value of the parameter SEMMSL, 32000 is the value of the parameter Semmns, 32 is the value of the parameter semopm, and 128 is the argument
The value of the number Semmni.
4). The above parameters can be modified with the following command
echo semmsl_value semmns_value semopm_value semmni_value > SEM

Where Semmsl_value, Semmns_value, Semopm_value, Semmni_value are replaced with corresponding values, and the order of these values cannot be reversed
5. Set the shared memory size, the shared memory size is generally set to half of the physical memory, where we assume that the physical memory is 512M the value of shared memory 419000000 and so on, if your physical memory is 1G then the value here is 838000000:
[Root@otest root]# echo 419000000 >/proc/sys/kernel/shmmax
[Root@otest root]# Cat/proc/sys/kernel/shmmax

3. Create user groups and user names:
First create an Oracle installation group and user group, assuming that two user groups are named Oinstall, DBA:
[Root@otest root]# Groupadd Oinstall
[Root@otest root]# Groupadd dba
[Root@otest root]# useradd–g oinstall–g dba Oracle
[Root@otest root]# passwd Oracle

4. Create the installation directory, as root user:
[Root@otest root]# mkdir–p/u01/app/oracle/product/9.2
[Root@otest root]# chown–r oracle.oinstall/u01/app/oracle
[Root@otest root]# mkdir/var/u01
[Root@otest root]# Mkdir/var/u01/oracle
[Root@otest root]# chown oracle.dba/var/u01/oracle
[Root@otest root]# chmod 755/var/u01/oracle

5. Set Oracle Environment:
To be performed by an Oracle User:
Vi/home/oracle/.bash_profile
Under FI Insert the following statement:
Export Oracle_base=/u01/app/oracle
Export oracle_home=/u01/app/oracle/product/9.2
Export Oracle_sid=otest
Export Ld_library_path= $ORACLE _home/lib:/lib:/usr/lib:/usr/local/lib
Export path= $PATH: $ORACLE _home/bin

#CLASSPATH
Classpath= $ORACLE _home/jre: $ORACLE _home/jlib: $ORACLE _home/rdbms/jlib: $ORACLE _home/network/jlib: $CLASSPATH

Second, start installation oracle9i
1, switch to Oracle user, enter x-windows and install
2, appear oracle9i installation screen

3, enter the Oracle9i component selected installation screen.

4, enter the oracle9i version of the installation screen selected

Installation of 5,oracle9i Configuration selection screen


6, fill in the name of the database

7, installation directory selection screen

8, select the database format, I chose the UTF-8

9, enter the start installation screen and start the installation

10, in the installation process will appear in the following diagram of a hint.

11, the above tips do the following processing:
Go to/u01/app/oracle/product/9.2/ctx/lib, find the Env_ctx.mk file, append the following
$ (ldlibflag) DL, then point retry as shown:

12, continue to install, appear another (second hint) a hint, as shown

13, according to the above prompts the information, do the following operation
Entering/u01/app/oracle/product/9.2, enter the following command
./root.sh then enter, as shown
14, click "OK" to continue the installation

15, fill in the database access name and password

16, a complete picture of Oracle database installation appears

The above is the Oracle9i database, all the installation process.
Three, start and test
1, because the database has just been installed, so the database service is up, so just start test listening on it, with Oracle users, enter LSNRCTL start

2, perform the listening test and enter the following command with Oracle user
Netca
This will appear a screen, configure the listener, then select the Local net service name configuration, then select text, and then change the user password, the installation of the password to add in, OK! And then enter, until the completion.
3, if the new Linux, the system does not automatically start the Oracle9i service, you need to be an Oracle user to start the service, such as:
Su–oracle
Sqlplus/nolog
After entering the Sqlplus, enter:
Connect/as SYSDBA
When you go in, enter:
Startup
Then wait for the database startup to complete.
This is the time to start the Oracle service, and then start the listener, you need to start the test listening (repeat 1 action).





Note:
You may be prompted to start a service (orainstroot.sh) in the process of installing oracle9i. At this point, switch to the root user, enter/tmp directory, run
[Root@otest tmp]#./orainstroot.sh
After successful operation, return to the Oracle installation interface point continue continue to install.