这个错误是我在一个客户那里安装9i的时候报出来的,当时是先安装配置好了HACMP,然后再安装ORACLE的,安装软件的时候会出现一些的画面:
如果是在本机终端上安装,是不会出现这个画面的,当时是通过Xmanager来安装的,所以出现了这个问题,Oracle9i安装的时候比较傻,但检测到HA环境的时候就安装RAC的RDBMS,这就导致后来创建数据库的时候出现以下错误:
SQL> startup pfile='/home/oracle/pfile_test.ora' nomount
ORA-27504: Message 27504 not found; product=RDBMS; facility=ORA
ORA-27300: OS system dependent operation:socket failed with status: 68
ORA-27301: OS failure message: Can't assign requested address
ORA-27302: failure occurred at: sskgxpcre1
用DBCA建库,出现以下画面:
出现这种情况就不能创建数据库了!
出现这个错误就是我们安装的RAC的rdbms,那么将RAC选项关闭就可以了:
# su - oracle
$ ar -X32_64 -vt $ORACLE_HOME/rdbms/lib/libknlopt.a | grep ksnkcs
--正确的话,它应该有输出$ ar -X32_64 -vt $ORACLE_HOME/rdbms/lib/libknlopt.a | grep kcsm
--正确的话,它应该没有输出rw-r--r-- 300/203 2278 May 13 19:33 2002 kcsm.o
$ ar -X32_64 -vt $ORACLE_HOME/rdbms/lib/libknlopt.a | grep ksnkcs
$ cd $ORACLE_HOME/rdbms/lib
$ ls -l|grep ins_
-rw-r--r-- 1 oracle dba 21651 May 10 2002 ins_rdbms.mk
$ make -f ins_rdbms.mk rac_off <-- 将RAC选择关闭! rm -f /u01/app/oracle/product/9.2.0/db_1/lib/libskgxp9.a
cp /u01/app/oracle/product/9.2.0/db_1/lib//libskgxpd.a /u01/app/oracle/product/9.2.0/db_1/lib/libskgxp9.a
rm -f /u01/app/oracle/product/9.2.0/db_1/lib/libskgxn9.a
cp /u01/app/oracle/product/9.2.0/db_1/lib//libskgxns.a /u01/app/oracle/product/9.2.0/db_1/lib/libskgxn9.a
/bin/ar -X64 d /u01/app/oracle/product/9.2.0/db_1/rdbms/lib/libknlopt.a kcsm.o
/bin/ar -X64 cr /u01/app/oracle/product/9.2.0/db_1/rdbms/lib/libknlopt.a /u01/app/oracle/product/9.2.0/db_1/rdbms/lib/ksnkcs.o
$ make -f ins_rdbms.mk ioracle - Linking Oracle
rm -f /u01/app/oracle/product/9.2.0/db_1/rdbms/lib/oracle
ld -b64 -o /u01/app/oracle/product/9.2.0/db_1/rdbms/lib/oracle -L/u01/app/oracle/product/9.2.0/db_1/rdbms/lib/ -L/u01/app/oracle/product/9.2.0/db_1/lib/ -bbigtoc -bnoipath -bI:/u01/app/oracle/product/9.2.0/db_1/lib/ksms.imp /u01/app/oracle/product/9.2.0/db_1/rdbms/lib/opimai.o /u01/app/oracle/product/9.2.0/db_1/rdbms/lib/ssoraed.o /u01/app/oracle/product/9.2.0/db_1/rdbms/lib/ttcsoi.o /u01/app/oracle/product/9.2.0/db_1/lib/nautab.o /u01/app/oracle/product/9.2.0/db_1/lib/naeet.o /u01/app/oracle/product/9.2.0/db_1/lib/naect.o /u01/app/oracle/product/9.2.0/db_1/lib/naedhs.o /u01/app/oracle/product/9.2.0/db_1/rdbms/lib/config.o -lserver9 /u01/app/oracle/product/9.2.0/db_1/lib/libodm9.so -lskgxp9 -lskgxn9 -lclient9 -lvsn9 -lwtcserver9 -lcommon9 -lgeneric9 /u01/app/oracle/product/9.2.0/db_1/rdbms/lib/defopt.o -lknlopt `if /bin/ar -X64 tv /u01/app/oracle/product/9.2.0/db_1/rdbms/lib/libknlopt.a | grep xsyeolap.o > /dev/null 2>&1 ; then echo "-loraolap9 -bE:/u01/app/oracle/product/9.2.0/db_1/rdbms/lib/olap.exp -bE:/u01/app/oracle/product/9.2.0/db_1/rdbms/lib/libamd.exp" ; fi` -lslax9 -lpls9 -lplp9 -bE:/u01/app/oracle/product/9.2.0/db_1/rdbms/lib/plsqlncomp.exp -lserver9 -lclient9 -lvsn9 -lwtcserver9 -lcommon9 -lgeneric9 -lknlopt -lslax9 -lpls9 -lplp9 -ljox9 -bE:/u01/app/oracle/product/9.2.0/db_1/rdbms/lib//oracle.exp -lwwg9 `sed -e 's/-ljava//g' /u01/app/oracle/product/9.2.0/db_1/lib/ldflags` -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lnzjs9 -lnro9 `sed -e 's/-ljava//g' /u01/app/oracle/product/9.2.0/db_1/lib/ldflags` -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lnzjs9 -lclient9 -lvsn9 -lwtcserver9 -lcommon9 -lgeneric9 -lwtcserver9 -lmm -lnls9 -lcore9 -lnls9 -lcore9 -lnls9 -lxml9 -lcore9 -lunls9 -lnls9 `sed -e 's/-ljava//g' /u01/app/oracle/product/9.2.0/db_1/lib/ldflags` -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lnzjs9 -lnro9 `sed -e 's/-ljava//g' /u01/app/oracle/product/9.2.0/db_1/lib/ldflags` -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lnzjs9 -lclient9 -lvsn9 -lwtcserver9 -lcommon9 -lgeneric9 -lpls9 -ltrace9 -lnls9 -lcore9 -lnls9 -lcore9 -lnls9 -lxml9 -lcore9 -lunls9 -lnls9 -lclient9 -lvsn9 -lwtcserver9 -lcommon9 -lgeneric9 -lnls9 -lcore9 -lnls9 -lcore9 -lnls9 -lxml9 -lcore9 -lunls9 -lnls9 -lserver9 `if /bin/ar -X64 tv /u01/app/oracle/product/9.2.0/db_1/rdbms/lib/libknlopt.a | grep "kxmnsd.o" > /dev/null 2>&1 ; then echo " " ; else echo "-lordsdo9"; fi` -lctxc9 -lctx9 -lzx9 -lgx9 -lctx9 -lzx9 -lgx9 -lordimt9 -lnls9 -lcore9 -lnls9 -lcore9 -lnls9 -lxml9 -lcore9 -lunls9 -lnls9 -lsnls9 -lunls9 -bE:/u01/app/oracle/product/9.2.0/db_1/rdbms/lib//libcorejava.exp -lld -lm `cat /u01/app/oracle/product/9.2.0/db_1/lib/sysliblist` -lm `if [ "\`/usr/bin/uname -v\`" = "4" ]; \
then echo "-bI:/u01/app/oracle/product/9.2.0/db_1/lib/pw-syscall.exp"; fi;` `if /bin/ar -X64 t /u01/app/oracle/product/9.2.0/db_1/rdbms/lib/libknlopt.a | grep '^'kcsm.o > /dev/null 2>&1 ; then echo "-lha_gs64_r -lha_em_r"; fi` -locijdbcst9 -lxsd9
ld: 0711-415 WARNING: Symbol lxscop is already exported.
ld: 0711-415 WARNING: Symbol ociepgoe is already exported.
ld: 0711-415 WARNING: Symbol pevm_INMDH_INDEXED_ADT is already exported.
ld: 0711-415 WARNING: Symbol pevm_INMDH_INDEXED_CHAR is already exported.
ld: 0711-415 WARNING: Symbol pevm_INMDH_INDEXED_DATETIME is already exported.
ld: 0711-415 WARNING: Symbol pevm_INMDH_INDEXED_INDEXED is already exported.
ld: 0711-415 WARNING: Symbol pevm_INMDH_INDEXED_INTERVAL is already exported.
ld: 0711-415 WARNING: Symbol pevm_INMDH_INDEXED_LOB is already exported.
ld: 0711-415 WARNING: Symbol pevm_INMDH_INDEXED_OBJREF is already exported.
ld: 0711-415 WARNING: Symbol pevm_INMDH_INDEXED_OPQ is already exported.
ld: 0711-415 WARNING: Symbol pevm_INMDH_INDEXED_SSCALAR is already exported.
ld: 0711-415 WARNING: Symbol pevm_INMDH_INDEXED_UROWID is already exported.
ld: 0711-415 WARNING: Symbol plzcls is already exported.
ld: 0711-415 WARNING: Symbol plzexe is already exported.
ld: 0711-415 WARNING: Symbol plzopn is already exported.
ld: 0711-415 WARNING: Symbol plzosq is already exported.
ld: 0711-415 WARNING: Symbol pevm_ENTER is already exported.
ld: 0711-415 WARNING: Symbol pevm_MOVX is already exported.
ld: 0711-415 WARNING: Symbol peslcl2 is already exported.
ld: 0711-415 WARNING: Symbol ldxdts is already exported.
ld: 0711-415 WARNING: Symbol ldxsto is already exported.
ld: 0711-415 WARNING: Symbol sldxgd is already exported.
ld: 0711-224 WARNING: Duplicate symbol: .bcopy
ld: 0711-224 WARNING: Duplicate symbol: .memmove
ld: 0711-224 WARNING: Duplicate symbol: .fsav
ld: 0711-224 WARNING: Duplicate symbol: .fres
ld: 0711-224 WARNING: Duplicate symbol: .isnan
ld: 0711-224 WARNING: Duplicate symbol: .ceil
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.
ld: 0711-319 WARNING: Exported symbol not defined: pen_PIPE
ld: 0711-319 WARNING: Exported symbol not defined: pevm_MOVCADT
ld: 0711-319 WARNING: Exported symbol not defined: pevm_MOVL
ld: 0711-319 WARNING: Exported symbol not defined: pevm_MOVS
ld: 0711-319 WARNING: Exported symbol not defined: pifi_i
ld: 0711-773 WARNING: Object /u01/app/oracle/product/9.2.0/db_1/lib//liboraolap9.a[sxstime.o], imported symbol timezone
Symbol was expected to be local. Extra instructions
are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u01/app/oracle/product/9.2.0/db_1/lib//libordsdo9.a[mdrcr.o], imported symbol kcbstdbz_
Symbol was expected to be local. Extra instructions
are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u01/app/oracle/product/9.2.0/db_1/lib//libordsdo9.a[mdrt.o], imported symbol kcbstdbz_
Symbol was expected to be local. Extra instructions
are being generated to reference the symbol.
ld: 0711-783 WARNING: TOC overflow. TOC size: 100496 Maximum size: 65536
Extra instructions are being generated for each reference to a TOC
symbol if the symbol is in the TOC overflow area.
mv -f /u01/app/oracle/product/9.2.0/db_1/bin/oracle /u01/app/oracle/product/9.2.0/db_1/bin/oracleO
mv /u01/app/oracle/product/9.2.0/db_1/rdbms/lib/oracle /u01/app/oracle/product/9.2.0/db_1/bin/oracle
chmod 6751 /u01/app/oracle/product/9.2.0/db_1/bin/oracle
$ ar -X32_64 -vt $ORACLE_HOME/rdbms/lib/libknlopt.a | grep kcsm -
-没有输出结果说明现在正确了$ ar -X32_64 -vt $ORACLE_HOME/rdbms/lib/libknlopt.a | grep ksnkcs
--有输出结果说明现在正确了rw-r--r-- 300/203 2382 May 13 19:33 2002 ksnkcs.o