Question

eclipse连接oracle报错 代码没错，plsqlk连上oracle 错误如下

数据库链接创建失败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: localhost:1521:oracle
实例名为oracle
listener.ora:
# listener.ora Network Configuration File: D:\oracle1\product\10.2.0\db_2\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle1\product\10.2.0\db_2)
(PROGRAM = extproc)
)

(SID_DESC =
(GLOBAL_DBNAME = ORALE)
(ORACLE_HOME = /app/oracle/oracle/product/10.2.0/db_2)
(SID_NAME = ORALE)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = PC-hp)(PORT = 1521))
)
)

Answer 1

配置文件中是 ORALE 少个C

(SID_DESC =
(GLOBAL_DBNAME = ORALE)
(ORACLE_HOME = /app/oracle/oracle/product/10.2.0/db_2)
(SID_NAME = ORALE)
)

Answer 2

plsql登陆，实例名前是@不是冒号
你的实例名是orale

Answer 3

你的监听器服务没开

Answer 4

用eclipse中的buildpath

Answer 5

HOST = localhost试一下