里面只有一个sqlnet.log。这是最近的记录 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=D:\app\lch\product\11.2.0\dbhome_1\bin\emagent.exe)(HOST=LCH-PC)(USER=SYSTEM)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 11.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production Time: 10-7月 -2014 07:11:55 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS: 无监听程序 ns secondary err code: 12560 nt main err code: 511 TNS-00511: 无监听程序 nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12528, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=D:\app\lch\product\11.2.0\dbhome_1\bin\emagent.exe)(HOST=LCH-PC)(USER=SYSTEM)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 11.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production Time: 10-7月 -2014 07:12:42 Tracing not turned on. Tns error struct: ns main err code: 12564 TNS-12564: TNS: 拒绝连接 ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12528, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=D:\app\lch\product\11.2.0\dbhome_1\bin\emagent.exe)(HOST=LCH-PC)(USER=SYSTEM)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 11.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production Time: 10-7月 -2014 07:12:42 Tracing not turned on. Tns error struct: ns main err code: 12564 TNS-12564: TNS: 拒绝连接 ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12505, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=lch-PC)(PORT=1521))(CONNECT_DATA=(SID=lch2014)(CID=(PROGRAM=D:\app\lch\product\11.2.0\dbhome_1\bin\emagent.exe)(HOST=LCH-PC)(USER=SYSTEM)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 11.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production Time: 10-7月 -2014 11:37:04 Tracing not turned on. Tns error struct: ns main err code: 12564 TNS-12564: TNS: 拒绝连接 ns secondary err code: 12560 nt main err code: 517 TNS-00517: 丢失连接 nt secondary err code: 54 nt OS err code: 0
d:\app\yakecan\diag\rdbms\orcl \orcl\trace 告警日志的路径,经色部分换成你的OS路径。 一般可以用这个命令查看的 show parameter background_dump
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app\lch\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app\lch\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = D:\app\lch\product\11.2.0\dbhome_1)
(SID_NAME = ORCL)
)
(SID_DESC =
(GLOBAL_DBNAME = lch2014)
(ORACLE_HOME = D:\app\lch\product\11.2.0\dbhome_1)
(SID_NAME = lch2014)
)
)LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = lch-PC)(PORT = 1521))
)ADR_BASE_LISTENER = D:\app\lch
我把它移走之后,lch2014那个服务就启动不了了
***********************************************************************
Fatal NI connect error 12541, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=D:\app\lch\product\11.2.0\dbhome_1\bin\emagent.exe)(HOST=LCH-PC)(USER=SYSTEM)))) VERSION INFORMATION:
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production
Time: 10-7月 -2014 07:11:55
Tracing not turned on.
Tns error struct:
ns main err code: 12541
TNS-12541: TNS: 无监听程序
ns secondary err code: 12560
nt main err code: 511
TNS-00511: 无监听程序
nt secondary err code: 61
nt OS err code: 0
***********************************************************************
Fatal NI connect error 12528, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=D:\app\lch\product\11.2.0\dbhome_1\bin\emagent.exe)(HOST=LCH-PC)(USER=SYSTEM)))) VERSION INFORMATION:
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production
Time: 10-7月 -2014 07:12:42
Tracing not turned on.
Tns error struct:
ns main err code: 12564
TNS-12564: TNS: 拒绝连接
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
***********************************************************************
Fatal NI connect error 12528, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=D:\app\lch\product\11.2.0\dbhome_1\bin\emagent.exe)(HOST=LCH-PC)(USER=SYSTEM)))) VERSION INFORMATION:
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production
Time: 10-7月 -2014 07:12:42
Tracing not turned on.
Tns error struct:
ns main err code: 12564
TNS-12564: TNS: 拒绝连接
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
***********************************************************************
Fatal NI connect error 12505, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=lch-PC)(PORT=1521))(CONNECT_DATA=(SID=lch2014)(CID=(PROGRAM=D:\app\lch\product\11.2.0\dbhome_1\bin\emagent.exe)(HOST=LCH-PC)(USER=SYSTEM)))) VERSION INFORMATION:
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production
Time: 10-7月 -2014 11:37:04
Tracing not turned on.
Tns error struct:
ns main err code: 12564
TNS-12564: TNS: 拒绝连接
ns secondary err code: 12560
nt main err code: 517
TNS-00517: 丢失连接
nt secondary err code: 54
nt OS err code: 0
告警日志的路径,经色部分换成你的OS路径。
一般可以用这个命令查看的
show parameter background_dump