Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> HELP!- Question and Problem in connecting to remote Oracle database using PRO*C
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 :password 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 :password AT 'DRLDBMS' USING 'DRLDBMS_THSORACLE' But it is still failed in connection.
Would you please advise on what I am missing?
Regards,
Ursula
Received on Sun Jul 18 2004 - 21:29:28 CDT