環境說明： RAC 啟動資料庫報 ORA-00119: invalid specification for system parameter REMOTE_LISTENER 。檢查 listener.ora 與 tnsnames.ora 沒有發現問題。

[root@node1 bin]# ./srvctl start database -d devdb

PRCR-1079 : Failed to start resource ora.devdb.db
CRS-5017: The resource action "ora.devdb.db start" encountered the following error:
ORA-00119: invalid specification for system parameter REMOTE_LISTENER
ORA-00132: syntax error or unresolved network name 'scan-cluster.localdomain:1521'
. For details refer to "(:CLSN00107:)" in "/u01/app/11.2.0/grid/log/node1/agent/crsd/oraagent_oracle/oraagent_oracle.log".

CRS-2674: Start of 'ora.devdb.db' on 'node1' failed
CRS-2632: There are no more servers to try to place resource 'ora.devdb.db' on that would satisfy its placement policy

最後，檢查 sqlnet.ora

把sqlnet.ora裡面的

NAMES.DIRECTORY_PATH=(TNSNAMES)

改成

NAMES.DIRECTORY_PATH=(EZCONNECT)

恢復正常。

ORA-00119: invalid specification for system parameter REMOTE_LISTENER

相關文章