HELP!- Question and Problem in connecting to remote Oracle database using PRO*C

Home -> Community -> Usenet -> c.d.o.server -> HELP!- Question and Problem in connecting to remote Oracle database using PRO*C

From: Ursula Lee <ursula.lee_at_thales-is.com>
Date: Mon, 19 Jul 2004 10:29:28 +0800
Message-ID: <cdfblf$ls82@imsp212.netvigator.com>

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