How to install Oracle SOA Suite On Windows XP

In this post I will document my experience of installing Oracle SOA Suite on Windows XP. No I am not switching and I’m still a Microsoft developer by heart. But I do feel that for me to improve my craft I must also understand how things are done in other camps such as Oracle, SUN, IBM etc.

The version I installed is Oracle Application Server SOA Suite 10.1.3.1.10 and I decided to do a basic installation which installs Oracle Lite database as opposed to a full blown Oracle database. You can think of Oracle Lite as similar to SQL Server Express.

Installation can be started by clicking setup.exe after extracting all files form the downloaded zip. Setup.exe will conduct a quick check to see that right amount of disk space is available. After this the installation wizard starts.

Screen 1

This screen allows me to make a choice between a Basic Install or Advance Install and supply a name for my Oracle Application Server and passwords for admin account. Note that you cannot change the admin user name and database type will be Oracle OLite. Next thing is to click on Install button.

Screen 2

The wizard at this stage will happily go and install the software. This screen shows that my installation is at 74%.

Error Mesage

At almost 99% the installer may throw an error.

I just clicked okay few times and the error went away. The installer continued fine after that.

Screen 3

This screen shows that the installer is configuring required components which are required for applications in the suite.

Screen 4

This final screen tells me that the installation was successful. Hurray!

After clicking exit, the start page for Oracle Suite appears.

Conclusion

Overall experience of installing Oracle SOA Suite on WindowsXP is pleasant. The installer other than a minor hitch does a good job without nagging you with too many questions.

Now that I have the suite installed, I’ll play with it a bit more and post my learning experiences here.

You can download Oracle SOA Suite for Windows using the quick search engine.

YOU CAN USE QUICK SEARCH ENGINE IN THE TOP FOR MORE DOWNLOADS OR DETAILS.

How to Install Oracle Client to Windows XP

The Oracle database is a database management system (RDBMS) software program developed and produced by Oracle Corporation. Oracle has a strong presence in the business and corporate community. The Oracle Client, used in connection with the databases, can be installed on a variety of platforms. Learning to install the Oracle client on Windows XP will help you get the most out of your office environment.

Instructions

Things You’ll Need:

• Oracle Database installation disk

YOU CAN USE QUICK SEARCH ENGINE IN THE TOP FOR MORE DOWNLOADS OR DETAILS.

Step1

Determine that your computer meets the system requirements for an Oracle installation. The computer must have 256 megabytes of RAM (or more), a minimum of 216 megabytes of free hard-drive space and a computer processor with a speed of at least 550 megahertz.

Step2

Insert the Oracle installation disk into the CD-ROM drive of your computer.

Step3

Click the "Start" menu in the lower left-hand corner of the Windows XP screen and select "My Computer." Double-click the CD drive. Typically, this drive is drive E:\\. Open the "Client" folder.

Step4

Double-click the setup.exe file to launch the Oracle Universal Installer. This installer program will guide you through the Oracle client installation. The entire process is automated. Do not close the installation dialog box until the entire process is complete. Depending on the speed of your computer processor, this may take several minutes.

Step5

Click the "Next" button in the "Welcome" window of the Oracle Universal Installer.

Step6

Choose the type of Oracle Client you wish to install on the Windows XP computer. You may choose Instant Client, Administrator, Runtime or a Custom installation. Click the "Next" button.

Step7

Name the Oracle Client home directory and click "Next."

Step8

Click the "Install" button in the "Summary" window to begin the installation process. Follow the onscreen prompts. You may be required to name the database the client is connecting to, as well as the manner in which you plan to connect (e.g. an IP network).

Step9

Click the "Exit" button at the end of the installation process to close and exit the Oracle Universal Installer program.

YOU CAN USE QUICK SEARCH ENGINE IN THE TOP FOR MORE DOWNLOADS OR DETAILS.

How to install Oracle 9 client and ODBC on Windows 2000 and XP

Make sure you have rights to install software on your PC before you start.

• Click on the Install/Deinstall option which appears when the CD is loaded. You can check what is installed at this stage.
• On the File Locations screen, accept the Oracle Home name as Oracle90 and suggested path C:\oracle\ora90. If you have two hard disks, accept the drive it wants to use since the installation will fail otherwise.
  Note that some stuff will get put into Program Files though and there seems to be no way of avoiding this.
• Note that Oracle documentation is held on a separate CD-ROM.

Available products are now loaded

YOU CAN USE QUICK SEARCH ENGINE IN THE TOP FOR MORE DOWNLOADS OR DETAILS.

Types of installation

There are 3 types of installation:

• Administrator : management console, management tools, networking services, utilities, basic client software (647Mb). Not relevent unless you want the database administrator tools
• Runtime : tools for developing applications, netwoking services, basic client software, networking services and basic client software (486Mb). Get too many tools!
• Custom: choose own components- best option as you get more control over installation

Custom Installation

If you just want ODBC,choose Custom and then deselect the options in the correct order (if you deselect in the wrong order you will not be able to deselect ones you do not want).

• deselect Oracle HTTP server
• deselect Workflow client
• optionally select/deselect Windows Documentation
• deselect Oracle Internet Directory client (this must be done after deselecting HTTP)
• deselect Enterprise manager (this is only for database administrators)
• make sure Net services is ticked
• make sure Universal installer is ticked so that you can check what is installed
• make sure the Programmer component is selected, expand and make sure ODBC is ticked, and tick whatever else you need. You are unlikely to need the Cobol and C options. Oracle provider for OLEDB goes together with Oracle Objects for OLE and is unlikely to be used, as is the object type translater and the call interface. XML and XML SQL also go together (only select them if you want to use XML).
• make sure you select the security option for network security
• select net9 client. This will install:
  • Net9 client (to talk to remote Oracle database)
  • Net9 Assistant (
  • Net9 Configuration Assistant
  • Sqlplus (to be able to type in sql commands)
• Sit around for about 10 minutes while it installs loads of products including JDBC.
• It should then get to the configuration assistant and run it. Sometimes you just sit there like an idiot wondering why nothing is happening while being told that the network assistant is running. If this is the case, press Alt/tab and select the java coffee cup- for some reason this is not shown on the open programmes panel at the bottom of the screen.

Oracle Network Configuration Assistant

The assistant will take you through the configuration either for Directory Usage Naming Methods or you can choose to perform a typical configuration.

Leave typical configuration unticked and select next.

You are then given the choice to complete the configuration now or defer.
Answer No.

oracle/ora90/network/admin/ folder, renaming any default sqlnet.ora file if it exists. This is the recommended thing to do.
The sqlnet.ora file looks like:

# C:\ORANT\NET80\ADMIN\SQLNET.ORA Configuration  File:C:\ORANT\net80\admin\sqlnet.ora # Generated by Oracle Net8 Assistant  NAME.DEFAULT_ZONE = world  #sqlnet.authentication_services = (NONE)  SQLNET.EXPIRE_TIME = 0  NAMES.DIRECTORY_PATH= (ONAMES,TNSNAMES, HOSTNAME) #names.directory_path = (TNSNAMES)  NAMES.DEFAULT_DOMAIN = bris.ac.uk #NAMES.DEFAULT_DOMAIN = world  NAMES.PREFERRED_SERVERS =    (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = oranamesrvr0.bris.ac.uk)(PORT = 1532))      (ADDRESS = (PROTOCOL = TCP)(HOST = oranamesrvr1.bris.ac.uk)(PORT = 1575))      (ADDRESS = (PROTOCOL = TCP)(HOST = oranamesrvr2.bris.ac.uk)(PORT = 1575))      (ADDRESS = (PROTOCOL = TCP)(HOST = oranamesrvr3.bris.ac.uk)(PORT = 1575))      ) AUTOMATIC_IPC = OFF #TRACE_LEVEL_CLIENT = OFF 

You can pick up the tnsnames.ora file (if you find you need it- for example if you get unrecognised service name) from a previous installation or from Maggie Shapland and paste it into the newly created oracle/ora90/network/admin/ folder making sure the old tnsnames.ora that was created by default if you did not exit, is renamed first. For each connection, the entry looks like (where datasource, machine_address, and database_name must be specified):

 datasource =   (DESCRIPTION =     (ADDRESS_LIST =        (ADDRESS = (PROTOCOL = TCP)(HOST = machine_address)(PORT =1521))     )     (CONNECT_DATA =       (sid = database_name)     )   )  

eg

 hprod.bris.ac.uk =    (DESCRIPTION =      (ADDRESS_LIST =          (ADDRESS =            (COMMUNITY = tcp.bris.ac.uk)           (PROTOCOL = TCP)           (Host = sunshine.bris.ac.uk)           (Port = 1521)         )     )     (CONNECT_DATA = (SID = hprod)     )   ) 

If you really want to carry on with the network configuration, you are given the choice to complete the configuration or defer. Make sure you tick No at this stage

On naming methods configuration, choose host name

The version of Oracle is 8i or later

The service name is the name of the database

the network protocol is tcp

the hostname is the name of the server- which should be suffixed with .bris.ac.uk

the port number is 1521

At this stage you can perform a test, but be aware the default test username/password is scott/tiger which is not installed in this database, so try typing the username, password and service name you have been given

This will create tnsnames.ora and sqlnet.ora, but the domain name will have an extra suffix of your department, so rename these two files and copy in the files you have been given. You can use Notepad to edit

Connection Timeout

You are now ready to stop the connection being timed out after the default 10 minutes.

Run regedit as a Start command. This will edit the registry

Find connectiontimeout

Choose Modify and show decimal

Change 600 to 0 (so does not disconnect) or to something bigger (the number represents seconds)

Testing the connection

select the DOS command prompt from Accessories

Type tnsping hprod
(one of the Bristol databases, otherwise type the name of one you want to test). It should identify the connection and confirm OK

Creating a Data Source

You need to create a data source to be able to use Access as a front end to Oracle

• Select Microsoft ODBC administrator from Oracle/Network Adminstration
• Data source types
  • Select the user DSN tab if the data source will only be used from your PC for the logged on username (Typically, entries in this tab are added by applications that are installed locally and that use a data source, such as Microsoft Office) else select the System DSN tab.
  • The System DSN tab allows you to configure a specific data source to a client-server database. Using the System DSN tab to configure a connection will write an entry for that connection in the registry in HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI\ODBC Data Sources. The advantage of this is faster access, since it is in the registry. The disadvantage is that it will have to be created on each local machine.
  • The File DSN tab does the same thing as the System DSN tab, but the File DSN tab will create a file stored on the local server with the extension .dsn on the local drive in the folder at C:\Program Files\Common Files\ODBC\Data Sources. The advantage of this approach is that the file can be easily copied to other machines.
• Press Add
• You will be asked which driver to use. Choose Oracle in OraHome90 NOT Microsoft ODBC for Oracle since this is the driver that you have just installed and will not cause problems such as described in ODBC PROBLEMES USE THE QUICK SEARCH ENGINE.
• Choose a data source name- can be the same as the data source service that you specified above eg xxx or perhaps the username to be used
• Choose a description eg xxx
• Give a data source service name. This must relate to the definition in the tnsnames.ora file eg xxx
• Give the default username for that datasource
• Click OK
• You can now test the data source by using ODBC test from Oracle/Network Adminstration
• Press Connect
• Choose a data source from the Machine Data Source tab
• Give the passwd for the given service name and username
• Type some SQL eg select table_name from user_tables
• Press the Execute button and hopefully some data will appear
• If something goes wrong, test the service name by typing tnsping xxx on the Command Prompt found in Program /Accessories on the Start menu to check the database is up
• The Connection Pooling tab allows you to enable and configure connection pooling for a specified driver. Connection pooling uses a connection to a data source from a pool of connections, so that a connection does not have to be reestablished each time you access the data source. Unless you are having trouble establishing or maintaining a connection, you probably will not use this tab. Connection pooling timeout is set to 120 second by default.

YOU CAN USE QUICK SEARCH ENGINE IN THE TOP FOR MORE DOWNLOADS OR DETAILS.

Installing Oracle on Windows server

The following outline describes the steps required to install Oracle9i (version 9.0.1.1) on the Microsoft Windows 2000 operating system. It is assumed that this is a fresh install and that no other Oracle products are installed at this time. If this is not the case, then these instructions may not work on your system.

Where to get Oracle9i for Windows NT/2000

YOU CAN USE QUICK SEARCH ENGINE IN THE TOP FOR MORE DOWNLOADS OR DETAILS.

These instructions may or may not be applicable for other versions of Oracle (such as Personal Oracle9i, Oracle9i Lite) or for other Microsoft Windows operating systems (such as Windows 98 or Windows 95). For the record: No Oracle Product will work on Windows ME or Windows XP Home Edition so don't even bother.

Checklist

Before you even start this process you should have:

• A Pentium III or Pentium 4 based PC with at least 800 MHz processor, 256 MB of RAM (512 is much better) and at least 10 Gigabytes of free disk space.
• If you only have 256 MB of RAM, make sure you have Windows manage at least 400 MB swap file (virtual memory).
• This machine MUST be running Windows 2000 with service pack 1 or (preferably) 2 installed. If you are running MS IIS, disable the web server (running on Port 80 by default) before starting the Oracle 9i installation.
• At least 10 GB of free disk space:

     Space to download or copy source ZIP files:  1.5 GB
    Space to unpack source ZIP files:            1.5 GB
    Space to install Oralce9i Software:          2.0 GB
    Space for Oracle data files (varies):        2.0 to 5.0 GB
  

The Installation Process

As with most Windows installation programs, inserting the CD-ROM (ordered or purchased from Oracle) into the CD-ROM drive automatically executes the setup program. (If this does not happen, use the Windows Explorer to view the contents of your CD-ROM drive and double click on the "setup" program there).

If you downloaded the Oracle9i from Oracle Technet, then you need to unzip the files into a three temporary directories and double click on the setup.exe program in the Disk1 directory) to get the installation process started.

The following Welcome window will appear:

It is assumed that this is a fresh install so no other Oracle products should be installed at this time.

Click on the Next button to move to the File Locations screen as shown below:

In this screen, the Source and Destination locations must be selected.

The Source path should reflect either your CD-ROM or the directory in which you unzipped the source files. Leave this as the default. In the example above, the source files were unzipped into c:\source\Oralce\9i\NT20009011\Disk1 directory.

For the Destination, leave the Oracle Home named OraHome90 as the default. Choose a hard disk drive that has at least 10 gigabytes of free space. In the example here, we are using the C: drive.

Leave the \Oracle\Ora90 path as it is (the default). If you must change this to a different drive, only change the drive letter and not the directories.

Click on the Next button to load the Product information. This may take up to 2 minutes (depending on the speed of your machine). Once the product information has been read, the following 3 "Available Products" options are presented:

Make sure the Oracle9i Database 9.0.1.1.1 is selected and click on the Next button.

The "Installation Types" screen will appear next. For this installation, we chose the Enterprise Edition.

The "Database Configuration" screen will appear next:

For this install, we chose the "General Purpose" Database option. Click on the Next button to continue.

The next step is to identify the database using the Global database name:

If some default Global database name and SID are given, keep them. Otherwise, use the following (make a note of these for later on):
Global Database Name is orcl
Oracle SID is orcl

Click on the Next button to continue to the "Data File Location " screen

In this step, you need to select where the Oracle data files will be located. In large operations, we typically keep the data files on a separate disk (or disks), however, for this install, we are storing the data files in the same C:\oracle directory tree. Keep the default as shown and click on the Next button to continue.

In the next screen, choose the default character set for the database:

Click on the Next button to move to the "Summary" screen:

In this screen (shown above), the products and files that will be installed are summarized. Note that in this example, it will take 1.5 GB MB of disk space for the installation of the software. Additional space will be required for the default database.

If everything looks OK at this point, click on the Install button to begin the installation.

During the install, you will notice various Oracle products being copied over to the hard disk. For example, in the above figure, a portion of the Oracle Enterprise Manager is being installed.

Once the installation is completed, the next step will be to configure the various additional services and the database. This is shown below:

Each of the configuration programs will be executed in turn. The HTTP Server (Oracle/Apache) should launch automatically and open up TCP/IP port 80. You should notice a new Command window as follows:

Oracle HTTP Server Powered by Apache/1.3.12 (Win32) ApacheJServ/1.1
mod_ssl/2.6.4 OpenSSL/0.9.5a mod_perl/1.24 running...

The Net Configuration Assistant and Oracle Intelligent Agent should run automatically and not prsent any sustained screens.

The Oracle Database Configuration Assistant will appear for some time while the default database is created and opened. As below:

Once the default database has been installed, the following screen will appear:

Clicking on the Password Management button and change the default passwords for the SYS, SYSTEM, SCOTT and DBSNMP accounts as shown below:

Click the OK button when done.

This should conclude the configuration of the database and the "End of Installation" screen should appear as below. Click on the Exit button and click on the following Yes button to confirm exiting the Installation program.

At this point, be sure to reboot your computer so any final changes can take affect. In particular, the path c:\oracle\ora90\bin will be added to the PATH environment variable.

---

New Program Groups

After Oracle9i is installed, you will notice several new program groups in the Start menu.

These include:

• Oracle Installation Products
  Tools to help manage the installation and removal of Oracle products on the machine.
• Oracle - OraHome90
  The set of tools used to work with Oracle90. These include:
  • Application Development - Tools to develop Oracle applications including SQL*Plus
  • Configuration and Migration Tools - Tools to migrate older Oracle databases to version 9i
  • Enterprise Management Packs
  • Enterprise Manager Quick Tours
  • Integrated Management Tools
  • Oracle HTTP Server

---

Starting and Stopping the Database

Under Windows NT and Windows 2000, the Oracle 9i database runs automatically as a service. Below is a view of the Windows 2000 Services mangement console showing the services installed by default:

Note the last one OracleServerORCL is the actual database process itself. OracleOraHome90TNSListener is the listener process for remote connections to the database. OracleOraHome90Agent is the Oracle Agent used to communicate with management services. Finally, the OracleOraHome90HTTPServer is the Oracle/Apache web server.

Since the OracleServerORCL service is set to start automatically, the database wll start and mount each time the computer is started up. To manage the database processes directly, one can use the Enterprise Manager Console in Stand-alone mode. From the Start menu, choose Programs -> Oracle - OraHome90 -> Enterprise Manager Console and select Launch Standalone. The following screen should appear:

Click on the plus sign to expand the Databases branch and then once again to expand the ORCL branch. When prompted for username and password, use the SYSTEM account and choose to log in as SYSDBA. In SYSDBA mode, the SYSTEM user can perform most any manipulation of the database.

Once logged in, clicking on the Instance tree and then the Configuration tree should display the current state of the database:

---

Testing the Installation

Once the database is running, the SQL*Plus tool can be used to connect to the database.

Go to the Start -> Programs -> Oracle - OraHome90 -> Application Development program group and run the SQL Plus application. Once SQL Plus is running, you will be prompted for 3 things: Username, password and Host String.

The default Database Administrator's account has a username of SYSTEM and a default password of MANAGER. You may have changed the SYSTEM account password in a previous step so use the new password.

Fill in the Username and password fields with the SYSTEM account and leave the Host String field blank. Since we are connecting to a local Oracle database, no Host String is required. Click on the OK button as shown below:

If the database is running and the username and password are typed correctly, SQL*Plus should log the SYSTEM user in and present the SQL> prompt as shown below:

By default, you can also log in with the SCOTT/TIGER account. That is, there is a demo account already set up in the database with username SCOTT and password TIGER. Many of the examples in the Oracle documentation use the tables included in the SCOTT user's account.

---

Using the On-Line Help

If you elected to install the Personal Oracle8i documentation to your hard disk, you can access the HTML help files by going to the Start -> Programs -> Oracle - OraHome90 program group and selecting the Release Documentation item.

Your default web browser will be launched and the opening page for the Oracle documentation will be displayed.

YOU CAN USE QUICK SEARCH ENGINE IN THE TOP FOR MORE DOWNLOADS OR DETAILS.

How To install Oracle On Linux Red Hat Fedora Core 4, 3, 1, RH 9 on x86 and x86-64 (AMD64/EM64T) Architecture

The following procedure is a step-by-step guide (Cookbook) with tips and information for installing Oracle Database 10g on Red Hat Fedora Core 4, 3, 1, RH 9 on x86 and x86-64 (AMD64/EM64T) Architecture

YOU CAN USE QUICK SEARCH ENGINE IN THE TOP FOR MORE DOWNLOADS OR DETAILS.

Download Oracle10g Software and Burning Oracle10g CDs

For Download Oracle use the quick Search Engine.
NOTE: To install a Oracle Database 10g (without RAC) you only need to download the database file ship.db.lnx32.cpio.gz, or 10201_database_linux_x86_64.cpio etc.

Compute a cyclic redundancy check (CRC) checksum for the downloaded files and compare the checksum numbers against the numbers posted on OTN's website. For example:

cksum ship.db.lnx32.cpio.gz

Uncompress the downloaded file(s):

gunzip ship.db.lnx32.cpio.gz

Unpack ship.db.lnx32.cpio:

$ cpio -idmv <>
Disk1/stage/Components/oracle.server/10.1.0.3.0/1
Disk1/stage/Components/oracle.server/10.1.0.3.0
Disk1/stage/Components/oracle.server
Disk1/stage/Components/oracle.tg/10.1.0.3.0/1/DataFiles
Disk1/stage/Components/oracle.tg/10.1.0.3.0/1
Disk1/stage/Components/oracle.tg/10.1.0.3.0
Disk1/stage/Components/oracle.tg
Disk1/stage/Components/oracle.assistants.dbca/10.1.0.3.0/1/DataFiles/doc.3.1.jar
Disk1/stage/Components/oracle.assistants.dbca/10.1.0.3.0/1/DataFiles/class.jar
...

I executed the following command to burn the Disk1 directory on a CD:

# mkisofs -r Disk1 | cdrecord -v dev=0,0,0 speed=20 -

(Drives' speed varies; you can get the dev numbers when you execute cdrecord -scanbus).

Note that 10g R2 won't fit on a single CD since it has over 780MB.

YOU CAN USE QUICK SEARCH ENGINE IN THE TOP FOR MORE DOWNLOADS OR DETAILS.

Checking Memory and Swap Space

Oracle says that the system must have at least 512MB of RAM and 1GB of swap space or twice the size of RAM. And for systems with more than 2 GB of RAM, the swap space can be between one and two times the size of RAM. You might also want to check out The quick search Engine
For test sake I tried to install an Oracle Database 10g (Type: General Purpose Database) on a little PC with 256MB of RAM and 1 GB of swap space. I was able to get a 10g database up and running on this little PC without a problem.

To check the size of physical memory, execute:

grep MemTotal /proc/meminfo

To check the size of swap space, execute:

grep SwapTotal /proc/meminfo

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

su - root
dd if=/dev/zero of=tmpswap bs=1k count=900000
chmod 600 tmpswap
mkswap tmpswap
swapon tmpswap

To disable the temporary swap space execute the following commands:

su - root
swapoff tmpswap
rm tmpswap

YOU CAN USE QUICK SEARCH ENGINE IN THE TOP FOR MORE DOWNLOADS OR DETAILS.

Checking /tmp Space

According to Oracle's documentation, the Oracle Universal Installer (OUI) requires up to 400 MB of free space in the /tmp directory. But OUI checks if /tmp is only greater than 80 MB.

To check the space in /tmp, run:

$ df /tmp

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

su - root
mkdir //tmp
chown root.root //tmp
chmod 1777 //tmp
export TEMP=/           # used by Oracle
export TMPDIR=/         # used by Linux programs like the linker "ld"

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

su - root
rmdir //tmp
unset TEMP

YOU CAN USE QUICK SEARCH ENGINE IN THE TOP FOR MORE DOWNLOADS OR DETAILS.
unset TMPDIR

Checking Software Packages (RPMs)

General

Before you install an Oracle Database 10g you need to check the system for required RPMs. On my systems I usually install a minimum list of RPMs which usually requires the installation of additional packages for Oracle databases. Always ensure to use the latest RPMs and kernels!

For 10g R2 (64-bit) on RHEL 4 x86_64,

  binutils-2.15.92.0.2-10.EL4
 compat-db-4.1.25-9
 control-center-2.8.0-12
 gcc-3.4.3-9.EL4
 gcc-c++-3.4.3-9.EL4
 glibc-2.3.4-2
 glibc-common-2.3.4-2
 gnome-libs-1.4.1.2.90-44.1
 libstdc++-3.4.3-9.EL4
 libstdc++-devel-3.4.3-9.EL4
 make-3.80-5
 pdksh-5.2.14-30
 sysstat-5.0.5-1
 xscreensaver-4.18-5.rhel4.2

Also ensure to install the libaio-0.3.96 RPM or a newer version! Otherwise the OUI prerequisite check will fail.

To check if you are running the x86_64 kernel on a x86_64 platform, run:

  # uname -mi
 x86_64 x86_64

To check the RPMs, run:

  rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE}  (%{ARCH})\n' \
             binutils compat-db control-center gcc gcc-c++ glibc glibc-common gnome-libs \
             libstdc++ libstdc++-devel make pdksh sysstat xscreensaver libaio

It is important to have these x86_64 RPMs installed. The above command will list the architecture of each binary package. You will see that some RPMs are installed twice when you run this command (x86 RPM and x86_64 RPM). You need to ensure that all required x86-64 RPMs listed here are installed.


For 10g R2 (32-bit) on RHEL 4 x86,

  binutils-2.15.92.0.2-10.EL4
 compat-db-4.1.25-9
 control-center-2.8.0-12
 gcc-3.4.3-9.EL4
 gcc-c++-3.4.3-9.EL4
 glibc-2.3.4-2
 glibc-common-2.3.4-2
 gnome-libs-1.4.1.2.90-44.1
 libstdc++-3.4.3-9.EL4
 libstdc++-devel-3.4.3-9.EL4
 make-3.80-5
 pdksh-5.2.14-30
 sysstat-5.0.5-1
 xscreensaver-4.18-5.rhel4.2

Also ensure to install the libaio-0.3.96 RPM or a newer version! Otherwise the OUI prerequisite check will fail.

To check the RPMs, run:

  rpm -q binutils compat-db control-center gcc gcc-c++ glibc glibc-common gnome-libs \
        libstdc++ libstdc++-devel make pdksh sysstat xscreensaver libaio

For 10g R2 (32-bit) on RHEL 3 x86

  make-3.79.1
 gcc-3.2.3-34
 glibc-2.3.2-95.20
 compat-db-4.0.14-5
 compat-gcc-7.3-2.96.128
 compat-gcc-c++-7.3-2.96.128
 compat-libstdc++-7.3-2.96.128
 compat-libstdc++-devel-7.3-2.96.128
 openmotif21-2.1.30-8
 setarch-1.3-1

Also ensure to install the libaio-0.3.96-5 RPM or a newer version! Otherwise the OUI prerequisite check will fail.

To check the RPMs, run:

  rpm -q make gcc glibc compat-db compat-gcc compat-gcc-c++ compat-libstdc++ compat-libstdc++-devel openmotif21 setarch libaio

For 10g R1 (64-bit) on RHEL 3 x86_64

  make-3.79.1
 gcc-3.2.3-34
 glibc-2.3.2-95.20
 glibc-devel-2.3.2-95.20
 glibc-devel-2.3.2-95.20   (32 bit)
 compat-db-4.0.14-5
 compat-gcc-7.3-2.96.128
 compat-gcc-c++-7.3-2.96.128
 compat-libstdc++-7.3-2.96.128
 compat-libstdc++-devel-7.3-2.96.128
 gnome-libs-1.4.1.2.90-34.1   (32 bit)
 openmotif21-2.1.30-8
 setarch-1.3-1
 libaio-0.3.96-3
 libaio-devel-0.3.96-3

To check if you are running the x86_64 kernel on a x86_64 platform, run:

  # uname -mi
 x86_64 x86_64

To check the RPMs, run:

  rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE}  (%{ARCH})\n' \
             make gcc glibc glibc-devel compat-db compat-gcc compat-gcc-c++ compat-libstdc++ \
             compat-libstdc++-devel gnome-libs openmotif21 setarch libaio libaio-devel

It is important to have the right x86 and x86_64 RPMs installed. The above command will list the architecture of each binary package. And as you can see in the above list, glibc-devel and other RPMs are listed twice. This means that you have to install packages for both architectures, x86 and x86_64.


For 10g R1 (32-bit) on RHEL 3 x86, package versions or higher:

  make-3.79.1
 gcc-3.2.3-34
 glibc-2.3.2-95.20
 compat-db-4.0.14-5
 compat-gcc-7.3-2.96.128
 compat-gcc-c++-7.3-2.96.128
 compat-libstdc++-7.3-2.96.128
 compat-libstdc++-devel-7.3-2.96.128
 openmotif21-2.1.30-8
 setarch-1.3-1

To check the RPMs, run:

  rpm -q make gcc glibc compat-db compat-gcc compat-gcc-c++ compat-libstdc++ compat-libstdc++-devel openmotif21 setarch

For 10g R1 (32-bit) on RHEL 2.1, package versions or higher:

  make-3.79.1
 glibc-2.2.4-32
 gcc-2.96-128
 gcc-c++-2.96-128
 libstdc++-2.96-128
 openmotif-2.1.30-11

To check these RPMs, run:

  rpm -q make glibc gcc gcc-c++ libstdc++ openmotif

The installation of an Oracle 10g Database worked fine without installing any compatibility RPMs (e.g. compat-gcc, compat-libstdc++). However, since it's listed as a requirement for RHEL 3 I'd recommend to install it on RHEL3 and on newer releases as well. It's not a requirement for RHEL 2.1 though.

For RHEL 3 and RHEL 2.1 it is also important to have binutils-2.11.90.0.8-12 or a newer version installed. Make sure you have the binutils RPM installed on other releases as well like Fedora Core:

rpm -q binutils

NOTE: OUI for x86 will also complain if the openmotif package is missing (don't confuse it with the openmotif21 package). Also, Red Hat changed the version naming schema from openmotif-2.2.2-16 in the original release to openmotif-2.2.3-5.RHEL3.2 in RHEL3 Update 5. This seems to confuse OUI in RHEL3 U5 since it complaining that it can't find the right openmotif version. I ignored this. The openmotif-2.2.3-5.RHEL3.2 is just a newer version of openmotif-2.2.2-16 which worked fine and I didn't have any problems. To check the RPM, run:

rpm -q openmotif

Also, make sure the redhat-release package is installed. Earlier versions of e.g. RHEL 3 didn't install it by default when you selected a minimum system installation:

rpm -q redhat-release

The setarch utility is new in RHEL4, RHEL3 and Fedora Core. It is used to tell the kernel to report a different architecture than the current one. It is also used to emulate a 3GB virtual address space for applications that don't run properly with a larger virtual address space. To check the RPM, run:

rpm -q setarch

Installing the RPMs


10g R2 on RHEL AS 4 (x86_64)

On my RHEL AS 4 x86_64 system I installed the following RPMs and dependencies:

  rpm -Uvh gcc-3.4.4-2.x86_64.rpm \
          gcc-c++-3.4.4-2.x86_64.rpm \
          libstdc++-devel-3.4.4-2.x86_64.rpm \
          cpp-3.4.4-2.x86_64.rpm \
          glibc-devel-2.3.4-2.13.x86_64.rpm \
          glibc-headers-2.3.4-2.13.x86_64.rpm \
          glibc-kernheaders-2.4-9.1.98.EL.x86_64.rpm

 rpm -Uvh gnome-libs-1.4.1.2.90-44.1.x86_64.rpm \
          compat-db-4.1.25-9.x86_64.rpm \
          ORBit-0.5.17-14.x86_64.rpm \
          gtk+-1.2.10-33.x86_64.rpm \
          imlib-1.9.13-23.x86_64.rpm \
          libpng10-1.0.16-1.x86_64.rpm \
          gdk-pixbuf-0.22.0-16.el4.x86_64.rpm \
          libungif-4.1.3-1.x86_64.rpm

 rpm -Uvh sysstat-5.0.5-1.x86_64.rpm

Note that you also need to install the following i386 and x86_64 RPMs if not already installed, otherwise you will get various different error messages.
For a detailed list of error messages, USE THE QUICK SEARCH ENGINE.

  rpm -Uvh xorg-x11-deprecated-libs-6.8.2-1.EL.13.20.i386.rpm \
          xorg-x11-libs-6.8.2-1.EL.13.20.i386.rpm \
          xorg-x11-Mesa-libGL-6.8.2-1.EL.13.20.i386.rpm \
          expat-1.95.7-4.i386.rpm \
          fontconfig-2.2.3-7.i386.rpm \
          freetype-2.1.9-1.i386.rpm \
          zlib-1.2.1.2-1.2.i386.rpm

  rpm -Uvh libaio-0.3.103-3.x86_64.rpm

 rpm -Uvh compat-libstdc++-33-3.2.3-47.3.x86_64.rpm

 rpm -Uvh glibc-devel-2.3.4-2.13.i386.rpm \
          libgcc-3.4.4-2.i386.rpm

If you haven't installed Update 3 or later, don't forget to install an updated binutils RPM :

   rpm -Uvh --force binutils-2.15.92.0.2-13.0.0.0.2.x86_64.rpm

If you don't install a newer binutil RPM from Oracle or RHN, then you will get the following error message:

/usr/bin/ld: /u01/app/oracle/oracle/product/10.2.0/db_1/lib//libirc.a(fast_memcpy.o):
   relocation R_X86_64_PC32 against `_memcpy_mem_ops_method' can not be usedwhen making a shared object; recompile with -fPIC
/usr/bin/ld: final link failed: Bad value
collect2: ld returned 1 exit status

For more information on this bug, see Quick SEARCH ENGINE IN THE TOP .

I don't know why the control-center RPM and the xscreensaver RPM are listed as requirements. On my system I did not install these RPMs since I'm against installing desktop stuff on servers, see list below. When I installed 10g R2 I did not experience any problems when these RPMs were missing. But just for completeness I've listed all the RPMs you may have to install if you want to install the control-center and xscreensaver RPMs unless you ignore dependencies:

   rpm -Uvh control-center-2.8.0-12.rhel4.2.x86_64.rpm \
           xscreensaver-4.18-5.rhel4.9.x86_64.rpm \
           eel2-2.8.1-2.x86_64.rpm \
           gail-1.8.0-2.x86_64.rpm \
           gnome-desktop-2.8.0-5.x86_64.rpm \
           gnome-icon-theme-2.8.0-1.el4.1.3.noarch.rpm \
           libgail-gnome-1.1.0-1.x86_64.rpm \
           libxklavier-1.02-3.x86_64.rpm \
           metacity-2.8.6-2.8.x86_64.rpm \
           nautilus-2.8.1-4.x86_64.rpm \
           startup-notification-0.7-1.x86_64.rpm \
           xloadimage-4.1-34.RHEL4.x86_64.rpm \
           xorg-x11-Mesa-libGLU-6.8.2-1.EL.13.20.x86_64.rpm \
           at-spi-1.6.0-3.x86_64.rpm \
           desktop-backgrounds-basic-2.0-26.2.1E.noarch.rpm \
           eog-2.8.1-2.x86_64.rpm \
           gnome-panel-2.8.1-3.3E.x86_64.rpm \
           gnome-vfs2-smb-2.8.2-8.2.x86_64.rpm \
           hicolor-icon-theme-0.3-3.noarch.rpm \
           libexif-0.5.12-5.1.x86_64.rpm \
           librsvg2-2.8.1-1.x86_64.rpm \
           nautilus-cd-burner-2.8.3-6.x86_64.rpm \
           redhat-artwork-0.120.1-1.2E.x86_64.rpm \
           scrollkeeper-0.3.14-3.x86_64.rpm \
           cdrecord-2.01.1-5.x86_64.rpm \
           docbook-dtds-1.0-25.noarch.rpm \
           evolution-data-server-1.0.2-9.x86_64.rpm \
           intltool-0.31.2-1.x86_64.rpm \
           libcroco-0.6.0-4.x86_64.rpm \
           libgnomeprint22-2.8.0-3.x86_64.rpm \
           libgnomeprintui22-2.8.0-1.x86_64.rpm \
           libgsf-1.10.1-1.x86_64.rpm \
           libwnck-2.8.1-1.rhel4.1.x86_64.rpm \
           mkisofs-2.01.1-5.x86_64.rpm \
           samba-common-3.0.10-1.4E.2.x86_64.rpm \
           ghostscript-7.07-33.x86_64.rpm \
           ghostscript-fonts-5.50-13.noarch.rpm \
           gnutls-1.0.20-3.2.1.x86_64.rpm \
           libgnomecups-0.1.12-5.x86_64.rpm \
           libsoup-2.2.1-2.x86_64.rpm \
           openjade-1.3.2-14.x86_64.rpm \
           perl-XML-Parser-2.34-5.x86_64.rpm \
           sgml-common-0.6.3-17.noarch.rpm \
           urw-fonts-2.2-6.1.noarch.rpm \
           xml-common-0.6.3-17.noarch.rpm \
           VFlib2-2.25.6-25.x86_64.rpm \
           chkfontpath-1.10.0-2.x86_64.rpm \
           perl-URI-1.30-4.noarch.rpm \
           perl-libwww-perl-5.79-5.noarch.rpm \
           xorg-x11-font-utils-6.8.2-1.EL.13.20.x86_64.rpm \
           perl-HTML-Parser-3.35-6.x86_64.rpm \
           xorg-x11-xfs-6.8.2-1.EL.13.20.x86_64.rpm \
           perl-HTML-Tagset-3.03-30.noarch.rpm \
           ttmkfdir-3.0.9-14.1.EL.x86_64.rpm

10g R2 on RHEL AS 4 (x86)

On my RHEL AS 4 x86 system I had to install the following RPMs and dependencies to meet the software requirements:

   rpm -Uvh gcc-3.4.4-2.i386.rpm \
           gcc-c++-3.4.4-2.i386.rpm \
           libstdc++-devel-3.4.4-2.i386.rpm \
           glibc-devel-2.3.4-2.13.i386.rpm \
           glibc-headers-2.3.4-2.13.i386.rpm \
           glibc-kernheaders-2.4-9.1.98.EL.i386.rpm

  rpm -Uvh gnome-libs-1.4.1.2.90-44.1.i386.rpm \
           compat-db-4.1.25-9.i386.rpm \
           ORBit-0.5.17-14.i386.rpm \
           gtk+-1.2.10-33.i386.rpm \
           imlib-1.9.13-23.i386.rpm \
           libpng10-1.0.16-1.i386.rpm \
           gdk-pixbuf-0.22.0-16.el4.i386.rpm \
           libungif-4.1.3-1.i386.rpm \
           alsa-lib-1.0.6-5.RHEL4.i386.rpm \
           audiofile-0.2.6-1.i386.rpm \
           esound-0.2.35-2.i386.rpm

  rpm -Uvh sysstat-5.0.5-1.i386.rpm

  rpm -Uvh libaio-0.3.103-3.i386.rpm

  rpm -Uvh xorg-x11-deprecated-libs-6.8.2-1.EL.13.20.i386.rpm

  rpm -Uvh compat-libstdc++-33-3.2.3-47.3.i386.rpm

I don't know why the control-center RPM and the xscreensaver RPM are listed as requirements. On my system I did not install these RPMs since I'm against installing desktop stuff on servers. When I installed 10g R2 I did not experience any problems when these RPMs were missing. When you want to install control-center RPM and the xscreensaver, then have fun. The list can be very long with all the dependencies like gnome-desktop, cdrecord etc..



10g R1 on RHEL AS 4 (x86_64)

NOTE: No certification has been projected for 10g R1 64-bit on RHEL AS 4 (x86_64) at the time of this writing.

On my RHEL AS 4 x86_64 system I installed the following RPMs and dependencies:

  rpm -Uvh gcc-3.4.3-22.1.x86_64.rpm \
          cpp-3.4.3-22.1.x86_64.rpm \
          glibc-devel-2.3.4-2.9.x86_64.rpm \
          glibc-headers-2.3.4-2.9.x86_64.rpm \
          glibc-kernheaders-2.4-9.1.87.x86_64.rpm

 rpm -Uvh glibc-devel-2.3.4-2.9.i386.rpm

 rpm -Uvh openmotif-2.2.3-9.RHEL4.1.x86_64.rpm \
          xorg-x11-deprecated-libs-6.8.2-1.EL.13.6.x86_64.rpm

 rpm -Uvh xorg-x11-deprecated-libs-6.8.2-1.EL.13.6.i386.rpm \
          xorg-x11-libs-6.8.2-1.EL.13.6.i386.rpm \
          xorg-x11-Mesa-libGL-6.8.2-1.EL.13.6.i386.rpm \
          expat-1.95.7-4.i386.rpm fontconfig-2.2.3-7.i386.rpm \
          freetype-2.1.9-1.i386.rpm zlib-1.2.1.2-1.i386.rpm

  rpm -Uvh libgcc-3.4.3-22.1.i386.rpm

You will get various different error messages during the installation if not all of these RPMs are installed on your system for 10g R1 64-bit.
For more information, see The Quick Search Engine in The top.

10g R1 on RHEL AS 4 (x86)

On my RHEL AS 4 x86 system I had to install the following RPMs and dependencies to meet the software requirements:

  rpm -Uvh gcc-3.4.3-9.EL4.i386.rpm          \
           glibc-devel-2.3.4-2.i386.rpm     \
           glibc-headers-2.3.4-2.i386.rpm   \
           glibc-kernheaders-2.4-9.1.87.i386.rpm

 rpm -Uvh openmotif-2.2.3-6.RHEL4.2.i386.rpm \
          xorg-x11-deprecated-libs-6.8.1-23.EL.i386.rpm

Note that the 10g 10.1.0.3 OUI Product-specific Prerequisite check will fail for the gcc, binutils, and openmotif versions. You can ignore these failed checks and proceed.
The redhat-release RPM should already be installed by default. But note that 10.1.0.3.0 OUI does not recognize RHEL AS 4 as a supported release yet. This means you will have to edit the /etc/redhat-release file, see below, or you apply the 4153257 patch for 10g R1 on RHEL 4. 10g R2 does recognise RHEL AS 4 as a supported platform.



10g R1 and R2 on RHEL AS 3 (x86)

On my RHEL AS 3 x86 system I had to install the following RPMs and dependencies to meet the software requirements:

   rpm -Uvh gcc-3.2.3-52.i386.rpm \
          cpp-3.2.3-52.i386.rpm \
          glibc-devel-2.3.2-95.33.i386.rpm \
          glibc-headers-2.3.2-95.33.i386.rpm \
          glibc-kernheaders-2.4-8.34.1.i386.rpm

 rpm -Uvh compat-db-4.0.14-5.1.i386.rpm \
          compat-gcc-7.3-2.96.128.i386.rpm \
          compat-gcc-c++-7.3-2.96.128.i386.rpm \
          compat-libstdc++-7.3-2.96.128.i386.rpm \
          compat-libstdc++-devel-7.3-2.96.128.i386.rpm \
          tcl-8.3.5-92.2.i386.rpm

 rpm -Uvh libaio-0.3.96-5.i386.rpm

 rpm -Uvh openmotif21-2.1.30-9.RHEL3.6.i386.rpm

 rpm -Uvh openmotif-2.2.3-5.RHEL3.2.i386.rpm

10g R1 on RHEL AS 3 (x86_64)

On my RHEL AS 3 x86_64 system I had to install the following RPMs and dependencies to meet the software requirements:

  rpm -Uvh gcc-3.2.3-52.x86_64.rpm \
 cpp-3.2.3-52.x86_64.rpm \
 glibc-devel-2.3.2-95.33.x86_64.rpm \
 glibc-headers-2.3.2-95.33.x86_64.rpm \
 glibc-kernheaders-2.4-8.34.1.x86_64.rpm

 rpm -Uvh glibc-devel-2.3.2-95.33.i386.rpm

 rpm -Uvh compat-db-4.0.14-5.1.x86_64.rpm \
          compat-gcc-7.3-2.96.128.i386.rpm \
          compat-gcc-c++-7.3-2.96.128.i386.rpm \
          compat-libstdc++-7.3-2.96.128.i386.rpm \
          compat-libstdc++-devel-7.3-2.96.128.i386.rpm \
          tcl-8.3.5-92.2.x86_64.rpm \
          libgcc-3.2.3-52.i386.rpm

 rpm -Uvh libaio-0.3.96-5.x86_64.rpm \
          libaio-devel-0.3.96-5.x86_64.rpm

 # RHEL AS 3 x86_64 U5 does not come with a i386 gnome-libs RPM 
 rpm -Uvh gnome-libs-1.4.1.2.90-34.2.x86_64.rpm \
          ORBit-0.5.17-10.4.x86_64.rpm \
          audiofile-0.2.3-7.1.x86_64.rpm \
          esound-0.2.28-6.x86_64.rpm \
          gtk+-1.2.10-31.x86_64.rpm \
          imlib-1.9.13-13.4.x86_64.rpm \
          gdk-pixbuf-0.22.0-12.el3.x86_64.rpm \
          libpng10-1.0.13-15.x86_64.rpm \
          libungif-4.1.0-15.x86_64.rpm

 # RHEL AS 3 x86_64 U5 does not come with a x86_64 openmotif21 RPM 
 rpm -Uvh openmotif21-2.1.30-9.RHEL3.6.i386.rpm \
          XFree86-libs-4.3.0-81.EL.i386.rpm \
          XFree86-Mesa-libGL-4.3.0-81.EL.i386.rpm \
          expat-1.95.5-6.i386.rpm \
          fontconfig-2.2.1-13.i386.rpm \
          freetype-2.1.4-4.0.i386.rpm \
          zlib-1.1.4-8.1.i386.rpm

Make sure to use the right i386 and x86_64 RPMs as listed above!

Note, if you don't install the i386 XFree86-libs RPM, you will get an error message similar to this one:

/tmp/OraInstall2005-06-15_07-36-25AM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory

For more information, see Quick Search Engine In the TOP.


10g R1 on RHEL AS 2.1 (x86)

On my RHEL AS 2.1 x86 system I had to install the following RPMs and dependencies to meet the software requirements:

  rpm -Uvh glibc-2.2.4-32.11.i686.rpm \
          glibc-common-2.2.4-32.11.i386.rpm

 rpm -Uvh gcc-2.96-108.1.i386.rpm \
          binutils-2.11.90.0.8-12.i386.rpm \
          cpp-2.96-108.1.i386.rpm \
          glibc-devel-2.2.4-32.11.i386.rpm \
          kernel-headers-2.4.9-e.3.i386.rpm

 rpm -Uvh openmotif-2.1.30-11.i386.rpm

 rpm -Uvh redhat-release-as-2.1AS-4.noarch.rpm

I had to upgrade glibc in order to pass Oracle's "Product-specific Prerequisite" checks. Oracle's recommended glibc version is 2.2.4.31.7 or higher.
There is no setarch RPM for RHEL AS 2.1.
Also, it's important to install a newer kernel version for RHEL AS 2.1. Definitely don't use a kernel older than 2.4.9-e.25. To check the kernel version run uname -r. For more information on upgrading the kernel, see Quick Search Engine In the TOP.


10g R2 on Fedora Core 4 (x86)

On my FC4 system I had to install the following RPMs and dependencies to meet the software requirements:

  rpm -Uvh gcc-4.0.0-8.i386.rpm \
          cpp-4.0.0-8.i386.rpm \
          glibc-devel-2.3.5-10.i386.rpm \
          glibc-headers-2.3.5-10.i386.rpm \
          glibc-kernheaders-2.4-9.1.94.i386.rpm

 rpm -Uvh compat-libstdc++-33-3.2.3-47.fc4.i386.rpm

 rpm -Uvh openmotif-2.2.3-10.i386.rpm \
          xorg-x11-deprecated-libs-6.8.2-31.i386.rpm

 rpm -Uvh openmotif21-2.1.30-14.i386.rpm

 rpm -Uvh libaio-0.3.104-2.i386.rpm

 rpm -Uvh selinux-policy-targeted-1.25.2-4.noarch.rpm

NOTE: I also had to patch the SELinux policy by upgrading the selinux-policy-targeted RPM. You can download the latest version from http://download.fedora.redhat.com/pub/fedora/linux/core/updates/4/i386/. If you don't upgrade to a newer version you will get the following error:

Exception in thread "main" java.lang.UnsatisfiedLinkError: /tmp/OraInstall2005-07-24_09-03-19AM/jre/1.4.2/lib/i386/libawt.so:
/tmp/OraInstall2005-07-24_09-03-19AM/jre/1.4.2/lib/i386/libawt.so: cannot restore segment prot after reloc: Permission denied

You could also disable SELinux which I don't recommend. For more information, search in The quick search Engine.


10g R1 on Fedora Core 3 (x86)

On my FC3 system I had to install the following RPMs and dependencies to meet the software requirements:

  rpm -Uvh gcc-3.4.2-6.fc3.i386.rpm \
          cpp-3.4.2-6.fc3.i386.rpm \
          glibc-devel-2.3.3-74.i386.rpm \
          glibc-headers-2.3.3-74.i386.rpm \
          glibc-kernheaders-2.4-9.1.87.i386.rpm

 rpm -Uvh openmotif-2.2.3-6.i386.rpm \
          xorg-x11-deprecated-libs-6.8.1-12.i386.rpm

 rpm -Uvh openmotif21-2.1.30-11.i386.rpm

 rpm -Uvh setarch-1.6-1.i386.rpm

The gcc version that comes with FC3 will not pass Oracle's "Product-specific Prerequisite" checks. I ignored this warning on FC3.


10g R1 on Fedora Core 1 (x86)

On my FC1 system I had to install the following RPMs and dependencies to meet the software requirements:

  rpm -Uvh gcc-3.3.2-1.i386.rpm                \
          glibc-devel-2.3.2-101.i386.rpm      \
          cpp-3.3.2-1.i386.rpm                \
          glibc-headers-2.3.2-101.i386.rpm    \
          glibc-kernheaders-2.4-8.36.i386.rpm \
          binutils-2.14.90.0.6-3.i386.rpm

 rpm -Uvh openmotif-2.2.2-16.1.i386.rpm

 rpm -Uvh setarch-1.0-1.i386.rpm

FC1 is not supported by Oracle and you will have a hard time to find the right RPM version for Oracle10g. I tried to use the RPMs that came with the FC1 CDs which are easily available to everyone. I did not had any problems installing an Oracle Database 10g (General Purpose Database) on FC1 with these RPMs.


10g R1 on Red Hat 9 (x86)

On my RH9 system I had to install the following RPMs and dependencies to meet the software requirements:

  rpm -Uvh openmotif-2.2.2-14.i386.rpm

 rpm -Uvh gcc-3.2.2-5.i386.rpm                \
          glibc-devel-2.3.2-5.i386.rpm        \
          cpp-3.2.2-5.i386.rpm                \
          glibc-kernheaders-2.4-8.10.i386.rpm \
          binutils-2.13.90.0.18-9.i386.rpm

There is no setarch RPM for RH9. RH9 is not supported by Oracle.


Checking/Updating the redhat-release File

Verify that the redhat-release RPM is installed on your Red Hat system:

rpm -q redhat-release

This RPM is important for RHEL since RHEL AS 4, RHEL AS 3, and RHEL AS 2.1 are Linux releases supported by Oracle. Without this RPM, Oracle 10g OUI won't be able to recognize it as a supported OS. However, the installer of 10g 10.1.0.3 does not recognize RHEL AS 4 as a supported release yet. This means that you will have to edit the /etc/redhat-release file. You also have to change /etc/redhat-release for unsupported releases like Fedora Core and RH9.

I do not recommend to execute "runInstaller -ignoreSysPrereqs" since this will disable other checks you probably don't want to.

On RHEL AS 4 (for 10g R1), RH9, and FC 1 you have to change the /etc/redhat-release file to make Oracle 10g believe it's running on a supported release.
Regarding RHEL AS 4, the installer for 10g 10.1.0.3 does not recognize RHEL AS 4 as a supported release but 10g R2 OUI does.

To change the /etc/redhat-release file, you can simply copy/paste the following commands:

su - root
cp /etc/redhat-release /etc/redhat-release.orig
cat > /etc/redhat-release << EOF
Red Hat Enterprise Linux AS release 3 (Taroon)
EOF

After you are done with the Oracle10g installation, undo the changes you made to /etc/redhat-release:

su - root
cp /etc/redhat-release.orig /etc/redhat-release

NOTE: On FC3 you don't have to edit /etc/redhat-release since the OUI is not very clever. If OUI finds e.g. digit number "3" in the /etc/redhat-release file, you pass the "operating system version" check since it believes it's a RHEL3 system.

YOU CAN USE QUICK SEARCH ENGINE IN THE TOP FOR MORE DOWNLOADS OR DETAILS.

Checking Kernel Parameters

To see all kernel parameters, execute:

su - root
sysctl -a

For Oracle10g, the following kernel parameters have to be set to values greater than or equal to the recommended values which can be changed in the proc filesystem:

shmmax  = 2147483648     (To verify, execute: cat /proc/sys/kernel/shmmax)
shmmni  = 4096           (To verify, execute: cat /proc/sys/kernel/shmmni)
shmall  = 2097152        (To verify, execute: cat /proc/sys/kernel/shmall)   (for 10g R1)
shmmin  = 1              (To verify, execute: ipcs -lm |grep "min seg size")
shmseg  = 10             (It's hardcoded in the kernel - the default is much higher)

semmsl  = 250            (To verify, execute: cat /proc/sys/kernel/sem | awk '{print $1}')
semmns  = 32000          (To verify, execute: cat /proc/sys/kernel/sem | awk '{print $2}')
semopm  = 100            (To verify, execute: cat /proc/sys/kernel/sem | awk '{print $3}')
semmni  = 128            (To verify, execute: cat /proc/sys/kernel/sem | awk '{print $4}')

file-max = 65536         (To verify, execute: cat /proc/sys/fs/file-max)

ip_local_port_range = 1024 65000
                        (To verify, execute: cat /proc/sys/net/ipv4/ip_local_port_range)

NOTE: Do not change the value of any kernel parameter on a system where it is already higher than listed as minimum requirement.

On RHEL AS 4 x86, RHEL AS 3 U5 x86, RHEL AS 3 U5 x86_64, RHEL AS 2.1, RH9, FC1, FC3, and FC4 I had to increase the kernel parameters shmmax, semopm, and filemax to meet the minimum requirement. On RHEL AS 4 x86_64 I had to increase shmmax and semopm.

Oracle also recommends to set the local port range ip_local_port_range for outgoing messages to "1024 65000" which is needed for high-usage systems. This kernel parameter defines the local port range for TCP and UDP traffic to choose from.

I added the following lines to the /etc/sysctl.conf file which is used during the boot process:

kernel.shmmax=2147483648
kernel.sem=250 32000 100 128
fs.file-max=65536
net.ipv4.ip_local_port_range=1024 65000

Adding these lines to the /etc/sysctl.conf file will cause the system to change these kernel parameters after each boot using the /etc/rc.d/rc.sysinit script which is invoked by /etc/inittab. But in order that these new added lines or settings in /etc/sysctl.conf become effective immediately, execute the following command:

su - root
sysctl -p

Starting with 10g R2 some network settings must be adjusted as well which is checked by OUI. For more information on setting these parameters
YOU CAN USE QUICK SEARCH ENGINE IN THE TOP FOR MORE DOWNLOADS OR DETAILS.

Sizing Disk Space for Oracle10g

Oracle says that about 2.5 GB of disk space should be reserved for the Oracle software on Linux.

When I did an Oracle 10g Release 1 (10.1.0.3.0) "General Purpose Database" installation (not including any software from the Oracle Database 10g Companion CD), the Oracle software used about 1.3 GB of disk space, and the preconfigured "General Purpose Database" (datafiles, etc.) used about 710 MB of disk space.

$ du -m -s /u01
1963    /u01
$ du -m -s /u01/app/oracle/oradata
720     /u01/app/oracle/oradata

If you also install additional software from the Oracle Database 10g Companion CD, then add at least 1 GB of free disk space.

So if you install Oracle10g Enterprise Edition and additional software from the Oracle Database 10g Companion CD, then you need about 2.5 GB of disk for the Oracle software. And if you also want to add a preconfigured database on the same filesystem, make sure to add another 1 GB of disk space.

NOTE: If you don't put Oracle10g on a separate filesystems, then make sure the root filesystem "/" has enough disk space. You can check the free space of the root filesystem with the following command:

df -h /

YOU CAN USE QUICK SEARCH ENGINE IN THE TOP FOR MORE DOWNLOADS OR DETAILS.

Creating Oracle User Accounts

To create the oracle account and groups, execute the following commands:

su - root
groupadd dba          # group of users to be granted SYSDBA system privilege
groupadd oinstall     # group owner of Oracle files
useradd -c "Oracle software owner" -g oinstall -G dba oracle
passwd oracle

YOU CAN USE QUICK SEARCH ENGINE IN THE TOP FOR MORE DOWNLOADS OR DETAILS.

Setting Shell Limits for the Oracle User

Most shells like Bash provide control over various resources like the maximum allowable number of open file descriptors or the maximum number of processes available to a user. For more information on ulimit for the Bash shell, see man bash and search for ulimit.

If you just install a small test database, then you might be ok with the current settings (note that the limits very often vary). But for (larger) production databases, you should increase the following shell limits to the following values recommended by Oracle:

nofile = 65536     (To verify, execute: ulimit -n)
nproc  = 16384     (To verify, execute: ulimit -u)

The nofile option denotes the maximum number of open file descriptors, and nproc denotes the maximum number of processes available to a single user.

To see all shell limits, execute:

ulimit -a

YOU CAN USE QUICK SEARCH ENGINE IN THE TOP FOR MORE DOWNLOADS OR DETAILS.

Creating Oracle Directories

For Oracle10g you only need to create the directory for $ORACLE_BASE:

su - root
mkdir -p /u01/app/oracle
chown oracle.oinstall /u01/app/oracle

But if you want to comply with Oracle's Optimal Flexible Architecture (OFA), then you don't want to place the database files in the /u01 directory but in another directory/filesystem/disk like /u02. This is not a requirement but if you want to comply with OFA, then you might want to create the following directories as well:

su - root
mkdir -p /u02/oradata/orcl
chown oracle.oinstall /u02/oradata/orcl

In this example, "orcl" stands for the name of the database which will also be the name of the instance. This is typically the case for single instance databases.


Optimal Flexible Architecture (OFA) for 10g R1 (10.1.0.2)

The OFA standard is a guideline created by Oracle to ensure reliable Oracle installations. For Oracle 10g Database, the OFA recommended Oracle home path has changed.

The home path for the first 10g (10.1.0) database installation on a system would be:

  /u01/app/oracle/product/10.1.0/db_1

If you would install a second Oracle 10g Database 10g (10.1.0) on the same system, the Oracle home directory would be as follows:

  /u01/app/oracle/product/10.1.0/db_2

If the Oracle10g software is not owned by the user oracle but by the user "oraowner", then the path of the Oracle home directory would be:

  /u01/app/oraowner/product/10.1.0/db_1
 /u01/app/oraowner/product/10.1.0/db_2

The standard directory name for Oracle10g is "app":

  /u01/app/oracle/product/10.1.0/db_1

Oracle recommends to use mount points such as /u01, /u02, etc. which complies with the OFA guidelines. But others can be used, for example:

  /disk_1/app/oracle/product/10.1.0/db_1

The subtree for database files not stored in ASM disk groups should be named as follows:

  /u02/oradata/<db_name_1>
 /u02/oradata/<db_name_2>
 /u03/oradata/<db_name_1>

 /u03/oradata/<db_name_2>

The mount point /u01 should be used for the Oracle software only. /u02, /u03, /u04 etc. should be used for the database files. The db_name stands for the DB_NAME initialization parameter which is typically the same as the SID name for single instance databases.

YOU CAN USE QUICK SEARCH ENGINE IN THE TOP FOR MORE DOWNLOADS OR DETAILS.

Setting Oracle Environments

Since the Oracle Universal Installer (OUI) "runInstaller" is run from the oracle account, some environment variables must be configured for this account before OUI is started.

Execute the following commands for the Bash shell which is the default shell on Red Hat Linux (to verify your shell run: echo $SHELL):

su - oracle
export ORACLE_BASE=/u01/app/oracle
export ORACLE_SID=orcl

NOTE: If ORACLE_BASE is used, then Oracle recommends that you don't set the ORACLE_HOME environment variable but that you choose the default path suggested by the OUI. You can set and use ORACLE_HOME after you finished running OUI.

Also, the environment variables ORACLE_HOME and TNS_ADMIN should not be set. If you've already set these environment variables, you can unset them by running the following commands:

unset ORACLE_HOME
unset TNS_ADMIN

To have these environment variables set automatically each time you login as oracle, you can add these environment variables to the ~oracle/.bash_profile file which is the user startup file for the Bash shell on Red Hat Linux. To do this you could simply copy/paste the following commands to make these settings permanent for your oracle's Bash shell:

su - oracle
cat >> ~oracle/.bash_profile << EOF
export ORACLE_BASE=/u01/app/oracle
export ORACLE_SID=orcl

YOU CAN USE QUICK SEARCH ENGINE IN THE TOP FOR MORE DOWNLOADS OR DETAILS.
EOF

Installing Oracle10g

Installing Oracle10g on a Remote Linux Server

If you don't install Oracle on your local system but on a remote server, then you need to relink X to your local desktop. The easiest way to do this is to use the "X11 forwarding" feature of ssh. This means that you don't have to run xhost and set the DISPLAY environment variable.

Here is an example how to make use of the "X11 forward" feature of ssh. Simply run the following command from your local desktop:

$ ssh -X oracle@oracle_remote_server_name

Now when you try to run any GUI tool on the remote server, it will automatically be relinked to your local desktop. If this is not working, verify that the ForwardX11 setting is not set to "no" in /etc/ssh/ssh_config on the remote server:

su - root
# grep ForwardX11 /etc/ssh/ssh_config | grep -v "^#"
       ForwardX11 yes
#

If you are using telnet, however, you will have to set DISPLAY manually, see my other article Starting runInstaller for more information.


Starting Oracle Universal Installer

Insert the Oracle CD that contains the image of the downloaded file ship.db.lnx32.cpio, or change to the directory that contains the image directory Disk1.

If you install Oracle10g from a CD, mount the CD by running the following commands in another terminal:

su - root
mount /mnt/cdrom

For RHEL AS 4, RHEL AS 3, and FC3 you have to execute:

su - root
mount /media/cdrom

Before you execute runInstaller, make sure the Oracle environment variables are set, see Setting Oracle Environments. You can verify the settings by running the set command:

su - oracle
oracle$ set

To execute runInstaller from the mounted CD, run the following command as the oracle user:

oracle$ /mnt/cdrom/runInstaller

On RHEL AS 4, RHEL AS 3, and FC3 run the following command:

oracle$ /media/cdrom/runInstaller

Using Oracle Universal Installer (OUI)

The following example shows how to install x86 Oracle 10g Release 1 Database Software and a "General Purpose" database:
(Note, the screens and questions will look different if you install 10g R2 or 64-bit 10g R1 database)

 - Welcome Screen:
                    - Basic Installation:       Checked it which is the default
                    - Oracle Home Location:     Use default: /u01/app/oracle/product/10.1.0/db_1
                    - Installation Type:        I used the default: Enterprise Edition
                    - UNIX DBA Group:           Use default: dba
                    - Create Starter Databases: I checked it for this example which is the default
                      - Global Database Name:     orcl
                      - Database password:        Type in the password for SYS, SYSTEM, SYSMAN, and DBSNMP accounts
                    - Advanced Installation:    For this article I did not check it
                    Click Next

- Specify Inventory directory and credentials:
                    - Full path of the inventory directory: Use default: /u01/app/oracle/oraInventory
                    - Specify Operating System group name:  Use default: oinstall
                    Click Next

- A window pops up to run the orainstRoot.sh script:
                    Run the script in another terminal:
                      su - root
                      # /u01/app/oracle/oraInventory/orainstRoot.sh
                      Creating the Oracle inventory pointer file (/etc/oraInst.loc)
                      Changing groupname of /u01/app/oracle/oraInventory to oinstall.
                      #
                    Click Continue

- Product-specific Prerequisite Checks:
                    Verify that all checks have been passed.
                    Make sure that the status of each Check is set to "Succeeded".
                    On RHEL AS 4 ignore the warnings for binutils, gcc, and openmotif and proceed.
                    If a check failed, see Oracle10g Installation Errors on Linux.
                    Note that the "Retry" button doesn't work after you fixed one of the failed checks.
                    Click Next

- Select Database Configuration:
                    I selected "General Purpose".
                    Click Next

- Specify Database Configuration Options:
                    - Global Database Name: I used "orcl".
                    - SID: I used "orcl".
                    Click Next

- Select Database Management Option:
                    I selected "Use Database Control for Database Management".
                    Click Next

- Specify Database File Storage Option:
                    I selected "File System".
                    - File System
                      - Specify Database file location: /u01/app/oracle/oradata/
                          If you want to comply with OFA, you might want to select another mount point
                          than '/u01', e.g. /u02/oradata.
                    Click Next

- Specify Backup and Recovery Options:
                    For my test installation I selected "Do no enable Automated Backups".
                    Click Next

- Specify Database Schema Passwords:
                    Make sure that the password(s) don't start with a digit number! Otherwise you
                    will later get error message(s) like "ORA-00988 missing or invalid password".
                    Click Next

- Summary:          Click Install

                    If Enterprise manager configuration fails due to port allocation problems,
                    check out Oracle10g/Linux Errors and Problems.


                    When a window pops up to run the root.sh script, execute the script
                    in another terminal as root:

                      su - root
                      # /u01/app/oracle/product/10.1.0/db_1/root.sh
                      Running Oracle10 root.sh script...
                      \nThe following environment variables are set as:
                          ORACLE_OWNER= oracle
                          ORACLE_HOME=  /u01/app/oracle/product/10.1.0/db_1

                      Enter the full pathname of the local bin directory: [/usr/local/bin]:
                         Copying dbhome to /usr/local/bin ...
                         Copying oraenv to /usr/local/bin ...
                         Copying coraenv to /usr/local/bin ...

                      \nCreating /etc/oratab file...
                      Adding entry to /etc/oratab file...
                      Entries will be added to the /etc/oratab file as needed by
                      Database Configuration Assistant when a database is created
                      Finished running generic part of root.sh script.
                      Now product-specific root actions will be performed.
                      /var/opt/oracle does not exist. Creating it now.
                      /etc/oracle does not exist. Creating it now.
                      Successfully accumulated necessary OCR keys.
                      Creating OCR keys for user 'root', privgrp 'root'..
                      Operation successful.
                      Oracle Cluster Registry for cluster has been initialized

                      Adding to inittab
                      Checking the status of Oracle init process...
                      Expecting the CRS daemons to be up within 600 seconds.
                      CSS is active on these nodes.
                              mars
                      CSS is active on all nodes.
                      Oracle CSS service is installed and running under init(1M)
                      #

                    Click OK

- End of Installation:
                    Click Exit

Updates after Running Oracle Universal Installer

After Oracle10g has been installed, make sure that ORACLE_HOME, PATH, and LD_LIBRARY_PATH are set for the oracle account.

Note that the path for ORACLE_HOME might be different on your system!
Also note that LD_LIBRARY_PATH is needed for some Oracle binaries such as sysresv!

For 10g R1 (10.1.0.3) I added the following lines to the ~oracle/.bash_profile file:

export ORACLE_HOME=$ORACLE_BASE/product/10.1.0/db_1
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib

For 10g R2 (10.2.0.1.0) I added the following lines to the ~oracle/.bash_profile file:

export ORACLE_HOME=$ORACLE_BASE/oracle/product/10.2.0/db_1
export PATH=$PATH:$ORACLE_HOME/bin

YOU CAN USE QUICK SEARCH ENGINE IN THE TOP FOR MORE DOWNLOADS OR DETAILS.
export LD_LIBRARY_PATH=$ORACLE_HOME/lib

After that run the following command to set all environment variables in ~oracle/.bash_profile:

$ . ~oracle/.bash_profile

This commmand will add the environment variables to the ~oracle/.profile and source in the file for the current shell by executing ". ~oracle/.bash_profile".