Oracle 11g - Startup Error #ORA-00119#ORA-00130
I met the ORA-00119 error while I modified the hostname and restarted the node.
[oracle@dbvm01]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue Jan 5 10:35:12 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected.
SQL> startup nomount
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=dbvm01)(PORT=1521))'
SQL>
With the messages, maybe the local_listener is wrong?
so I check the spfile and found that the parameter is not set!!!
[oracle@dbvm01 dbs]$ strings spfileorcl11g.ora
orcl11g.__db_cache_size=306184192
orcl11g.__java_pool_size=4194304
orcl11g.__large_pool_size=8388608
orcl11g.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
orcl11g.__pga_aggregate_target=293601280
orcl11g.__sga_target=436207616
orcl11g.__shared_io_pool_size=0
orcl11g.__shared_pool_size=109051904
orcl11g.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/orcl11g/adump'
*.audit_trail='db'
*.compatible='11.2.0.4.0'
*.control_files='/u01/app/oracle/oradata/o
rcl11g/control01.ctl','/u01/app/oracle/fast_recovery_area/orcl11g/control02.ctl'
*.db_block_size=8192
*.db_domain='us.oracle.com'
*.db_name='orcl11g'
*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=4353687552
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orcl11gXDB)'
*.memory_target=729808896
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
[oracle@dbvm01 dbs]$
Backgroud is that I rename the hostname and reboot the node, I modified the /etc/sysconfig/network and /etc/hostname just like the following contents.
[oracle@dbvm01 ~]$ cat /etc/sysconfig/network
NETWORKING=yes
NOZEROCONF=yes
HOSTNAME=dbvm01 ----> add this new line.
[oracle@dbvm01 ~]$ cat /etc/hostname
dbvm01 ----> add this new line.
[oracle@dbvm01 ~]$
However I did NOT modified the /etc/hosts file…
[oracle@dbvm01 ~]$ cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
[oracle@dbvm01 ~]$
While I modified the /etc/hosts to the correct hostname, it can be startup now.
[oracle@dbvm01 ~]$ cat /etc/hosts
127.0.0.1 dbvm01 localhost.localdomain localhost4 localhost4.localdomain4
::1 dbvm01 localhost.localdomain localhost6 localhost6.localdomain6
[oracle@dbvm01 ~]$
So it is important that while you change the hostname, do NOT forget to modify the /etc/hosts file!
++++++++++++++++ EOF LinHong ++++++++++++++++