bdump下量trc檔案，NS Primary Error: TNS-12533: TNS:illegal ADDRESS parameters

 

-rw-r----- 1 oracle dba 2.0M Mar 23 11:16 b2beai_ora_17646.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:16 b2beai_ora_17667.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:16 b2beai_ora_17669.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:17 b2beai_ora_17683.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:17 b2beai_ora_17692.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:17 b2beai_ora_17710.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:19 b2beai_ora_17790.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:19 b2beai_ora_17800.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:19 b2beai_ora_17833.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:19 b2beai_ora_17835.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:19 b2beai_ora_17841.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:19 b2beai_ora_17843.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:19 b2beai_ora_17845.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:19 b2beai_ora_17847.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:20 b2beai_ora_17860.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:20 b2beai_ora_17877.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:20 b2beai_ora_17879.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:20 b2beai_ora_17883.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:20 b2beai_ora_17887.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:20 b2beai_ora_17889.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:20 b2beai_ora_17905.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:20 b2beai_ora_17907.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:21 b2beai_ora_17943.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:22 b2beai_ora_18000.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:22 b2beai_ora_18036.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:22 b2beai_ora_18038.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:22 b2beai_ora_18044.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:23 b2beai_ora_18049.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:23 b2beai_ora_18062.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:23 b2beai_ora_18064.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:23 b2beai_ora_18066.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:23 b2beai_ora_18073.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:23 b2beai_ora_18075.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:23 b2beai_ora_18086.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:23 b2beai_ora_18123.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:24 b2beai_ora_18125.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:24 b2beai_ora_18174.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:25 b2beai_ora_18233.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:26 b2beai_ora_18243.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:26 b2beai_ora_18245.trc
-rw-r----- 1 oracle dba 2.0M Mar 23 11:26 b2beai_ora_18247.trc
--More--

 

 

 

/u01/product/admin/b2beai/bdump/b2beai_ora_17883.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engine
and Real Application Testing options
ORACLE_HOME = /u01/product/oracle
System name:    Linux
Node name:      MXB2B-TOTEAP1
Release:        2.6.18-128.el5
Version:        #1 SMP Wed Dec 17 11:41:38 EST 2008
Machine:        x86_64
Instance name: b2beai
Redo thread mounted by this instance: 1
Oracle process number: 14
Unix process pid: 17883, image: (D000)

Warning: keltnfy call to ldmInit failed with error 46
*** 2010-03-23 11:20:25.353
network error encountered getting listening address:
  NS Primary Error: TNS-12533: TNS:illegal ADDRESS parameters
  NS Secondary Error: TNS-12560: TNS:protocol adapter error
  NT Generic Error: TNS-00503: Illegal ADDRESS parameters
OPIRIP: Uncaught error 108. Error stack:
ORA-00108: failed to set up dispatcher to accept connection asynchronously
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x208, PC: [0x7a06d8, kslgetl()+120]
*** 2010-03-23 11:20:25.356
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kslgetl()+120] [SIGSEGV] [Address not mapped to object] [0x000000208] [] []
ORA-00108: failed to set up dispatcher to accept connection asynchronously
Current SQL information unavailable - no session.
----- Call Stack Trace -----
calling              call     entry                argument values in hex
location             type     point                (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+31          call     ksedst1()            000000000 ? 000000001 ?
                                                   2B9A07580D50 ? 2B9A07580DB0 ?
                                                   2B9A07580CF0 ? 000000000 ?
ksedmp()+610         call     ksedst()             000000000 ? 000000001 ?
                                                   2B9A07580D50 ? 2B9A07580DB0 ?
                                                   2B9A07580CF0 ? 000000000 ?
ssexhd()+629         call     ksedmp()             000000003 ? 000000001 ?
                                                   2B9A07580D50 ? 2B9A07580DB0 ?
                                                   2B9A07580CF0 ? 000000000 ?
__restore_rt()+0     call     ssexhd()             00000000B ? 2B9A07581D70 ?
                                                   2B9A07581C40 ? 2B9A07580DB0 ?
                                                   2B9A07580CF0 ? 000000000 ?
kslgetl()+120        signal   __restore_rt()       0600EBD48 ? 0000000E8 ?
                                                   2D2BA5D40 ? 0000009A9 ?
                                                   000003980 ? 2D2BA5D58 ?
ksfglt()+108         call     kslgetl()            0600EBD48 ? 000000001 ?
                                                   2D2BA5D40 ? 0000009A9 ?
                                                   000003980 ? 2D2BA5D58 ?
kghfre()+2238        call     ksfglt()             0600EBD48 ? 0600EBD48 ?
                                                   000000000 ? 2D2BA5D40 ?
                                                   0000009A9 ? 2D2BA5D58 ?
kmnsbf()+96          call     kghfre()             0068966E0 ? 060044218 ?
                                                   7FFFA5237EB0 ? 000012000 ?
                                                   005609158 ? 2D2BA5D58 ?
nsbfr()+311          call     kmnsbf()             0068966E0 ? 060044218 ?
                                                   7FFFA5237EB0 ? 000012000 ?
                                                   005609158 ? 2D2BA5D58 ?
nsiofrrg()+478       call     nsbfr()              0068966E0 ? 009E6F750 ?
                                                   7FFFA5237EB0 ? 000012000 ?
                                                   005609158 ? 2D2BA5D58 ?
nsiocancel()+198     call     nsiofrrg()           009E6E970 ? 009E6EE20 ?
                                                   000000000 ? 000012000 ?
                                                   005609158 ? 2D2BA5D58 ?
nsopen_shutitdown()  call     nsiocancel()         009E6E970 ? 009E6EE20 ?
"b2beai_ora_17883.trc" [converted] 35542L, 2029169C   

 

 

 

檢查一下/etc/hosts檔案有沒有什麼問題，或者訪問許可權是不是有問題

/etc/hosts

 

 

MXB2B-TOTEAP1$cat hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1         localhost.localdomain   localhost

 

加入ip及hostname之後 bdump下的 trc檔案恢復正常 。

MXB2B-TOTEAP1$cat hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1         localhost.localdomain   localhost
10.13.13.189       MXB2B-TOTEAP1