【Vegas原创】ORA-12505问题解决方法

现象：client进行sqlplus连接时，报此错误，并提示tnsname无法连接。

解决方案：更改listener.ora文件

 

原来的文件：

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = dtberp)(PORT = 1521))
      )
    )
  )

更改后：

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1)
      (PROGRAM = extproc)
    )
      (SID_DESC =
      (SID_NAME = dtberp)
      (ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1)
      (GLOBAL_DBNAME = dtberp)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = dtberp)(PORT = 1521))
      )
    )
  )