ora-00119,ora-00130 Error Handling

Environment Description: Operating system version: Redhat 6.5

Database version: Oracle 12.1.0.2

The original hostname ora12c is the host name DG1

Original IP Address: 192.168.1.7 now IP address: 192.168.1.135

After you modify the hostname and IP address, start the database to report the following error

sql> startup Nomount;
ORA-00119:INVALID specification for system parameter Local_listener
Ora-00130:invalid Listener Address ' (address= (PROTOCOL=TCP) (host=ora12c) (port=1521)) '

Cause of Error:

1. Check the specific description of the error number:

 [[email protected] ~]$ oerr ora 119   00119 , 00000 ,  " INVALID specification for system parameter%s   //  *cause:the syntax for the specified parameter is incorrect.  //  *action:refer to the Oracle Reference Manual for the correct syntax.  

00130 00130 00000 " Invalid listener address '%s ' " // *cause:  The Listener address specification is not valid. // *action:make sure that all fields in the listener address //           (protocol, port, host, key, ...) are correct.

Depending on the individual description of the error message, you should know that the problem is in the system parameter configuration and listening address error.

2, because the hostname has changed, the listening configuration file must be modified

LISTENER. Ora file contents:

LISTENER =  = =    ora12c1521--the original hostname needs to be replaced with a new hostname: DG1       = (PROTOCOL = IPC) (KEY = EXTPROC1521))))         

Tnsnames.ora File Contents

LISTENER_SCP =  ora12c1521))  ==        ora12c 1521  --Need to replace the original hostname with a new hostname: DG1     = = dedicated)      = scp)   ))      

After the above adjustment, start the database again:

sql>1010827264  bytesfixed size            2931904  bytesvariable size           662700864 bytesdatabase buffers       339738624 Bytesredo buffers             5455872 bytes SQL> ALTER DATABASE mount;database altered. SQL> ALTER DATABASE open;database altered.

ora-00119,ora-00130 Error Handling