Installation Guide for Oracle Self-Service E-Billing > Configuring the Oracle Database >

Configuring Oracle Services

You must edit the following Oracle configuration files that control access to the Oracle Self-Service E-Billing production database:

• listener.ora. Includes a list of service names and address of all listeners on a computer, the instance names of the databases for which they listen, and listener control parameters. The address for a server in the listener.ora file requires the SID (SID_NAME) of a database server in the tnsnames.ora file.

  You modify the listener.ora file on the database servers.

• tnsnames.ora. Includes a list of service names of network databases that are mapped to connect descriptors. Clients and distributed database servers use this file to identify potential server destinations. The address of a given database server in the tnsnames.ora file matches the address of a listener for that server in the listener.ora file.

  You modify the tnsnames.ora file on the database clients.

By default, these files install in the network administration directory of your Oracle Self-Service E-Billing database server $ORACLE_HOME/network/admin (%ORACLE_HOME%\network\admin on Windows).

Consult with your onsite DBA to configure database connectivity, to make sure you comply with client standards for the enterprise.

For help with database connectivity, create a service request (SR) on My Oracle Support. Alternatively, you can phone Oracle Global Customer Support directly to create a service request or get a status update on your current SR. Support phone numbers are listed on My Oracle Support.

This task is a step in Roadmap for Configuring the Oracle Self-Service E-Billing Database.

To configure Oracle services

1. Change the directory to the network administration directory of your Oracle Self-Service E-Billing database server, for example:
   • UNIX. $ORACLE_HOME/network/admin
   • Windows. %ORACLE_HOME%\network\admin
2. Open the listener.ora file, and edit the SID_LIST_LISTENER section to reflect your Oracle SID and Oracle Self-Service E-Billing database home directory, for example:

   SID_LIST_LISTENER=

   (SID_LIST=

   (SID_DESC =

   (SID_NAME = OLTP)

   (ORACLE_HOME = /opt/oracle/product/11.2.0.1)

   )

   (SID_DESC =

   (SID_NAME = OLAP)

   (ORACLE_HOME = /opt/oracle/product/11.2.0.1)

   ))

3. Save and close the listener.ora file.
4. Change directory to the network administration directory of your Oracle Self-Service E-Billing database client, for example, %ORACLE_HOME%\network\admin.
5. Open the tnsnames.ora file, and edit the database service that identifies your protocol, host, and port.

   The following text is an example of a tnsnames.ora file that uses the service names OLTP and OLAP, installed on the database server localhost. Your service names might be different:

   OLTP =

   (DESCRIPTION =

   (ADDRESS_LIST =

   (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

   )

   (CONNECT_DATA =

   (SERVICE_NAME = OLTP)

   )

   )

   OLAP =

   (DESCRIPTION =

   (ADDRESS_LIST =

   (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

   )

   (CONNECT_DATA =

   (SERVICE_NAME = OLAP)

   )

   )

6. Save and close the tnsnames.ora file.
7. Repeat Step 5 for the tnsnames.ora file on your application server.

   This file installs with your database client software. Single computer environments can skip this step.

8. Stop and restart the Oracle listener with the following listener control commands.

   > lsnrctl stop

   > lsnrctl start

9. After the Oracle listener is restarted, to see the service summary for the Oracle Self-Service E-Billing instance, run:

   > lsnrctl status

   Services Summary...

   OLAP has 1 service handler(s)

   OLTP has 1 service handler(s)

This service handler must match the name you entered for the Oracle SID during Oracle Self-Service E-Billing database configuration, in this example, OLTP and OLAP.