oracle log.xml分析,Oracle 监听器日志解析（续）

/

监听start后监听日志记录信息如下:

Tue Feb 06 13:03:06 2018

System parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora

Log messages written to /u01/app/oracle/diag/tnslsnr/wang/listener/alert/log.xml

Trace information written to /u01/app/oracle/diag/tnslsnr/wang/listener/trace/ora_5682_140618561201984.trc

Trace level is currently 0

Started with pid=5682

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=wang)(PORT=1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

WARNING: Subscription for node down event still pending

06-FEB-2018

13:03:06 *

(CONNECT_DATA=(CID=(PROGRAM=)(HOST=wang)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647552))

* status * 0

Tue Feb 06 13:03:48 2018

06-FEB-2018 13:03:48 * service_register * DBdb * 0

Tue Feb 06 13:04:36 2018

06-FEB-2018 13:04:36 * service_update* DBdb * 0

Tue Feb 06 13:05:45 2018

06-FEB-2018 13:05:45 * service_update * DBdb * 0

Tue Feb 06 13:06:15 2018

06-FEB-2018 13:06:15 * service_update * DBdb * 0

Tue Feb 06 13:13:13 2018

06-FEB-2018 13:13:13 * service_update * DBdb * 0

Tue Feb 06 13:19:48 2018

WARNING: Subscription for node down event still pending

06-FEB-2018

13:19:48 *

(CONNECT_DATA=(CID=(PROGRAM=)(HOST=wang)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647552))

* status * 0

Tue Feb 06 13:23:13 2018

06-FEB-2018 13:23:13 * service_update * DBdb * 0

//

通过plsql建立连接：如下是日志信息：

Tue Feb 06 13:23:41 2018

06-FEB-2018

13:23:41 *

(CONNECT_DATA=(SERVICE_NAME=DBdb)(CID=(PROGRAM=E:\????\PLSQL_Developer8.0??????\plsqldev.exe)(HOST=SC-201707102126)(USER=Administrator)))

* (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.1)(PORT=53088)) * establish *

DBdb * 0

06-FEB-2018 13:23:41 *

(CONNECT_DATA=(SERVICE_NAME=DBdb)(CID=(PROGRAM=E:\????\PLSQL_Developer8.0??????\plsqldev.exe)(HOST=SC-201707102126)(USER=Administrator)))

* (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.1)(PORT=53089)) * establish *

DBdb * 0

06-FEB-2018 13:23:43 *service_update * DBdb * 0

06-FEB-2018 13:23:46 * service_update * DBdb * 0

///

客户端tns信息

DBDB =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.12)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = DBdb)

)

)

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