This chapter helps you to configure and manage your network environment so that users can access your database.
This chapter discusses the following:
Move your mouse over this icon to show all screenshots.
You can also move your mouse over each individual icon to see only the screenshot
associated with it.
The Net Services Administration page can be used to manage Oracle Net services.
Follow the steps below to access the Net Services Administration page:
| 1. |
Log in to Enterprise Manager Database Console by opening your browser and specifying the SYS username and password. Click Login.
|
| 2. | Click the Listener link in
the General section of the Database Home page.
|
| 3. | The Listener Home page is displayed.
Scroll down to the bottom of the page.
|
| 4. | Click Net Services Administration
in the Related Links section.
|
| 5. | The Net Services Administration
page is displayed. This page provides a means of administering listeners,
directory naming, local naming, and specifying the file location.
|
In this section you learn how to start the listener using Enterprise Manager. Note: You will not be able to access Enterprise Manager Database Control in your browser if the listener is down. The steps listed in this section are only applicable if you have an Enterprise Manager Database Control window open. If you do not, refer to the next section for detailed information on starting the listener using the listener control utility.
Perform the steps listed below to start the listener using Enterprise Manager:
| 1. | Click the Listener link in
the General section of the Database Home page.
|
| 2. | The Listener Home page is displayed.
Click Start to start the listener.
|
| 3. | The Start/Stop: LISTENER page
is displayed. Click OK.
|
| 4. | The Processing: Start Listener
page is displayed. The Listener home page is displayed after the
listener is started.
|
In this section you learn how to start the listener using the listener control utility. These steps are applicable when you cannot access Enterprise Manager Database Control to start your listener.
Perform the steps listed below to start the listener using the listener control utility:
| 1. |
Log on to the operating system as the oracle user. Issue the following command to start the listener:
|
| 2. |
You can check the status of the listener by issuing the following command:
|
In this section you configure local naming to connect to another database. You can configure local naming using Net Manager on a client PC or using Enterprise Manager as described in the following sections:
|
Configuring Local Naming Using Net Manager | |
|
Configuring Local Naming Using Enterprise Manager | |
You must configure a client machine so it can connect to an
Oracle database. You must first install Oracle Database client software, which
includes Oracle Net software. Once you have installed Oracle Net, you can use
Oracle Net Manager to configure a net service name using the local naming method
as follows:
| 1. |
On Windows, start Oracle Net Manager by clicking: Start->Programs->Oracle->Configuration and Migration Tools->Net Manager On UNIX or Linux, invoke Oracle Net Manager by entering
netmgr at the command
line.
The Welcome page appears.
|
| 2. |
Expand Local and select Service Naming. Click the (plus) + on the left hand side of the page.
|
| 3. |
The Net Service Name wizard appears. Enter a net service name. Click Next.
|
| 4. |
Select the protocol to use to connect to your database. You can accept the default TCP/IP (Internet Protocol). The database listener must be configured to use the same network protocol. Click Next.
|
| 5. |
Enter the host name of the database machine. Click Next.
|
| 6. |
Enter the database service name. In addition, select a Connection Type, either Shared or Dedicated. If you are unsure or would like to use the default database connection type, select Database Default. Click Next.
|
| 7. |
The last page of the wizard enables you to test the
connection using the information you entered.
|
| 8. |
You can change the default login by clicking Change
login and entering a username and password. Click Test. The wizard
tells you if the connection test succeed or not. Click Close and
then click Finish.
|
| 9. |
The new service appears under the Service Naming
folder. You can view or modify the configuration for the highlighted service
under Service Identification and Address Configuration.
|
Perform the steps listed below to configure a net service
name using Enterprise Manager as follows:
| 1. | Click the Listener link in
the General section of the Database Home page.
|
| 2. | The Listener Home page is displayed.
Scroll down to the bottom of the page. Click Net Services Administration
in the Related Links section.
|
| 3. | The Net Services Administration
page is displayed. Select the appropriate Configuration File Location.
Select Local Naming from the Administer pull down menu. Click
Go.
|
| 4. | Enter your host username and password
and click Login.
|
| 5. | The Local Naming page is displayed.
Click the Create button or select an existing Net Service Name and
click Create Like.
|
| 6. |
The Create Net Service Name general page is displayed. Enter a name in the Net Service Name field. In the Database Information section, configure service support by entering a destination service and selecting a database connection type. If the destination service is an Oracle8i or later release database, then select Use Service Name, and enter a service name in the Service Name field. If the destination service is an Oracle release 8.0 database, then select Use SID, and enter an Oracle System Identifier for an instance in the SID field. Then scroll down to the bottom of the page. In the Addresses section, configure protocol support. Click Add. Note: If you are performing this task on
the same machine that you configured local naming using Net Manager, be
sure to enter a different name in the Net Service Name field.
|
| 7. | The Add Address page is displayed.
From the Protocol list, select the protocol upon which the listener
is configured to listen. Enter the Port and Host fields. These
must match the listening address. Click OK.
|
| 8. | The Create Net Service Name
page is displayed again. Click OK. A successful creation message
is displayed on the Local Naming page.
|
| 9. | Select the net service name you just
created. Click Test Connection.
|
| 10. | Enter the password for dbsnmp
and click Test.
|
| 11. | The Test Result page is displayed.
Click OK.
|
Move your mouse over this icon to hide all screenshots