Installing Oracle 9i on Red Hat Enterprise Linux Advanced Server

http://www.blogjava.net/rocky/archive/2005/10/09/15085.html

 

 

Installing Oracle 9i on Red Hat Enterprise Linux Advanced Server 4, 3, 2.1, and on Red Hat 9, 8.0, 7.3, 7.2, 7.1 (x86)

Here is a summary (HOWTO) how I installed:

Oracle 9iR2 (9.2.0.6.0) Database on Red Hat Advanced Server 4 (x86, kernel 2.6.9-5.EL, glibc-2.3.4-2)
Oracle 9iR2 (9.2.0) Database on Red Hat Advanced Server 3 (x86, kernel 2.4.21-4.EL, glibc 2.3.2-95.3)
Oracle 9iR2 (9.2.0) Database on Red Hat Advanced Server 2.1 (x86, kernel 2.4.9-e.3, glibc 2.2.4-26)
Oracle 9iR2 (9.2.0) Database on Red Hat 9 (x86, kernel kernel-2.4.20-6, glibc 2.3.2-5)
Oracle 9iR2 (9.2.0) Database on Red Hat 8.0 (x86, kernel 2.4.18-18.8.0, glibc 2.2.93-5)
Oracle 9iR2 (9.2.0) Database on Red Hat 7.3 (x86, kernel 2.4.18-3, glibc 2.2.5-34)
Oracle 9iR1 (9.0.1) Database on Red Hat 7.3 (x86, kernel 2.4.18-3, glibc 2.2.5-34)
Oracle 9iR1 (9.0.1) Database on Red Hat 7.2 (x86, kernel 2.4.7-10, glibc 2.2.4-13)
Oracle 9iR1 (9.0.1) Database on Red Hat 7.1 (x86, kernel 2.4.2-2, glibc 2.2.2-10)

People recommended this installation guide also for Red Hat Fedora Core 2.

Validation/Certification:

For Validations/Certifications, check the following links:
Oracle's Certification Matrices
Oracle Products on Red Hat Linux
Red Hat Enterprise Linux Application List
Errors and Problems:
Some of the Oracle errors and problems covered here were only experienced in connection with 9i (9.0.1) and some only with 9iR2 (9.2.0). But since I cannot say for sure that a 9i (9.0.1) installation error will never show up during 9iR2 (9.2.0) installation, I simply kept all errors and problems listed together, see Oracle Installation Errors and Oracle Installation Problems, Important Tips and Hints.

Red Hat Enterprise Linux Advanced Server 3 (RHEL AS 3)
In order to install an Oracle9iR2 database on RH AS 3, the "Oracle9iR2 Patch Set 3 9.2.0.4.0" patchset and some other patches must be applied. Some errors can only be fixed by applying the 9.2.0.4 patchset. For more information, see Running Oracle Installation on Red Hat Enterprise Linux Advanced Server 3.

Red Hat 9:
Red Hat 9 includes the Native POSIX Thread Library (NPTL) which is an improved implementation of POSIX threads for Linux. But using NPTL will cause several problems for Oracle applications. Note that Oracle9i has not been certified on Red Hat 9!
So to fix this problem, you can set the environment variable LD_ASSUME_KERNEL to 2.4.1, which means that the old "Linuxthreads with floating stacks" implementation will be used. Otherwise the Oracle installer runInstaller will hang, the Database Configuration Assistant dbca won't start etc.; see Oracle Installation Errors for more information. To see where this environment variable can be set, see Set Oracle Environments. For more information on LD_ASSUME_KERNEL, see Red Hat Linux 9 Release Notes.
NOTE: Before you install Oracle9iR2, make sure that you first read the information about the error message "Error in invoking target install of make file /u01/app/oracle/product/9.2.0/network/lib/ins_oemagent.mk" in the Oracle Installation Errors section!

Red Hat 8.0:
The only problem I experienced with Oracle 9iR2 (9.2.0) on Red Hat 8.0 was:
"Error in invoking target install of makefile /u01/app/oracle/product/9.2.0/ctx/lib/ins_ctx.mk"
But this does not necessarily mean that you won't see other problems described here. See Oracle Installation Errors for more information.
 

This article covers the following subjects and steps:

* Documentations
* Downloading and Installing Red Hat Linux 7.1, 7.2, 7.3, 8.0, 9
* Unpacking Downloaded Oracle9i Installation Files and Burning Oracle9i CDs
* Setting Swap Space
* Setting Shared Memory
* Checking /tmp Space
* Sizing Oracle Disk Space
* The "binutils" Issue
* Checking Packages (RPMs)
* JDK
* Creating Oracle User Accounts
* Creating Oracle Directories
* Setting Oracle Environments
* Starting runInstaller
* Running Oracle Installation on RH 7.1, 7.2, 7.3, 8.0, 9, and on RH AS 2.1
* Running Oracle Installation on Red Hat Enterprise Linux Advanced Server 3
     Installing Oracle9iR2 on RH AS 3
     Patching Oracle9iR2 on RH AS 3
     Patching Oracle Intelligent Agent on RH AS 3
* Running Oracle Installation on Red Hat Enterprise Linux Advanced Server 4
     Installing Oracle9iR2 on RH AS 4
     Patching Oracle9iR2 on RH AS 4
* Startup and Shutdown of the Oracle 9i Database
* Oracle Installation Problems, Tips and Hints
* Oracle Installation Errors

Documentations

Oracle9i Database Documentation for Linux
Tuning and Optimizing Red Hat Linux Advanced Server for Oracle9i Database
Oracle9iR2 on Linux: Performance, Reliability and Manageability Enhancements on Red Hat Linux Advanced Server 2.1
An Overview of Red Hat Advanced Server V2.1 Reliability, Availability, Scalability, and Manageability (RASM) Features

Downloading and Installing Red Hat Linux 7.1, 7.2, 7.3, 8.0, 9

To download Red Hat Linux 7.x, 8.0, 9, check the links at http://www.puschitz.com/LinuxDownload.shtml.
You can find the installation guides for installing Red Hat Linux under Red Hat Linux Manuals.

NOTE: You cannot download Red Hat Linux Advanced Server 2.1, you can only download the source code. If you want to get the binary CDs, you will have to buy it at http://www.redhat.com/software/linux/advanced/.

Installing Software Packages (RPMs)

You don't have to install all RPMs when you want to run an Oracle9i database on Red Hat Linux.

For instance, if you install Red Hat Advanced Server, you are fine when you select the Installation Type "Advanced Server" and when you don't select the Package Group "Software Development". There are only a few other RPMs that are required for installing Oracle9i. These other RPMs are covered in this article.

Or when you install Oracle9i on Red Hat Linux 7.x, 8.0, or 9, you are fine when you select the installation type "Server".

Unpacking Downloaded Oracle9i Installation Files and Burning Oracle9i CDs

Download Oracle9i for Linux from the following web site:
http://otn.oracle.com/software/products/oracle9i/htdocs/linuxsoft.html

Uncompress and unpack downloaded files:

For Oracle9i (9.2.0):

One step procedure (uses less disk space and is faster):

  zcat lnx_920_disk1.cpio.gz | cpio -idmv
  zcat lnx_920_disk2.cpio.gz | cpio -idmv
  zcat lnx_920_disk3.cpio.gz | cpio -idmv

Two step procedure:

  # Uncompress
  # Unpack the downloaded files:

For Oracle9i (9.0.1):

One step procedure (uses less disk space and is faster):

Two step procedure:

  # Uncompress
  

  # Unpack the downloaded files:
  

Now you should have 3 directories containing installation files:

Disk1
Disk2
Disk3

I executed the following commands when I burned the 3 CDs:

(You can get the dev numbers when you execute cdrecord -scanbus).

Setting Swap Space

In order to perform. a typical Oracle 9i installation and to create a simple prototype database, Oracle says that you need a minimum of 512MB of RAM for the Oracle9i (9.0.1) Server, and the amount of disk space (swap space) should be equal to twice the amount of RAM or at least 400 MB, whichever is greater.
I tried to test the limits on an older PC with 256 MB of RAM and with 600 MB of swap space. I was able to install Oracle 9i (9.0.1 & 9.2.0) and Oracle's default database without any problems. But when I used less swap space on this PC (256MB RAM), I was runnig out of memory. So I definitely recommend to use more RAM and/or more swap space as specified in the Oracle installation guide.

NOTE: If you do not have enough swap space or RAM during the Oracle installation, in particular during the database creation, your Oracle server (Linux) will temporarily become unresponsive to any events for several minutes.

For more information on correctly sizing the swap space for your database, see Sizing Swap Space.

To check the memory, run:

To check the swap space, run:

You can also add temporary swap space by creating a temporary swap file instead of using a raw device. Here is the procedure:

To disable the temporary swap space execute the following commands:

 

Setting Shared Memory

For Oracle 9i (9.2.0) installation I had to increase the maximum shared memory size on my Linux server for all Red Hat versions. The Oracle Database Configuration Assistant displayed the following error message on my server:

ORA-27123: unable to attach to shared memory segment.

I temporarely increased the shmmax setting for the kernel by executing the following command:

$ 
# 
33554432
# 
# 
1073741824

It is recommended to increase the shmmax setting permanently for Oracle. For more information, see Setting Shared Memory.

For more information on optimizing shared memory settings for Oracle databases on Linux, see Setting Shared Memory. These parameters apply to all Red Hat Linux versions. But note that except for the shmmax parameter, these parameter do not need to be changed for installing Oracle on Linux. But you might want to adjust all shared memory settings later to optimize the server for Oracle.

Checking /tmp Space

The Oracle Universal Installer requires up to 400 MB of free space in the /tmp directory.

To check the space in /tmp, run:

$ 

If you do not have enough space in the /tmp directory, you can temporarily create a tmp directory in another filesystem. Here is how you can do this:

# used by Oracle# used by Linux programs like the linker "ld"

When you are done with your Oracle installation, shutdown Oracle and remove the temporary directory:

 

Sizing Oracle Disk Space

You will need about 2.5 GB for the database software. If you perform. a typical database installation and not a customized database installation, then you will need about 3.5 GB of disk space.

The "binutils" Issue

Skip this step for Oracle9iR2.

I did not experience this problem with Oracle 9i (9.2.0), but only with Oracle 9i (9.0.1).

The binutils package that comes with Red Hat 7.1, 7.2, 7.3, and with RedHat 2.1 Advanced Server doesn't work with Oracle 9i (9.0.1) Universal Installer. Here are the options you have for 9.0.1:

• I recommend the following approach:
  
  Wait for the following Oracle installation error:

  "Error invoking target install of makefile /u01/app/oracle/product/9.0.1/plsql/lib/ins_plsql.mk"

  And fix this problem as described in Oracle Installation Errors.
  I recommend this approach since it obviates the need to change binutils.

• I do not recommend the following approach:
  
  Download the following binutil RPM version and downgrade binutil on the Oracle server:
  ftp://ftp.redhat.com/pub/redhat/linux/7.0/en/os/i386/RedHat/RPMS/binutils-2.10.0.18-1.i386.rpm
  

  su - root
  rpm -Uvh --force --nodeps binutils-2.10.0.18-1.i386.rpm

  When you are done with the Oracle installation, you upgrade your binutil RPM back to the version you had before you downgraded. E.g. on the Red Hat 7.2 server I did:

  rpm -Uvh --force --nodeps binutils-2.11.90.0.8-9.i386.rpm

• Here is Oracle's official solution for Oracle 9iR1 or 9iR1 iAS on RedHat 2.1 Advanced Server which I don't like:
  http://otn.oracle.com/software/products/oracle9i/files/binutils_readme.html

 

Checking Packages (RPMs)

You will need some RPM development packages for the Oracle installer to build the Oracle modules, otherwise you will get error messages similar to this one:

NOTE: Always ensure to use the latest RPM versions!


Packages (RPMs) for RH 7.1, 7.2, and RH AS 2.1:

To see if these development packages are installed on your server, run the following command:

For instance, most of these packages will be missing when you installed RedHat 2.1 Advanced Server and if you did not select the "Software Development" package. For the RedHat 2.1 Advanced Server I executed the following commands to install the missing RPMs from the two CDs:

Packages (RPMs) for RH 7.3, 8.0, and 9:

To see if these development packages are installed on your server, run the following command:

For instance, when I installed Red Hat 9.0 and when I used the default packages for the Installation Type "Server", I had to install the following RPMs afterwards:

NOTE: Before you install Oracle9iR2 on Red Hat 9, make sure that you also read the information about the error message "Error in invoking target install of make file /u01/app/oracle/product/9.2.0/network/lib/ins_oemagent.mk" in the Oracle Installation Errors section!


Packages (RPMs) for Red Hat Enterprise Linux Advanced Server 3 (RHEL AS 3):

Ensure the following required packages are installed on your server by running the following command:

Packages (RPMs) for Red Hat Enterprise Linux Advanced Server 4 (RHEL AS 4):

See also Oracle9i Release Notes Release 2 (9.2.0.4.0) for Linux x86 for the list of required RPMs.

Ensure the following required packages are installed on your server by running the following command:

Many of these packages depend on other packages. For example, compat-gcc-32 requires binutils, gcc etc. Since I like to install a system with as few RPMs as possible I had to install the following RPMs to satisfy dependencies:

For xorg-x11-deprecated-libs-devel and xorg-x11-devel I had to install the following RPMs.
Note that these two packages are required for the Oracle patch 4198954 below.

And for gnome-libs and gnome-libs-devel I had to install the following RPMs:

HINT:
If you are using RHN, you could simply run:

You can use the up2date command for any packages. It takes care of dependencies by installing all required packages automatically.

To install the compat-oracle-rhel4 and compat-libcwait packages you have to download the patch 4198954 from http://metalink.oracle.com. Make sure to select the Linux x86 platform. To unzip the downloaded p4198954_21_LINUX.zip file, run:

$ 
Archive:  p4198954_21_LINUX.zip
   creating: 4198954/
  inflating: 4198954/compat-oracle-rhel4-1.0-5.i386.rpm
  inflating: 4198954/compat-libcwait-2.0-2.i386.rpm
  inflating: 4198954/README.txt
#

Note that the compat-oracle-rhel4 and compat-libcwait packages require the xorg-x11-deprecated-libs and xorg-x11-deprecated-libs-devel packages, see above. To install the two RPMs from the 4198954 patch, run:

# 

 

JDK

Skip this step for Oracle9iR2.

I successfully installed Oracle9iR2 without installing JDK on the system. Oracle comes now with its own Java. This means that you don't have to execute the following steps which were required for older Oracle versions:

Download JDK 1.3.1 or Blackdown 1.1.8_v3: (I usually used Blackdown)
http://www.blackdown.org
http://java.sun.com

According to the JDK documentation, install JDK under /usr/local. Then create a symbolic link to the JDK under /usr/local/java:

 

Creating Oracle User Accounts

# group of users to be granted with SYSDBA system privilege# group owner of Oracle files

For more information on the "oinstall" group account, see When to use "OINSTALL" group during install of oracle.

Creating Oracle Directories

In this example, make sure that the /u01 filesystem is large enough, see Oracle Disk Space for more information. If /u01 is not on a separate filesystem, then make sure the root filesystem "/" has enough space.

 

Setting Oracle Environments

Set the following Oracle environment variables before you start runInstaller.

As the oracle user execute the following commands:

#
#
# Use the "Linuxthreads with floating stacks" implementation instead of NPTL:
    # 
   # 

# Oracle Environment
# export TNS_ADMIN= Set if sqlnet.ora, tnsnames.ora, etc. are not in $ORACLE_HOME/network/admin
# Set shell search paths

I successfully installed Oracle9iR2 without setting the following CLASSPATH environment variable:

# CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
# CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib
# export CLASSPATH

You can put these environment settings at the end of the ~oracle/.bash_profile file if you use bash. By this way you don't have to set the environment variables again when you login as "oracle", or when you switch to the user "oracle" by executing "su - oracle".

Starting runInstaller

Before you continue, make sure you have set the Oracle environment variables, see above.

Oracle no longer supports a character mode installer. Therefore, in order to execute runInstaller directly from a console of a machine you are logged into (in this example the node name where Oracle is running is called "oracleserver"), you need to set the DISPLAY environment variable. Before you do that, make sure that you also allow runInstaller on "oracleserver" to display X information on your Linux desktop machine (in this example, the PC name where you are running X Windows like KDE or GNOME is called "yourdesktop"), because programs running on remote machines cannot display information to your screen unless you give them the authority to do so. Note that the X display relink mechanism does not work for NT desktop machines unless you use Exceed.

Before you run runInstaller, execute e.g. 'xterm' to see if your X setup is really working! If you install Oracle on your desktop PC and not on a remote node, then you can skip step 1 and 3.

Step 1: Allow "oracleserver" to display X information to your desktop PC "yourdesktop":

  yourdesktop:user$ 

Step 2: Open a new window and login to the Oracle server "oracleserver" as root. This window will be used for mounting and unmounting the Oracle CDs.

  oracleserver:$ 
  oracleserver:root# 

Step 3: From the console of your Oracle server "oracleserver" where you will run runInstaller, execute the following commands:

  oracleserver:$ 
  oracleserver:oracle$ 

Step 4: Now execute runInstaller as "oracle". Do not cd to /mnt/cdrom !!

  oracleserver:oracle$ 

NOTE 1:

If you use for example Red Hat Fedora Core 3 as your desktop and you want to install the database on another machine, then you need to set the DisallowTCP entry in /etc/X11/gdm/gdm.conf for the GNOME Display Manager to read:

After that you need to restart your X server. I usually do this with the init command:

NOTE 2:

Don't run runInstaller for Red Hat Enterprise Linux Advanced Server 3 (RHEL AS 3) yet! See Running Oracle Installation on Red Hat Enterprise Linux Advanced Server 3 for more information.

Running Oracle Installation on RH 7.1, 7.2, 7.3, 8.0, 9, and on RH AS 2.1

Keep in mind that you may get one or more errors here during the Oracle installation! See Oracle Installation Errors for more information.

This is how I answered the questions for the runInstaller:

- What would you like as the base directory (Inventory Location):

- UNIX Group Name (permission for updating Oracle software):

  You could also use "dba" which I do not recommend for security reasons.
  For more information on the "oinstall" group account, see
  .
  

- Full path name for Oracle Home:

etc.

Running Oracle Installation on Red Hat Enterprise Linux Advanced Server 3

In order to install an Oracle9iR2 database on RH AS 3, the "Oracle9iR2 Patch Set 3 9.2.0.4.0" patchset and some other patches must be applied. Some errors can only be fixed by applying the 9.2.0.4 patchset.


Installing Oracle9iR2 on RH AS 3

Install the following RPMs (see Oracle Note:252217.1 for more information):

Relink gcc so that the older gcc will be used during the Oracle installation (see Oracle Note:252217.1 for more information):

# if g++ doesn't exist, then gcc-c++ was not installed

When you execute runInstaller from the Oracle 9iR2 (9.2.0) CD, you will get the following error message:

To resolve the __libc_wait symbol issue, download the patch p3006854_9204_LINUX.zip from http://metalink.oracle.com. See bug 3006854 for more information.

To apply the patch, run

# 
Archive:  p3006854_9204_LINUX.zip
   creating: 3006854/
  inflating: 3006854/rhel3_pre_install.sh
  inflating: 3006854/README.txt

# 
# 
Applying patch...
Patch successfully applied
# 

NOTE: If you get the following error when you run rhel3_pre_install.sh:

Then you forgot to install or link gcc, see above. This means you can't start any binaries any more:

#

#

#

To fix that, run the echo command which is a built-in shell command:

# 

And start over again.


Now runInstaller can be started from the CD:

$     # it is important that this variable is set!
2.4.1
$ 

 - Welcome Screen:      
 - Inventory Location:  
 - Unix Group Name:     
 - File Locations:      
 - Available Products:  
 - Installation Types:  
 - Available Products:  
 - Components Locations:
 - Privileged Operating System Groups:
                        
 - Oracle Managent Server Repository:
                        
 - Create database:     
 - Summary:             
 - Configuration tools: 
 - 

 

You may get the following errors:

Error in invoking target install of makefile /u01/app/oracle/product/9.2.0/network/lib/ins_oemagent.mk.

The /u01/app/oracle/product/9.2.0/install/make.log file reads:

Click ignore. This will be fixed by applying the patch 3119415 after the 9.2.0.4 patchset has been applied. You won't be able to apply the patch 3119415 at this time since the file /u01/app/oracle/oraInventory/ContentsXML/comps.xml doesn't exist yet.


Error in invoking target install of makefile /u01/app/oracle/product/9.2.0/ctx/lib/ins_ctx.mk.

The /u01/app/oracle/product/9.2.0/install/make.log file reads:

Click ignore. This is fixed by applying the 9.2.0.4 patchset.


Patching Oracle9iR2 on RH AS 3

To patch Oracle9iR2, download the Oracle 9i Release 2 Patch Set 3 Version 9.2.0.4.0 for Linux x86 from http://metalink.oracle.com.

Copy the downloaded "p3095277_9204_LINUX.zip" file to e.g. /tmp and run the following command:

$ 
$ 
$ 
Archive:  p3095277_9204_LINUX.zip
  inflating: 9204_lnx32_release.cpio
  inflating: README.html
  inflating: patchnote.css
$
$ 
Disk1/stage/locks
Disk1/stage/Patches/oracle.apache.isqlplus/9.2.0.4.0/1/DataFiles/bin.1.1.jar
Disk1/stage/Patches/oracle.apache.isqlplus/9.2.0.4.0/1/DataFiles/lib.1.1.jar
...

To patch the runInstaller, run:

$     # it is important that this variable is set!
2.4.1
$ 
$ 

 - Welcome Screen:      
 - File Locations:      
 - Available Products:  
 - Components Locations:
 - Summary:             
 - 

To patch Oracle9iR2, run:

$     # it is important that this variable is set!
2.4.1
$ 
$ 

 - Welcome Screen:      
 - File Locations:      
 - Available Products:  
 - Summary:             
 - 

You may get the following error:

Error in invoking target install of makefile /u01/app/oracle/product/9.2.0/network/lib/ins_oemagent.mk.

The /u01/app/oracle/product/9.2.0/install/make.log file reads:

Click ignore. This will be fixed by applying the patch 3119415 after the 9.2.0.4 patchset has been applied. The patch 3119415 cannot be applied while the patch process for the 9.2.0.4 patchset is running.


After the 9.2.0.4 patchset has been applied, download the patch p3119415_9204_LINUX.zip from http://metalink.oracle.com. See bug 3119415 for more information. Also, download the opatch Release 2.2.0 utility from http://metalink.oracle.com. See bug 2617419 for more information.

To install opatch, run:

$ 
$ 
$ 

Before you apply the 3119415 patch, you need to make sure the fuser binary can be found by the oracle user, see the PATH environment variable below. Otherwise the patch can't be applied because the fuser binary is used by opatch.

To apply the 3119415 patch, run

$ 
$ 
$ 
$         # the patch needs "fuser" which is located in /sbin
$ 
/tmp/OPatch/opatch
$ 

Now you should be able to create a database with dbca:

Patching Oracle Intelligent Agent on RH AS 3

When you run "agentctl start" (Oracle 9.2.0.4), dbsnmp will crash:

$ 
$ 

To resolve this problem, apply the patch p3238244_9204_LINUX.zip from http://metalink.oracle.com. See bug/patch 3238244 for more information.

Before you apply the patch, make sure the instance is down!

Also make sure the opatch script. appears in your $PATH. See "Patching Oracle9iR2 on Red Hat AS 3" for information on getting and installing opatch. To verify if opatch is in your $PATH, run the which command:

$ 
$ 
/tmp/OPatch/opatch
$

To apply now the patch, run:

$ 
$ 
$ 
$         # the patch needs "fuser" which is located in /sbin
$ 

Now you need to relink dbsnmp. This is the binary that crashed when running agentctl start. To find which makefile handles the linking of dbsnmp, you can run:

$ 
$ 
/u01/app/oracle/product/9.2.0/network/lib/ins_oemagent.mk
/u01/app/oracle/product/9.2.0/network/lib/env_oemagent.mk
$

I relinked dbsnmp and all associated executables which are maintained by the ins_oemagent.mk makefile:

$ 
$ 
$ 

Now you should be able to start the agent:

$ 
$ 

NOTE: Don't forget to undo the changes (links) to /usr/bin/gcc and /usr/bin/g++ if you don't need it any more. Also don't forget the /etc/ld.so.preload file.

Running Oracle Installation on Red Hat Enterprise Linux Advanced Server 4

In order to install Oracle9i Release 2 (9.2.0.6) I've applied the 9.2.0.6 patch set for the Oracle database server (patch number 3948480) after the Oracle9i Release 2 (9.2.0.4) installation. For more information, see Oracle9i Release Notes Release 2 (9.2.0.4.0) for Linux x86 - Red Hat Enterprise Linux 4 Certification Update.


Installing Oracle9iR2 on RH AS 4

Before you continue, ensure all the required RPMs are installed, see Packages (RPMs) for Red Hat Enterprise Linux Advanced Server 4 (RHEL AS 4).

Also ensure LD_ASSUME_KERNEL is set to 2.4.19 (see Setting Oracle Environments):

$ 
$ 
2.4.19
$

Now launch runInstaller:

$ 
2.4.19
$ 

 - Welcome Screen:      
 - Inventory Location:  
 - Unix Group Name:     
 - File Locations:      
 - Available Products:  
 - Installation Types:  
 - Available Products:  
 - Components Locations:
 - Privileged Operating System Groups:
                        
 - Oracle Managent Server Repository:
                        
 - Create database:     
 - Summary:             
 

Patching Oracle9i R2 (9.2.0.4) on RH AS 4

Download the patch 3948480 (Oracle9i Patch Set Release 2 (9.2.0.6) Patch Set 5) from http://metalink.oracle.com and execute the following commands:

$ 
$ 
$ 
Archive:  p3948480_9206_LINUX.zip
   creating: Disk1/
   creating: Disk1/stage/
   creating: Disk1/stage/Patches/
...

Now download the patch 4188455 from http://metalink.oracle.com.
This patch is needed for launching the runInstaller that came with the patch 3948480 we just downloaded above.

$ 
$ 
$ 
Archive:  p4188455_10103_LINUX.zip
  inflating: oraparam.ini
  inflating: README.txt
$

The /tmp/oraparam.ini file will now be used for launching the runInstaller that came with the patch 3948480.

To patch the runInstaller itself, run:

$ 
2.4.19
$ 

 - Welcome Screen:      
 - File Locations:      
 - Available Products:  
 - Summary:             
 - 

Ensure that no Oracle processes are running:

Now to patch Oracle9iR2, run:

$     # it is important that this variable is set!
2.4.19
$ 

 - Welcome Screen:      
 - File Locations:      
 - Available Products:  
 - Summary:             
                        
 - 

After the 9.2.0.6 patchset has been applied, download the patch 4190568 from http://metalink.oracle.com. Also, download the opatch utility for release 10.1.0.2 (patch 2617419) from http://metalink.oracle.com.

To install opatch, run:

$ 
$ 
$ 
$ 

To apply the 4190568 patch, run

$ 
$ 
$ 
$ 

If you intend to use Direct I/O Support, you must also download and apply patch 2448994.

Now you should be able to create a database with dbca:

When dbca died on my system with the following error:

I executed the following command:

and restarted dbca. If you know a better solution, let me know!

Startup and Shutdown of the Oracle 9i Database

sqlplus:

svrmgrl is not supported any more. You can now do everything with sqlplus.

For instance, to startup the database, run the following commands:

oracle$ 
SQL> 
SQL> 

The slash connects you to the schema owned by SYS. So in this example you will be connected to the schema owned by SYS with the privilege SYSDBA. SYSDBA gives you the following privileges:
  - sysoper privileges WITH ADMIN OPTION
  - create database
  - recover database until

$ORACLE

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8102208/viewspace-471544/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8102208/viewspace-471544/