解決DBCA的ORA-32700錯誤

gdutllf2006發表於2010-10-25

解決DBCAORA-32700錯誤

 

IBMRAC環境的小機上,嘗試用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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章