ORA-12514错误的处理-优快云博客

本文介绍了解决Oracle数据库中ORA-12514错误的方法。该错误通常由于listener.ora文件中缺少相应的SID描述引起。通过修改listener.ora文件并重启TNS监听器可以解决此问题。

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.