Go语言视频零基础入门到精通

admin

服务器莫名其妙的报这个错，之前一直正常，从Google获取解决方案，解决之，记录如下：



1. Open the ""<OracleHome>/network/admin/listener.ora" file in the host,and you will see:

   SID_LIST_LISTENER =

   (SID_LIST =

     (SID_DESC =

       (SID_NAME = PLSExtProc)

       (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)

       (PROGRAM = extproc)

     )

   )

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

            (SID_DESC =

       (GLOBAL_DBNAME = ORACLE)

       (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)   

       (SID_NAME = ORACLE)

      )

  3. At last the content of the file become to the following section:

SID_LIST_LISTENER =

   (SID_LIST =

     (SID_DESC =

       (SID_NAME = PLSExtProc)

       (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)

       (PROGRAM = extproc)

     )

     (SID_DESC =

       (GLOBAL_DBNAME = ORACLE)

       (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)   

       (SID_NAME = ORACLE)

      )

   )

  4. Save the file and restart the TNSListener service in the host. That"s OK!