k/lib/libnmi.a(snmitcln.o)(.text+0x1603): more undefined references to `__ctype_b'''' follow collect2: ld returned 1 exit status make: *** [dbsnmp] Error 1 Click ignore. This will be fixed by applying the patch 3119415 after the 9.2.0.4 patchset has been applied. You won''''t be able to apply the patch 3119415 at this time since the file /opt/oracle/oraInventory/ContentsXML/comps.xml doesn''''t exist yet. Error in invoking target install of makefile /opt/oracle/product/9.2.0/ctx/lib/ins_ctx.mk. The /opt/oracle/product/9.2.0/install/make.log file reads: /usr/bin/ld: ctxhx: hidden symbol `stat'''' in /usr/lib/libc_nonshared.a(stat.oS) is referenced by DSO collect2: ld returned 1 exit status make: *** [ctxhx] Error 1 Click ignore. This is fixed by applying the 9.2.0.4 patchset. Patching Oracle9iR2: To patch Oracle9iR2, download the Oracle 9i Release 2 Patch Set 3 Version 9.2.0.4.0 for Linux x86 from http://metalink.oracle.com. Copy the downloaded "p3095277_9204_LINUX.zip" file to e.g. /tmp and run the following command: su - oracle $ cp p3095277_9204_LINUX.zip /tmp $ cd /tmp $ unzip p3095277_9204_LINUX.zip Archive: p3095277_9204_LINUX.zip inflating: 9204_lnx32_release.cpio inflating: README.html inflating: patchnote.css $ $ cpio -idmv < 9204_lnx32_release.cpio Disk1/stage/locks Disk1/stage/Patches/oracle.apache.isqlplus/9.2.0.4.0/1/DataFiles/bin.1.1.jar Disk1/stage/Patches/oracle.apache.isqlplus/9.2.0.4.0/1/DataFiles/lib.1.1.jar ... To patch the runInstaller, run: su - oracle $ echo $LD_ASSUME_KERNEL # it is important that this variable is set! 2.4.1 $ cd /tmp/Disk1/ $ ./runInstaller - Welcome Screen: Click Next - File Locations: Use default values - Available Products: Select "Oracle Universial Installer 2.2.0.18.0 !" - Components Locations: Accept default values and click Next - Summary: Start the Install - At the end of the installation, exit runInstaller! To patch Oracle9iR2, run: su - oracle $ echo $LD_ASSUME_KERNEL # it is important that this variable is set! 2.4.1 $ cd $ORACLE_HOME/bin $ ./runInstaller - Welcome Screen: Click Next - File Locations: Use default values - Available Products: Select "Oracle9iR2 Patch Set 3 9.2.0.4.0 !" - Summary: Start the Install - At the end of the installation, exit runInstaller You may get the following error: Error in invoking target install of makefile /opt/oracle/product/9.2.0/network/lib/ins_oemagent.mk. The /opt/oracle/product/9.2.0/install/make.log file reads: /opt/oracle/product/9.2.0/network/lib/libnmi.a(snmitcl.o)(.text+0x1cc): In function `get_ora_stmt_handle'''': : undefined reference to `__ctype_b'''' /opt/oracle/product/9.2.0/network/lib/libnmi.a(snmitcl.o)(.text+0x124e): In function `OraProcess_Oid'''': : undefined reference to `__ctype_b'''' /opt/oracle/product/9.2.0/network/lib/libnmi.a(snmitcl.o)(.text+0x176c): more undefined references to `__ctype_b'''' follow collect2: ld returned 1 exit status make: *** [dbsnmp] Error 1 Click ignore. This will be fixed by applying the patch 3119415 after the 9.2.0.4 patchset has been applied. The patch 3119415 cannot be applied while the patch process for the 9.2.0.4 patchset is running. After the 9.2.0.4 patchset has been applied, download the patch p3119415_9204_LINUX.zip from http://metalink.oracle.com. See bug 3119415 for more information. Also, download the opatch Release 2.2.0 utility from http://metalink.oracle.com. See bug 2617419 for more information. To install opatch, run: su - oracle $ cp p2617419_210_GENERIC.zip /tmp $ cd /tmp $ unzip p2617419_210_GENERIC.zip Before you apply the 3119415 patch, you need to make sure the fuser is accessable by the oracle user, see below. Otherwise the patch can''''t be applied since fuser is used by opatch. To apply the 3119415 patch, run su - oracle $ unzip p3119415_9204_LINUX.zip $ cd 3119415 $ export PATH=$PATH:/tmp/OPatch $ export PATH=$PATH:/sbin # the patch needs "fuser" which is located in /sbin $ which opatch /tmp/OPatch/opatch $ opatch apply Now you should be able to create a database with dbca: su - oracle dbca And don''''t forget to undo the changes (links) to /usr/bin/gcc and /usr/bin/g++ if you don''''t need it any more. Also don''''t forget the /etc/ld.so.preload file. Startup and Shutdown of the Oracle 9i Database sqlplus: svrmgrl is not supported any more. You can now do everything with sqlplus. For instance, to startup the database, run the following commands: oracle$ sqlplus /nolog SQL> connect / as sysdba SQL> startup The slash connects you to the schema owned by SYS. So in this example you will be connected to the schema owned by SYS with the privilege SYSDBA. SYSDBA gives you the following privileges: - sysoper privileges WITH ADMIN OPTION - create database - recover database until $ORACLE_HOME/bin/dbstart and $ORACLE_HOME/bin/dbshut You can also use $ORACLE_HOME/bin/dbstart to startup the database, and $ORACLE_HOME/bin/dbshut to shutdown the database. You can place $ORACLE_HOME/bin/dbstart into the /etc/rc.d/rc.local boot script to automatically bring up the database at system boot time. To get $ORACLE_HOME/bin/dbstart and $ORACLE_HOME/bin/dbshut working, you need to change the third field for your Oracle SID in /etc/oratab from "N" to "Y". For example, for the Oracle SID "test" I changed the line in /etc/oratab from: test:/opt/oracle/product/9.2.0:N to read: test:/opt/oracle/product/9.2.0:Y In some cases for 9.2.0 I also had to copy the init file for my SID "test" from /opt/oracle/admin/test/pfile to $ORACLE_HOME/dbs to get dbstart and dbshut working: cp /opt/oracle/admin/test/pfile/inittest.ora.642002224936 $ORACLE_HOME/dbs/inittest.ora But first make sure if your init file already exists in $ORACLE_HOME/dbs! If you want to properly integrate Oracle9i into the Red Hat Linux 7 SysV init process, check out http://www.gurulabs.com/downloads.html. "Oracle9i RHL Run Package" is based on a GPLd RPM provided by SuSE, but has been heavily modified to fit as seamlessly as possible into Red Hat Linux. Oracle Installation Problems, Tips and Hints Some of these problems apply only to 9.0.1! Do not cd to /mnt/cdrom to run ./runInstaller! If you do so, the installation will fail because you won''''t be able to change the CDs. If you forgot to set the DISPLAY environment variable (e.g. export DISPLAY=oracleserver:0.0), or if you forgot to give the remote console - your Oracle Server - authority to display X information on your desktop PC (e.g. xhost +oracleserver), then you will get the following error: Xlib: connection to ":0.0" refused by server Xlib: Client is not authorized to connect to Server In this case, I always had to kill runInstaller in Oracle9iR1 (9.0.1) which was still running in the background. If I didn''''t do this in 9.0.1, runInstaller didn''''t completely come up any more without displaying any error messages. You might also want to clean up /tmp/OraInstall. When runInstaller starts to configure the tools ("Configuration Tools"), the "Oracle Net Configuration Assistant" will sometimes hang. Simply stop the Assistant and restart it, or continue the installation. When the rest of the installation is finished, do a "Retry" for "Oracle Net Configuration Assistant". This always worked for me. When the system stops responding during the Oracle installation in particular during the database creation, then that''''s probably because you don''''t have enough RAM or enough swap space. I saw the whole system not responding or to "hang" for several minutes when I did not have enough swap space. If this happens, simply wait until the system starts to respond again. The Oracle installation also runs make etc. In a production environmen上一页 [1] [2] [3] [4] [5] [6] [7] 下一页 |