个人简介
偶尔有空上来看看
文章分类
文章存档
最近访客
相关博文
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
分类： oracle
2021-01-01 17:55:00
干了这么多年，一直觉得用户的环境变量中 ld_library_path 没啥用途
看到一个案例
http://horia-berca-oracledba.blogspot.com/2011/10/ora-00030-raised-on-kill-session.html
但是感觉不对，我自己的环境，没有设置 /lib64
[oracle@db1 ~]$ which libpthread.so.0
/usr/bin/which: no libpthread.so.0 in (/u01/app/oracle/product/19.0.0/dbhome_1/bin:/u01/app/oracle/product/19.0.0/dbhome_1/opatch:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/oracle/.local/bin:/home/oracle/bin)
[oracle@db1 ~]$ env|grep path
ld_library_path=/u01/app/oracle/product/19.0.0/dbhome_1/lib:/lib:/usr/lib:/lib64/
path=/u01/app/oracle/product/19.0.0/dbhome_1/bin:/u01/app/oracle/product/19.0.0/dbhome_1/opatch:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/oracle/.local/bin:/home/oracle/bin
也是如此提示
[oracle@db1 ~]$ pstack 42028
#0 0x00007f5dd6feb740 in __read_nocancel () from /lib64/libpthread.so.0
#1 0x0000000012ae95a4 in read ()
#2 0x0000000012ae110c in sntpread ()
#3 0x0000000012ae0fae in ntpfprd ()
#4 0x0000000012ac9c0f in nsbasic_brc ()
#5 0x0000000012ad2846 in nioqrc ()
#6 0x000000001266c407 in opikndf2 ()
#7 0x00000000027acace in opitsk ()
#8 0x00000000027b1788 in opiino ()
#9 0x000000001266e972 in opiodr ()
#10 0x00000000027a8c26 in opidrv ()
#11 0x00000000032f4cf5 in sou2o ()
#12 0x0000000000daf056 in opimai_real ()
#13 0x0000000003300641 in ssthrdmain ()
#14 0x0000000000daee80 in main () <--从下往上看
[oracle@db1 ~]$
看来并不是异常原因。
看到一个案例
http://horia-berca-oracledba.blogspot.com/2011/10/ora-00030-raised-on-kill-session.html
但是感觉不对，我自己的环境，没有设置 /lib64
[oracle@db1 ~]$ which libpthread.so.0
/usr/bin/which: no libpthread.so.0 in (/u01/app/oracle/product/19.0.0/dbhome_1/bin:/u01/app/oracle/product/19.0.0/dbhome_1/opatch:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/oracle/.local/bin:/home/oracle/bin)
[oracle@db1 ~]$ env|grep path
ld_library_path=/u01/app/oracle/product/19.0.0/dbhome_1/lib:/lib:/usr/lib:/lib64/
path=/u01/app/oracle/product/19.0.0/dbhome_1/bin:/u01/app/oracle/product/19.0.0/dbhome_1/opatch:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/oracle/.local/bin:/home/oracle/bin
也是如此提示
[oracle@db1 ~]$ pstack 42028
#0 0x00007f5dd6feb740 in __read_nocancel () from /lib64/libpthread.so.0
#1 0x0000000012ae95a4 in read ()
#2 0x0000000012ae110c in sntpread ()
#3 0x0000000012ae0fae in ntpfprd ()
#4 0x0000000012ac9c0f in nsbasic_brc ()
#5 0x0000000012ad2846 in nioqrc ()
#6 0x000000001266c407 in opikndf2 ()
#7 0x00000000027acace in opitsk ()
#8 0x00000000027b1788 in opiino ()
#9 0x000000001266e972 in opiodr ()
#10 0x00000000027a8c26 in opidrv ()
#11 0x00000000032f4cf5 in sou2o ()
#12 0x0000000000daf056 in opimai_real ()
#13 0x0000000003300641 in ssthrdmain ()
#14 0x0000000000daee80 in main () <--从下往上看
[oracle@db1 ~]$
看来并不是异常原因。
- http://orafun.info/
给主人留下些什么吧！~~