Microsoft Windows [Version 5.2.3790] (C) Copyright 1985-2003 Microsoft Corp.C:\Documents and Settings\Administrator>sqlplusSQL*Plus: Release 9.2.0.1.0 - Production on Tue Nov 16 12:21:44 2004Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.Enter user-name: dcx Enter password: ERROR: ORA-12560: TNS:protocol adapter error其实并不是服务没有起来,而是没有指定要登陆的服务。C:\Documents and Settings\Administrator>sqlplus uid/pwd@sidSQL*Plus: Release 9.2.0.1.0 - Production on Tue Nov 16 12:23:16 2004Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.4.0 - ProductionSQL>指定要登陆的服务名就可以了。sqlplus uid/pwd@sid
然后看看tns 有没有配置正确
,说明SID有问题,有可能是你的机器名有改
用lsnrctl Start命令在cmd中运行看看,应该有错误提示的。很有可能你改过机器名,这样在
C:\oracle\ora92\network\admin(你的Oracle安装路径)中的listener.ora中的LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 你的新机器名)(PORT = 1521))
)
)
)
(C) Copyright 1985-2003 Microsoft Corp.C:\Documents and Settings\Administrator>sqlplusSQL*Plus: Release 9.2.0.1.0 - Production on Tue Nov 16 12:21:44 2004Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.Enter user-name: dcx
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error其实并不是服务没有起来,而是没有指定要登陆的服务。C:\Documents and Settings\Administrator>sqlplus uid/pwd@sidSQL*Plus: Release 9.2.0.1.0 - Production on Tue Nov 16 12:23:16 2004Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - ProductionSQL>指定要登陆的服务名就可以了。sqlplus uid/pwd@sid