installation environment
[root@rac1 ~]# uname -a
Linux rac1 2.6.9-78.ELsmp #1 SMP Wed Jul 9 15:39:47 EDT 2008 i686 i686 i386 GNU/Linux
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
unset USERNAME
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/db9i
export ORACLE_SID=orcl1
export LD_LIBRABRY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
export TNS_ADMIN=$ORACLE_HOME/network/admin
export TMP=/tmp
umask 022
if [ $USER = "oracle" ];then
if [ $SHELL = "/bin/ksh" ];then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
LD_ASSUME_KERNEL=2.4.19
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
安装问题1:Error occurred during initialization of VM Unable to load library:
/tmp/OraInstall2007-03-20_06-31-37PM/jre/lib/i386/libjava.so: symbol __libc_wait.version GLIBC_2.0 not
defined in file libc.so.6 with link time reference
解决方法:此问题的发生是由于oracle的安装缺少一个补丁:p3006854_9204 patch p3006854_9204_LINUX.zip
下载地址: http://www.idevelopment.info/data/Oracle/DBA_tips/Linux/FedoraCore2_RPMS/p3006854_9204_LINUX.zip
使用方法:在终端中运行:# unzip p3006854_9204_LINUX.zip
Archive: p3006854_9204_LINUX.zip
creating: 3006854/
inflating: 3006854/rhel3_pre_install.sh
inflating: 3006854/README.txt
[oracle@rac1 u01]$ cd 3006854/
[oracle@rac1 3006854]$ ls
README.txt rhel3_pre_install.sh
[oracle@rac1 3006854]$ ./rhel3_pre_install.sh
-bash: ./rhel3_pre_install.sh: Permission denied
[oracle@rac1 3006854]$ ll
total 8
-rw-rw-r-- 1 oracle oinstall 1127 Oct 22 2003 README.txt
-rw-r--r-- 1 oracle oinstall 930 Oct 22 2003 rhel3_pre_install.sh
[oracle@rac1 3006854]$ chmod 777 rhel3_pre_install.sh
[oracle@rac1 3006854]$ ./rhel3_pre_install.sh
Must be root to run this script, please login as root and re-try
[oracle@rac1 3006854]$ su -
Password:
[root@rac1 ~]# cd /u01
[root@rac1 u01]# cd 3006854/
[root@rac1 3006854]# ./rhel3_pre_install.sh
Applying patch...
Patch successfully applied
问题2:
Exception String: Error in invoking target install of makefile
/orasys/oracle/product/9.2.0/plsql/lib/ins_plsql.mk
解决方法:
在linux下执行以下操作
mv /usr/bin/gcc /usr/bin/gccold
mv /usr/bin/gcc32 /usr/bin/gcc
然后安装正常 成功后记的改回去
mv /usr/bin/gcc /usr/bin/gcc32
mv /usr/bin/gccold /usr/bin/gcc
问题3:解决Agent Configuration Assistant安装失败
$ unzip p3238244_9204_LINUX.zip
$ cp 3238244/files/lib/stubs/* $ORACLE_HOME/lib/stubs/
$ cd $ORACLE_HOME/network/lib/
$ make -f ins_oemagent.mk install
下载 OPatch p6880880_101000_LINUX.zip
unzip p6880880_101000_LINUX.zip
cp -a OPatch/ $ORACLE_HOME/.
[oracle@rac1 ~]$ cd 3238244/
[oracle@rac1 3238244]$ opatch apply
Oracle Interim Patch Installer version 1.0.0.0.63
Copyright (c) 2009 Oracle Corporation. All Rights Reserved..
Oracle recommends you to use the latest OPatch version
and read the OPatch documentation available in the OPatch/docs
directory for usage. For information about the latest OPatch and
other support-related issues, refer to document ID 293369.1
available on My Oracle Support (https://myoraclesupport.oracle.com)
Oracle Home : /u01/app/oracle/db9i
Oracle Home Inventory : /u01/app/oracle/oraInventory
Central Inventory : /u01/app/oracle/oraInventory
from : /etc/oraInst.loc
OUI location : /u01/app/oracle/oui
OUI shared library : /u01/app/oracle/oui/bin/linux/liboraInstaller.so
Java location : /u01/app/oracle/jre/1.3.1/bin/java
Log file location : /u01/app/oracle/db9i/.patch_storage//*.log
Creating log file "/u01/app/oracle/db9i/.patch_storage/3238244/Apply_3238244_01- 13-2011_02-06-41.log"
Invoking fuser to check for active processes.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y
Oracle Configuration Manager has been installed but not configured. OCM enables
Oracle to provide superior, proactive support for our customers. Oracle
strongly recommends customers configure OCM. To complete the configuration of
OCM, refer to the OCM Installation and Administration Guide
(http://www.oracle.com/technology/documentation/ocm.html).
Backing up comps.xml ...
OPatch detected non-cluster Oracle Home from the inventory and will patch the lo cal system only.
Please shut down Oracle instances running out of this ORACLE_HOME
(Oracle Home = /u01/app/oracle/db9i)
Is this system ready for updating?
Please respond Y|N >
y
Applying patch 3238244...
Patching copy files...
Inventory is good and does not have any dangling patches.
Updating inventory...
Verifying patch...
Backing up comps.xml ...
OPatch succeeded.
[oracle@rac1 3238244]$ agentctl start
DBSNMP for Linux: Version 9.2.0.4.0 - Production on 13-JAN-2011 02:08:53
Copyright (c) 2003 Oracle Corporation. All rights reserved.
Starting Oracle Intelligent Agent...\nAgent startup failed.
Check /u01/app/oracle/db9i/network/log/dbsnmp.nohup for details
[oracle@rac1 3238244]$ more /u01/app/oracle/db9i/network/log/dbsnmp.nohup
------------------------ Thu Jan 13 01:18:58 EST 2011 ------------------------
Failed while initializing Comm service
Error initializing subsystems
Agent exited at Thu Jan 13 01:18:59 EST 2011 with return value 55
Could not start agent. Initialization failure
solution:
vi /etc/hosts--add host ip hostname
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
This version of OPatch is obsolete. Please go to https://myoraclesupport.oracle.com
and download Patch 6880880, choosing your platform. and the OPatch version
applicable to your system. For example, if OUI 10.1 is installed in this Oracle home, then
choose 10.1.0.0.0 to obtain the latest 1.0.0.0.xx version for your Oracle Home.
ERROR: OPatch failed because of cmd. args. problem.
这个是版本问题
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
问题4:解决 Oracle Net Configuration Assistant, Oracle Database Configuration Assistant 安装失败
$ rm $ORACLE_HOME/JRE
$ ln -s $ORACLE_BASE/jre/1.3.1/ $ORACLE_HOME/JRE
$ ln -s $ORACLE_HOME/JRE/bin/java $ORACLE_HOME/JRE/bin/jre
$ ln -s $ORACLE_HOME/JRE/bin/i386/native_threads/java $ORACLE_HOME/JRE/bin/i386/native_threads/jre
reference to below urls:
http://www.wm000.com/jiaocheng_view.asp?id=253
http://hi.baidu.com/ubuntu110/blog/item/2fa7863e1bf157cb7d1e71c4.html
http://v64500.**.com/blog/224658
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for Linux: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production
注:
[oracle@rac1 3238244]$ opatch apply
PERL5LIB=/u01/app/oracle/db9i/Apache/perl/lib/5.00503:/u01/app/oracle/db9i/OPatch/perl_modules; export PERL5LIB
/u01/app/oracle/db9i/Apache/perl/bin/perl /u01/app/oracle/db9i/OPatch/opatch.pl apply
OPatch Version 1.0.0.0.48
Perl Version 5.00503
/u01/app/oracle/db9i/OPatch/opatch.pl version: 1.0.0.0.48
Copyright (c) 2001,2002,2003 Oracle Corporation. All Rights Reserved.
Some commands below are not in your path:
Command= fuser
Path= /u01/app/oracle/db9i/bin:/u01/app/oracle/db9i/OPatch:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/u01/app/oracle/bin
fuser在/sbin 下 把sbin放入path中即可
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/21993926/viewspace-683748/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/21993926/viewspace-683748/