Your tnsnames.ora file has the following entry for the service alias ORCL:
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 at the server.
B.
The orcl.oracle.com database service is not registered with the listener.
C.
The DEFAULT_DOMAIN parameter is set to a wrong value in the SQLNET.ORA file.
D.
The TNS_ADMIN environmental variable is set to a wrong value.
Correct answer is C.
The sqlnet.ora file enables you to:
•Specify the client domain to append to unqualified names
NAMES.DEFAULT_DOMAIN
Purpose
Use the parameter NAMES.DEFAULT_DOMAIN to set the domain from which the client most often looks up names resolution requests. When this parameter is set, the default domain name is automatically appended to any unqualified net service name or service name.
For example, if the default domain is set to us.acme.com, the connect string CONNECT scott/tiger@sales gets searched as sales.us.acme.com. If the connect string includes the domain extension, such as CONNECT scott/[email protected], the domain is not appended.