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.

 

转载于:https://www.cnblogs.com/arcer/archive/2013/03/28/2987048.html