-
编辑 删除
oracle 11g 监听文件
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora# Generated by Oracle configuration tools.LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.56)(PORT = 1...
-
编辑 删除
配置tnsping跟踪来诊断Oracle Net连接
1.配置跟踪参数 默认情况下tnsping跟踪功能是关闭的.需要在sqlnet.ora配置文件中进行手工配置.sqlnet.ora文件目录在E:\oracle\product\10.2.0\db_1\NETWORK\ADMIN,注意：配置是在客户端，执行tnsping命令也是在客户端# This file is actually generated by netca. But if customers choose to # ins...
-
编辑 删除
oracle监听开启trace file
查看监听trace跟踪是否开启查下trace语法LSNRCTL> help tracetrace OFF | USER | ADMIN | SUPPORT [] : set tracing to the specified level我们可以使用show命令查看当前trace的级别LSNRCTL> show trc_level正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)...
