Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Local connection with Oracle 9i

RE: Local connection with Oracle 9i

From: Rabinowicz, Barbara <Barbara.Rabinowicz_at_sensis.com.au>
Date: Thu, 16 Jun 2005 09:58:03 +1000
Message-ID: <FC46652987C43548969685CA58AFA80D017BFD1C@C1-EXG-VS2.corp.org.local>

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:

  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

> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US