Hi,

I am unable to connect to Oracle database from another server using
Client/Server relationship.

(FYI...Program is written as Pro*C using Oracle 9.2.0.1.0 running on
UNIX HP-UX11)

In my Pro*C program, I am using syntax as follows:

EXEC SQL CONNECT :username IDENTIFIED BY assword AT :db_name USING
:db_string;

(Client Server: THS_1
Database Server: THSORACLE
Database Instance: DRLDBMS
TNSNAMES defined on Client Server: DRLDBMS_THSORACLE
)

I have 2 instances running on THS_ORACLE, but I made the
ORACLE_SID = DRLDBMS, ie. the instance I need to connect.

So for the above connection, I am using:

EXEC SQL CONNECT :username IDENTIFIED BY assword AT 'DRLDBMS' USING
'DRLDBMS_THSORACLE'

But it is still failed in connection.

Would you please advise on what I am missing?

Regards,
Ursula