tnsnames.ora in clients
Hello All, Good morning! I would like to know how the 'tnsnames.ora' file on all client(windows) machines can be updated automatically whenever something changed on central 'tnsnames.ora' file. Is this the process still being used extensively or else advanced features like ONS. Your suggestions are highly appreciated. Thanks, Suren Consultant DBA Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: tnsnames.ora in clients
You can write a script and each time when a user logs into a domain it will check and copy the latest tnsnames.ora file. Or you can just place the tnsnames.ora file on the network drive and point everyone to it. >>> [EMAIL PROTECTED] 07/23/01 10:55AM >>> Hello All, Good morning! I would like to know how the 'tnsnames.ora' file on all client(windows) machines can be updated automatically whenever something changed on central 'tnsnames.ora' file. Is this the process still being used extensively or else advanced features like ONS. Your suggestions are highly appreciated. Thanks, Suren Consultant DBA Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: tnsnames.ora in clients
One method I have seen used a lot is to set the TNS_ADMIN variable to point to the centralized file. Another is to have the LAN guys add a check to their login script to check to see if the TNSNAMES.ORA has been updated and if it has, have it pushed down when the user logs into the LAN. > -Original Message- > From: Tirumala, Surendra [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 23, 2001 10:56 AM > To: Multiple recipients of list ORACLE-L > Subject: tnsnames.ora in clients > > > Hello All, > > Good morning! > I would like to know how the 'tnsnames.ora' file on all > client(windows) > machines can be updated automatically whenever something changed on > central 'tnsnames.ora' file. > Is this the process still being used extensively or else > advanced features > like ONS. > > Your suggestions are highly appreciated. > > Thanks, > > Suren > Consultant DBA > Sony > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Tirumala, Surendra > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: tnsnames.ora in clients
We switched to ONS 3 years ago & have never regretted it. Getting rid of the tnsnames.ora file was the berries. Dick Goulet Reply Separator Author: "Page; Bruce" <[EMAIL PROTECTED]> Date: 7/23/2001 7:52 AM One method I have seen used a lot is to set the TNS_ADMIN variable to point to the centralized file. Another is to have the LAN guys add a check to their login script to check to see if the TNSNAMES.ORA has been updated and if it has, have it pushed down when the user logs into the LAN. > -Original Message- > From: Tirumala, Surendra [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 23, 2001 10:56 AM > To: Multiple recipients of list ORACLE-L > Subject: tnsnames.ora in clients > > > Hello All, > > Good morning! > I would like to know how the 'tnsnames.ora' file on all > client(windows) > machines can be updated automatically whenever something changed on > central 'tnsnames.ora' file. > Is this the process still being used extensively or else > advanced features > like ONS. > > Your suggestions are highly appreciated. > > Thanks, > > Suren > Consultant DBA > Sony > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Tirumala, Surendra > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: tnsnames.ora in clients
except that ONS is going away in favor of ldap. joe >>> [EMAIL PROTECTED] 07/23/01 12:58PM >>>We switched to ONS 3 years ago & have never regretted it. Getting rid of thetnsnames.ora file was the berries.Dick GouletReply SeparatorAuthor: "Page; Bruce" <[EMAIL PROTECTED]>Date: 7/23/2001 7:52 AMOne method I have seen used a lot is to set the TNS_ADMIN variable to point tothe centralized file.Another is to have the LAN guys add a check to their login script to check tosee if the TNSNAMES.ORA has been updated and if it has, have it pushed down whenthe user logs into the LAN.> -Original Message-> From: Tirumala, Surendra [mailto:[EMAIL PROTECTED]]> Sent: Monday, July 23, 2001 10:56 AM> To: Multiple recipients of list ORACLE-L> Subject: tnsnames.ora in clients> > > Hello All,> > Good morning!> I would like to know how the 'tnsnames.ora' file on all > client(windows)> machines can be updated automatically whenever something changed on> central 'tnsnames.ora' file.> Is this the process still being used extensively or else > advanced features> like ONS.> > Your suggestions are highly appreciated.> > Thanks,> > Suren> Consultant DBA> Sony> -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com> -- > Author: Tirumala, Surendra> INET: [EMAIL PROTECTED]> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051> San Diego, California -- Public Internet access / Mailing Lists> > To REMOVE yourself from this mailing list, send an E-Mail message> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in> the message BODY, include a line containing: UNSUB ORACLE-L> (or the name of mailing list you want to be removed from). You may> also send the HELP command for other information (like subscribing).> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Page, Bruce INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: tnsnames.ora in clients
Does this method of "sharing" the tnsnames work for you? What operating system are you using? I use Novell and when I tried this method of sharing the tnsnames it wouls not work. We had to resolve to downloading the latest copy to the users when they logged in. ROR mª¿ªm >>> [EMAIL PROTECTED] 07/23/01 11:41AM >>> You can write a script and each time when a user logs into a domain it will check and copy the latest tnsnames.ora file. Or you can just place the tnsnames.ora file on the network drive and point everyone to it. >>> [EMAIL PROTECTED] 07/23/01 10:55AM >>> Hello All, Good morning! I would like to know how the 'tnsnames.ora' file on all client(windows) machines can be updated automatically whenever something changed on central 'tnsnames.ora' file. Is this the process still being used extensively or else advanced features like ONS. Your suggestions are highly appreciated. Thanks, Suren Consultant DBA Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: tnsnames.ora in clients
We use a shared tnsnames.ora from a NT server. > -Original Message- > From: Ron Rogers [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 23, 2001 2:33 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: tnsnames.ora in clients > > > Does this method of "sharing" the tnsnames work for you? What > operating system are you using? I use Novell and when I tried > this method of sharing the tnsnames it wouls not work. We had > to resolve to downloading the latest copy to the users when > they logged in. > ROR mª¿ªm > > >>> [EMAIL PROTECTED] 07/23/01 11:41AM >>> > You can write a script and each time when a user logs into a domain > it will check and copy the latest tnsnames.ora file. Or you can just > place the tnsnames.ora file on the network drive and point everyone > to it. > > >>> [EMAIL PROTECTED] 07/23/01 10:55AM >>> > Hello All, > > Good morning! > I would like to know how the 'tnsnames.ora' file on all > client(windows) > machines can be updated automatically whenever something changed on > central 'tnsnames.ora' file. > Is this the process still being used extensively or else > advanced features > like ONS. > > Your suggestions are highly appreciated. > > Thanks, > > Suren > Consultant DBA > Sony > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Tirumala, Surendra > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Richard Ji > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ron Rogers > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: tnsnames.ora in clients
Thanks to who responded and responding. Suren -Original Message- Sent: Monday, July 23, 2001 2:13 PM To: Multiple recipients of list ORACLE-L except that ONS is going away in favor of ldap. joe >>> [EMAIL PROTECTED] 07/23/01 12:58PM >>> We switched to ONS 3 years ago & have never regretted it. Getting rid of the tnsnames.ora file was the berries. Dick Goulet Reply Separator Author: "Page; Bruce" <[EMAIL PROTECTED]> Date: 7/23/2001 7:52 AM One method I have seen used a lot is to set the TNS_ADMIN variable to point to the centralized file. Another is to have the LAN guys add a check to their login script to check to see if the TNSNAMES.ORA has been updated and if it has, have it pushed down when the user logs into the LAN. > -Original Message- > From: Tirumala, Surendra [ mailto:[EMAIL PROTECTED]] <mailto:[EMAIL PROTECTED]]> > Sent: Monday, July 23, 2001 10:56 AM > To: Multiple recipients of list ORACLE-L > Subject: tnsnames.ora in clients > > > Hello All, > > Good morning! > I would like to know how the 'tnsnames.ora' file on all > client(windows) > machines can be updated automatically whenever something changed on > central 'tnsnames.ora' file. > Is this the process still being used extensively or else > advanced features > like ONS. > > Your suggestions are highly appreciated. > > Thanks, > > Suren > Consultant DBA > Sony > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com <http://www.orafaq.com> > -- > Author: Tirumala, Surendra > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com <http://www.orafaq.com> -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com <http://www.orafaq.com> -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]:RE: tnsnames.ora in clients
ahhh no, oracle has already claimed desupport for ONS, whereas they've not for pl/sql. joe >>> <[EMAIL PROTECTED]> 07/23/01 01:04PM >>>Yeah, at the same rate that SQLJ is replacing PL/SQL!Dick GouletReply SeparatorSubject: Re:RE: tnsnames.ora in clientsAuthor: "JOE TESTA" <[EMAIL PROTECTED]>Date: 7/23/2001 1:00 PMexcept that ONS is going away in favor of ldap.joe>>> [EMAIL PROTECTED] 07/23/01 12:58PM >>>We switched to ONS 3 years ago & have never regretted it. Getting rid of thetnsnames.ora file was the berries.Dick GouletReply SeparatorAuthor: "Page; Bruce" <[EMAIL PROTECTED]>Date: 7/23/2001 7:52 AMOne method I have seen used a lot is to set the TNS_ADMIN variable to point tothe centralized file.Another is to have the LAN guys add a check to their login script to check tosee if the TNSNAMES.ORA has been updated and if it has, have it pushed down whenthe user logs into the LAN.> -Original Message-> From: Tirumala, Surendra [mailto:[EMAIL PROTECTED]]> Sent: Monday, July 23, 2001 10:56 AM> To: Multiple recipients of list ORACLE-L> Subject: tnsnames.ora in clients> > > Hello All,> > Good morning!> I would like to know how the 'tnsnames.ora' file on all > client(windows)> machines can be updated automatically whenever something changed on> central 'tnsnames.ora' file.> Is this the process still being used extensively or else > advanced features> like ONS.> > Your suggestions are highly appreciated.> > Thanks,> > Suren> Consultant DBA> Sony> -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com> -- > Author: Tirumala, Surendra> INET: [EMAIL PROTECTED]> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051> San Diego, California -- Public Internet access / Mailing Lists> > To REMOVE yourself from this mailing list, send an E-Mail message> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in> the message BODY, include a line containing: UNSUB ORACLE-L> (or the name of mailing list you want to be removed from). You may> also send the HELP command for other information (like subscribing).> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Page, Bruce INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).except that ONS is going away in favor of ldap. joe >>> [EMAIL PROTECTED] 07/23/01 12:58PM >>>We switched to ONS 3 years ago & have never regretted it. Getting rid of thetnsnames.ora file was the berries.Dick GouletReply SeparatorAuthor:"Page; Bruce" <[EMAIL PROTECTED]>Date: 7/23/2001 7:52 AMOne method I have seen used a lot is to set the TNS_ADMIN variable to point tothe centralized file.Another is to have the LAN guys add a check to their login script to check tosee if the TNSNAMES.ORA has been updated and if it has, have it pushed down whenthe user logs into the LAN.> -Original Message-> From: Tirumala, Surendra [href="mailto:[EMAIL PROTECTED]]">mailto:[EMAIL PROTECTED]m]> Sent: Monday, July 23, 2001 10:56 AM> To: Multiple recipients of list ORACLE-L> Subject: tnsnames.ora in clients> > > Hello All,> > Good morning!> I would like to know how the 'tnsnames.ora' file on all > client(windows)> machines can be updated automatically whenever something changed on> central
Re[2]:RE: tnsnames.ora in clients
Yeah, at the same rate that SQLJ is replacing PL/SQL! Dick Goulet Reply Separator Author: "JOE TESTA" <[EMAIL PROTECTED]> Date: 7/23/2001 1:00 PM except that ONS is going away in favor of ldap. joe >>> [EMAIL PROTECTED] 07/23/01 12:58PM >>> We switched to ONS 3 years ago & have never regretted it. Getting rid of the tnsnames.ora file was the berries. Dick Goulet Reply Separator Author: "Page; Bruce" <[EMAIL PROTECTED]> Date: 7/23/2001 7:52 AM One method I have seen used a lot is to set the TNS_ADMIN variable to point to the centralized file. Another is to have the LAN guys add a check to their login script to check to see if the TNSNAMES.ORA has been updated and if it has, have it pushed down when the user logs into the LAN. > -Original Message- > From: Tirumala, Surendra [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 23, 2001 10:56 AM > To: Multiple recipients of list ORACLE-L > Subject: tnsnames.ora in clients > > > Hello All, > > Good morning! > I would like to know how the 'tnsnames.ora' file on all > client(windows) > machines can be updated automatically whenever something changed on > central 'tnsnames.ora' file. > Is this the process still being used extensively or else > advanced features > like ONS. > > Your suggestions are highly appreciated. > > Thanks, > > Suren > Consultant DBA > Sony > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Tirumala, Surendra > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). except that ONS is going away in favor of ldap. joe >>> [EMAIL PROTECTED] 07/23/01 12:58PM >>>We switched to ONS 3 years ago & have never regretted it. Getting rid of thetnsnames.ora file was the berries.Dick GouletReply SeparatorAuthor: "Page; Bruce" <[EMAIL PROTECTED]>Date: 7/23/2001 7:52 AMOne method I have seen used a lot is to set the TNS_ADMIN variable to point tothe centralized file.Another is to have the LAN guys add a check to their login script to check tosee if the TNSNAMES.ORA has been updated and if it has, have it pushed down whenthe user logs into the LAN.> -Original Message-> From: Tirumala, Surendra [mailto:[EMAIL PROTECTED]]";>mailto:[EMAIL PROTECTED] m]> Sent: Monday, July 23, 2001 10:56 AM> To: Multiple recipients of list ORACLE-L> Subject: tnsnames.ora in clients> > > Hello All,> > Good morning!> I would like to know how the 'tnsnames.ora' file on all > client(windows)> machines can be updated automatically whenever something changed on> central 'tnsnames.ora' file.> Is this the process still being used extensively or else > advanced features> like ONS.> > Your suggestions are highly appreci
SHARED SQLNET.ora? RE: tnsnames.ora in clients
Has anyone been successful with putting the SQLNET.ora file in the same shared location as the TNSNAMES.ora file? I know it's supposed to be used solely on the user workstation in /network/admin (Net80/admin), but some people are trying to place it on the shared drive as well. We're actually implementing ONAMES, so we're replacing the SQLNET.ora file to specify ONAMES, and some Regions are thinking they only need to place this on the shared drive where TNS_ADMIN points to. I don't think this is supported or works in all situations. Any experiences or comments?? Ed -Original Message- Sent: Tuesday, July 24, 2001 1:02 PM To: Multiple recipients of list ORACLE-L We use a shared tnsnames.ora from a NT server. > -Original Message- > From: Ron Rogers [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 23, 2001 2:33 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: tnsnames.ora in clients > > > Does this method of "sharing" the tnsnames work for you? What > operating system are you using? I use Novell and when I tried > this method of sharing the tnsnames it wouls not work. We had > to resolve to downloading the latest copy to the users when > they logged in. > ROR mª¿ªm > > >>> [EMAIL PROTECTED] 07/23/01 11:41AM >>> > You can write a script and each time when a user logs into a domain > it will check and copy the latest tnsnames.ora file. Or you can just > place the tnsnames.ora file on the network drive and point everyone > to it. > > >>> [EMAIL PROTECTED] 07/23/01 10:55AM >>> > Hello All, > > Good morning! > I would like to know how the 'tnsnames.ora' file on all > client(windows) > machines can be updated automatically whenever something changed on > central 'tnsnames.ora' file. > Is this the process still being used extensively or else > advanced features > like ONS. > > Your suggestions are highly appreciated. > > Thanks, > > Suren > Consultant DBA > Sony > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Tirumala, Surendra > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Richard Ji > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ron Rogers > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other inf
RE: SHARED SQLNET.ora? RE: tnsnames.ora in clients
Hi Ed, We use ONAMES. We had tried putting SQLNET.ora on the shared drive. It was working. However, they later found out that accessing it at all times from various locations was not always the fastest, easiest and acceptable way. We have a number of portable clients. And all shared drives are not always mapped as it depends on how they chose to connect/dial-in. So, lately we just keep a master copy of SQLNET.ora on a shared drive. We seldom change it (we use aliases for the Servers running the Names). As new clients (laptops) are deployed, the PC support team just copies it to the PCs from the shared (master) location. And this process has been working great for a few years now. If you need any specific information, please let me know. Thanks. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Haskins, Ed [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, July 24, 2001 12:29 PM > To: Multiple recipients of list ORACLE-L > Subject: SHARED SQLNET.ora? RE: tnsnames.ora in clients > > Has anyone been successful with putting the SQLNET.ora file in the same > shared location as the TNSNAMES.ora file? I know it's supposed to be used > solely on the user workstation in /network/admin (Net80/admin), but some > people are trying to place it on the shared drive as well. > > We're actually implementing ONAMES, so we're replacing the SQLNET.ora file > to specify ONAMES, and some Regions are thinking they only need to place > this on the shared drive where TNS_ADMIN points to. I don't think this is > supported or works in all situations. Any experiences or comments?? > > Ed > > -Original Message- > Sent: Tuesday, July 24, 2001 1:02 PM > To: Multiple recipients of list ORACLE-L > > > We use a shared tnsnames.ora from a NT server. > > > -Original Message- > > From: Ron Rogers [mailto:[EMAIL PROTECTED]] > > Sent: Monday, July 23, 2001 2:33 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: tnsnames.ora in clients > > > > > > Does this method of "sharing" the tnsnames work for you? What > > operating system are you using? I use Novell and when I tried > > this method of sharing the tnsnames it wouls not work. We had > > to resolve to downloading the latest copy to the users when > > they logged in. > > ROR mª¿ªm > > > > >>> [EMAIL PROTECTED] 07/23/01 11:41AM >>> > > You can write a script and each time when a user logs into a domain > > it will check and copy the latest tnsnames.ora file. Or you can just > > place the tnsnames.ora file on the network drive and point everyone > > to it. > > > > >>> [EMAIL PROTECTED] 07/23/01 10:55AM >>> > > Hello All, > > > > Good morning! > > I would like to know how the 'tnsnames.ora' file on all > > client(windows) > > machines can be updated automatically whenever something changed on > > central 'tnsnames.ora' file. > > Is this the process still being used extensively or else > > advanced features > > like ONS. > > > > Your suggestions are highly appreciated. > > > > Thanks, > > > > Suren > > Consultant DBA > > Sony > > -- > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SHARED SQLNET.ora? RE: tnsnames.ora in clients
We have a shared location for on campus, and it's working with tnsnames.ora and sqlnet.ora. But for laptops going off campus they have a local copy, updated as needed from the network copy. > -Original Message- > From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 24, 2001 2:16 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: SHARED SQLNET.ora? RE: tnsnames.ora in clients > > > Hi Ed, > We use ONAMES. We had tried putting SQLNET.ora on the shared > drive. It was > working. However, they later found out that accessing it at > all times from > various locations was not always the fastest, easiest and > acceptable way. We > have a number of portable clients. And all shared drives are > not always > mapped as it depends on how they chose to connect/dial-in. > So, lately we > just keep a master copy of SQLNET.ora on a shared drive. We > seldom change it > (we use aliases for the Servers running the Names). As new clients > (laptops) are deployed, the PC support team just copies it to > the PCs from > the shared (master) location. And this process has been > working great for a > few years now. > > If you need any specific information, please let me know. > > Thanks. > > Regards, > > - Kirti Deshpande > Verizon Information Services >http://www.superpages.com > > > -Original Message- > > From: Haskins, Ed [SMTP:[EMAIL PROTECTED]] > > Sent: Tuesday, July 24, 2001 12:29 PM > > To: Multiple recipients of list ORACLE-L > > Subject:SHARED SQLNET.ora? RE: tnsnames.ora in clients > > > > Has anyone been successful with putting the SQLNET.ora file > in the same > > shared location as the TNSNAMES.ora file? I know it's > supposed to be used > > solely on the user workstation in /network/admin > (Net80/admin), but some > > people are trying to place it on the shared drive as well. > > > > We're actually implementing ONAMES, so we're replacing the > SQLNET.ora file > > to specify ONAMES, and some Regions are thinking they only > need to place > > this on the shared drive where TNS_ADMIN points to. I > don't think this is > > supported or works in all situations. Any experiences or comments?? > > > > Ed > > > > -Original Message- > > Sent: Tuesday, July 24, 2001 1:02 PM > > To: Multiple recipients of list ORACLE-L > > > > > > We use a shared tnsnames.ora from a NT server. > > > > > -Original Message- > > > From: Ron Rogers [mailto:[EMAIL PROTECTED]] > > > Sent: Monday, July 23, 2001 2:33 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject: Re: tnsnames.ora in clients > > > > > > > > > Does this method of "sharing" the tnsnames work for you? What > > > operating system are you using? I use Novell and when I tried > > > this method of sharing the tnsnames it wouls not work. We had > > > to resolve to downloading the latest copy to the users when > > > they logged in. > > > ROR mª¿ªm > > > > > > >>> [EMAIL PROTECTED] 07/23/01 11:41AM >>> > > > You can write a script and each time when a user logs > into a domain > > > it will check and copy the latest tnsnames.ora file. Or > you can just > > > place the tnsnames.ora file on the network drive and > point everyone > > > to it. > > > > > > >>> [EMAIL PROTECTED] 07/23/01 10:55AM >>> > > > Hello All, > > > > > > Good morning! > > > I would like to know how the 'tnsnames.ora' file on all > > > client(windows) > > > machines can be updated automatically whenever something > changed on > > > central 'tnsnames.ora' file. > > > Is this the process still being used extensively or else > > > advanced features > > > like ONS. > > > > > > Your suggestions are highly appreciated. > > > > > > Thanks, > > > > > > Suren > > > Consultant DBA > > > Sony > > > -- > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Deshpande, Kirti > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message &
RE: SHARED SQLNET.ora? RE: tnsnames.ora in clients
Kirti is right. We had the same issues. We used to have our TNSNAMES out on a lan space on my old job but, when we got Oracle Names up and running, we found out just what kind of lag time we had. It really was noticable at the connect time. -Original Message- Sent: Tuesday, July 24, 2001 1:16 PM To: Multiple recipients of list ORACLE-L Hi Ed, We use ONAMES. We had tried putting SQLNET.ora on the shared drive. It was working. However, they later found out that accessing it at all times from various locations was not always the fastest, easiest and acceptable way. We have a number of portable clients. And all shared drives are not always mapped as it depends on how they chose to connect/dial-in. So, lately we just keep a master copy of SQLNET.ora on a shared drive. We seldom change it (we use aliases for the Servers running the Names). As new clients (laptops) are deployed, the PC support team just copies it to the PCs from the shared (master) location. And this process has been working great for a few years now. If you need any specific information, please let me know. Thanks. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Haskins, Ed [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, July 24, 2001 12:29 PM > To: Multiple recipients of list ORACLE-L > Subject: SHARED SQLNET.ora? RE: tnsnames.ora in clients > > Has anyone been successful with putting the SQLNET.ora file in the same > shared location as the TNSNAMES.ora file? I know it's supposed to be used > solely on the user workstation in /network/admin (Net80/admin), but some > people are trying to place it on the shared drive as well. > > We're actually implementing ONAMES, so we're replacing the SQLNET.ora file > to specify ONAMES, and some Regions are thinking they only need to place > this on the shared drive where TNS_ADMIN points to. I don't think this is > supported or works in all situations. Any experiences or comments?? > > Ed > > -Original Message- > Sent: Tuesday, July 24, 2001 1:02 PM > To: Multiple recipients of list ORACLE-L > > > We use a shared tnsnames.ora from a NT server. > > > -Original Message- > > From: Ron Rogers [mailto:[EMAIL PROTECTED]] > > Sent: Monday, July 23, 2001 2:33 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: tnsnames.ora in clients > > > > > > Does this method of "sharing" the tnsnames work for you? What > > operating system are you using? I use Novell and when I tried > > this method of sharing the tnsnames it wouls not work. We had > > to resolve to downloading the latest copy to the users when > > they logged in. > > ROR mª¿ªm > > > > >>> [EMAIL PROTECTED] 07/23/01 11:41AM >>> > > You can write a script and each time when a user logs into a domain > > it will check and copy the latest tnsnames.ora file. Or you can just > > place the tnsnames.ora file on the network drive and point everyone > > to it. > > > > >>> [EMAIL PROTECTED] 07/23/01 10:55AM >>> > > Hello All, > > > > Good morning! > > I would like to know how the 'tnsnames.ora' file on all > > client(windows) > > machines can be updated automatically whenever something changed on > > central 'tnsnames.ora' file. > > Is this the process still being used extensively or else > > advanced features > > like ONS. > > > > Your suggestions are highly appreciated. > > > > Thanks, > > > > Suren > > Consultant DBA > > Sony > > -- > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).