Here is a list of common Oracle10g installation problems and other issues.
Note that most of the issues are due to not following correctly the installation procedure. And some errors are due to not using an Oracle supported Linux OS.
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.
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 ...
See
Checking/Updating the redhat-release File
for more information.
Checking for gcc-2.96; found Not found. Failed <<<<
See
Checking Software Packages (RPMs)
for more information.
Note that "Retry" in the "Product-specific Prerequisite Checks" window does not work. So you either set it manually to Passed or you restart OUI.
Checking for openmotif-2.1.30-11; found Not found. Failed <<
See
Checking Software Packages (RPMs)
for more information.
Note that "Retry" in the "Product-specific Prerequisite Checks" window does not work. So you either set it manually to Passed or you restart OUI.
Checking for shmmax=2147483648; found shmmax=33554432. Failed <<<<
Increase the
shmmax
kernel parameter.
For more information on
shmmax
, see
Checking Kernel Parameters
.
Note that "Retry" in the "Product-specific Prerequisite Checks" window does not work. So you either set it manually to Passed or you restart OUI.
Checking for semopm=100; found semopm=32. Failed <<<<
Increase the
semopm
kernel parameter.
For more information on
semopm
, see
Checking Kernel Parameters
.
Note that "Retry" in the "Product-specific Prerequisite Checks" window does not work. So you either set it manually to Passed or you restart OUI.
Checking for filemax=65536; found filemax=26163. Failed <<<<
Increase the
file-max
kernel parameter:
For more information on
file-max
, see
Checking Kernel Parameters
.
Note that "Retry" in the "Product-specific Prerequisite Checks" window does not work. So you either set it manually to Passed or you restart OUI.
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
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 (e.g from
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 Oracle10g 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 Oracle10g installation.
$ sysresv -i 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
:
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 login to the remote Oracle server again by using the "X11 forward" feature of ssh. Execute 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 your remote server:
su - root
#
grep ForwardX11 /etc/ssh/ssh_config | grep -v "^#"
ForwardX11 yes #
NOTE: 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:
DisallowTCP=false
After that you need to restart your X server. I usually do this with the
init
command:
su - root init 3 init 5
If you are using
telnet
, however, you will have to set
DISPLAY
manually, see my other article
Starting runInstaller
for more information.
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 Oracle10g 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 Oracle10g installation.
$ ./runInstaller ... 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 get this error message on RHEL3 x86_64, RHEL4 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't 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
On my
RHEL3 x86_64
system for 10g (10.1.0.3) I had to install the i386
XFree86-libs
package (
XFree86-libs-4.3.0-81.EL.i386.rpm
). In order to satisfy dependencies for this i386 package, I had 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
On my
RHEL4 x86_64 U1
system for 10g (10.1.0.3) I had to install the i386
xorg-x11-deprecated-libs
package (
xorg-x11-deprecated-libs-6.8.2-1.EL.13.6.i386.rpm
). In order to satisfy dependencies for this i386 package, I had to install a few other i386 RPMs as well:
#
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
On my
RHEL4 x86_64 U2
system for 10g R2 (10.2.0.1.0) I had to install 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, I had 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
On my
RHEL4 x86 U2
system for 10g R2 (10.2.0.1.0) I had to install the following RPM:
rpm -Uvh xorg-x11-deprecated-libs-6.8.2-1.EL.13.20.i386.rpm
If you get this error message on Fedora Core 3 x86, install the
xorg-x11-deprecated-libs
RPM. For example:
#
rpm -Uvh xorg-x11-deprecated-libs-6.8.1-12.FC3.21
After I installed these RPMs I had to restart the installation. If you know a more elegant way to continue, please drop me an email.
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
You may get this error message or a similar one when installing 64-bit 10g on RHEL4 x86_64.
On my RHEL4 U1 x86_64 system for 10g (10.1.0.3) I installed the following i386RPM to fix this problem:#
rpm -Uvh glibc-devel-2.3.4-2.9.i386.rpm
On my RHEL4 U2 x86-64 system for 10g R2 (10.2.0.1.0) I installed the following i386RPM to fix this problem:#
rpm -Uvh glibc-devel-2.3.4-2.13.i386.rpm
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: cannot find -lgcc_s_32 collect2: ld returned 1 exit status make[1]: Leaving directory `/u01/app/oracle/OraHome_1/sysman/lib' make[1]: *** [/u01/app/oracle/OraHome_1/sysman/lib/libnmemso.so] Error 1
You may get this error message or a similar one when installing 64-bit 10g on RHEL4 x86_64.
On my RHEL4 U1 x86_64 system for 10g (10.1.0.3) I installed the following i386RPM to fix this problem:#
rpm -Uvh libgcc-3.4.3-22.1.i386.rpm
On my RHEL4 U2 x86_64 system for 10g R2 (10.2.0.1.0) I installed the following i386RPM to fix this problem:#
rpm -Uvh libgcc-3.4.4-2.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.
For example in RHEL 3 x86:
#
rpm -Uvh libaio-0.3.96-5.i386.rpm
For example in RHEL 4 U2 x86_64:
#
rpm -Uvh libaio-0.3.103-3.x86_64.rpm
$ ./runInstaller ... 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 at java.lang.ClassLoader$NativeLibrary.load(Native Method) at java.lang.ClassLoader.loadLibrary0(Unknown Source) at java.lang.ClassLoader.loadLibrary(Unknown Source) ...
I saw this error when I installed 10g R2 on Fedora Core 4. I fixed it by patchting/upgrading the SELinux policy:
#
rpm -Uvh selinux-policy-targeted-1.25.2-4.noarch.rpm
You can download the latest
selinux-policy-targeted
RPM from
http://download.fedora.redhat.com/pub/fedora/linux/core/updates/4/i386/
.
You could also disable SELinux which I DO NOT recommend:
#
/usr/sbin/setenforce 0
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 showed 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 my
RHEL4 U2 x86_64
system for 10g R2 (10.2.0.1.0) I installed the following
x86_64
RPM to fix this problem:
#
rpm -Uvh compat-libstdc++-33-3.2.3-47.3.x86_64.rpm
Note that 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' 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 showed 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.
On my
RHEL 4 U2 x86
system for 10g R2 (10.2.0.1.0) I installed the following RPM to fix this problem:
#
rpm -Uvh compat-libstdc++-33-3.2.3-47.3.i386.rpm
NOTE: 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 RHEL 4 U2:
compat-libstdc++-296-2.96-132.7.2.i386.rpm compat-libstdc++-33-3.2.3-47.3.i386.rpm
In Fedora Core 4 x86 I installed the following RPM to fix this problem:
#
rpm -Uvh compat-libstdc++-33-3.2.3-47.fc4.i386.rpm
NOTE: 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 FC4:
compat-libstdc++-296-2.96-132.fc4.i386.rpm compat-libstdc++-33-3.2.3-47.fc4.i386.rpm
After that hit Retry in the error dialog window.
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 showed 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 RHEL4 x86_64. Make sure to upgrade to RHEL4 U3 or to download the
binutils
RPM from
https://rhn.redhat.com/
or from
http://oss.oracle.com/projects/compat-oracle/files/RedHat/
:
#
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. For example, this can happen during ASM instance startup when the
libaio
RPM is not installed on the system.
$ 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 peer 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 start
as
oracle
again.
Oracle Database Documentation Library
Werner's Oracle Linux Page
