| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Local connection with Oracle 9i
Hi Barbara,
I made the usual mistake, I didn't 'reply all' to your question.
Now I know what you're looking for, this might help:
In the listener.ora specify:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = PNPKEY))
(ADDRESS = (PROTOCOL = TCP)(HOST = dbalert199)(PORT = 1521))
)
This way, with an address list with two addresses, one for each protocol, your listener will listen internally for IPC and externally for the remote clients.
Now, in tnsnames create a similar address list:
dgs.dbalert.nl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = PNPKEY))
(ADDRESS = (PROTOCOL = TCP)(HOST = dbalert199)(PORT = 1521))
)
I tested it by making two connections, one through tcp (I commented out the first ADDRESS specification) and one through ipc.
My listener.ora showed:
16-JUN-2005 18:51:34 *
(CONNECT_DATA=(SID=dgs)(CID=(PROGRAM=)(HOST=dbalert199)(USER=oracle))) *
(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)) * establish * dgs * 0
16-JUN-2005 18:54:10 *
(CONNECT_DATA=(SID=dgs)(CID=(PROGRAM=)(HOST=dbalert199)(USER=oracle))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=dbalert199)(PORT=37769)) * establish * dgs
* 0
This way you can use the same tnsnames file for both your local and remote clients. The local clients will not use the network, but IPC instead.
HTH Best regards,
Carel-Jan Engel
===
If you think education is expensive, try ignorance. (Derek Bok)
===
On Thu, 2005-06-16 at 02:05, Rabinowicz, Barbara wrote:
> Carel-Jan, > > What you specified below is the exact behavior I am looking for. > > 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. > > > > -----Original Message----- > From: Carel-Jan Engel [mailto:cjpengel.dbalert_at_xs4all.nl] > Sent: Wednesday, 15 June 2005 8:52 PM > To: Rabinowicz, Barbara > Subject: Re: Local connection with Oracle 9i > > Just for clarification: > > Do you mean that you will use a 'universal' method for connecting to the > instance, always supplying a connect string alias (@db), and that this > should translate to a network connection when the instance lives on > another server, but translate to a local connection when it lives on the > same server as where the program is started? > > Regards, Carel-Jan > > === > If you think education is expensive, try ignorance. (Derek Bok) > === > > > > > 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. > > > > > > > > > > > > > > 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 > > 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 > > > > > > > > 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-lReceived on Thu Jun 16 2005 - 14:05:50 CDT
 |
 |