GET ORA-32700 WHEN TRYING TO CREATE DATABASE USING 9.2

GET ORA-32700 WHEN TRYING TO CREATE DATABASE USING 9.2
建庫時報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

 

> cp ins_rdbms.mk ins_rdbms.mk.bak20099017
> make -f ins_rdbms.mk rac_off
make -f ins_rdbms.mk ioracle    rm -f /orajzz/app/oracle/product/9.2.0/lib/libskgxp9.a
        cp /orajzz/app/oracle/product/9.2.0/lib//libskgxpd.a /orajzz/app/oracle/product/9.2.0/lib/libskgxp9.a
        rm -f /orajzz/app/oracle/product/9.2.0/lib/libskgxn9.a
        cp /orajzz/app/oracle/product/9.2.0/lib//libskgxns.a /orajzz/app/oracle/product/9.2.0/lib/libskgxn9.a
/bin/ar -X64 d /orajzz/app/oracle/product/9.2.0/rdbms/lib/libknlopt.a kcsm.o
        /bin/ar -X64 cr /orajzz/app/oracle/product/9.2.0/rdbms/lib/libknlopt.a /orajzz/app/oracle/product/9.2.0/rdbms/lib/ksnkcs.o
> make -f ins_rdbms.mk ioracle

 - Linking Oracle
        rm -f /orajzz/app/oracle/product/9.2.0/rdbms/lib/oracle
        ld -b64 -o /orajzz/app/oracle/product/9.2.0/rdbms/lib/oracle -L/orajzz/app/oracle/product/9.2.0/rdbms/lib/ -L/orajzz/app/oracle/product/9.2.0/lib/  -bbigtoc -bnoipath -bI:/orajzz/app/oracle/product/9.2.0/lib/ksms.imp /orajzz/app/oracle/product/9.2.0/rdbms/lib/opimai.o /orajzz/app/oracle/product/9.2.0/rdbms/lib/ssoraed.o /orajzz/app/oracle/product/9.2.0/rdbms/lib/ttcsoi.o  /orajzz/app/oracle/product/9.2.0/lib/nautab.o /orajzz/app/oracle/product/9.2.0/lib/naeet.o /orajzz/app/oracle/product/9.2.0/lib/naect.o /orajzz/app/oracle/product/9.2.0/lib/naedhs.o /orajzz/app/oracle/product/9.2.0/rdbms/lib/config.o  -lserver9 /orajzz/app/oracle/product/9.2.0/lib/libodm9.so  -lskgxp9 -lskgxn9 -lclient9  -lvsn9 -lwtcserver9  -lcommon9 -lgeneric9 /orajzz/app/oracle/product/9.2.0/rdbms/lib/defopt.o -lknlopt  `if /bin/ar -X64 tv /orajzz/app/oracle/product/9.2.0/rdbms/lib/libknlopt.a | grep xsyeolap.o > /dev/null 2>&1 ; then echo "-loraolap9 -bE:/orajzz/app/oracle/product/9.2.0/rdbms/lib/olap.exp" ; fi` -lslax9 -lpls9  -lplp9 -bE:/orajzz/app/oracle/product/9.2.0/rdbms/lib/plsqlncomp.exp  -lserver9 -lclient9  -lvsn9 -lwtcserver9  -lcommon9 -lgeneric9  -lknlopt -lslax9 -lpls9  -lplp9  -ljox9 -bE:/orajzz/app/oracle/product/9.2.0/rdbms/lib//oracle.exp  -lwwg9  `sed -e 's/-ljava//g' /orajzz/app/oracle/product/9.2.0/lib/ldflags`      -lncrypt9 -lnsgr9 -lnzjs9 -ln9  -lnl9 -lnzjs9 -lnro9 `sed -e 's/-ljava//g' /orajzz/app/oracle/product/9.2.0/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' /orajzz/app/oracle/product/9.2.0/lib/ldflags`      -lncrypt9 -lnsgr9 -lnzjs9 -ln9  -lnl9 -lnzjs9 -lnro9 `sed -e 's/-ljava//g' /orajzz/app/oracle/product/9.2.0/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 /orajzz/app/oracle/product/9.2.0/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:/orajzz/app/oracle/product/9.2.0/rdbms/lib//libcorejava.exp  -lld -lm `cat /orajzz/app/oracle/product/9.2.0/lib/sysliblist`  -lm  `if [ "\`/usr/bin/uname -v\`" = "4" ]; \
        then echo "-bI:/orajzz/app/oracle/product/9.2.0/lib/pw-syscall.exp"; fi;`  `if /bin/ar -X64 t /orajzz/app/oracle/product/9.2.0/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 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 lxgu2t is already exported.
ld: 0711-415 WARNING: Symbol sldxgd is already exported.
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-319 WARNING: Exported symbol not defined: puisun_SetUserName
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/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 /orajzz/app/oracle/product/9.2.0/lib//liboraolap9.a[xsft.o], imported symbol kslltt_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//liboraolap9.a[xsft.o], imported symbol kslltl_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//liboraolap9.a[xsft.o], imported symbol ksupro_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//libordsdo9.a[mdowd.o], imported symbol ksuitpr_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//libordsdo9.a[mdidx.o], imported symbol ksuitpr_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//liboraolap9.a[ExpressOlapiDataSourceModule_s.o], imported symbol ksuitpr_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//liboraolap9.a[ExpressConnectionModule_s.o], imported symbol ksuitpr_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//liboraolap9.a[ExpressOlapiDataSourceModule.o], imported symbol ksuitpr_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//liboraolap9.a[ExpressOlapiDataCursorModule.o], imported symbol ksuitpr_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//liboraolap9.a[ExpressMdmModule.o], imported symbol ksuitpr_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//liboraolap9.a[ExpressConnectionModule.o], imported symbol ksuitpr_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//liboraolap9.a[ExpressModule.o], imported symbol ksuitpr_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//liboraolap9.a[xsoqoes.o], imported symbol ksuitpr_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//liboraolap9.a[xsknx.o], imported symbol ksuitpr_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/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 /orajzz/app/oracle/product/9.2.0/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-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//liboraolap9.a[xsdbpc.o], imported symbol kcmshr_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//liboraolap9.a[update.o], imported symbol kcmshr_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//liboraolap9.a[xsdbpc.o], imported symbol kxfpxser_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//liboraolap9.a[xsdbpc.o], imported symbol xsdbpcc_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//liboraolap9.a[xsdbpc.o], imported symbol xsdbpccdata_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//liboraolap9.a[xsdbpc.o], imported symbol xsdbpccerep_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//liboraolap9.a[xsdbpc.o], imported symbol xsdbpcdqr_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//liboraolap9.a[xsdbpc.o], imported symbol xsdbpcdqe_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//liboraolap9.a[update.o], imported symbol xspgcco_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//liboraolap9.a[xsft.o], imported symbol xscalcflw1_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//liboraolap9.a[xsft.o], imported symbol xscalcflw2_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//liboraolap9.a[xsft.o], imported symbol xscalcflw3_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//liboraolap9.a[xsft.o], imported symbol xssinfoflw1_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//liboraolap9.a[xsft.o], imported symbol xssinfoflw2_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//liboraolap9.a[xsawsga.o], imported symbol xsawsga_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//liboraolap9.a[xsawsga.o], imported symbol xsawSGAlopen_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//liboraolap9.a[xsawsga.o], imported symbol xsawSGAlclose_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /orajzz/app/oracle/product/9.2.0/lib//liboraolap9.a[xsawsga.o], imported symbol xsawst_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-783 WARNING: TOC overflow. TOC size: 102112    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 /orajzz/app/oracle/product/9.2.0/bin/oracle /orajzz/app/oracle/product/9.2.0/bin/oracleO
        mv /orajzz/app/oracle/product/9.2.0/rdbms/lib/oracle /orajzz/app/oracle/product/9.2.0/bin/oracle
        chmod 6751 /orajzz/app/oracle/product/9.2.0/bin/oracle
>