Configuring the Oracle Network Environment

Posted on
Share on Google+Share on LinkedInShare on FacebookShare on RedditTweet about this on TwitterEmail this to someone

These questions are derived from the Self Test Software Practice Test for 1Z0-042 – Oracle Database 10g: Administration I.

 

Objective: Configuring the Oracle Network Environment
SubObjective: Use Database Control to create additional listeners

 

Item Number: 1Z0-042.11.1.3
Single Answer, Multiple Choice

 

You have configured a listener named LSNR1 using Database Control. The listener is listening for two of your databases, MASTERDB and EMPDB. You create a new database, SALESDB, and then modify the listener.ora file for LSNR1 to ensure that LSNR1 also listens for the SALESDB database. Finally, you issue the following command from the lsnrctl utility:

 

LSNRCTL> RELOAD LSNR1

 

What does this command do?

 

 

  1. The command resets the listener, LSNR1, to listen only for the SALESDB database.
  2. The command stops the listener, LSNR1, and starts it with the new settings defined in the listener.ora file.
  3. The command dynamically resets the listener, LSNR1, with the new settings and rules defined in the listener.ora file.
  4. The command starts the listener, LSNR1, with the new settings defined in the listener.ora file, and resets all the client connections.

 

Answer:
C. The command dynamically resets the listener, LSNR1, with the new settings and rules defined in the listener.ora file.

 

Tutorial:
The RELOAD LSNR1 command dynamically resets the listener, LSNR1, with the new settings and rules defined in the listener.ora file. The RELOAD command is a listener control utility command used to dynamically reset the listener with the new settings defined in the listener.ora file. Issuing this command will direct the listener control utility to reread the listener.ora file and apply the modified settings dynamically without modifying the current sessions.

 

Issuing the RELOAD LSNR1 command does not direct the listener to listen only for the SALESDB database. The listener will listen for all those databases whose information is present in the listener.ora file.

 

Issuing the RELOAD LSNR1 command to reset the listener with the new settings does not stop the listener. The new settings are applied dynamically.

 

Issuing the RELOAD LSNR1 command does not reset all the client connections. The settings are applied dynamically without modifying the current sessions.

 

Reference:
1. Oracle Database Net Services Reference 10g Release 2 (10.2)
Part Number B14213-01
Chapter: 2 Oracle Connection Manager Control Utility
Topic: Oracle Connection Manager Control Utility Commands – RELOAD

http://download-east.oracle.com/docs/cd/B19306_01/network.102/b14213/cmctl.htm#sthref167

Share on Google+Share on LinkedInShare on FacebookShare on RedditTweet about this on TwitterEmail this to someone
cmadmin

ABOUT THE AUTHOR

Posted in Archive|

Comment:

Leave a comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>