ora-12505错误---SID错误
通常出现在项目开发中,在JDBC串中出现,因为JDBC用到SID,如:
jdbc:oracle:thin:@192.168.3.98:1521:orcl
解决:sid要匹配服务器listener.ora里的sid_name
例1:这是个从网上搜到的实际的例子
"最近,我在使用jdbc连接oracle 9i数据库时,发生如下错误:
Error occured while trying to connect to the database
Error connecting to database: (using class racle.jdbc.driver.OracleDriver)
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:
192.168.1.1:1521:bbcd"
----解决办法,经查找,以上的bbcd并不是listener.ora中定义的sid_name,而是SERVICE_NAME
改用sid_name后,运行正常。
ORA-12514错误--------service_name出错
通常是sqlplus报错,因为sqlplus登录时会用到service_name的(PL/SQL Devoloper用的也是基于sqlplus)
oracle linux 上的sqlplus, 用的service_name是查自tnsname.ora
例1:
SQL> connect sys/admin123@oral as sysdba;
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
原来orcl输错成oral(funny, 很黄的一个词)
Warning: You are no longer connected to ORACLE.
SQL> connect sys/admin123@orcl as sysdba;
Connected.