看起来应该是和os相关的,我都重装了oracle还是不行,有什么办法?
[php]
C:\>lsnrctl status
LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 17-9月 -2006 14:26
:59
Copyright (c) 1991, 2002, Oracle Corporation.All rights reserved.
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=IBM-31BE186027C)(PORT=1521)
))
TNS-12541: TNS:无监听器
TNS-12560: TNS: 协议适配器错误
TNS-00511: 无监听器
32-bit Windows Error: 61: Unknown error
C:\>LSNRCTL STOP
LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 17-9月 -2006 14:28
:04
Copyright (c) 1991, 2002, Oracle Corporation.All rights reserved.
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=IBM-31BE186027C)(PORT=1521)
))
TNS-12541: TNS:无监听器
TNS-12560: TNS: 协议适配器错误
TNS-00511: 无监听器
32-bit Windows Error: 61: Unknown error
C:\>lsnrctl start
LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 17-9月 -2006 14:28
:14
Copyright (c) 1991, 2002, Oracle Corporation.All rights reserved.
启动tnslsnr:请稍候...
Service OracleOraHome92TNSListener already running.
TNS-12560: TNS: 协议适配器错误
TNS-00530: 协议适配器错误
32-bit Windows Error: 1056: Unknown error
C:\>
[/php]
listener.ora
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = IBM-31BE186027C)(PORT = 1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = C:\ORACLE\ORA92)
(SID_NAME = ORCL)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = C:\ORACLE\ORA92)
(SID_NAME = STBY)
)
)
tnsnames.ora
STBY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IBM-31BE186027C)(PORT = 1521))
)
(CONNECT_DATA =
(SID = STBY)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IBM-31BE186027C)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORCL)
)
)
|