oracle startup 报ORA-00119错的解决方法

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'

1.sqlplus "/ as sysdba"

2.重建pfile文件

create pfile from spfile='/home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/spfileorcl.ora'

pfile文件在$ORACLE_HOME/dbs目录下，叫做init<sid>.ora

3.修改pfile文件

找到local_listener这一行，然后将其值修改为：

(ADDRESS_LIST=(Address=(Protocol=tcp) (Host=your_hostname)(Port=1521)))

修改之前可能是这样

*.local_listener='LISTENER_ORCL'

修改后的值大概就是这个样子了

*.local_listener='(ADDRESS_LIST=(Address=(Protocol=tcp) (Host=your_hostname)(Port=1521)))'

4.重建spfile文件

create spfile from pfile='/home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/initorcl.ora'

5.startup