ORA-00119,ORA-00132

SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'

1.查看参数

[oracle@primary dbs]$ strings spfileorcl.ora  | grep  LISTENER_ORCL
*.local_listener='LISTENER_ORCL'

2.根据spfile创建pfile

sql> create pfile from spfile;

3.修改pfile文件

*.local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = primary)(PORT = 1521))'

4.从pfile打开数据库

 SQL> startup pfile='/u01/app/oracle/product/10.2.0/db_1/dbs/initorcl.ora';

5.重新创建spfile

SQL>create spfile from pfile;

6.关闭数据库

SQL>shutdown immediate;

7.打开数据库

SQL>startup