oracleoralinux,linux下连接oracle数据库出错：ORA12514cannot...

linux下连接oracle数据库出错&＃xff1a;ORA-12514 cannot...

发布时间:2008-03-02 00:02:27来源:红联作者:dwillin

今天连接数据库时出了错&＃xff0c;监听启动正常&＃xff0c;/ 下启动数据库也正常&＃xff0c;用sys连接时提示出错&＃xff0c;

数据库名是oradb,sid是oradb:

$lsnrctl start

提示&＃xff1a;成功&＃xff01;

$sqlplus "/ as sysdba"

sql>startup

提示&＃xff1a;成功&＃xff01;

sql>conn sys/oracle&＃64;oradb as sysdba;

报错&＃xff1a;

ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect

descriptor&＃xff01;

我是这样解决的&＃xff1a;以root身份登录&＃xff0c;查看/oracle/product/9.2.0.4/network/admin目录

下的

listener.ora和tnsnames.ora两个配置文件的配置是否正确。

$vi tnsnames.ora

oradb &＃61;

(DESCRIPTION &＃61;

(ADDRESS_LIST &＃61;

(ADDRESS &＃61; (PROTOCOL &＃61; TCP)(HOST &＃61; 192.168.0.101)(PORT &＃61; 1521))

)

(CONNECT_DATA &＃61;

(SERVICE_NAME &＃61; orcl.oradb.localdomain)

)

)

修改SERVICE_NAME &＃61; orcl.oradb.localdomain为SERVICE_NAME &＃61; oradb

保存退出

$vi listener.ora

LISTENER &＃61;

(DESCRIPTION_LIST &＃61;

(DESCRIPTION &＃61;

(ADDRESS_LIST &＃61;

(ADDRESS &＃61;(PROTOCOL&＃61;TCP)(HOST&＃61;192.168.0.101)(PORT&＃61; 1521))

)

(ADDRESS_LIST &＃61;

(ADDRESS &＃61;(PROTOCOL&＃61;IPC)(KEY&＃61;EXTPROC))

)

)

)

SID_LIST_LISTENER &＃61;

(SID_LIST &＃61;

(SID_DESC &＃61;

(SID_NAME &＃61; PLSExtProc)

(ORACLE_HOME &＃61; /opt/u01/app/oracle/product/9.2.0.4)

(PROGRAM &＃61; extproc)

)

)

在SID_LIST_LISTENER 中增加下列内容&＃xff1a;

(SID_DESC &＃61;

(GLOBAL_DBNAME &＃61; oradb)

(ORACLE_HOME &＃61; /opt/u01/app/oracle/product/9.2.0.4)

(SID_NAME &＃61; oradb)

)

完整的listener.ora的内容是&＃xff1a;

LISTENER &＃61;

(DESCRIPTION_LIST &＃61;

(DESCRIPTION &＃61;

(ADDRESS_LIST &＃61;

(ADDRESS &＃61; (PROTOCOL &＃61; IPC)(KEY &＃61; EXTPROC0))

)

(ADDRESS_LIST &＃61;

(ADDRESS &＃61; (PROTOCOL &＃61; TCP)(HOST &＃61; 192.168.0.101)(PORT &＃61; 1521))

)

)

)

SID_LIST_LISTENER &＃61;

(SID_LIST &＃61;

(SID_DESC &＃61;

(SID_NAME &＃61; PLSExtProc)

(ORACLE_HOME &＃61; /opt/u01/app/oracle/product/9.2.0.4)

(PROGRAM &＃61; extproc)

)

(SID_DESC &＃61;

(GLOBAL_DBNAME &＃61; oradb)

(ORACLE_HOME &＃61; /opt/u01/app/oracle/product/9.2.0.4)

(SID_NAME &＃61; oradb)

)

)

再以oracle身份登录&＃xff0c;启动监听和数据库&＃xff0c;连接数据库都正常了。