Multiple choice technology programming languages

ORA-12154 Means?

  1. TNS:name lookup failure"

  2. TNS:could not resolve service name"

  3. TNS:protocol adapter error"

  4. Package error raised with DBMS_SYS_ERROR.RAISE_SYSTEM_ERROR
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

ORA-12154 is 'TNS:could not resolve the service name' - Oracle's TNS listener cannot find the database service name specified in the connect string. This is a TNS (Transparent Network Substrate) naming/configuration error. Option A would be ORA-12154 (name lookup failure is essentially the same), Option C is ORA-12560 (protocol adapter error). The key issue is service name resolution in tnsnames.ora.

Keep practicing — related questions