I am getting an error in the connection log when I am trying to connect to RAC database server
BLABLA(devel): sqlplus user/password@MY_TNS_NAME
SQL*Plus: Release 11.2.0.2.0 Production on Fri Jan 11 14:11:21 2019
Copyright (c) 1982, 2010, Oracle. All rights reserved.
FATAL: OCI listening thread exited. Failed to get IP address of host.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics, Real Application Testing and Unified Auditing options
SQL>
BLABLA(devel): sqlplus user/password@MY_TNS_NAME
SQL*Plus: Release 11.2.0.2.0 Production on Fri Jan 11 14:11:21 2019
Copyright (c) 1982, 2010, Oracle. All rights reserved.
FATAL: OCI listening thread exited. Failed to get IP address of host.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics, Real Application Testing and Unified Auditing options
SQL>
As the name suggests sqlplus is not able to determine the IP address of local machine and showing this error.
It looks like it is a warning and can be fixed very easily by adding the hostname and the IP address in the /etc/hosts file.
Once it is done then I tried connecting and it is fixed.
BLABLA(devel): sqlplus user/password@MY_TNS_NAME
SQL*Plus: Release 11.2.0.2.0 Production on Fri Jan 11 14:13:19 2019
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics, Real Application Testing and Unified Auditing options
SQL>
No comments:
Post a Comment