Creating an Oracle Net Listener in Oracle 10g
After completing this topic, you should be able to create and configure an Oracle Net Listener.
In this exercise, you're required to create and configure an Oracle Net Listener in Oracle Database 10 g.
This involves the following tasks:
- creating a backup listener
- configuring static database registration
Because your system hosts many users, all of whom use different methods to connect to your database, you need to have a backup listener in place.
Task 1: Creating a backup listener
Database administrators should create a backup listener in case the default fails.
Starting from the Related Links section of the page for your default listener, create a listener called BACKUP that connects to the localhost.localdomain host and uses port 1561.
|1. Select the Net Services Administration link|
|2. Ensure that Listeners is selected in the Administer drop-down list and click Go|
| 3. Click Login|
|4. Click Create|
| 5. Type |
|6. In the Addresses section, click Add|
| 7. In the Port field, type |
| 8. In the Host field, type |
|9. Click OK|
|10. Click OK|
Task 2: Configuring static registration
You now want to modify the BACKUP listener to assign a service name that the listener will serve.
Starting from the General tabbed page of the Edit Listener page for the BACKUP listener, configure static registration for the
orcl.oracle.com. service. This service is situated in the
/oracle/product/10.1.0/db_1 directory and its SID is
|1. Select the Static Database Registration tab|
|2. Click the Add button|
| 3. In the Service Name field, type |
| 4. In the Oracle Home Directory field, type |
| 5. In the Oracle System Identifier (SID) field, type |
|6. Click OK|
|7. Click OK|
A backup listener has now been created and you have configured static registration to register the database with the listener.