DINYA

丁亚军 - 简单生活

ORA-12514错误的处理

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.

阅读更多
个人分类: Oracle技术
上一篇如何创建Java存储过程
下一篇Linux环境设置Oracle随系统启动
想对作者说点什么? 我来说一句

<em>ORA-12514</em>错误解决办法

2017年12月22日 0B 下载

没有更多推荐了,返回首页

关闭
关闭