LD_LIBRARY_PATH设置不当导致无法登陆和启动oracle

最新推荐文章于 2022-06-08 18:59:06 发布

congdiku5262

最新推荐文章于 2022-06-08 18:59:06 发布

阅读量354

点赞数

OS: HP B.11.23

DB: oracle 10205

症状：数据库无法登陆，sqlplus / as sysdba报告如下错误

Thu Jul 05 21:41:59 EDT 2012

Errors in file /d_db00/app/oracle/admin/justin/udump/justin_ora_7569.trc:

ORA-07445: exception encountered: core dump [] [SIGFPE] [HP Conditional trap] [0xC00000000751993B] [] []

justin[help]:/d_orasw/dba>more /d_db00/app/oracle/admin/justin/udump/justin_ora_7569.trc

/d_db00/app/oracle/admin/justin/udump/justin_ora_7569.trc

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORACLE_HOME = /d_db00/app/oracle/product/db_1

System name: HP-UX

Node name: justin

Release: B.11.23

Version: U

Machine: 9000/800

Instance name: justin

Redo thread mounted by this instance: 1

Oracle process number: 0

Unix process pid: 7569, image: oracle@justin

Exception signal: 8 (SIGFPE), code: 13 (HP Conditional trap), addr: 0xc00000000751993b, PC: [0xc000000007519938, M-^@]

Registers:

r1: c0000000073060d8 r22: 7020686561700000 sr4: e975400

rp: c0000000075198a7 arg3: 8000000100159880 sr0: f35e800

r3: 800003ffbfffab90 arg2: 0 sr1: 7f22000

r4: 800003ffbfffa6e0 arg1: 2 sr2: 0

r5: c0000000075190d8 arg0: 552 sr3: 0

r6: 8000000100013a68 dp: 800003ffbffcbc00 sr5: e9e3800

r7: 551 ret0: 8000000100157094 sr6: 7f22000

r8: 0 ret1: 551 sr7: f35e800

r9: 1 sp: 800003ffbfffab90 cr0: 10000013dd9c0

r10: 0 r31: ffffffffffffffff cr8: 700000000

r11: 4 sar: 3f cr9: 0

r12: 0 pcoqh: c00000000751993b ccr: 0

r13: 0 pcsqh: f35e800 cr12: 0

r14: 800003ffbfff3758 pcoqt: c00000000751993f cr13: faef8

r15: 40000000013de300 pcsqt: f35e800 cr24: e04378

r16: 196 eiem: ffffffffffffffff cr25: c4eb0

r17: 21 iir: b0024e0 cr26: 3a3a800

r18: 4000000001bb9180 isr: 0 mpsfu_hi: 800003ffbfe49410

r19: c000000062880688 ior: 0 mpsfu_lo: 69a4b040

r20: 7020686561700000 ipsw: 806000f mpsfu_ov: 20f4d00

r21: c000000030609e64 goto: a38bc pad: 31fb098750

*** 2012-07-05 21:41:59.772

ksedmp: internal or fatal error

ORA-07445: exception encountered: core dump [M-^@] [SIGFPE] [HP Conditional trap] [0xC00000000751993B] [] []

Current SQL information unavailable - no session.

----- Call Stack Trace -----

calling call entry argument values in hex

location type point (? means dubious value)

-------------------- -------- -------------------- ----------------------------

ksedst()+40 ? ksedst1() C000000000141988 ?

4000000001BB9180 ?

000000000 ?

20202020676F746F ?

ksedmp()+632 ? ksedst() 000000000 ?

20202020676F746F ?

8000000100159894 ?

00000004E ?

ssexhd()+1080 ? ksedmp() C00000000001354B ?

C000000000030823 ?

800003FFBFFFE3E0 ?

000000000 ?

_sigreturn()+0 ? ssexhd() 000000000 ? 000000000 ?

00B0024E0 ?

800003FFBFFFAB90 ?

joxnfy_()+2144 ? _sigreturn() 8000000100013EA8 ?

40000000013DE300 ?

80000001001B7440 ?

000000000 ?

joxnfy()+48 ? joxnfy() 000000001 ? 000002000 ?

08C2FD800 ?

40000000024A4CEB ?

kscnfy()+552 ? joxnfy() 08C2FD800 ?

40000000024A4CEB ?

000000001 ?

800000010001473C ?

ksmcpg()+72 ? kscnfy() 000000000 ? 000000003 ?

000000000 ? 000000000 ?

ksucrp()+296 ? ksmcpg() 000000000 ? 000000000 ?

000000000 ? 000000000 ?

ksucresg()+56 ? ksucrp() 8000000100146908 ?

80000001000FF4D8 ?

000000000 ? 000000000 ?

kpolna()+368 ? ksucresg() 000000000 ?

8000000100194330 ?

000000000 ? 000000000 ?

kpoauth()+2792 ? kpolna() 000000000 ? 000000000 ?

000000000 ? 000000000 ?

opiodr()+1412 ? kpoauth() 000000000 ? 000000000 ?

000000000 ? 000000000 ?

ttcpip()+420 ? opiodr() F001C5163 ?

4000000001DA9273 ?

000000000 ? 000017EE8 ?

opitsk()+2664 ? ttcpip() 800003FFBFFECD98 ?

8000000100013EA8 ?

000007FFF ? 000000000 ?

opiino()+1080 ? opitsk() 800003FFBFE6E6D8 ?

800003FFBFE6F6D8 ?

000000000 ?

800003FFBFE6E6D8 ?

opiodr()+1412 ? opiino() C0000000002138D3 ?

1950104BFFF1DD0 ?

C00000000019F7DB ?

8000000100162788 ?

opidrv()+848 ? opiodr() C0000000000149EB ?

800003FFBFFE6410 ?

100000000000000 ?

800003FFBFFEC978 ?

sou2o()+120 ? opidrv() 4000000002115C0F ?

000000000 ? 000000000 ?

800003FFBFFF000B ?

opimai_real()+316 ? sou2o() 800003FFBFFE6C58 ?

2BFE27818 ? 000000000 ?

800003FFBFFEC978 ?

main()+124 ? opimai_real() 800003FFBFFF0B10 ?

6170702F6F726163 ?

300000004 ? A004000270026 ?

$START$()+160 ? main() 077FF0155 ? 000000000 ?

000000090 ?

800003FFBFFF0A79 ?

尝试多次均无果，于是kill -9 pmon_pid然后打算重启，这下搞得数据库都无法启动了

Starting up ORACLE RDBMS Version: 10.2.0.5.0.

System parameters with non-default values:

processes = 150

timed_statistics = TRUE

trace_enabled = FALSE

disk_asynch_io = FALSE

tape_asynch_io = FALSE

control_files = /d_db03/oracle/justin/ctrl1.ctl, /d_db09/oracle/justin/ctrl2.ctl, /d_db11/oracle/justin/ctrl3.ctl

db_block_size = 8192

compatible = 10.2.0

db_file_multiblock_read_count= 8

fast_start_mttr_target = 300

undo_management = AUTO

undo_tablespace = UNDO

undo_retention = 900

instance_name = justin

job_queue_processes = 10

background_dump_dest = /d_db00/app/oracle/admin/justin/bdump

user_dump_dest = /d_db00/app/oracle/admin/justin/udump

core_dump_dest = /d_db00/app/oracle/admin/justin/cdump

audit_file_dest = /d_db00/app/oracle/admin/justin/adump

db_name = justin

open_cursors = 30000

star_transformation_enabled= FALSE

query_rewrite_enabled = TRUE

Fri Jul 06 02:24:45 EDT 2012

Errors in file /d_db00/app/oracle/admin/justin/udump/justin_ora_29152.trc:

ORA-07445: exception encountered: core dump [joxnfy_()+2144] [SIGFPE] [HP Conditional trap] [0xC00000000751993B] [] []

Fri Jul 06 02:42:37 EDT 2012

justin[help]:/d_orasw/dba>more /d_db00/app/oracle/admin/justin/udump/justin_ora_23683.trc

/d_db00/app/oracle/admin/justin/udump/justin_ora_23683.trc

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORACLE_HOME = /d_db00/app/oracle/product/db_1

System name: HP-UX

Node name: justin

Release: B.11.23

Version: U

Machine: 9000/800

Instance name: justin

Redo thread mounted by this instance: 0

Oracle process number: 0

Unix process pid: 23683, image: oracle@justin

Parsing user specified table space list to be ignored

Dynamic strand is set to TRUE

Running with 2 shared and 18 private strand(s). Zero-copy redo is FALSE

Exception signal: 8 (SIGFPE), code: 13 (HP Conditional trap), addr: 0xc00000000751993b, PC: [0xc000000007519938, joxnfy_()+2144]

Registers:

r1: c0000000073060d8 r22: 7020686561700000 sr4: e975400

rp: c0000000075198a7 arg3: 8000000100159880 sr0: f35e800

r3: 800003ffbfff9660 arg2: 0 sr1: 2673000

r4: 800003ffbfff91b0 arg1: 2 sr2: 0

r5: c0000000075190d8 arg0: 552 sr3: 0

r6: 8000000100013a68 dp: 800003ffbffcbc00 sr5: f3ca000

r7: 551 ret0: 8000000100157094 sr6: 2673000

r8: 0 ret1: 551 sr7: f35e800

r9: 1 sp: 800003ffbfff9660 cr0: 10000013dd9c0

r10: 0 r31: ffffffffffffffff cr8: 700000000

r11: 4000000000d4d698 sar: 3f cr9: 0

r12: 8000000100159f38 pcoqh: c00000000751993b ccr: 0

r13: 800000010015b3d0 pcsqh: f35e800 cr12: 0

r14: 8000000100159888 pcoqt: c00000000751993f cr13: faef8

r15: 0 pcsqt: f35e800 cr24: e04378

r16: 14b eiem: ffffffffffffffff cr25: c4eb0

r17: 21 iir: b0024e0 cr26: 3a3a800

r18: 4000000001bb9180 isr: 0 mpsfu_hi: 800003ffbfe49410

r19: c000000039c80688 ior: 0 mpsfu_lo: 69a4b040

r20: 7020686561700000 ipsw: 806000f mpsfu_ov: 20f4d00

r21: c00000003060ae64 goto: a38bc pad: 320ee0944a

*** 2012-07-06 02:42:37.560

ksedmp: internal or fatal error

ORA-07445: exception encountered: core dump [joxnfy_()+2144] [SIGFPE] [HP Conditional trap] [0xC00000000751993B] [] []

Current SQL information unavailable - no session.

----- Call Stack Trace -----

calling call entry argument values in hex

location type point (? means dubious value)

-------------------- -------- -------------------- ----------------------------

ksedst()+40 ? ksedst1() C000000000141988 ?

4000000001BB9180 ?

000000000 ?

20202020676F746F ?

ksedmp()+632 ? ksedst() 000000000 ?

20202020676F746F ?

4000000000897828 ?

00000004E ?

ssexhd()+1080 ? ksedmp() 800003FFBFE75080 ?

6B716A623836392C ?

000000003 ?

646D61646D696E00 ?

_sigreturn()+0 ? ssexhd() 000000000 ? 000000000 ?

00B0024E0 ?

800003FFBFFF9660 ?

joxnfy_()+2144 ? _sigreturn() 8000000100013EA8 ?

000000000 ?

80000001001AE3C0 ?

000000000 ?

joxnfy()+48 ? joxnfy() 000000001 ? 000002000 ?

08C2FD800 ?

40000000024A4CEB ?

kscnfy()+552 ? joxnfy() 08C2FD800 ?

40000000024A4CEB ?

C00000003079DE08 ?

800000010001473C ?

ksmcpg()+72 ? kscnfy() 800003FFBFE6E6D8 ?

000000000 ?

800003FFBFFF85E5 ?

4000000000BC7350 ?

ksucrp()+296 ? ksmcpg() 3800000000 ?

4000000000BC71F8 ?

000000000 ? 000000000 ?

opistr_real()+1080 ? ksucrp() 000000000 ? 000000000 ?

000000000 ? 000000000 ?

opistr()+276 ? opistr_real() 800003FFBFE772A0 ?

C00000000020E077 ?

C000000000017DE7 ?

000001D20 ?

opiodr()+1412 ? opistr() 800003FFBFFF6630 ?

000000014 ?

400000000183D8BB ?

800003FFBFFF6E60 ?

ttcpip()+420 ? opiodr() 800000010018D2C0 ?

8000000100146908 ?

40000000020EC9B7 ?

000015960 ?

opitsk()+612 ? ttcpip() 800003FFBFFECD98 ?

8000000100013EA8 ?

000007FFF ? 000000000 ?

opiino()+1080 ? opitsk() 800003FFBFE6E6D8 ?

800003FFBFE6F6D8 ?

000000000 ?

800003FFBFE6E6D8 ?

opiodr()+1412 ? opiino() C0000000002138D3 ?

1950104BFFF1DE0 ?

C00000000019F7DB ?

8000000100162788 ?

opidrv()+848 ? opiodr() C0000000000149EB ?

800003FFBFFE6408 ?

100000000000000 ?

800003FFBFFEC978 ?

sou2o()+120 ? opidrv() 4000000002115C0F ?

000000000 ? 000000000 ?

800003FFBFFF000B ?

opimai_real()+316 ? sou2o() 800003FFBFFE6C50 ?

2BFE27818 ? 000000000 ?

800003FFBFFEC978 ?

main()+124 ? opimai_real() 800003FFBFFF0B20 ?

6170702F6F726163 ?

300000004 ? A004000270026 ?

$START$()+160 ? main() 077FF0135 ? 000000000 ?

000000090 ?

800003FFBFFF0A89 ?

麻烦更大了，不得已开了SR，然后给出答复 “Please review following documents and check if different versions are being used for database and listener:
Ora-07445 Core Dump From joxnfy() When Connecting to a Remote Instance. (Doc ID 747187.1)
ORA-7445 [joxnfy_] Using 10.2.0.4 Listener With 10.2.0.3 Database On the Same Server”，用处不大；

最后想起检查LD_LIBRARY_PATH环境变量，更正为$ORACLE_HOME/lib后问题就解决了；

以下是搜索到的关于LD_LIBRARY_PATH的资料

LD_LIBRARY_PATH

Function

Environment variable to specify the path used to search for libraries on UNIX and Linux. The environment variable may have a different name on some operating systems, such as LIBPATH on AIX, and SHLIB_PATH on HP-UX.

　Linux环境变量名，该环境变量主要用于指定查找共享库（动态链接库）时除了默认路径之外的其他路径。(该路径在默认路径之前查找)

　　移植程序时的经常碰到需要使用一些特定的动态库，而这些编译好的动态库放在我们自己建立的目录里，这时可以将这些目录设置到LD_LIBRARY_PATH中。

　当执行函数动态链接.so时，如果此文件不在缺省目录下‘/usr/local/lib’ and ‘/usr/lib’.

　　那么就需要指定环境变量LD_LIBRARY_PATH

　　假如现在需要在已有的环境变量上添加新的路径名，则采用如下方式：

　　LD_LIBRARY_PATH=NEWDIRS:$LD_LIBRARY_PATH.（newdirs是新的路径串）

　　（注：GNU系统可以自动添加在 /etc/ld.so.conf文件中来实现环境变量的设置）

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

转载于:http://blog.itpub.net/15480802/viewspace-734827/

congdiku5262

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
LD_LIBRARY_PATH设置不当导致无法登陆和启动oracle

OS: HP B.11.23DB: oracle 10205症状：数据库无法登陆，sqlplus / as sysdba报告如下错误Thu Jul 05 21:41:59 EDT 2012Errors in f...
复制链接

扫一扫