一個32位的linux系統按裝的oracle 9i,突然不能連線資料庫,並且listener程式也沒有了，重起listener報錯。
發現listener.log已經達到2G，造成的原因就是不能再寫日誌：
[oracle@new0 ~]$ ps -ef|grep ora
oracle 1829 1 0 Aug09 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 1851 1 0 Aug09 ? 00:00:20 oraclegg01 (LOCAL=NO)
oracle 2057 1 0 Aug09 ? 00:00:08 oraclegg01 (LOCAL=NO)
oracle 3116 1 0 Aug09 ? 00:00:17 oraclegg01 (LOCAL=NO)
root 4495 4471 0 Jul27 ? 00:05:28 hald-addon-storage: polling /dev/scd0
oracle 5102 1 0 Jul27 ? 00:01:00 ora_pmon_gg01
oracle 5104 1 0 Jul27 ? 00:03:47 ora_dbw0_gg01
oracle 5106 1 0 Jul27 ? 00:03:38 ora_dbw1_gg01
oracle 5108 1 0 Jul27 ? 00:03:35 ora_dbw2_gg01
oracle 5110 1 0 Jul27 ? 00:15:53 ora_lgwr_gg01
oracle 5112 1 0 Jul27 ? 00:00:48 ora_ckpt_gg01
oracle 5114 1 0 Jul27 ? 00:00:22 ora_smon_gg01
oracle 5116 1 0 Jul27 ? 00:00:00 ora_reco_gg01
oracle 5118 1 0 Jul27 ? 00:00:10 ora_cjq0_gg01
oracle 5120 1 0 Jul27 ? 00:05:38 ora_qmn0_gg01
oracle 5122 1 0 Jul27 ? 00:00:00 ora_s000_gg01
oracle 5124 1 0 Jul27 ? 00:00:00 ora_d000_gg01
oracle 5126 1 0 Jul27 ? 00:07:00 ora_arc0_gg01
oracle 5128 1 0 Jul27 ? 00:07:01 ora_arc1_gg01
oracle 5148 1 0 Jul27 ? 00:34:04 oraclegg01 (LOCAL=NO)
oracle 5150 1 0 Jul27 ? 00:00:09 oraclegg01 (LOCAL=NO)
oracle 5162 1 0 Jul27 ? 00:00:37 oraclegg01 (LOCAL=NO)
oracle 5165 1 0 Jul27 ? 00:00:09 oraclegg01 (LOCAL=NO)
oracle 5832 1 0 Jul27 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 5946 1 0 Jul27 ? 00:00:39 oraclegg01 (LOCAL=NO)
oracle 5951 1 0 Jul27 ? 00:00:09 oraclegg01 (LOCAL=NO)
oracle 6432 1 0 Jul27 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 6440 1 0 Jul27 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 6751 1 0 Jul27 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 6837 1 0 Jul27 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 7141 1 0 Jul27 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 7232 1 0 Jul27 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 7359 1 0 Jul27 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 7492 1 0 Jul27 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 7496 1 0 Jul27 ? 00:00:01 oraclegg01 (LOCAL=NO)
oracle 7832 1 0 Jul27 ? 00:00:01 oraclegg01 (LOCAL=NO)
oracle 7898 1 0 Jul27 ? 00:00:01 oraclegg01 (LOCAL=NO)
oracle 7918 1 0 Aug15 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 8350 1 0 Jul27 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 8365 1 0 Jul27 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 8436 1 0 Jul27 ? 00:00:01 oraclegg01 (LOCAL=NO)
oracle 8481 1 0 Jul27 ? 00:00:01 oraclegg01 (LOCAL=NO)
oracle 8483 1 0 Jul27 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 8588 1 0 Jul27 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 9449 1 0 Jul29 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 9461 1 0 Jul29 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 9567 1 0 Jul29 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 9585 1 0 Jul29 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 11352 1 0 Aug12 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 11354 1 0 Aug12 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 11916 1 0 Aug12 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 11918 1 0 Aug12 ? 00:00:15 oraclegg01 (LOCAL=NO)
oracle 11946 1 0 Aug12 ? 00:00:05 oraclegg01 (LOCAL=NO)
oracle 13140 1 0 Aug12 ? 00:00:08 oraclegg01 (LOCAL=NO)
oracle 13645 1 0 Aug08 ? 00:00:03 oraclegg01 (LOCAL=NO)
oracle 13669 1 0 Aug08 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 13755 1 0 Aug08 ? 00:00:03 oraclegg01 (LOCAL=NO)
oracle 13757 1 0 Aug08 ? 00:00:01 oraclegg01 (LOCAL=NO)
oracle 13793 1 0 Aug08 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 14053 1 0 Aug08 ? 00:00:09 oraclegg01 (LOCAL=NO)
oracle 14137 1 0 Jul29 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 14139 1 0 Jul29 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 14141 1 0 Jul29 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 14143 1 0 Jul29 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 14458 1 0 Aug08 ? 00:00:02 oraclegg01 (LOCAL=NO)
oracle 18074 1 0 Aug04 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 19261 1 0 Aug04 ? 00:00:18 oraclegg01 (LOCAL=NO)
oracle 19287 1 0 Aug04 ? 00:00:11 oraclegg01 (LOCAL=NO)
oracle 20204 1 0 Aug16 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 20247 1 0 Aug04 ? 00:00:00 oraclegg01 (LOCAL=NO)
root 20507 4619 0 10:03 ? 00:00:00 sshd: oracle [priv]
oracle 20509 20507 0 10:03 ? 00:00:00 sshd: oracle@pts/1
oracle 20510 20509 0 10:03 pts/1 00:00:00 -bash
oracle 20569 20510 0 10:09 pts/1 00:00:00 ps -ef
oracle 20570 20510 0 10:09 pts/1 00:00:00 grep ora
oracle 21303 1 0 Aug03 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 21339 1 0 Aug03 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 21812 1 0 Jul28 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 21814 1 0 Jul28 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 23701 1 0 Aug03 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 23902 1 0 Jul28 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 24441 1 0 Aug16 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 24752 1 0 Aug11 ? 00:00:04 oraclegg01 (LOCAL=NO)
oracle 24832 1 0 Jul28 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 24984 1 0 Jul28 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 25212 1 0 Jul28 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 25238 1 0 Jul28 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 25250 1 0 Jul28 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 25399 1 0 Jul28 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 25425 1 0 Jul28 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 27089 1 0 Aug01 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 27647 1 0 Jul28 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 29370 1 0 Jul28 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 30250 1 0 Aug11 ? 00:00:07 oraclegg01 (LOCAL=NO)
oracle 30505 1 0 Jul31 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 31322 1 0 Aug09 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 31324 1 0 Aug09 ? 00:00:00 oraclegg01 (LOCAL=NO)
oracle 31437 1 0 Aug09 ? 00:00:01 oraclegg01 (LOCAL=NO)
oracle 31553 1 0 Aug09 ? 00:00:07 oraclegg01 (LOCAL=NO)
[oracle@new0 ~]$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/cciss/c0d0p5 379G 207G 153G 58% /
/dev/cciss/c0d0p2 426G 178G 226G 45% /opt
/dev/cciss/c0d0p1 99M 12M 83M 12% /boot
tmpfs 2.0G 0 2.0G 0% /dev/shm
[oracle@new0 ~]$ sqlplus /nolog

SQL*Plus: Release 9.2.0.6.0 - Production on Wed Aug 17 10:09:55 2016

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect / as sysdba
Connected.
SQL> select instance_name,status from v$instance;

INSTANCE_NAME STATUS
---------------- ------------
gg01 OPEN

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
[oracle@new0 ~]$ lsnrctl stop

LSNRCTL for Linux: Version 9.2.0.6.0 - Production on 17-AUG-2016 10:10:37

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=new0)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
[oracle@new0 ~]$ lsnrctl start

LSNRCTL for Linux: Version 9.2.0.6.0 - Production on 17-AUG-2016 10:10:53

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Starting /opt/oracle/product/9ir2/bin/tnslsnr: please wait...

TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe
[oracle@new0 ~]$ cd $ORACLE_HOME
[oracle@new0 9ir2]$ ls
Apache classes demo ds inventory jdk jsp mgw ocs4j oraInst.loc owm relnotes soap sysman xdk
assistants ctx diagnostics hs jar jlib ldap network oem_webstage ord plsql root.sh sqlj ultrasearch
BC4J cwmlite dm install javavm jre lib oci olap otrace precomp root.sh.old sqlplus weboamlib
bin dbs doc install.platform jdbc JRE md ocommon oracore oui rdbms slax syndication wwg
[oracle@new0 9ir2]$ cd net*
[oracle@new0 network]$ ls
admin agent doc install jlib lib log mesg snmp tools trace
[oracle@new0 network]$ cd admin
[oracle@new0 admin]$ ls
libnk59.def listener.ora shrept.lst sqlnet12021011AM2335.bak sqlnet.ora tnsnames.ora
listener12021011AM2335.bak listener.ora1 snmp_ro.ora sqlnet12021011AM2525.bak tnsnames12021011AM2335.bak tnsnames.ora.old
listener.bak samples snmp_rw.ora sqlnet.log tnsnames12021011AM2525.bak
[oracle@new0 admin]$ ll
total 84
-rw-r--r-- 1 oracle oinstall 825 Jul 26 2003 libnk59.def
-rw-r--r-- 1 oracle oinstall 541 Feb 10 2012 listener12021011AM2335.bak
-rw-r--r-- 1 oracle oinstall 669 Dec 2 2011 listener.bak
-rw-r--r-- 1 oracle oinstall 670 Nov 23 2012 listener.ora
-rw-r--r-- 1 oracle oinstall 541 Feb 10 2012 listener.ora1
drwxr-xr-x 2 oracle oinstall 4096 Dec 2 2011 samples
-rw-r--r-- 1 oracle oinstall 130 Mar 18 2002 shrept.lst
-rw-rw-r-- 1 oracle oinstall 356 Nov 27 2012 snmp_ro.ora
-rw-rw-r-- 1 oracle oinstall 51 Nov 27 2012 snmp_rw.ora
-rw-r--r-- 1 oracle oinstall 187 Feb 10 2012 sqlnet12021011AM2335.bak
-rw-r--r-- 1 oracle oinstall 187 Feb 10 2012 sqlnet12021011AM2525.bak
-rw-r--r-- 1 oracle oinstall 695 Jan 9 2012 sqlnet.log
-rw-rw-r-- 1 oracle oinstall 187 Jan 11 2012 sqlnet.ora
-rw-r--r-- 1 oracle oinstall 4659 Feb 10 2012 tnsnames12021011AM2335.bak
-rw-r--r-- 1 oracle oinstall 4659 Feb 10 2012 tnsnames12021011AM2525.bak
-rw-r--r-- 1 oracle oinstall 7891 Nov 18 2014 tnsnames.ora
-rw-r--r-- 1 oracle oinstall 4659 Jul 31 2012 tnsnames.ora.old
[oracle@new0 admin]$ cat listener.ora
# LISTENER.ORA Network Configuration File: /opt/oracle/product/9ir2/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/product/9ir2)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = gg01)
(ORACLE_HOME = /opt/oracle/product/9ir2)
(SID_NAME = gg01m)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = new0)(PORT = 1521))
)
)
)

[oracle@new0 admin]$
[oracle@new0 admin]$
[oracle@new0 admin]$ ping new0
PING new0 (10.98.32.70) 56(84) bytes of data.
64 bytes from new0 (10.98.32.70): icmp_seq=1 ttl=64 time=0.017 ms
64 bytes from new0 (10.98.32.70): icmp_seq=2 ttl=64 time=0.011 ms
64 bytes from new0 (10.98.32.70): icmp_seq=3 ttl=64 time=0.011 ms
64 bytes from new0 (10.98.32.70): icmp_seq=4 ttl=64 time=0.011 ms
64 bytes from new0 (10.98.32.70): icmp_seq=5 ttl=64 time=0.011 ms

--- new0 ping statistics ---
5 packets transmitted, 5 received, 0% packet loss, time 4000ms
rtt min/avg/max/mdev = 0.011/0.012/0.017/0.003 ms
[oracle@new0 admin]$ ls
libnk59.def listener.ora shrept.lst sqlnet12021011AM2335.bak sqlnet.ora tnsnames.ora
listener12021011AM2335.bak listener.ora1 snmp_ro.ora sqlnet12021011AM2525.bak tnsnames12021011AM2335.bak tnsnames.ora.old
listener.bak samples snmp_rw.ora sqlnet.log tnsnames12021011AM2525.bak
[oracle@new0 admin]$ cd ..
[oracle@new0 network]$ ls
admin agent doc install jlib lib log mesg snmp tools trace
[oracle@new0 network]$ cd log
[oracle@new0 log]$ ls
dbsnmp.log dbsnmp.nohup listener.log nmiconf.log sqlnet.log z
[oracle@new0 log]$ ll
total 2099404
-rw-rw---- 1 oracle oinstall 983 Nov 27 2012 dbsnmp.log
-rw-rw-r-- 1 oracle oinstall 3022 Nov 27 2012 dbsnmp.nohup
-rw-rw-r-- 1 oracle oinstall 2147483647 Aug 17 01:03 listener.log
-rw-rw---- 1 oracle oinstall 785 Nov 27 2012 nmiconf.log
-rw-r--r-- 1 oracle oinstall 184346 Jul 26 10:50 sqlnet.log
-rw-r--r-- 1 oracle oinstall 0 Feb 18 2004 z
[oracle@new0 log]$ mv listener.log listener.bak
[oracle@new0 log]$ ll
total 2099404
-rw-rw---- 1 oracle oinstall 983 Nov 27 2012 dbsnmp.log
-rw-rw-r-- 1 oracle oinstall 3022 Nov 27 2012 dbsnmp.nohup
-rw-rw-r-- 1 oracle oinstall 2147483647 Aug 17 01:03 listener.bak
-rw-rw---- 1 oracle oinstall 785 Nov 27 2012 nmiconf.log
-rw-r--r-- 1 oracle oinstall 184346 Jul 26 10:50 sqlnet.log
-rw-r--r-- 1 oracle oinstall 0 Feb 18 2004 z

[oracle@new0 log]$ cd
[oracle@new0 ~]$ lsnrctl start

LSNRCTL for Linux: Version 9.2.0.6.0 - Production on 17-AUG-2016 10:13:58

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Starting /opt/oracle/product/9ir2/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 9.2.0.6.0 - Production
System parameter file is /opt/oracle/product/9ir2/network/admin/listener.ora
Log messages written to /opt/oracle/product/9ir2/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=new0)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 9.2.0.6.0 - Production
Start Date 17-AUG-2016 10:13:58
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /opt/oracle/product/9ir2/network/admin/listener.ora
Listener Log File /opt/oracle/product/9ir2/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=new0)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "gg01" has 1 instance(s).
Instance "gg01m", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@new0 ~]$ cd /opt/oracle/product/9ir2/network/log
[oracle@new0 log]$ ll
total 2099408
-rw-rw---- 1 oracle oinstall 983 Nov 27 2012 dbsnmp.log
-rw-rw-r-- 1 oracle oinstall 3022 Nov 27 2012 dbsnmp.nohup
-rw-rw-r-- 1 oracle oinstall 2147483647 Aug 17 01:03 listener.bak
-rw-r--r-- 1 oracle oinstall 2810 Aug 17 10:14 listener.log
-rw-rw---- 1 oracle oinstall 785 Nov 27 2012 nmiconf.log
-rw-r--r-- 1 oracle oinstall 184346 Jul 26 10:50 sqlnet.log
-rw-r--r-- 1 oracle oinstall 0 Feb 18 2004 z
[oracle@new0 log]$

tail -16 listener.bak

17-AUG-2016 01:02:36 * (CONNECT_DATA=(SID=gg01)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.32.13)(PORT=9125)) * establish * gg01 * 0
17-AUG-2016 01:02:38 * service_update * gg01 * 0
17-AUG-2016 01:02:41 * (CONNECT_DATA=(SID=gg01)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.32.13)(PORT=9126)) * establish * gg01 * 0
17-AUG-2016 01:02:47 * (CONNECT_DATA=(SID=gg01)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.32.13)(PORT=9127)) * establish * gg01 * 0
17-AUG-2016 01:02:52 * (CONNECT_DATA=(SID=gg01)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.32.13)(PORT=9128)) * establish * gg01 * 0
17-AUG-2016 01:02:58 * (CONNECT_DATA=(SID=gg01)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.32.13)(PORT=9129)) * establish * gg01 * 0
17-AUG-2016 01:03:03 * (CONNECT_DATA=(SID=gg01)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.32.13)(PORT=9130)) * establish * gg01 * 0
17-AUG-2016 01:03:09 * (CONNECT_DATA=(SID=gg01)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.32.13)(PORT=9131)) * establish * gg01 * 0
17-AUG-2016 01:03:14 * (CONNECT_DATA=(SID=gg01)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.32.13)(PORT=9132)) * establish * gg01 * 0
17-AUG-2016 01:03:19 * (CONNECT_DATA=(SID=gg01)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.32.13)(PORT=9133)) * establish * gg01 * 0
17-AUG-2016 01:03:25 * (CONNECT_DATA=(SID=gg01)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.32.13)(PORT=9134)) * establish * gg01 * 0
17-AUG-2016 01:03:28 * (CONNECT_DATA=(SID=gg01)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.32.13)(PORT=9135)) * establish * gg01 * 0
17-AUG-2016 01:03:31 * (CONNECT_DATA=(SID=gg01)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.32.13)(PORT=9137)) * establish * gg01 * 0
17-AUG-2016 01:03:36 * (CONNECT_DATA=(SID=gg01)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.32.13)(PORT=9138)) * establish * gg01 * 0
17-AUG-2016 01:03:42 * (CONNECT_DATA=(SID=gg01)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.32.13)(PORT=9139)) * establish * gg01 * 0
17-AUG-2016 01:03:47 * (CONNECT_DATA=(SID=gg01)(CID=(P[oracle@new0 log]$

32位系統報錯TNS-12547: TNS:lost contact

相關文章