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/[email protected] could be the reason for this?
Question:
What could be the reason for this?
Options:
The listener is not running on the database node.
The TNS_ADMIN environmental variable is set to a wrong value.
The orcl.oracle.com database service is not registered with the listener.
The DEFAULT_DOMAIN parameter is set to a wrong value in the sqlnet.ora file.
Correct Answer
The Correct Answer for this Question is
The orcl.oracle.com database service is not registered with the listener.
