HP R4.2 - Manual (Page 279)

5
Database Administration Voice System Database Administration
UCS 1000 R4.2 Administration 585-313-507 Issue 3 April 2000 240
2 Start the listener process.
3 Provide 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
Environment
Variables If you are using PRO*C, you must set the environment variables
ORACLE_HOME and ORACLE_SID. Two methods are available:
• Shell wrapper approach
• putenv function call