BigdataLyn's TECH Blog! 刀不磨要生锈,人不学习要落后 - Thinking ahead

Oracle 11g - Startup Error #ORA-00119#ORA-00130

2018-01-05

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 ++++++++++++++++


Similar Posts

Comments