HELP! - Unable to connect to remote Oracle database
Date: Mon, 19 Jul 2004 10:01:26 +0800
Message-ID: <cdfa1v$lsi2_at_imsp212.netvigator.com>
Hi,
[Quoted] 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 Mon Jul 19 2004 - 04:01:26 CEST