Multiple choice

While attempting to connect to a remote server, the following error appeared: ORA-12533: TNS:illegal ADDRESS parameters To attempt to resolve the error, the tnsnames.ora file was examined. What should be verified in this file?

  1. That the correct service name exists in the tnsnames.ora file

  2. That the service name of the database was entered correctly in the connect string

  3. That the connect descriptor's' protocol-specific parameters located in the ADDRESS section are correct

  4. That the service name of the database was entered correctly in the connect string
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

ORA-12533 indicates illegal ADDRESS parameters in the TNS connect string, meaning the protocol-specific settings (HOST, PORT, PROTOCOL) in the ADDRESS section are incorrect. The service name options (B, D) would produce different errors like ORA-12154 (TNS:could not resolve the connect identifier), while option A is too general.

Keep practicing — related questions