1Z0-052 · Question #129
The tnsnames.ora file has an entry for the service alias ORCL as follows: ORCL = ( DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.24.216)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (S
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #129. The question stem and answer options stay visible for context.
Question
The tnsnames.ora file has an entry for the service alias ORCL as follows:
ORCL = ( DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.24.216)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.oracle.com) ) ) The TNSPING command executes successfully when tested with ORCL, but you are not able to connect to the database instance with the following command:
SQL> CONNECT scott/tiger@orcl What could be the reason for this?
Options
- AThe listener is not running on the database node.
- BThe TNS_ADMIN environmental variable is set to a wrong value.
- CThe orcl.oracle.com database service is not registered with the listener.
- DThe DEFAULT_DOMAIN parameter is set to a wrong value in the sqlnet.ora file.
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.