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:
By default, these files install in the network administration directory of your Oracle Self-Service E-Billing database server:
- UNIX.
$ORACLE_HOME/network/admin
- Windows.
%ORACLE_HOME%\network\admin :
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
- 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
- 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 = EBILL)
(ORACLE_HOME = /opt/oracle/product/11.2.0.3)
))
- Save and close the listener.ora file.
- Change directory to the network administration directory of your Oracle Self-Service E-Billing database client, for example,
%ORACLE_HOME%\network\admin.
- 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 name EBILL, installed on the database server localhost. Your service name might be different:
EBILL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = EBILL)
)
)
- Save and close the tnsnames.ora file.
- 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.
- Stop and restart the Oracle listener with the following listener control commands.
lsnrctl stop
lsnrctl start
- After the Oracle listener is restarted, to see the service summary for the Oracle Self-Service E-Billing instance, run:
lsnrctl status
Services Summary...
EBILL 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, EBILL.
|