window2003 ORACLE10g现无法登陆,
sqlplus /nolog
connect rocky/rocky@demo登陆时,命令符界面停止不动........
pl/sql develpoer登陆也是在登陆界面不动.....
请问如何解决.??
sqlplus /nolog
connect rocky/rocky@demo登陆时,命令符界面停止不动........
pl/sql develpoer登陆也是在登陆界面不动.....
请问如何解决.??
先试一下
=================================
没有错误提示吗?==>没有提示啊
(C) 版权所有 1985-2003 Microsoft Corp.C:\Documents and Settings\rocky>tnsping demoTNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 24-3月 -
2008 12:38:27Copyright (c) 1997, 2005, Oracle. All rights reserved.已使用的参数文件:
d:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rocky)(P
ORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = demo)))
OK (100 毫秒)C:\Documents and Settings\rocky>sqlplus rocky/rocky@demoSQL*Plus: Release 10.2.0.1.0 - Production on 星期一 3月 24 12:39:11 2008Copyright (c) 1982, 2005, Oracle. All rights reserved.就是一直停止在命令符里,不动.....
难道重装ORACLE??
SQL> conn sys/system@zxp as sysdba
Connected.重啓ORACLE服務也是可以解決問題的!