Oracle
1Z0-032 · Question #71
You receive the following error while connecting to an Oracle9i database instance: ORA-12523 TNS:listener could not find instance appropriate for the client connection Which action would be…
The correct answer is C. executing the lsnrctl services command to verify that the instances are registered with the listener. Oracle 1Z0-032 Exam
Provisioning and Connecting to a Database Deployment
Question
You receive the following error while connecting to an Oracle9i database instance:
ORA-12523 TNS:listener could not find instance appropriate for the client connection Which action would be appropriate in the context of investigating the cause of error?
Options
- Achecking the listener.ora file to verify that the protocol specified in ADDRESS is supported by
- Bchecking the sqlnet.ora file to verify that the NAMES.DIRECTORY_PATH = (TNSNAMES,HOSTNAME)
- Cexecuting the lsnrctl services command to verify that the instances are registered with the listener,
- Dchecking the tnsnames.ora file to verify that the net service name specified in your connect string
How the community answered
(28 responses)- A14% (4)
- B7% (2)
- C75% (21)
- D4% (1)
Explanation
Oracle 1Z0-032 Exam
Topics
#ORA-12523#TNS listener#lsnrctl services#instance registration
Community Discussion
No community discussion yet for this question.