The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNSPING command executes successfully when tested with ORCL; however, from the same OS user session, 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 Or 1 (23.03 KiB) Viewed 107 times
A. The listener is not running on the database node.
B. The TNS_ADMIN environment variable is set to the wrong value.
C. The orcl.oracle.com database service is not registered with the listener.
D. The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file. E. The listener is running on a different port.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!