SQL> conn system/system;
Connected to Oracle Database 10g Enterprise Edition Release 10.1.0.2.0
Connected as systemwindow xp环境下,oracle 10G ,
服务OracleOraDb10g_home1TNSListener以及OracleServiceORCL都是启动着的。但是java应用程序连接不上:报如下错误:
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
Skyman:1521:orcl百度、google之后,在plsql命令敞口模式下执行检查如下:
SQL> select * from v$instance;INSTANCE_NUMBER INSTANCE_NAME HOST_NAME VERSION STARTUP_TIME STATUS PARALLEL THREAD# ARCHIVER LOG_SWITCH_WAIT LOGINS SHUTDOWN_PENDING DATABASE_STATUS INSTANCE_ROLE ACTIVE_STATE
--------------- ---------------- ---------------------------------------------------------------- ----------------- ------------ ------------ -------- ---------- -------- --------------- ---------- ---------------- ----------------- ------------------ ------------
1 orcl SKYMAN 10.1.0.2.0 2009-04-22 1 OPEN NO 1 STOPPED ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMALSQL> conn system/system@orcl;
Not logged onSQL> conn system/system;
Connected to Oracle Database 10g Enterprise Edition Release 10.1.0.2.0
Connected as system怎么会这样呢?
Connected to Oracle Database 10g Enterprise Edition Release 10.1.0.2.0
Connected as systemwindow xp环境下,oracle 10G ,
服务OracleOraDb10g_home1TNSListener以及OracleServiceORCL都是启动着的。但是java应用程序连接不上:报如下错误:
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
Skyman:1521:orcl百度、google之后,在plsql命令敞口模式下执行检查如下:
SQL> select * from v$instance;INSTANCE_NUMBER INSTANCE_NAME HOST_NAME VERSION STARTUP_TIME STATUS PARALLEL THREAD# ARCHIVER LOG_SWITCH_WAIT LOGINS SHUTDOWN_PENDING DATABASE_STATUS INSTANCE_ROLE ACTIVE_STATE
--------------- ---------------- ---------------------------------------------------------------- ----------------- ------------ ------------ -------- ---------- -------- --------------- ---------- ---------------- ----------------- ------------------ ------------
1 orcl SKYMAN 10.1.0.2.0 2009-04-22 1 OPEN NO 1 STOPPED ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMALSQL> conn system/system@orcl;
Not logged onSQL> conn system/system;
Connected to Oracle Database 10g Enterprise Edition Release 10.1.0.2.0
Connected as system怎么会这样呢?
换成ip试试
重啟下數據庫試試