You work as a database administrator for TCS .com. You decided to manage client and server connections using Local Naming method in TCS .com. When you try to connect to the database you get the following error: ERROR: ORA-12154:TNS:couldnot resolve service name Which network configuration files would you look into to resolve this error?
-
snmp.ora
-
names.ora
-
spfile.ora
-
sqlnet.ora
-
listener.ora
-
tnsnames.ora
D,F
Correct answer
Explanation
The ORA-12154 error indicates TNS cannot resolve the service name, which is a Local Naming configuration issue. The two key files to check are sqlnet.ora (which configures Oracle Net services) and tnsnames.ora (which contains service name aliases). snmp.ora is for SNMP monitoring, names.ora is for Oracle Names, spfile.ora is the server parameter file, and listener.ora configures the listener - none of these directly cause TNS resolution errors.