Chapter 29. Oracle 10g and Linux Installation Errors and Troubleshooting

This chapter presents many common Oracle 10g problems and other issues.

Note

Most of the issues are caused by not following the installation procedure correctly. Some errors are caused by not using an Oracle supported Linux OS version such as Red Hat Enterprise Linux.
The Installation log file can be found in $ORACLE_BASE/oraInventory/logs. The Database Creation log file can be found in $ORACLE_BASE/admin/$ORACLE_SID/create.
An Error While Starting the Oracle Universal Installer

You may receive the following error while running the Oracle Universal Installer: 

Starting Oracle Universal Installer...
Checking installer requirements...

Checking operating system version: must be redhat-2.1, UnitedLinux-1.0 or 
    redhat-3
    Failed <<<<

Exiting Oracle Universal Installer, log for this session can be found at ...
A solution for how to fix this can be found at Section 20.8, “Verifying and Updating the redhat-release File”.

Note

The "Retry" in the "Product-specific Prerequisite Checks" window does not work. When correcting errors, you must either set them manually to Passed or you restart OUI.
Checking for gcc-2.96; found Not found. Failed >>>>

Refer to Section 19.3, “Verifying Software Packages (RPMs)” for information on this problem and how to solve it.

Checking for shmmax=2147483648; found shmmax=33554432. Failed >>>>

Solution: Increase the shmmax kernel parameter.

See Section 19.4, “Verifying Kernel Parameters” for information on this problem and how to solve it.
Checking for semopm=100; found semopm=32. Failed <<<<

Increase the semopm kernel parameter.

See Section 19.4, “Verifying Kernel Parameters” for information on this problem and how to solve it.
Checking for filemax=65536; found filemax=26163. Failed <<<<

Increase the file-max kernel parameter.

See Section 19.4, “Verifying Kernel Parameters” for information on this problem and how to solve it.
ORA-01034: ORACLE not available, ORA-27101: shared memory realm does not exist, Linux Error: 2: No such file or directory, or ORA-01034: ORACLE not available

First check if ORACLE_SID is set correctly. If the ORACLE_SID is set correctly, then you probably have a trailing slash "/" on the ORACLE_HOME environment variable. Remove it and try again to connect to sys. For example, change ORACLE_HOME=/u01/app/oracle/product/10.1.0/db_1/ to ORACLE_HOME=/u01/app/oracle/product/10.1.0/db_1.

ORA-00988 missing or invalid password(s)

During the Oracle 10g installation you probably provided a password for the Oracle database accounts that started with a number. Ignore this error message and change the password when you are done with the Oracle 10g installation.

sysresv -i outputs sysresv: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory

Make sure LD_LIBRARY_PATH is set to $ORACLE_HOME/lib by executing: 

oracle$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib
X11 connection rejected because of wrong authentication X connection to localhost:10.0 broken (explicit kill or server shutdown)

To rectify this problem, try to log in to the remote Oracle server again by using the "X11 forward" feature of ssh. Execute the following command, after changing oracle_remote_server_name to your server, 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 should 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 your remote server: 
su - root
# grep ForwardX11 /etc/ssh/ssh_config | grep -v "^#"
		ForwardX11 yes
#

Note

If you use newer Red Hat Enterprise Linux versions 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: DisallowTCP=false.
After that you need to restart your X server. You can do this with the init command: 
su - root init 3 init 5
If you are using telnet you will have to set the DISPLAY variable manually.
Recovery Manager(rman) hangs

You are probably running the wrong rman binary which belongs to the XFree86-devel RPM: 

$ which rman
/usr/X11R6/bin/rman
ORA-00988 missing or invalid password(s)

During the Oracle 10g installation you probably provided a password for the Oracle database accounts that started with a digit number. Ignore this error message and change the password when you are done with the Oracle 10g installation.

./runInstaller Crashes

The Oracle installer ./run Installer crashes with the 

Exception java.lang.UnsatisfiedLinkError: /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 occurred..
java.lang.UnsatisfiedLinkError: /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
	at java.lang.ClassLoader$NativeLibrary.load(Native Method)
	at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1560)
	at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1477)
You may receive this error message on Red Hat Enterprise Linux 3 x86-64, Red Hat Enterprise Linux 4 x86-64, and on other systems. Even though you most probably have /usr/X11R6/lib64/libXp.so.6 installed on your system, this error messages is complaining that it can not find the libXp.so.6 shared library for i386: 
/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
Follow the instructions below to install the i386 XFree86-libs package (XFree86-libs-4.3.0-81.EL.i386.rpm or newer) on Red Hat Enterprise Linux 3 x86-64 with 10g (10.1.0.3) . In order to satisfy dependencies for this i386 package, you may need to install a few other i386 RPMs as well: 
# rpm -ivh 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
In order to install 10g (10.1.0.3) on Red Hat Enterprise Linux 4 x86-64 update 1 you must install the i386 xorg-x11-deprecated-libs package (xorg-x11-deprecated-libs-6.8.2-1.EL.13.6.i386.rpm). The installation depends on the following packages, to install these packages execute the follow commands: 
# 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
Installing 10g R2 (10.2.0.1.0) on Red Hat Enterprise Linux 4 x86-64 Update 2 requires the i386 xorg-x11-deprecated-libs package (xorg-x11-deprecated-libs-6.8.2-1.EL.13.20.i386.rpm). In order to satisfy dependencies for this i386 package, you may have to install a few other i386 RPMs as well: 
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
An Oracle 10g R2 (10.2.0.1.0) install on Red Hat Enterprise Linux 4 x86 Update 2 system requires the following RPM: 
rpm -Uvh xorg-x11-deprecated-libs-6.8.2-1.EL.13.20.i386.rpm
After you have installed the appropriate RPMs, restart the installation by running .runInstaller again.
An error in relinking during the Oracle install

You may get this error message or a similar one when installing 64 bit 10g on Red Hat Enterprise Linux4 x86-64. 

make -f /u01/app/oracle/OraHome_1/sysman/lib/ins_sysman.mk relink_sharedobj SHAREDOBJ=libnmemso
make[1]: Entering directory `/u01/app/oracle/OraHome_1/sysman/lib'
gcc -o /u01/app/oracle/OraHome_1/sysman/lib/libnmemso.so -m32 ...
...
/usr/bin/ld: crti.o: No such file: No such file or directory
collect2: ld returned 1 exit status
make[1]: *** [/u01/app/oracle/OraHome_1/sysman/lib/libnmemso.so] Error 1
On Red Hat Enterprise Linux4 U1 x86-64 to install 10g (10.1.0.3) you need the following i386 RPM to fix this problem: 
# rpm -Uvh glibc-devel-2.3.4-2.9.i386.rpm
On Red Hat Enterprise Linux 4 U2 x86-64 to install 10g R2 (10.2.0.1.0) you need the following i386 RPM to fix this problem: 
# rpm -Uvh glibc-devel-2.3.4-2.13.i386.rpm
Error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

Make sure the libaio RPM is installed.

On Red Hat Enterprise Linux 3 x86: 
# rpm -Uvh libaio-0.3.96-5.i386.rpm
On Red Hat Enterprise Linux 4 Update 2 x86-64: 
# rpm -Uvh libaio-0.3.103-3.x86_64.rpm
Your version of libaio may be different.
Error in invoking target 'all_no_orcl'

The error text in full: 

Error in invoking target 'all_no_orcl' of makefile '/u01/app/oracle/oracle/product/10.2.0/db_1/rdbms/lib/ins_rdbms.mk'. 
See '/u01/app/oracle/oraInventory/logs/installActions2005-11-13_01-07-04AM.log' for details.
The log file shows the following error: 
INFO: gcc:
INFO: /usr/lib64/libstdc++.so.5: No such file or directory
INFO:

INFO: /u01/app/oracle/oracle/product/10.2.0/db_1/bin/genorasdksh: 
	Failed to link liborasdkbase.so.10.2

INFO: make: *** [liborasdkbase] Error 1
On Red Hat Enterprise Linux 4 U2 x86-64 with 10g R2 (10.2.0.1.0) install the following x86-64 RPM to fix this problem: 
# rpm -Uvh compat-libstdc++-33-3.2.3-47.3.x86_64.rpm

Note

You may already have the "i386" compat-libstdc++-33 RPM installed on your systems but you need the "x86-64" RPM to fix this problem. To verify which compat-libstdc++-33 RPM you have installed on your system, run: 
# rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE}  (%{ARCH})\n' compat-libstdc++-33
Error in invoking target 'all_no_orcl ihsodbc'

The full error message: 

Error in invoking target 'all_no_orcl ihsodbc' of makefile '/u01/app/oracle/oracle/product/10.2.0/db_1/rdbms/lib/ins_rdbms.mk'.
See '/u01/app/oracle/oraInventory/logs/installActions2005-07-24_09-25-22AM.log' for details.
The log file shows the following error: 
 
INFO: Creating /u01/app/oracle/oracle/product/10.2.0/db_1/lib/liborasdkbase.so.10.2

INFO: gcc:
INFO: /usr/lib/libstdc++.so.5: No such file or directory
INFO:

INFO: /u01/app/oracle/oracle/product/10.2.0/db_1/bin/genorasdksh: 
	Failed to link liborasdkbase.so.10.2
This means that the "33" version of the compat-libstdc++ RPM is missing.
Installing 10g R2 (10.2.0.1.0) on Red Hat Enterprise Linux 4 Update 2 x86 you require the following RPM to fix this problem: 
# rpm -Uvh compat-libstdc++-33-3.2.3-47.3.i386.rpm
You need the "33" version of the compat-libstdc++ RPM. For i386 there is also a "296" version of the compat-libstdc++ RPM. Here are the two compat-libstdc++ RPMs that come with Red Hat Enterprise Linux 4 Update 2: 
compat-libstdc++-296-2.96-132.7.2.i386.rpm
compat-libstdc++-33-3.2.3-47.3.i386.rpm
After that hit Retry in the error dialog window.
Error in invoking target 'all_no_orcl' of makefile

The full error is listed below. 

Error in invoking target 'all_no_orcl' of makefile '/u01/app/oracle/oracle/product/10.2.0/db_1/rdbms/lib/ins_rdbms.mk'. 
See '/u01/app/oracle/oraInventory/logs/installActions2005-11-13_01-25-49AM.log' for details.
The log file shows the following error: 
INFO: /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 used 
when making a shared object; recompile with -fPIC /usr/bin/ld: final link failed: Bad value
collect2: ld returned 1 exit status

INFO: /u01/app/oracle/oracle/product/10.2.0/db_1/bin/genorasdksh: 
	Failed to link liborasdkbase.so.10.2
This error comes up when installing 10g R2 (10.2.0.1.0) on Red Hat Enterprise Linux 4 x86-64. Make sure to upgrade to Red Hat Enterprise Linux 4 Update 3, or higher, otherwise to download the binutils RPM from https://rhn.redhat.com/ or from http://oss.oracle.com/projects/compat-oracle/files/RedHat/. After you have downloaded the RPM install it: 
# rpm -Uvh --force binutils-2.15.92.0.2-13.0.0.0.2.x86_64.rpm
For more information on this bug, see Bugzilla Bug 679.
ORA-12547: TNS:lost contact

There can be many reasons for this error. This can happen during the ASM instance start up when the libaio RPM is not installed on the system.

You can test this by running lsnrctl as the oracle user. 
$ lsnrctl start
...

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
   TNS-12547: TNS:lost contact
      TNS-12560: TNS:protocol adapter error
         TNS-00517: Lost contact
	    Linux Error: 104: Connection reset by peeras 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=centauri)(PORT=1521)))
   TNS-12547: TNS:lost contact
      TNS-12560: TNS:protocol adapter error
         TNS-00517: Lost contact
	    Linux Error: 104: Connection reset by peer
Make sure the loopback entry in /etc/hosts is not missing when you start the listener: 
127.0.0.1       localhost.localdomain   localhost
Now try to run lsnrctl as the user oracle again.