What could be the reason for this?

The tnsnames.ora file has an entry for the service alias ORCL as follows:
ORCL =
( DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.24.216)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.oracle.com)
)
)
The TNSPING command executes successfully when tested with ORCL, but you are not able to
connect to the database instance with the following command:
SQL> CONNECT scott/tiger@orcl
What could be the reason for this?

The tnsnames.ora file has an entry for the service alias ORCL as follows:
ORCL =
( DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.24.216)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.oracle.com)
)
)
The TNSPING command executes successfully when tested with ORCL, but you are not able to
connect to the database instance with the following command:
SQL> CONNECT scott/tiger@orcl
What could be the reason for this?

A.
The listener is not running on the database node.

B.
The TNS_ADMIN environmental variable is set to a wrong value.

C.
The orcl.oracle.com database service is not registered with the listener.

D.
The DEFAULT_DOMAIN parameter is set to a wrong value in the sqlnet.ora file.

Show Hint

Leave a Reply 1

Your email address will not be published. Required fields are marked *

noëlle

noëlle

TNSPING is a utility in the ORACLE HOME/bin directory used to test if a SQL*Net connect string can connect to a remote listener (check if the socket is reachable).
Note: This utility only tests if the listener is available. It cannot tell if the databases behind the listener is up or not.

Reply