ORA-00119: invalid specification for system parameter LOCAL_LISTENER

1、问题描述

View Code

[oracle@DG3 admin]$ sqlplus sys/oracle as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Mar 28 16:12:08 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=DG3)(PORT=1521))'
SQL> 

 2、解决方法

根据spfile创建pfile

[oracle@DG3 dbs]$ sqlplus sys/oracle as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Mar 28 16:25:09 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> create pfile from spfile;

File created.

修改pfile文件

[oracle@DG3 dbs]$ vi initDB202.ora

DB202.__db_cache_size=134217728
DB202.__java_pool_size=4194304
DB202.__large_pool_size=4194304
DB202.__oracle_base='/u01'#ORACLE_BASE set from environment
DB202.__pga_aggregate_target=167772160
DB202.__sga_target=251658240
DB202.__shared_io_pool_size=0
DB202.__shared_pool_size=96468992
DB202.__streams_pool_size=0
*.audit_file_dest='/u01/admin/DB202/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/oradata/DB202/control01.ctl','/u01/flash_recovery_area/DB202/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='DB202'
*.db_recovery_file_dest='/u01/flash_recovery_area'
*.db_recovery_file_dest_size=4070572032
*.diagnostic_dest='/u01'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=DB202XDB)'
*.log_archive_format='%t_%s_%r.dbf'
*.memory_target=417333248
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
*.local_listener='(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.202)))'
~
~
~
~
~
~
~
~
"initDB202.ora" 27L, 966C written         

添加*.local_listener='(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.202)))'

注意:ip地址与自己实际ip地址一致

根据pfile创建spfile

SQL> create spfile from pfile;

File created.

启动数据库

[oracle@DG3 dbs]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Thu Mar 28 16:28:20 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area  417546240 bytes
Fixed Size                  2213936 bytes
Variable Size             272631760 bytes
Database Buffers          134217728 bytes
Redo Buffers                8482816 bytes
Database mounted.
Database opened.