Re: Local connection with Oracle 9i

From: Martic Zoran <zoran_martic_at_yahoo.com>
Date: Wed, 15 Jun 2005 01:38:15 -0700 (PDT)
Message-ID: <20050615083815.75965.qmail@web52603.mail.yahoo.com>

The main rules for making the local connections that I know:

Your application environment variables need to be set the same as the environment of your running instance where are you connecting to ORACLE_HOME as the usage of binaries/libraries from that home (PATH) are the must. Of course do not forget ORACLE_SID variable pointing where to go. This automaticlally means both app and your database needs to be on the same server.
The application you are running and the Oracle instance should be bit compatible, so if the db is 64 bit the libraries used in your app should be 64-bit (or simple saying your app needs to be 64-bit) It your app is 32 bit you will need to have 32-bit Oracle instance/installation for the local connection.

With these two rules you do not need to supply the connect string, either connecting with Java, C or sqlplus.

Dependant on your OS the setup of the environment will be a little bit different, but not too much if not Windows of course.

Maybe I missed something.

Regards,
Zoran

"Rabinowicz, Barbara" <Barbara.Rabinowicz_at_sensis.com.au> wrote:

> Hi Guys,
>
> What would be the best way to define local
> connection on Oracle 9i? We
> used to use BEQ with Oracle 8i, is it used also with
> Oracle 9i?
>
> Kind Regards,
>
> Barbara Rabinowicz
> Senior SME
> DBA Team
> Directory Technology Pty Ltd
>
>
>
> +61 3 9835 0015 (Desk), +61 3 9835 0001 (Fax)
> AMDOCS > INTEGRATED CUSTOMER MANAGEMENT
> The information contained in this message is
> proprietary of Amdocs,
> protected from disclosure, and may be privileged.
> The information is
> intended to be conveyed only to the designated
> recipient(s) of the
> message. If the reader of this message is not the
> intended recipient,
> you are hereby notified that any dissemination, use,
> distribution or
> copying of this communication is strictly prohibited
> and may be
> unlawful. If you have received this communication in
> error, please
> notify us immediately by replying to the message and
> deleting it from
> your computer. Thank you.

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jun 15 2005 - 04:43:23 CDT