在啟動資料庫時出現下列錯誤
[oracle@edbjr2p1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon May 5 21:56:00 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SYS@PROD>startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LSNR2'
解決辦法
[oracle@edbjr2p1 ~]$ cd $ORACLE_HOME/dbs
[oracle@edbjr2p1 dbs]$ ls
hc_orcl1.dat hc_PROD.dat initPROD.ora ora_control1 orapworcl snapcf_PROD.f
hc_orcl.dat init.ora lkPROD ora_control2 orapwPROD
[oracle@edbjr2p1 dbs]$ vim initPROD.ora
找到這行，删除
*.local_listener='LSNR2‘
啟動Oracle資料庫
ORACLE instance started.
Total System Global Area 835104768 bytes
Fixed Size 2257840 bytes
Variable Size 528485456 bytes
Database Buffers 301989888 bytes
Redo Buffers 2371584 bytes
Database mounted.
Database opened.