解决DBCA的ORA-32700错误

解决DBCA的ORA-32700错误

 

在IBM原RAC环境的小机上，尝试用DBCA建立一个单机的数据库实例，报ORA-32700错误．

在网上找到相关的解决方案如下．来自Itpuber. Paulyibinyi

 

建库时报ORA-32700,原因如下

如果Oracle 9i装在cluster OS系统上，默认会选上Oracle RAC组建，导致建库报ORA-32700，移除RAC组件关闭gis实例

而我安装是在cluster os上创建一个单实例数据库的。所以解决方法如下：

Disable the RAC option, since it is not going to be used .

1. Login as the Oracle software owner and shutdown all database instances on all nodes

in the cluster. ( if any db available )

2. cd $ORACLE_HOME/rdbms/lib (Make sure that you have the env variables are set right)

3. make -f ins_rdbms.mk rac_off

If this step did not fail with fatal errors, proceed to step 4.

4. make -f ins_rdbms.mk ioracl

 

cd $ORACLE_HOME/rdbms/lib

make -f ins_rdbms.mk rac_off

make -f ins_rdbms.mk ioracle

 

 

 

操作步骤如下：

oracle@aix01:/u01/app/oracle/product/9i/rdbms/lib>cp ins_rdbms.mk ins_rdbms.mk.201011025

 

oracle@aix01:/u01/app/oracle/product/9i/rdbms/lib> touch /tmp/now9.14

 

oracle@aix01:/u01/app/oracle/product/9i/rdbms/lib>make -f ins_rdbms.mk rac_off

        rm -f /u01/app/oracle/product/9i/lib/libskgxp9.a

        cp /u01/app/oracle/product/9i/lib//libskgxpd.a /u01/app/oracle/product/9i/lib/libskgxp9.a

        rm -f /u01/app/oracle/product/9i/lib/libskgxn9.a

        cp /u01/app/oracle/product/9i/lib//libskgxns.a /u01/app/oracle/product/9i/lib/libskgxn9.a

/bin/ar -X64 d /u01/app/oracle/product/9i/rdbms/lib/libknlopt.a kcsm.o

        /bin/ar -X64 cr /u01/app/oracle/product/9i/rdbms/lib/libknlopt.a /u01/app/oracle/product/9i/rdbms/lib/ksnkcs.o

 

oracle@aix01:/u01/app/oracle/product/9i/rdbms/lib>make -f ins_rdbms.mk ioracle

 - Linking Oracle

        rm -f /u01/app/oracle/product/9i/rdbms/lib/oracle

        ld -b64 -o /u01/app/oracle/product/9i/rdbms/lib/oracle -L/u01/app/oracle/product/9i/rdbms/lib/ -L/u01/app/oracle/product/9i/lib/  -bbigtoc -bnoipath -bI:/u01/app/oracle/product/9i/lib/ksms.imp /u01/app/oracle/product/9i/rdbms/lib/opimai.o /u01/app/oracle/product/9i/rdbms/lib/ssoraed.o /u01/app/oracle/product/9i/rdbms/lib/ttcsoi.o  /u01/app/oracle/product/9i/lib/nautab.o /u01/app/oracle/product/9i/lib/naeet.o /u01/app/oracle/product/9i/lib/naect.o /u01/app/oracle/product/9i/lib/naedhs.o /u01/app/oracle/product/9i/rdbms/lib/config.o  -lserver9 /u01/app/oracle/product/9i/lib/libodm9.so  -lskgxp9 -lskgxn9 -lclient9  -lvsn9 -lwtcserver9  -lcommon9 -lgeneric9 /u01/app/oracle/product/9i/rdbms/lib/defopt.o -lknlopt  `if /bin/ar -X64 tv /u01/app/oracle/product/9i/rdbms/lib/libknlopt.a | grep xsyeolap.o > /dev/null 2>&1 ; then echo "-loraolap9 -bE:/u01/app/oracle/product/9i/rdbms/lib/olap.exp" ; fi` -lslax9 -lpls9  -lplp9 -bE:/u01/app/oracle/product/9i/rdbms/lib/plsqlncomp.exp  -lserver9 -lclient9  -lvsn9 -lwtcserver9  -lcommon9 -lgeneric9  -lknlopt -lslax9 -lpls9  -lplp9  -ljox9 -bE:/u01/app/oracle/product/9i/rdbms/lib//oracle.exp  -lwwg9  `sed -e 's/-ljava//g' /u01/app/oracle/product/9i/lib/ldflags`      -lncrypt9 -lnsgr9 -lnzjs9 -ln9  -lnl9 -lnzjs9 -lnro9 `sed -e 's/-ljava//g' /u01/app/oracle/product/9i/lib/ldflags`      -lncrypt9 -lnsgr9 -lnzjs9 -ln9 

……………..     

oracle@aix01:/u01/app/oracle/product/9i>find ./ -newer /tmp/now9.14

./bin

./bin/oracle

./rdbms/lib

./rdbms/lib/libknlopt.a

./lib

./lib/libskgxp9.a

./lib/libskgxn9.a       

 

对比发现是更新了四个文件．

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10248702/viewspace-676702/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10248702/viewspace-676702/