|
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.
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? |
