INBOUND_CONNECT_TIMEOUT parameter to terminate connection attempts that
cannot establish and authenticate connections within the specified interval. Set the server-side
SQLNET.INBOUND_CONNECT_TIMEOUT parameter to a higher value than the INBOUND_
CONNECT_TIMEOUT_listener_name parameter in the listener.ora file.
Debugging Connection Problems
Oracle Net connections require that a number of communication mechanisms be properly
configured. The connections involve host-to-host communication, proper identification of
services and databases, and proper configuration of the listener server processes. In the event
of connection problems when using Oracle Net, it is important to eliminate as many of these
components as possible.
Start by making sure that the host the connection is trying to reach is accessible via the
network. This can be checked via the ssh command:
ssh host_name
If this command is successful, you will be prompted for a username and password on the
remote host. If the ping command is available to you, you may use it instead. The following
command will check to see if the remote host is available and will return a status message:
ping host_name
If the host is available on the network, the next step is to check if the listener is running; you
can use the tnsping utility provided by Oracle to verify Oracle Net connectivity to a remote
database listener. The tnsping utility has two parameters??”the service name to connect to and
the number of connections to attempt.
Pages:
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811