ORA-00119: invalid specification for system parameter LOCAL_LISTENER - 转

时间:2023-12-16 08:40:44

错误分析

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>