You work as a database administrator for Certkiller .com. You decided to manage client and server connections using Local Naming method in Certkiller .com. When you try to connect to the database you get the following error:
ERROR:
ORA-12154: TNS:could not resolve service name
Which network configuration files would you look into to resolve this error? Choose two.
A.
snmp.ora
B.
names.ora
C.
spfile.ora
D.
sqlnet.ora
E.
listener.ora
F.
tnsnames.ora
Explanation:
Error: ORA-12154 / TNS-12154
Text: TNS:could not resolve service name
——————————–
Cause: The service name specified is not defined correctly in the TNSNAMES.ORA file. Action: Make the following checks and correct the error:
– Verify that a TNSNAMES.ORA file exists and is in the proper place and accessible. See the operating system specific manual for details on the required name and location.The SQL*Net layer cannot find a definition for the alias supplied Diagnosis:
1) Check the tnsnames.ora file you are using, verify that it is accessible.
5) Check the default domain name being used, and the path used to locate aliases, in the SQLNET.ORA file. The default domain is specified in the NAMES.DEFAULT_DOMAIN parameter – this is appended to the alias specified in the connect string if there is no domain given.
REF.: Metalink Note:21321.1 ORA 12154 “TNS: could not resolve service name”