木易: 按你的方法,结果是这样的: E:\>lsnrctl startLSNRCTL for 32-bit Windows: Version 8.1.6.0.0 - Production on 30-6月 -2001 22:11 :50(c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.启动tnslsnr:请稍候...Failed to open service <OracleOraHome81TNSListener>, error 1060. TNSLSNR for 32-bit Windows: Version 8.1.6.0.0 - Production NL-00280: 创建日志数据流E:\Oracle\Ora81\network\log\listener.log时出错 NL-00278: 无法打开日志文件 SNL-00016: snlfohd:打开文件出现错误 32-bit Windows Error: 2: No such file or directory
这是我用SQLPLUS进去的结果,用户名输入system,密码输入manager。回车之后就提示TNS:协议适配器错误 E:\>sqlplusSQL*Plus: Release 8.1.6.0.0 - Production on 星期六 6月 30 22:19:14 2001(c) Copyright 1999 Oracle Corporation. All rights reserved.请输入用户名: system 请输入口令: ERROR: ORA-12560: TNS: 协议适配器错误
按你的方法,结果是这样的:
E:\>lsnrctl startLSNRCTL for 32-bit Windows: Version 8.1.6.0.0 - Production on 30-6月 -2001 22:11
:50(c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.启动tnslsnr:请稍候...Failed to open service <OracleOraHome81TNSListener>, error 1060.
TNSLSNR for 32-bit Windows: Version 8.1.6.0.0 - Production
NL-00280: 创建日志数据流E:\Oracle\Ora81\network\log\listener.log时出错
NL-00278: 无法打开日志文件
SNL-00016: snlfohd:打开文件出现错误
32-bit Windows Error: 2: No such file or directory
服务里面没有类似于OracleOraHome81TNSListener之类的服务。
只有上述两个服务
ORACLE 8i安装完了之后还需要进行什么初始化之类的配置呢?
E:\>sqlplusSQL*Plus: Release 8.1.6.0.0 - Production on 星期六 6月 30 22:19:14 2001(c) Copyright 1999 Oracle Corporation. All rights reserved.请输入用户名: system
请输入口令:
ERROR:
ORA-12560: TNS: 协议适配器错误
服务已经启动了,LOG里面显示如下信息,我应该如何找到正确的SID,我安装时配置的SID是oradb:
TNSLSNR for 32-bit Windows: Version 8.1.6.0.0 - Production on 30-6月 -2001 22:21:39(c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.写入E:\Oracle\Ora81\network\log\listener.log的日志信息
写入E:\Oracle\Ora81\network\trace\listener.trc的跟踪信息
跟踪级别当前为0监听:(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\PNPKEYipc)))
监听:(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=papa)(PORT=1521)))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
30-6月 -2001 22:21:42 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Administrator))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=135290880)) * status * 0
30-6月 -2001 22:23:58 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Administrator))(COMMAND=services)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=135290880)) * services * 0
30-6月 -2001 22:25:15 * (CONNECT_DATA=(SID=ORADB)(SERVER=DEDICATED)(CID=(PROGRAM=D:\Program Files\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=PAPA)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=202.97.220.141)(PORT=1232)) * establish * ORADB * 12505
TNS-12505: TNS: 监听器无法分解在连接描述符中给出 SID
30-6月 -2001 22:25:15 * (CONNECT_DATA=(SID=ORADB)(SERVER=DEDICATED)(CID=(PROGRAM=D:\Program Files\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=PAPA)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=202.97.220.141)(PORT=1233)) * establish * ORADB * 12505
TNS-12505: TNS: 监听器无法分解在连接描述符中给出 SID
30-6月 -2001 22:25:58 * (CONNECT_DATA=(SID=ORADB)(CID=(PROGRAM=D:\Program Files\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=PAPA)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=202.97.220.141)(PORT=1234)) * establish * ORADB * 12505
TNS-12505: TNS: 监听器无法分解在连接描述符中给出 SID
30-6月 -2001 22:25:58 * (CONNECT_DATA=(SID=ORADB)(CID=(PROGRAM=D:\Program Files\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=PAPA)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=202.97.220.141)(PORT=1235)) * establish * ORADB * 12505
TNS-12505: TNS: 监听器无法分解在连接描述符中给出 SID
30-6月 -2001 22:26:26 * (CONNECT_DATA=(SID=ORADB)(SERVER=DEDICATED)(CID=(PROGRAM=D:\Program Files\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=PAPA)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=202.97.220.141)(PORT=1236)) * establish * ORADB * 12505
TNS-12505: TNS: 监听器无法分解在连接描述符中给出 SID
30-6月 -2001 22:26:26 * (CONNECT_DATA=(SID=ORADB)(SERVER=DEDICATED)(CID=(PROGRAM=D:\Program Files\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=PAPA)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=202.97.220.141)(PORT=1237)) * establish * ORADB * 12505
TNS-12505: TNS: 监听器无法分解在连接描述符中给出 SID
30-6月 -2001 22:26:59 * (CONNECT_DATA=(SID=oradb)(CID=(PROGRAM=D:\Program Files\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=PAPA)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=202.97.220.141)(PORT=1238)) * establish * oradb * 12505
TNS-12505: TNS: 监听器无法分解在连接描述符中给出 SID
30-6月 -2001 22:26:59 * (CONNECT_DATA=(SID=oradb)(CID=(PROGRAM=D:\Program Files\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=PAPA)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=202.97.220.141)(PORT=1239)) * establish * oradb * 12505
TNS-12505: TNS: 监听器无法分解在连接描述符中给出 SID
30-6月 -2001 22:27:07 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=D:\Program Files\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=PAPA)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=202.97.220.141)(PORT=1240)) * establish * orcl * 12505
TNS-12505: TNS: 监听器无法分解在连接描述符中给出 SID
30-6月 -2001 22:27:07 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=D:\Program Files\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=PAPA)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=202.97.220.141)(PORT=1241)) * establish * orcl * 12505
TNS-12505: TNS: 监听器无法分解在连接描述符中给出 SID
30-6月 -2001 22:27:18 * (CONNECT_DATA=(SID=oraHome)(CID=(PROGRAM=D:\Program Files\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=PAPA)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=202.97.220.141)(PORT=1242)) * establish * oraHome * 12505
TNS-12505: TNS: 监听器无法分解在连接描述符中给出 SID
30-6月 -2001 22:27:18 * (CONNECT_DATA=(SID=oraHome)(CID=(PROGRAM=D:\Program Files\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=PAPA)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=202.97.220.141)(PORT=1243)) * establish * oraHome * 12505
TNS-12505: TNS: 监听器无法分解在连接描述符中给出 SID
30-6月 -2001 22:27:26 * (CONNECT_DATA=(SID=oraHome81)(CID=(PROGRAM=D:\Program Files\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=PAPA)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=202.97.220.141)(PORT=1244)) * establish * oraHome81 * 12505
TNS-12505: TNS: 监听器无法分解在连接描述符中给出 SID
30-6月 -2001 22:27:26 * (CONNECT_DATA=(SID=oraHome81)(CID=(PROGRAM=D:\Program Files\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=PAPA)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=202.97.220.141)(PORT=1245)) * establish * oraHome81 * 12505
TNS-12505: TNS: 监听器无法分解在连接描述符中给出 SID
还有一个SERVICE
OracleServiceORACLE是如何启动的?