关闭

ORA-12514错误的处理

标签: databasedescriptororacleserverlistfile
3758人阅读 评论(0) 收藏 举报
分类:

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

Cause :
 -------
 In the "<OracleHome>/network/admin/listener.ora" file (in this case,
 "<OracleHome>" refers to the Oracle Home where the Database is installed)
 of the server that hosts the Database (corresponding to the TNS Alias),
 the SID description of that Database does not exist.

 Fix :
 -----
 In order to fix this error, execute the following steps :-

     1. Open the '<OracleHome>/network/admin/listener.ora' file of the
        server that hosts the Database (corresponding to the TNS Alias)
        and go to the section that contains the following lines -

        SID_LIST_LISTENER =
          (SID_LIST =
            (SID_DESC =
              (SID_NAME = PLSExtProc)
              (ORACLE_HOME = /oracle/Ora9iDB)
              (PROGRAM = extproc)
            )
          )

     2. Add the following lines after the 7th line in the above excerpt -

            (SID_DESC =
              (GLOBAL_DBNAME = Ora9iDB)
              (ORACLE_HOME = /oracle/Ora9iDB)
              (SID_NAME = Ora9iDB)
            )

     3. Save the aforesaid change made in the '<OracleHome>/network/admin/
        listener.ora' file.
     4. Restart the TNS Listener corresponding to the Database.

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:138088次
    • 积分:2009
    • 等级:
    • 排名:第19111名
    • 原创:56篇
    • 转载:20篇
    • 译文:2篇
    • 评论:17条
    文章分类
    最新评论