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.
