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

The ORA-12533 error specifically indicates illegal ADDRESS parameters in the TNS connect descriptor. You need to verify the protocol-specific parameters (PORT, HOST, etc.) in the ADDRESS section of tnsnames.ora. The service name (B, D) is irrelevant to this specific error.

Keep practicing — related questions