5 Database Administration

Voice System Database Administration

2Start the listener process.

3Provide the server’s network name and database instance name (ORACLE_SID) to each UCS 1000 R4.2 client system.

Accessing a Remote Database Using PRO*C or SQL*PLUS

The following are application development issues related to accessing a remote database using PRO*C or SQL*PLUS programs.

Setting the Connect Descriptor

If you are using PRO*C or SQL*PLUS with an IRAPI application, you must change or verify the correct form of the connect string. The database interface assigns the node name of the system with the remote database as the connect string. The connect string should be in the form “remote_system” with the name of the system contained in quotes. For example, if the remote system name is cop3, the connect string must be “cop3”.

Setting

If you are using PRO*C, you must set the environment variables

Environment

ORACLE_HOME and ORACLE_SID. Two methods are available:

Variables

Shell wrapper approach

 

 

putenv function call

UCS 1000 R4.2 Administration 585-313-507

Issue 3 April 2000 240