Chapter 4: Configuring the Network Environment
Chapter 4: Configuring the Network Environment
This chapter helps you to configure and manage your network
environment so that users can access your database.
Approximately 1 hour
This tutorial covers the following topics:
Place the cursor over this icon to load and view all the screenshots for this tutorial.
(Caution: This action loads all screenshots simultaneously, so response time may be slow depending on your Internet connection.)
Note: Alternatively, you can place the cursor over
an individual icon in the following steps to load and view only the screenshot
associated with that step. You can hide an individual screenshot by clicking
it.
Before you perform this tutorial, you should:
Back to Topic List
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.
Click Net Services Administration in the Related Links section
at the bottom of the page.
|
| 4. |
The Net Services Administration
page is displayed. This page provides a means of administering listeners,
directory naming, local naming, and specifying the file location.
|
Back to Topic List
In this section you learn how to start and stop the listener
using the listener control utility. These steps are applicable when you cannot
access Enterprise Manager Database Control to start or stop your listener.
Perform the steps listed below to check the status of the
listener, to stop the listener, and to start the listener using the listener
control utility:
| 1. |
Log on to the operating system as the oracle
user. You can check the status of the listener by issuing the following
command, where listener
is the name of your listener:
lsnrctl status listener
|
| 2. |
If your listener is started, issue the following command
to stop the listener:
lsnrctl stop
listener
If your listener is already stopped, proceed to step
3.
|
| 3. |
Issue the following command to start the listener:
lsnrctl start listener
|
Back to Topic List
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:
Back to Topic List
Configuring Local
Naming Using Net 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 UNIX or Linux, invoke Oracle Net Manager by entering netmgr
at the command line.
The Welcome window appears.
|
| 2. |
Expand Local and select Service Naming.
Click the (plus) + on the left hand side of the page.
|
| 3. |
Click Edit > Create.
|
| 4. |
The Net Service Welcome window appears. Enter a net service name. Click
Next.
|
| 5. |
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.
|
| 6. |
Enter the host name of the database machine. Click Next.
|
| 7. |
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.
|
| 8. |
The last window of the wizard enables you to test the connection using
the information you entered. Click Test.
|
| 9. |
By default, the user named SCOTT is used
for the test. If this account is locked as shown in the example, you can
change the default login by clicking Change Login and entering a different
username and password. Click Change Login.
|
| 10. |
Enter a username and password to test the connection. You can use system
with the password of oracle. Click OK.
|
| 11. |
Click Test.
|
| 12. |
The wizard tells you if the connection test succeed or not. Click Close.
|
| 13. |
Click Finish.
|
| 14. |
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.
|
| 15. |
Save your changes and exit out of Oracle Net Manager window by clicking
File -> Save Network Configuration and then File -> Exit.
|
Back to Topic
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 list. Click Go.
|
| 4. |
Enter your host username and password, select
Save as Preferred Credential, 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, dbsnmp,
for the user dbsnmp. Click Test.
|
| 11. |
The Test Result page is displayed. Click OK.
|
Back to Topic
In this tutorial, you learned how to:
 |
Log into the Net Services Administration
application. |
|
Start and stop the listener using the lsnrctl
command. |
|
Configure a client machine to connect to
an Oracle database using Oracle Net Manager. |
|
Create a Local Naming entry using Enterprise
Manager. |
Back to Topic List
Place the cursor over this icon to hide all screenshots.
|
Bookmark
