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.
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.
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.
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.
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.
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.
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).
Recovery Manager rman hangs
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
For example in RHEL 3 x86:
You could also disable SELinux which I DO NOT recommend:
On my RHEL 4 U2 x86 system for 10g R2 (10.2.0.1.0) I installed the following RPM to fix this problem:
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.
ORA-12547: TNS:lost contact
$ 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
地址: http://www.puschitz.com/InstallingOracle10g.shtml
Checking/Updating the redhat-release File for more information.
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.
- See
- See
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.
- See
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.
- Increase the
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.
- Increase the
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.
- Increase the
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.
- First check if
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).
- 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.
- Make sure
oracle$
- 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
$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:
# 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: After that you need to restart your X server. I usually do this with the init command: 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
$ /usr/X11R6/bin/rman
- 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.
- You may get this error message on RHEL3 x86_64, RHEL4 x86_64, and on other systems. Even though you most probably have
/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 directoryOn 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:
#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:
#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: On my RHEL4 x86 U2 system for 10g R2 (10.2.0.1.0) I had to install the following RPM: If you get this error message on Fedora Core 3 x86, install the xorg-x11-deprecated-libs RPM. For example:
#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
#On my RHEL4 U2 x86-64 system for 10g R2 (10.2.0.1.0) I installed the following i386 RPM to fix this problem:
#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
#On my RHEL4 U2 x86_64 system for 10g R2 (10.2.0.1.0) I installed the following i386 RPM to fix this problem:
#error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
- Make sure the
For example in RHEL 3 x86:
#For example in RHEL 4 U2 x86_64:
#$ ./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:
#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:
#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:
#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:
#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:
On my RHEL 4 U2 x86 system for 10g R2 (10.2.0.1.0) I installed the following RPM to fix this problem:
#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.rpmIn Fedora Core 4 x86 I installed the following RPM to fix this problem:
#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.rpmAfter 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:
#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
$ 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
地址: http://www.puschitz.com/InstallingOracle10g.shtml
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22608279/viewspace-668229/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22608279/viewspace-668229/