oracle ORA-00119, ORA-00132問題解決

標籤：nbsp   col   resolved   nis   str   bho   work   spec   syntax   

使用PL/SQL登入oracle報ORA-12154: TNS: 無法解析指定的串連標識符
sqlplus /nolog
connect /as sysdba
startup
報如下錯誤：
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name ‘LISTENER_ORCL‘

LOCAL_LISTENER為D:\app\Administrator\product\11.2.0\dbhome_1\database\SPFILEORCL.ORA檔案中*.local_listener參數
LISTENER_ORCL為*.local_listener參數值，如：*.local_listener=‘LISTENER_ORCL‘

ORA-00119,ORA-00132是因為*.local_listener=‘LISTENER_ORCL‘的值，即LISTENER_ORCL在D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora檔案中未申明，需求修改設定檔即可。

LISTENER_ORCL =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 1521))
    )
  )

oracle ORA-00119, ORA-00132問題解決