iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Problem Solver

    .Home      .Subscribe     .Login      .Start Learning      .Certification      .Cancel      .Password Reminder      .Password Change     .Sign out

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       .Email2aFriend    |

 

Online Oracle Training for beginners and advanced - The most comprehensive Oracle tutorial

The authors do not guarantee or take any responsibility for the accuracy, or completeness of the information.

DBAs - Fundamentals II

 

Lesson 01 | Lesson 02 | Lesson 03 | Lesson 04 | Lesson 05 | Lesson 06 | Lesson 07 | Lesson 08 | Lesson 09 | Lesson 10 | Lesson 11 | Lesson 12 | Lesson 13 | Lesson 14 | Lesson 15 | Lesson 16 | Lesson 17 | Lesson 18 | Lesson 19 | Lesson 20 | Lesson 21 | Lesson 22 | Lesson 23 | Lesson 24 | Lesson 25 | Lesson 26 | Lesson 27 | Lesson 28 | Lesson 29 |

 

Lesson 27

"If you don't learn to laugh at troubles, you won't have anything to laugh at when you grow old." -Edward W. Howe

 

Configuring a Listener using the “Net Manager” tool

 

Introduction

As a DBA, you are responsible for configuring a listener using the “Net Manager” tool. Your job responsibilities dictate that you should at least be informed of the following basic fundamental subjects:

 

Adding a listener,

Modifying a listener,

Viewing a listener,

Configuring a listener

Enabling a listener’s "logging" file

Enabling a listener’s "tracing" file

Disabling a listener’s "logging" file

Disabling a listener’s "tracing" file

Adding a listener's "Location address"

 

Hands-on

Open Net Manager

Go to Start > Programs > Oracle Home > Configuration and Migration Tools >, and then select the Net Manager option.

You use the Net Manager Tool, to perform your network task.

In the Oracle Net Configuration section, expand the Local item. In the Local item, you can create, delete, or change a database default user profile, service naming, and listeners.

First, you should make sure that you create the database listener correctly. Without a listener, there is no way anybody can access to your database in the server.

 

Create a listener

Click on the ‘+’ sign next to the ‘Listeners’ item to expand it. You will see a default created listener. To create a new listener, highlight the ‘Listeners’ item and click on the green ‘+’ sign in the vertical toolbar in the Oracle Net Manager window. In the ‘Choose Listener Name’ window, type a new listener name such as ‘MYLISTENER’ and then click OK.

 

Add addresses to listener

Since the listener is new, there are no addresses associated with it. Click on the ‘Add Address’ button to establish a new address. In the Address1 table, change your network configuration; such as protocol type, server host name, and the port that the listener is using. Use the default port such as port 1521 or 1526.

Click on the Down Arrow next to Listening Location to give you a list of listener configuration option such as ‘General Parameters,’ ‘Listening Locations,’ ‘Database Services,’ and ‘Other Services.’

 

General Parameters tab

Click on the General Parameters tab to change the Startup Wait Time parameter per second. The default value is zero. Click on the ‘Logging & Tracing’ tab to enable or disable your logging. The default is enabled and the location of your log is:

%ORACLE_HOME<your listener name>. You can also, disable or enable the tracing. The default is disabled. Enabling this option may generate thousands of bytes of dump to trace the network traffic. The tracing can be on USER, ADMIN, etc.

 

Authentication tab

In the Authentication tab, you can assign a password so when you start or shutdown the listener then you enter your password.

 

Database Services

Click on the Database Service option, to show you which databases this listener give a service. A listener can give services to multiple database on a different port. Since this a new listener so there is no database assign it. Click on the ‘Add Database’ push button, to add the database information such as its Global Database Name, Oracle Home Directory, and its SID (System Identification). Type ‘SCHOOL’ in the Global Database Name box, ‘C:’ into the Oracle Home Directory box, and ‘SCHOOL’ in the SID box.

 

"To avoid criticism, do nothing, say nothing, and be nothing." -Elbert Hubbard

 

Questions:

Q: How do you add a listener using the Net Manager tool?

Q: How do you modify a listener using the Net Manager tool?

Q: How do you view all listeners in your server using the Net Manager tool?

Q: How do you enable or disable a listener’s logging or tracing using the Net Manager tool?