Zoran/Sinardy, thanks a lot guys for your answers.
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=0D
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.
-----Original Message-----
From: Martic Zoran [mailto:zoran_martic_at_yahoo.com]=0D
Sent: Wednesday, 15 June 2005 6:38 PM
To: Rabinowicz, Barbara; oracle-l_at_freelists.org
Subject: Re: Local connection with Oracle 9i
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,
>=0D
> 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?
>=0D
> Kind Regards,
>=0D
> Barbara Rabinowicz
> Senior SME
> DBA Team
> Directory Technology Pty Ltd
>=0D
>=0D
>=0D
> +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=0D
http://mail.yahoo.com=0D
www.about.sensis.com.au
A leading Australian advertising, information and directories business.
www.sensis.com.au
www.yellowpages.com.au
www.whitepages.com.au
www.citysearch.com.au
www.whereis.com.au
www.telstra.com.au
www.tradingpost.com.au
www.universalpublishers.com.au
This email and any attachments are intended only for the use of the=
recipient and may be confidential and/or legally privileged.
Sensis Pty Ltd disclaims liability for any errors, omissions, viruses, loss=
and/or damage arising from using, opening or transmitting this email.
If you are not the intended recipient you must not use, interfere with,=
disclose, copy or retain this email and you should notify the sender=
immediately by return email or by contacting Sensis Pty Ltd by telephone=
on [+61 3 8653 5000]
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 15 2005 - 20:03:27 CDT