错误分析
listener 可以正常启动:
[oracle@o_target admin]$ cat listener.ora
# listener.ora Network
Configuration File:
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
#
Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION
=
(ADDRESS = (PROTOCOL = TCP)(HOST =
127.0.0.1)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /u01/app/oracle
[oracle@o_target admin]$
*********************************
数据库无法启动
[oracle@o_target ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0
Production on Fri Apr 4 09:18:56 2014
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=o_target.loc)(PORT=1521))‘
SQL> show
parameter local_listener;
ORA-01034: ORACLE not available
Process ID:
0
Session ID: 0 Serial number: 0
SQL> startup
nomount;
ORA-00119: invalid specification for system parameter
LOCAL_LISTENER
ORA-00130: invalid listener address
‘(ADDRESS=(PROTOCOL=TCP)(HOST=o_target.loc)(PORT=1521))‘
SQL>
SQL>
startup force;
ORA-00119: invalid specification for system parameter
LOCAL_LISTENER
ORA-00130: invalid listener address
‘(ADDRESS=(PROTOCOL=TCP)(HOST=o_target.loc)(PORT=1521))‘
SQL>
*********************************
参考:http://www.cnblogs.com/dba001/archive/2011/10/22/2221267.html
[oracle@o_target dbs]$
pwd
/u01/app/oracle/product/11.2.0/dbhome_1/dbs
[oracle@o_target dbs]$
tail
initorcl.ora
*.db_recovery_file_dest=‘‘
*.diagnostic_dest=‘/u01/app/oracle‘
*.dispatchers=‘(PROTOCOL=TCP)
(SERVICE=orclXDB)‘
*.log_archive_dest=‘/u01/app/oracle/arch‘
*.memory_target=1024458752
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile=‘EXCLUSIVE‘
*.undo_tablespace=‘UNDOTBS1‘
*.local_listener=‘(ADDRESS_LIST=
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT =
1521)))‘
[oracle@o_target dbs]$
再次启动试验:
SQL> startup pfile=‘$ORACLE_HOME/dbs/init$ORACLE_SID.ora‘;
ORACLE
instance started.
Total System Global Area 1023004672 bytes
Fixed
Size
2219752 bytes
Variable
Size
633340184 bytes
Database
Buffers 381681664
bytes
Redo
Buffers
5763072 bytes
Database mounted.
Database opened.
SQL>
SQL> create spfile from pfile;
File created.
SQL>
*********************************
SQL> shutdown immediate;
Database closed.
Database
dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 1023004672
bytes
Fixed
Size
2219752 bytes
Variable
Size
633340184 bytes
Database
Buffers 381681664
bytes
Redo
Buffers
5763072 bytes
Database mounted.
Database opened.
SQL>
ORA-00119: invalid specification for system parameter LOCAL_LISTENER,布布扣,bubuko.com
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
原文:http://www.cnblogs.com/gaojian/p/3644524.html