Installation of Oracle 9i 9208 in Linux As3 U8 Environment

I. Preparations

◆ 1. Download oracle 9i for linux

◆ 2. Download patches

P3006854_9204_LINUX.zip before running runInstaller.

(The extracted name is rhel3_pre_install.sh)

◆ 3. Modify the kernel parameters (you don't need to modify the kernel parameters unless rman is used. You have to set the kernel parameters if necessary)

Echo "kernel. sem =" 250 32000 100 128 ">/etc/sysctl. conf

Echo "kernel. shmmax = 2147483648">/etc/sysctl. conf

Set Kernel Parameters

View Kernel Parameter Values cat sem or more sem

Echo 100 32000 100 100>/proc/sys/kernel/sem

/* Where 100 is the SEMMSL value,

32000 is the value of the SEMMNS parameter,

100 is the value of the SEMOPM parameter,

100 is the value of SEMMNI.

Echo 02653184>/proc/sys/kernel/shmmax

/* Set the shared memory size. Generally, the shared memory is half of the physical memory (318 mb ram)

Echo 4294967295>/proc/sys/kernel/shmmax

/* Set the shared memory size, which is generally half of the physical memory (512 MB 4294967295)

Depends on the memory size.

In the first command, 250, 32000, 100, and 128 are respectively

Corresponds to four core parameters: SEMMSL, SEMMNS, SEMOPM, and SEMMNI.

The above is a typical core parameter configuration. You may need to make appropriate changes based on your actual environment.

◆ 4. Check settings

More/etc/sysctl. conf | grep kernel. s

Kernel. sysrq = 0

Kernel. shmmax = 2147483648

Kernel. sem = "250 32000 100 128"

◆ 5. check whether all rpm packages are required for installation.

<In fact, when installing linux AS 3 U8, select "Install all". The following will be installed by default. You can skip this step.>

Make sure that the following rpm packages are installed,

If not, most of them are on the third disc. Pay attention to the installation sequence)

# Rpm-qa | grep compat

Compat-gcc-7.3-2.96.122

Compat-libstdc ++ devel-7.3-2.96.122

Compat-gcc-c ++-7.3-2.96.122

Compat-libstdc ++-7.3-2.96.122

Compat-glibc-7.x-2.2.4.32.5

Compat-db-4.0.14-5

# Rpm-qa | grep openmotif

Openmotif-2.2.2-16

Openmotif-devel-2.2.2-16

# Rpm-qa | grep setarch

Setarch-1.3-1 [/quote: db788a2c24]

◆ 6. Replace gcc and g ++ with version 2.96. ---- This step is not required for linux as 3. It is used as a reference here.

[Quote: db788a2c24] # mv/usr/bin/gcc/usr/bin/gcc323

# Ln-s/usr/bin/gcc296/usr/bin/gcc

# Mv/usr/bin/g ++ 323

# Ln-s/usr/bin/gcc296/usr/bin/gcc

◆ 7. Set User and environment variables and installation target path

A. Add users and groups

Groupadd dba # create a database administrator Group

Groupadd oinstall # create all groups of oracle files

Useradd-g oinstall-G dba oracle # create an oracle user

Passwd oracle # Set the password of an oracle user

B. Create the installation target path (this is defined by myself. It is usually created under the root directory. It is easy to find)

Mkdir/opt/oracle

Mkdir/opt/oracle/product

Mkdir/opt/oracle/product/9.2.0

Chown-R oracle. oinstall/opt/oracle

Mkdir/var/opt/oracle

Chown oracle. dba/var/opt/oracle

Chmod 755/var/opt/oracle

C. Set Environment Variables

Su-oracle

Vi. bash_profile Add the following content

Export LD_ASSUME_KERNEL = 2.4.1 # This parameter must be specified. Otherwise, the Java installation interface cannot be started,

This parameter is used to avoid incompatibility between NPTL (Native POSIX Thread Library) and Oracle Applications on Linux.

# Oracle Environment

Export ORACLE_BASE =/opt/oracle

Export ORACLE_HOME =/opt/oracle/product/9.2.0

Export ORACLE_SID = test

Export ORACLE_TERM = xterm

# Export TNS_ADMIN = Set if sqlnet. ora, tnsnames. ora, etc. are not in $ ORACLE_HOME/network/admin

Export NLS_LANG = AMERICAN;

Export ORA_NLS33 = $ ORACLE_HOME/ocommon/nls/admin/data

LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/lib

LD_LIBRARY_PATH = $ LD_LIBRARY_PATH:/usr/local/lib

Export LD_LIBRARY_PATH

Export PATH = $ PATH: $ ORACLE_HOME/bin

Then execute

$ Source. bash_profe # Make the configuration file take effect

◆ 8. Set swap and Temporary Folder

<I have enough configurations here, so this step is not done. In fact, the current Pc configuration can be done. In this step, you can skip this step and skip this step. Go directly to Step 9>

Oracle has high requirements on memory and swap. Oracle recommends that the Oracle 9i server need at least 512 MB of memory,

Two times the memory or no less than 400 M swap (swap) space. If you do not have enough swap space or memory,

During database creation, your Oracle server will become very slow.

The memory is only 256 M, and M of swap is added.

Su root

Dd if =/dev/zero of = tmpswap bs = 100 M count = 10

Chmod 600 tmpswap

Mkswap tmpswap

Swapon tmpswap

In addition, the installation of oracle requires at least MB of/tmp temporary space.

If you do not have enough space in/tmp, You can temporarily create a/tmp directory in another file system.

Su root

Mkdir/tmp

Chown root. root // tmp

Chmod 1777 // tmp

Export TEMP =/# used by Oracle

Export TMPDIR =/# used by Linux programs

After installing Oracle, close Oracle and delete the temporary directory:

Su root

Rmdir/tmp

Unset TEMP

Unset TMPDIR

Oracle Disk Space (Sizing Oracle Disk Space)

Only the database software is installed, and approximately 2.5 GB of disk space is required.

If you perform a standard database installation instead of a custom installation, about GB of space is required.

◆ 9. Unpack the installation file. <This user defined, as long as the folder created by the oracle user is>

Copy the downloaded file to/tmp. Decompress the package as the oracle user. If you use root to decompress the package, all the permissions are root. Further management is troublesome.

A. Extract

Gunzip lnx_920_disk1.cpio.gz lnx_920_disk2.cpio.gz lnx_920_disk3.cpio.gz Linux9i_Disk3.cpio.gz

B. Unpack

Cpio-idmv <lnx_920_disk1.cpio

Cpio-idmv <lnx_920_disk2.cpio

Cpio-idmv <lnx_920_disk3.cpio

Three folders, Disk1, Disk2, and Disk3, are generated.

2. Install the database software without creating a database .......

◆ 1. Make the first patch.

Install patch 3006854 before running the runInstaller: note that it must be run as root.

# Unzip p3006854_9204_LINUX.zip

Creates a directory under the current directory and enters the directory.

# Cd 1, 3006854

# Chmod + x *. sh

#./Rhel3_pre_install.sh

◆ 2. Run runinstall

1) su-oracle

2)/tmp/Disk1/runInstaller

(You can enter the Disk1 folder and execute./runInstaller)

3) The Oracle Installation interface will appear soon.

(If the installation interface is garbled, enter:

Export LC_ALL = en_US <you can skip this operation.>

Export LANG = en_US

Run./runinstaller again)

4) Click "Next" to proceed to the Next step.

5) Select default and click "OK" to continue

6) enter the group name "Enter oinstall or Dba" and click "Next" to proceed to the Next step.

7) follow the prompts to open another terminal and run the/tmp/orainstRoot. sh command as the root user.

8) after the command is executed instantly, click "Continue" to proceed to the next step.

9) Select default and click "Next" to continue

10) after "Loading product", go to the next installation page

11) Select "Oracle9i Database 9.2.0.4.0" and select "Product editions" to set the language.

12) Select "Simplified Chinese" and "Traditional Chinese" that support Mandarin, and click "OK"

13) Select "Enterprise Edition (2.56 GB)" and click "Next"

14) Wait for the installation process to run and enter the next installation Interface

15) Select "Software Only". In the future, we can use the dbca tool to create a database (generally only install software Only first)

16) Click "Install" to start database installation.

17) Wait for "link pending ......", Continue

18) after a long wait, I finally saw the long-awaited Interface

19) as prompted, press ctrl + shift + n to open a new terminal window and run/opt/oracle/product/9.2.0/root. sh on the terminal as the root user.

20) after the statement is executed, press enter to use the default path. You must wait until the statement execution is complete before returning to the installation page. Click "OK"

21) This screen proves that the database has been successfully installed. You can breathe a sigh of relief.

22) Click "Exit" to Exit the page. The OEM screen will pop out.

 

◆ 3. Upgrade

Unpack:

Unzip p4547809_92080_LINUX.zip-d/oarcle/9208

(You can create a folder and place it in a folder with oracle permissions. You can delete the folder once it is used up)

Now you can run./runInstaller again, select the second option, and upgrade to 9208.

Then you will be prompted to use the root identity to execute a script in/opt. You can also open a terminal and use the root identity to execute the script.

There is a problem in this area. If you decompress the package directly using the oracle Identity, you may be prompted for permission.