ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unre

[oracle@dbra ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Jan 23 10:27:15 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER

ORA-00132: syntax error or unresolved network name 'LISTENER_SUNDAY'

[oracle@dbra ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Jan 23 10:37:18 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> create pfile from spfile;

File created.

[oracle@dbra dbs]$ ls -l
total 32
-rw-rw---- 1 oracle oinstall 1544 Jan 21 14:04 hc_drb.dat
-rw-rw---- 1 oracle oinstall 1544 Jan 23 10:34 hc_sunday.dat
-rw-r--r-- 1 oracle oinstall 2851 May 15  2009 init.ora
-rw-r--r-- 1 oracle oinstall 1002 Jan 23 10:38 initsunday.ora
-rw-r--r-- 1 oracle oinstall 1004 Jan 12 15:30 initsunday.ora.bak
-rw-r----- 1 oracle oinstall   24 Jan 21 13:46 lkSUNDAY
-rw-r----- 1 oracle oinstall 1536 Jan 21 14:24 orapwsunday
-rw-r----- 1 oracle oinstall 3584 Jan 22 08:59 spfilesunday.ora

[oracle@dbra dbs]$ vi initsunday.ora   

sunday.__db_cache_size=125829120
sunday.__java_pool_size=41943040
sunday.__large_pool_size=8388608
sunday.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
sunday.__pga_aggregate_target=176160768
sunday.__sga_target=331350016
sunday.__shared_io_pool_size=0
sunday.__shared_pool_size=146800640
sunday.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/sunday/adump'
*.audit_trail='db'
*.compatible='11.2.0.4.0'
*.control_files='/u01/app/oracle/oradata/sunday/control01.ctl','/u01/app/oracle/fast_recovery_area/sunday/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='sunday'
*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=4385144832
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=sundayXDB)'
*.local_listener='LISTENER_SUNDAY'
*.log_archive_format='%t_%s_%r.dbf'
*.memory_target=507510784
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
~
~

找到*.local_listener='LISTENER_SUNDAY'

然后将其值修改为：

(ADDRESS_LIST=(Address=(Protocol=tcp) (Host=your_hostname)(Port=1521)))

[oracle@dbra ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Jan 23 10:43:09 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> create spfile from pfile;

File created.

[oracle@dbra dbs]$ ls -l
total 36
-rw-rw---- 1 oracle oinstall 1544 Jan 21 14:04 hc_drb.dat
-rw-rw---- 1 oracle oinstall 1544 Jan 23 10:34 hc_sunday.dat
-rw-r--r-- 1 oracle oinstall 2851 May 15  2009 init.ora
-rw-r--r-- 1 oracle oinstall 1049 Jan 23 10:42 initsunday.ora
-rw-r--r-- 1 oracle oinstall 1004 Jan 12 15:30 initsunday.ora.bak
-rw-r----- 1 oracle oinstall   24 Jan 21 13:46 lkSUNDAY
-rw-r----- 1 oracle oinstall 1536 Jan 21 14:24 orapwsunday
-rw-r----- 1 oracle oinstall 3584 Jan 23 10:44 spfilesunday.ora
-rw-r----- 1 oracle oinstall 3584 Jan 23 10:43 spfilesunday.ora.bak

SQL> startup
ORACLE instance started.

Total System Global Area  505233408 bytes
Fixed Size                  2254664 bytes
Variable Size             348129464 bytes
Database Buffers          150994944 bytes
Redo Buffers                3854336 bytes
Database mounted.

Database opened.