错误分析
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>
本文转自健哥的数据花园博客园博客，原文链接：http://www.cnblogs.com/gaojian/p/3644524.html，如需转载请自行联系原作者
