HELP! - Unable to connect to remote Oracle database

From: Ursula Lee <ursula.lee_at_thales-is.com>
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

Original text of this message