ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=ltitest.localdomain)(PORT=1521))'

 The contents are of my own testing and deployments. Not guaranteed that these might work in your environment. Please test before usage. 

Summary: In this session, I will teach you how to solve the below ora errors

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=ltitest.localdomain)(PORT=1521))'

Reason for this error You are changed to provide the wrong entry in the /etc/hosts.

Before:

SQL> startup

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=ltitest.localdomain)(PORT=1521))'

SQL>

[root@ltitest oracle]# cat /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.0.21    ramesh.localdomain

Please check the above bold letter I have changed the hostname instead of ltitest.localdomain

After I had changed It worked fine!

After:

[oracle@ltitest ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Sat Mar 18 23:51:49 2023

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

Connected to an idle instance.

SQL> startup;

ORACLE instance started.

Total System Global Area  713031680 bytes

Fixed Size                  2928488 bytes

Variable Size             574619800 bytes

Database Buffers          130023424 bytes

Redo Buffers                5459968 bytes

Database mounted.

Database opened.

[oracle@ltitest ~]$ cat /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.0.21    ltitest.localdomain

[oracle@ltitest ~]$

                                        Thanks for your time!!