使用操作系统命令来trace监听

strace tnsping prod

strace tnsping prod 2>&1 | less

strace -eopen tnsping prod 2>&1 | grep '= -1'

strace tnsping prod 2>&1  >/dev/null | grep -E '^stat|^open'

strace -e trace=access,open,stat tnsping no-such-sid  2>&1 >/dev/null | grep '\.ora' | cut -f2 -d\" | sort |uniq -c

strace -e trace=access,open,stat tnsping no-such-sid  prod 2>&1 >/dev/null | grep '\.ora' | cut -f2 -d\" | sort |uniq -c


[oracle@rh64 ~]$ strace -eopen tnsping prod 2>&1 | grep '= -1'

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/tls/x86_64/libclntsh.so.11.1", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/tls/libclntsh.so.11.1", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/x86_64/libclntsh.so.11.1", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib32/tls/x86_64/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib32/tls/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib32/x86_64/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib32/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libm.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libm.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libnsl.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libnsl.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libaio.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libaio.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libaio.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libociei.so", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libociicus.so", O_RDONLY) = -1 ENOENT (No such file or directory)



[oracle@rh64 ~]$ strace tnsping prod 2>&1  >/dev/null | grep -E '^stat|^open'

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/tls/x86_64/libclntsh.so.11.1", O_RDONLY) = -1 ENOENT (No such file or directory)

stat("/u01/app/oracle/product/11.2.0/dbhome_1/lib/tls/x86_64", 0x7ffff9beb660) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/tls/libclntsh.so.11.1", O_RDONLY) = -1 ENOENT (No such file or directory)

stat("/u01/app/oracle/product/11.2.0/dbhome_1/lib/tls", 0x7ffff9beb660) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/x86_64/libclntsh.so.11.1", O_RDONLY) = -1 ENOENT (No such file or directory)

stat("/u01/app/oracle/product/11.2.0/dbhome_1/lib/x86_64", 0x7ffff9beb660) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1", O_RDONLY) = 3

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libnnz11.so", O_RDONLY) = 3

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib32/tls/x86_64/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)

stat("/u01/app/oracle/product/11.2.0/dbhome_1/lib32/tls/x86_64", 0x7ffff9beb600) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib32/tls/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)

stat("/u01/app/oracle/product/11.2.0/dbhome_1/lib32/tls", 0x7ffff9beb600) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib32/x86_64/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)

stat("/u01/app/oracle/product/11.2.0/dbhome_1/lib32/x86_64", 0x7ffff9beb600) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib32/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)

stat("/u01/app/oracle/product/11.2.0/dbhome_1/lib32", 0x7ffff9beb600) = -1 ENOENT (No such file or directory)

open("/etc/ld.so.cache", O_RDONLY)      = 3

open("/lib64/libdl.so.2", O_RDONLY)     = 3

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libm.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libm.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/lib64/libm.so.6", O_RDONLY)      = 3

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/lib64/libpthread.so.0", O_RDONLY) = 3

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libnsl.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libnsl.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/lib64/libnsl.so.1", O_RDONLY)    = 3

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/lib64/libc.so.6", O_RDONLY)      = 3

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libaio.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libaio.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libaio.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/lib64/libaio.so.1", O_RDONLY)    = 3

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libociei.so", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libociicus.so", O_RDONLY) = -1 ENOENT (No such file or directory)

open("/u01/app/oracle/product/11.2.0/dbhome_1/nls/data/lx1boot.nlb", O_RDONLY) = 3

open("/u01/app/oracle/product/11.2.0/dbhome_1/nls/data/lx00001.nlb", O_RDONLY) = 3

open("/u01/app/oracle/product/11.2.0/dbhome_1/nls/data/lx20001.nlb", O_RDONLY) = 3

open("/u01/app/oracle/product/11.2.0/dbhome_1/nls/data/lx10001.nlb", O_RDONLY) = 3

open("/u01/app/oracle/product/11.2.0/dbhome_1/nls/data/lx40011.nlb", O_RDONLY) = 3

open("/etc/localtime", O_RDONLY)        = 3

stat("/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora", {st_mode=S_IFREG|0644, st_size=166, ...}) = 0

open("/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora", O_RDONLY) = 3

open("/u01/app/oracle/product/11.2.0/dbhome_1/network/mesg/tnsus.msb", O_RDONLY) = 3

open("/u01/app/oracle/product/11.2.0/dbhome_1/lib/libnque11.so", O_RDONLY) = 4

[oracle@rh64 ~]$ 



[oracle@rh64 ~]$ strace -e trace=access,open,stat tnsping no-such-sid  prod 2>&1 >/dev/null | grep '\.ora' | cut -f2 -d\" | sort |uniq -c

      1 /etc/tnsnames.ora

      1 /home/oracle/.tnsnames.ora

      1 /u01/app/oracle/product/11.2.0/dbhome_1/ldap/admin/fips.ora

      1 /u01/app/oracle/product/11.2.0/dbhome_1/ldap/admin/ldap.ora

      1 /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/ldap.ora

      2 /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora

      3 /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值