Oracle
1Z0-032 · Question #8
You receive the following error while connecting to an Oracle9i database instance: ORA-12520 TNS:listener could not find available handler for requested type of server Which action should you take…
The correct answer is D. executing the lsnrctl services command to verify that the instances are registered with the listener and. See the full explanation below for the reasoning.
Question
You receive the following error while connecting to an Oracle9i database instance:
ORA-12520 TNS:listener could not find available handler for requested type of server Which action should you take first to investigate the problem?
Options
- Achecking the listener.ora file to verify that the protocol specified in ADDRESS is supported by the
- Bchecking the sqlnet.ora file to verify that the NAMES.DIRECTORY_PATH = (TNSNAMES,HOSTNAME)
- Cchecking the tnsnames.ora file to verify that the net service name specified in your connect string is
- Dexecuting the lsnrctl services command to verify that the instances are registered with the listener and
How the community answered
(35 responses)- A6% (2)
- B3% (1)
- C14% (5)
- D77% (27)
Community Discussion
No community discussion yet for this question.