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