ORACLE ORA-27504 ORA-27300 ORA-27301 ORA-27302 ORA-27303 問題處理

環境: oracle + 10.2.0.4 rac
變成單機

make -f ins_rdbms.mk rac_off ioracle   --這個是關鍵點

[oracle@RAC1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Fri May 9 11:51:22 2014

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup nomount pfile='/home/oracle/initprod.ora';
ORA-27504: IPC error creating OSD context
ORA-27300: OS system dependent operation:gethostbyname failed with status: 0
ORA-27301: OS failure message: Error 0
ORA-27302: failure occurred at: skgxpiphost4
ORA-27303: additional information: requested interface 138.30.0.101 not found. Check output from ifconfig command
SQL>
SQL>
SQL> exit
Disconnected
[oracle@RAC1 ~]$
[oracle@RAC1 ~]$
[oracle@RAC1 ~]$ cd $ORACLE_HOME
[oracle@RAC1 db_1]$ ls
assistants   dbs               jdk      nls          owm            slax
bin          demo              jlib     oc4j         perl           sqlj
ccr          diagnostics       jre      odbc         plsql          sqlplus
cdata        has               ldap     olap         precomp        srvm
cfgtoollogs  hs                lib      OPatch       racg           sysman
clone        install           log      opmn         rdbms          uix
config       install.platform  md       oracore      relnotes       wwg
crs          inventory         mesg     oraInst.loc  root.sh        xdk
css          javavm            mgw      ord          root.sh.old
ctx          jdbc              network  oui          root.sh.old.1
[oracle@RAC1 db_1]$ cd rdbms
[oracle@RAC1 rdbms]$ ls
admin  demo  install  label.info  log   notes   xml
audit  doc   jlib     lib         mesg  public
[oracle@RAC1 rdbms]$ cd lib
[oracle@RAC1 lib]$ ls
config.c      jox.o      ksnnt2.o        rfscom.o    sskfeded.o
config.o      joxoff.o   ktd.o           rfsd.o      sskfoded.o
cursize.o     kciwcx.o   kxmnsd.o        rfsin.o     sskrmed.o
dbfsize.o     kcsm.o     kxmwsd.o        rfsxc.o     sskrned.o
defopt.o      kecnr.o    kzlnlbac.o      s0exudrv.o  sskrsed.o
dmndm.o       kecwr.o    kzvndv.o        s0impdrv.o  ssoraed.o
dmndmse.o     kfod.o     libdbtools10.a  s0kudbv.o   sstrced.o
dmwdm.o       kgupc.o    libdsga10.a     s0kuzr.o    strcpt.o
dumpsga.o     kgutc.o    libknlopt.a     s0kvpf.o    sulmain.o
env_rdbms.mk  kkpoban.o  libodm10.a      s0udexp.o   tg4pwd.o
genezi.o      kkxntp.o   libperfsrv10.a  s0udimp.o   tstshm.o
genksms.o     kkxwtp.o   libqsmashr.a    sbbdpt.o    ttcoerr.o
hoaoci.o      kopc.o     libskgxns.a     shorm.o     ttcsoi.o
hoat.o        kprnts.o   libskgxpd.a     shou.o      Turning RAC on
hoax.o        kprwts.o   libskgxpg.a     sjsex.o     wpspldrv.o
homts.o       kpucb.o    libskgxpr.a     skfedpt.o   xaondy.o
hormc.o       kpudfo.o   libskgxpu.a     skfodpt.o   xaonsl.o
hormd.o       kpundf.o   libxdb.a        skrmpt.o    xsnoolap.o
horm.o        ksms.o     mapsga.o        skrnpt.o    xsyeolap.o
hormt.o       ksnkcs.o   maxmem.o        skrspt.o    zsmsdrv.o
hout.o        ksnkkpo.o  nmliblist       sllfls.o
hsxaora.o     ksnktd.o   opimai.o        srfsd.o
ins_rdbms.mk  ksnnni.o   osh.o           ssbbded.o
[oracle@RAC1 lib]$ make -f ins_rdbms.mk rac_off ioracle  --這步實現
rm -f /home/oracle/10gR2/db_1/lib/libskgxp10.so
cp /home/oracle/10gR2/db_1/lib//libskgxpd.so /home/oracle/10gR2/db_1/lib/libskgxp10.so
rm -f /home/oracle/10gR2/db_1/lib/libskgxn2.so
cp /home/oracle/10gR2/db_1/lib//libskgxns.so \
              /home/oracle/10gR2/db_1/lib/libskgxn2.so
/usr/bin/ar d /home/oracle/10gR2/db_1/rdbms/lib/libknlopt.a kcsm.o
/usr/bin/ar cr /home/oracle/10gR2/db_1/rdbms/lib/libknlopt.a /home/oracle/10gR2/db_1/rdbms/lib/ksnkcs.o
chmod 755 /home/oracle/10gR2/db_1/bin

 - Linking Oracle
rm -f /home/oracle/10gR2/db_1/rdbms/lib/oracle
gcc  -o /home/oracle/10gR2/db_1/rdbms/lib/oracle -L/home/oracle/10gR2/db_1/rdbms/lib/ -L/home/oracle/10gR2/db_1/lib/ -L/home/oracle/10gR2/db_1/lib/stubs/ -L/usr/lib -lirc   -Wl,-E `test -f /home/oracle/10gR2/db_1/rdbms/lib/sskgpsmti.o && echo /home/oracle/10gR2/db_1/rdbms/lib/sskgpsmti.o` /home/oracle/10gR2/db_1/rdbms/lib/opimai.o /home/oracle/10gR2/db_1/rdbms/lib/ssoraed.o /home/oracle/10gR2/db_1/rdbms/lib/ttcsoi.o /home/oracle/10gR2/db_1/rdbms/lib/defopt.o  -Wl,--whole-archive -lperfsrv10 -Wl,--no-whole-archive /home/oracle/10gR2/db_1/lib/nautab.o /home/oracle/10gR2/db_1/lib/naeet.o /home/oracle/10gR2/db_1/lib/naect.o /home/oracle/10gR2/db_1/lib/naedhs.o /home/oracle/10gR2/db_1/rdbms/lib/config.o  -lserver10 -lodm10 -lnnet10 -lskgxp10 -lsnls10 -lnls10  -lcore10 -lsnls10 -lnls10 -lcore10 -lsnls10 -lnls10 -lxml10 -lcore10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 -lhasgen10 -lcore10 -lskgxn2 -locr10 -locrb10 -locrutl10 -lhasgen10 -lcore10 -lskgxn2   -lclient10  -lvsn10 -lcommon10 -lgeneric10 -lknlopt `if /usr/bin/ar tv /home/oracle/10gR2/db_1/rdbms/lib/libknlopt.a | grep xsyeolap.o > /dev/null 2>&1 ; then echo "-loraolap10" ; fi` -lslax10 -lpls10  -lplp10 -lserver10 -lclient10  -lvsn10 -lcommon10 -lgeneric10 `if [ -f /home/oracle/10gR2/db_1/lib/libavserver10.a ] ; then echo "-lavserver10" ; else echo "-lavstub10"; fi` `if [ -f /home/oracle/10gR2/db_1/lib/libavclient10.a ] ; then echo "-lavclient10" ; fi` -lknlopt -lslax10 -lpls10  -lplp10 -ljox10 -lserver10 -lclsra10 -ldbcfg10 -locijdbcst10 -lwwg  `cat /home/oracle/10gR2/db_1/lib/ldflags`    -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lnro10 `cat /home/oracle/10gR2/db_1/lib/ldflags`    -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lmm -lsnls10 -lnls10  -lcore10 -lsnls10 -lnls10 -lcore10 -lsnls10 -lnls10 -lxml10 -lcore10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 `cat /home/oracle/10gR2/db_1/lib/ldflags`    -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lnro10 `cat /home/oracle/10gR2/db_1/lib/ldflags`    -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10   -lsnls10 -lnls10  -lcore10 -lsnls10 -lnls10 -lcore10 -lsnls10 -lnls10 -lxml10 -lcore10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 `if /usr/bin/ar tv /home/oracle/10gR2/db_1/rdbms/lib/libknlopt.a | grep "kxmnsd.o" > /dev/null 2>&1 ; then echo " " ; else echo "-lordsdo10"; fi` -lctxc10 -lctx10 -lzx10 -lgx10 -lctx10 -lzx10 -lgx10 -lordimt10 -lsnls10 -lnls10  -lcore10 -lsnls10 -lnls10 -lcore10 -lsnls10 -lnls10 -lxml10 -lcore10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 -lsnls10 -lunls10  -lsnls10 -lnls10  -lcore10 -lsnls10 -lnls10 -lcore10 -lsnls10 -lnls10 -lxml10 -lcore10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 -laio    `cat /home/oracle/10gR2/db_1/lib/sysliblist` -Wl,-rpath,/home/oracle/10gR2/db_1/lib -lm    `cat /home/oracle/10gR2/db_1/lib/sysliblist` -ldl -lm   -L/home/oracle/10gR2/db_1/lib
/home/oracle/10gR2/db_1/lib//libcore10.a(lcd.o): In function `lcdprm':
lcd.c:(.text+0x8e8): warning: the `gets' function is dangerous and should not be used.
mv -f /home/oracle/10gR2/db_1/bin/oracle /home/oracle/10gR2/db_1/bin/oracleO
mv /home/oracle/10gR2/db_1/rdbms/lib/oracle /home/oracle/10gR2/db_1/bin/oracle
chmod 6751 /home/oracle/10gR2/db_1/bin/oracle
[oracle@RAC1 lib]$
[oracle@RAC1 lib]$
[oracle@RAC1 lib]$
[oracle@RAC1 lib]$ ls
^H^Hconfig.c      jox.o      ksnnt2.o        rfscom.o    sskfeded.o
config.o      joxoff.o   ktd.o           rfsd.o      sskfoded.o
cursize.o     kciwcx.o   kxmnsd.o        rfsin.o     sskrmed.o
dbfsize.o     kcsm.o     kxmwsd.o        rfsxc.o     sskrned.o
defopt.o      kecnr.o    kzlnlbac.o      s0exudrv.o  sskrsed.o
dmndm.o       kecwr.o    kzvndv.o        s0impdrv.o  ssoraed.o
dmndmse.o     kfod.o     libdbtools10.a  s0kudbv.o   sstrced.o
dmwdm.o       kgupc.o    libdsga10.a     s0kuzr.o    strcpt.o
dumpsga.o     kgutc.o    libknlopt.a     s0kvpf.o    sulmain.o
env_rdbms.mk  kkpoban.o  libodm10.a      s0udexp.o   tg4pwd.o
genezi.o      kkxntp.o   libperfsrv10.a  s0udimp.o   tstshm.o
genksms.o     kkxwtp.o   libqsmashr.a    sbbdpt.o    ttcoerr.o
hoaoci.o      kopc.o     libskgxns.a     shorm.o     ttcsoi.o
hoat.o        kprnts.o   libskgxpd.a     shou.o      Turning RAC on
hoax.o        kprwts.o   libskgxpg.a     sjsex.o     wpspldrv.o
homts.o       kpucb.o    libskgxpr.a     skfedpt.o   xaondy.o
hormc.o       kpudfo.o   libskgxpu.a     skfodpt.o   xaonsl.o
hormd.o       kpundf.o   libxdb.a        skrmpt.o    xsnoolap.o
horm.o        ksms.o     mapsga.o        skrnpt.o    xsyeolap.o
hormt.o       ksnkcs.o   maxmem.o        skrspt.o    zsmsdrv.o
hout.o        ksnkkpo.o  nmliblist       sllfls.o
hsxaora.o     ksnktd.o   opimai.o        srfsd.o
ins_rdbms.mk  ksnnni.o   osh.o           ssbbded.o
[oracle@RAC1 lib]$
[oracle@RAC1 lib]$
[oracle@RAC1 lib]$ cd /home/oracle
[oracle@RAC1 ~]$ ls
10204patch  admin  crsinstall  Desktop   initprod.ora
10gR2       all    dbinstall   init.ora  oraInventory
[oracle@RAC1 ~]$ ls -ltr
total 40
drwxr-xr-x 3 oracle oinstall 4096 May  8  2009 10204patch
drwxr-xr-x 3 oracle oinstall 4096 May  8  2009 crsinstall
drwxr-xr-x 3 oracle oinstall 4096 May  8  2009 dbinstall
drwxrwx--- 6 oracle oinstall 4096 May 31  2009 oraInventory
drwxr-xr-x 5 root   root     4096 Mar  3 16:56 all
drwxr-xr-x 2 oracle oinstall 4096 Apr 24 15:01 Desktop
-rw-r----- 1 oracle oinstall 2485 May  9 11:35 init.ora
drwxrwx--- 6 oracle oinstall 4096 May  9 11:38 10gR2
drwxr-x--- 5 oracle oinstall 4096 May  9 11:42 admin
-rw-r--r-- 1 oracle oinstall  644 May  9 11:50 initprod.ora
[oracle@RAC1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Fri May 9 11:55:43 2014

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to an idle instance.
                              

 

SQL> startup nomount pfile='/home/oracle/initprod.ora';
ORACLE instance started.

Total System Global Area  218103808 bytes
Fixed Size                  1266680 bytes
Variable Size              96472072 bytes
Database Buffers          117440512 bytes
Redo Buffers                2924544 bytes