Re: Local connection with Oracle 9i
- From: Martic Zoran <zoran_martic@xxxxxxxxx>
- To: Barbara.Rabinowicz@xxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 15 Jun 2005 01:38:15 -0700 (PDT)
The main rules for making the local connections that I
know:
1. 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.
2. 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@xxxxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
