RE: When to go for ORACLE NAMES Server
I beleave intelligent agent requires tnsnames.ora also. Alex Hillman -Original Message- Sent: Monday, May 14, 2001 1:47 AM To: Multiple recipients of list ORACLE-L On Sunday 13 May 2001 18:51, Mohan, Ross wrote: Sounds like client-based Forms would be OK with ONS, then. Or, izzit? Forms 5 wouldn't work on Solaris with ONS. I'm not sure about forms 6 or 6i. MetaBlink is stuck right now or I'd try and verify this through support. Jared - ross ( i won't FedEx you a burger, but write yerself a raincheck) || -Original Message- || From: Jared Still [mailto:[EMAIL PROTECTED]] || Sent: Friday, May 11, 2001 11:50 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: When to go for ORACLE NAMES Server || || || || Ross, || || What I was referring to was using Oracle Forms directly on || Unix, *not* through iAS. iAS takes care of that stuff for || you. || || Lesse, I tried using forms 5.x on Solaris a couple of years || ago, and much to my dismay found that tnsnames.ora was || *required* in order to connect to a database. This was || on a box that worked just fine with ORANAMES when || connecting via sqlplus or Perl. || || Reports had the same problem. || || I was troubleshooting some forms of the 6i variety on Solaris || a few months ago, and since I still had the tnsnames.ora setup || on that box from the previous go round with forms, I honestly || don't know if Forms 6i required it or not. || || The trouble shooting was in native forms mode on Solaris 2.6, || though the forms were moved to another box and run in iAS, || which functioned just fine with ORANAMES. || || I don't have ORANAMES setup here at home or I would try || and test this here. || || Jared || || On Friday 11 May 2001 10:45, Mohan, Ross wrote: || Jared, || || You may have just earned yourself a dinner. (And I || promise you will not receive it the way you did my || $0.02 recently ;-) || || Can you tell me more...alot more would be grand...about || how Forms needs tnsnames? || || *thanks* || || Ross || || || -Original Message- || || From: Jared Still [mailto:[EMAIL PROTECTED]] || || Sent: Friday, May 11, 2001 1:43 PM || || To: [EMAIL PROTECTED]; Mohan, Ross || || Subject: Re: When to go for ORACLE NAMES Server || || || || || || || || Somewhat of a pain to setup for the first time, for sure. || || || || But after you get it implemented, you will never want to || || go back. || || || || One caveat: There is a fair amount of software around || || that *requires* tnsnames.ora or it won't work. Oracle || || Forms on unix comes to mind. Yes, Oracle's own software || || does not fully utilize names. || || || || This is a minor problem when compared to the benefits though. || || || || Jared || || || || On Friday 11 May 2001 10:50, Mohan, Ross wrote: || || if the tediousness exceeds your perception of the || || || || difficulty, do Names. || || || || if not, not. || || || || In my very limited experience, a truly robust, || || || || well-managed Names service || || || || is great, but takes some work to set up, test, and document. || || || || YMMV || || || || || -Original Message- || || || From: Johnson Poovathummoottil [mailto:[EMAIL PROTECTED]] || || || Sent: Friday, May 11, 2001 12:15 PM || || || To: Multiple recipients of list ORACLE-L || || || Subject: When to go for ORACLE NAMES Server || || || || || || || || || There is another thread going on about no database on || || || a single server, I have another question to ask. || || || || || || We have nearly 30 databases across Sun and Win 2000 || || || Platforms. We are finding it tedious to keep track of || || || tnsnames.ora. While looking out for a solution we hit || || || at ORACLE Names server. I hear it is going to give way || || || to ORACLE Internet directory. But after reading a || || || little I think using either would be too much of a || || || kill for the problem. || || || || || || Any opinions? || || || || || || || || || __ || || || Do You Yahoo!? || || || Yahoo! Auctions - buy the things you want at great prices || || || http://auctions.yahoo.com/ || || || -- || || || Please see the official ORACLE-L FAQ: http://www.orafaq.com || || || -- || || || Author: Johnson Poovathummoottil || || || 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
RE: When to go for ORACLE NAMES Server
Nope! Most of the TNSNAMES.ORA files on my servers are empty, and IA still works (at least as much as can be expected). Perhaps LISTENER.ORA is what you were thinking of? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Hillman, Alex [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 09:55 To: Multiple recipients of list ORACLE-L Subject: RE: When to go for ORACLE NAMES Server I beleave intelligent agent requires tnsnames.ora also. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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: When to go for ORACLE NAMES Server
Sounds like client-based Forms would be OK with ONS, then. Or, izzit? - ross ( i won't FedEx you a burger, but write yerself a raincheck) || -Original Message- || From: Jared Still [mailto:[EMAIL PROTECTED]] || Sent: Friday, May 11, 2001 11:50 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: When to go for ORACLE NAMES Server || || || || Ross, || || What I was referring to was using Oracle Forms directly on || Unix, *not* through iAS. iAS takes care of that stuff for || you. || || Lesse, I tried using forms 5.x on Solaris a couple of years || ago, and much to my dismay found that tnsnames.ora was || *required* in order to connect to a database. This was || on a box that worked just fine with ORANAMES when || connecting via sqlplus or Perl. || || Reports had the same problem. || || I was troubleshooting some forms of the 6i variety on Solaris || a few months ago, and since I still had the tnsnames.ora setup || on that box from the previous go round with forms, I honestly || don't know if Forms 6i required it or not. || || The trouble shooting was in native forms mode on Solaris 2.6, || though the forms were moved to another box and run in iAS, || which functioned just fine with ORANAMES. || || I don't have ORANAMES setup here at home or I would try || and test this here. || || Jared || || On Friday 11 May 2001 10:45, Mohan, Ross wrote: || Jared, || || You may have just earned yourself a dinner. (And I || promise you will not receive it the way you did my || $0.02 recently ;-) || || Can you tell me more...alot more would be grand...about || how Forms needs tnsnames? || || *thanks* || || Ross || || || -Original Message- || || From: Jared Still [mailto:[EMAIL PROTECTED]] || || Sent: Friday, May 11, 2001 1:43 PM || || To: [EMAIL PROTECTED]; Mohan, Ross || || Subject: Re: When to go for ORACLE NAMES Server || || || || || || || || Somewhat of a pain to setup for the first time, for sure. || || || || But after you get it implemented, you will never want to || || go back. || || || || One caveat: There is a fair amount of software around || || that *requires* tnsnames.ora or it won't work. Oracle || || Forms on unix comes to mind. Yes, Oracle's own software || || does not fully utilize names. || || || || This is a minor problem when compared to the benefits though. || || || || Jared || || || || On Friday 11 May 2001 10:50, Mohan, Ross wrote: || || if the tediousness exceeds your perception of the || || || || difficulty, do Names. || || || || if not, not. || || || || In my very limited experience, a truly robust, || || || || well-managed Names service || || || || is great, but takes some work to set up, test, and document. || || || || YMMV || || || || || -Original Message- || || || From: Johnson Poovathummoottil [mailto:[EMAIL PROTECTED]] || || || Sent: Friday, May 11, 2001 12:15 PM || || || To: Multiple recipients of list ORACLE-L || || || Subject: When to go for ORACLE NAMES Server || || || || || || || || || There is another thread going on about no database on || || || a single server, I have another question to ask. || || || || || || We have nearly 30 databases across Sun and Win 2000 || || || Platforms. We are finding it tedious to keep track of || || || tnsnames.ora. While looking out for a solution we hit || || || at ORACLE Names server. I hear it is going to give way || || || to ORACLE Internet directory. But after reading a || || || little I think using either would be too much of a || || || kill for the problem. || || || || || || Any opinions? || || || || || || || || || __ || || || Do You Yahoo!? || || || Yahoo! Auctions - buy the things you want at great prices || || || http://auctions.yahoo.com/ || || || -- || || || Please see the official ORACLE-L FAQ: http://www.orafaq.com || || || -- || || || Author: Johnson Poovathummoottil || || || 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: Jared Still || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538
Re: When to go for ORACLE NAMES Server
On Sunday 13 May 2001 18:51, Mohan, Ross wrote: Sounds like client-based Forms would be OK with ONS, then. Or, izzit? Forms 5 wouldn't work on Solaris with ONS. I'm not sure about forms 6 or 6i. MetaBlink is stuck right now or I'd try and verify this through support. Jared - ross ( i won't FedEx you a burger, but write yerself a raincheck) || -Original Message- || From: Jared Still [mailto:[EMAIL PROTECTED]] || Sent: Friday, May 11, 2001 11:50 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: When to go for ORACLE NAMES Server || || || || Ross, || || What I was referring to was using Oracle Forms directly on || Unix, *not* through iAS. iAS takes care of that stuff for || you. || || Lesse, I tried using forms 5.x on Solaris a couple of years || ago, and much to my dismay found that tnsnames.ora was || *required* in order to connect to a database. This was || on a box that worked just fine with ORANAMES when || connecting via sqlplus or Perl. || || Reports had the same problem. || || I was troubleshooting some forms of the 6i variety on Solaris || a few months ago, and since I still had the tnsnames.ora setup || on that box from the previous go round with forms, I honestly || don't know if Forms 6i required it or not. || || The trouble shooting was in native forms mode on Solaris 2.6, || though the forms were moved to another box and run in iAS, || which functioned just fine with ORANAMES. || || I don't have ORANAMES setup here at home or I would try || and test this here. || || Jared || || On Friday 11 May 2001 10:45, Mohan, Ross wrote: || Jared, || || You may have just earned yourself a dinner. (And I || promise you will not receive it the way you did my || $0.02 recently ;-) || || Can you tell me more...alot more would be grand...about || how Forms needs tnsnames? || || *thanks* || || Ross || || || -Original Message- || || From: Jared Still [mailto:[EMAIL PROTECTED]] || || Sent: Friday, May 11, 2001 1:43 PM || || To: [EMAIL PROTECTED]; Mohan, Ross || || Subject: Re: When to go for ORACLE NAMES Server || || || || || || || || Somewhat of a pain to setup for the first time, for sure. || || || || But after you get it implemented, you will never want to || || go back. || || || || One caveat: There is a fair amount of software around || || that *requires* tnsnames.ora or it won't work. Oracle || || Forms on unix comes to mind. Yes, Oracle's own software || || does not fully utilize names. || || || || This is a minor problem when compared to the benefits though. || || || || Jared || || || || On Friday 11 May 2001 10:50, Mohan, Ross wrote: || || if the tediousness exceeds your perception of the || || || || difficulty, do Names. || || || || if not, not. || || || || In my very limited experience, a truly robust, || || || || well-managed Names service || || || || is great, but takes some work to set up, test, and document. || || || || YMMV || || || || || -Original Message- || || || From: Johnson Poovathummoottil [mailto:[EMAIL PROTECTED]] || || || Sent: Friday, May 11, 2001 12:15 PM || || || To: Multiple recipients of list ORACLE-L || || || Subject: When to go for ORACLE NAMES Server || || || || || || || || || There is another thread going on about no database on || || || a single server, I have another question to ask. || || || || || || We have nearly 30 databases across Sun and Win 2000 || || || Platforms. We are finding it tedious to keep track of || || || tnsnames.ora. While looking out for a solution we hit || || || at ORACLE Names server. I hear it is going to give way || || || to ORACLE Internet directory. But after reading a || || || little I think using either would be too much of a || || || kill for the problem. || || || || || || Any opinions? || || || || || || || || || __ || || || Do You Yahoo!? || || || Yahoo! Auctions - buy the things you want at great prices || || || http://auctions.yahoo.com/ || || || -- || || || Please see the official ORACLE-L FAQ: http://www.orafaq.com || || || -- || || || Author: Johnson Poovathummoottil || || || 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
RE: When to go for ORACLE NAMES Server
if the tediousness exceeds your perception of the difficulty, do Names. if not, not. In my very limited experience, a truly robust, well-managed Names service is great, but takes some work to set up, test, and document. YMMV || -Original Message- || From: Johnson Poovathummoottil [mailto:[EMAIL PROTECTED]] || Sent: Friday, May 11, 2001 12:15 PM || To: Multiple recipients of list ORACLE-L || Subject: When to go for ORACLE NAMES Server || || || There is another thread going on about no database on || a single server, I have another question to ask. || || We have nearly 30 databases across Sun and Win 2000 || Platforms. We are finding it tedious to keep track of || tnsnames.ora. While looking out for a solution we hit || at ORACLE Names server. I hear it is going to give way || to ORACLE Internet directory. But after reading a || little I think using either would be too much of a || kill for the problem. || || Any opinions? || || || __ || Do You Yahoo!? || Yahoo! Auctions - buy the things you want at great prices || http://auctions.yahoo.com/ || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Johnson Poovathummoottil || 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: Mohan, Ross 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: When to go for ORACLE NAMES Server
Somewhat of a pain to setup for the first time, for sure. But after you get it implemented, you will never want to go back. One caveat: There is a fair amount of software around that *requires* tnsnames.ora or it won't work. Oracle Forms on unix comes to mind. Yes, Oracle's own software does not fully utilize names. This is a minor problem when compared to the benefits though. Jared On Friday 11 May 2001 10:50, Mohan, Ross wrote: if the tediousness exceeds your perception of the difficulty, do Names. if not, not. In my very limited experience, a truly robust, well-managed Names service is great, but takes some work to set up, test, and document. YMMV || -Original Message- || From: Johnson Poovathummoottil [mailto:[EMAIL PROTECTED]] || Sent: Friday, May 11, 2001 12:15 PM || To: Multiple recipients of list ORACLE-L || Subject: When to go for ORACLE NAMES Server || || || There is another thread going on about no database on || a single server, I have another question to ask. || || We have nearly 30 databases across Sun and Win 2000 || Platforms. We are finding it tedious to keep track of || tnsnames.ora. While looking out for a solution we hit || at ORACLE Names server. I hear it is going to give way || to ORACLE Internet directory. But after reading a || little I think using either would be too much of a || kill for the problem. || || Any opinions? || || || __ || Do You Yahoo!? || Yahoo! Auctions - buy the things you want at great prices || http://auctions.yahoo.com/ || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Johnson Poovathummoottil || 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: Jared Still 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: When to go for ORACLE NAMES Server
Too much of a kill? Not at all. We are currently running ONAMES, and are planning on going OID as soon as we can get some time. OID (Oracle's LDAP) has other benefits like being able to authenticate more than just Oracle connections. ONAMES is relatively easy to setup. For your configuration, you will probably want to have a region database (repository), as well as more than one NAMES server running on different boxes for redundancy. With that setup, you can lose the region DB with no loss of service (each NAMES server keeps a local cache which is updated periodically), or either ONAMES server with no loss of connection for your clients. I hate to say it, but the Java Net8 Assistant does help quite a bit in setting up ONAMES. That is, when it doesn't hang or crash... When your ONAMES is setup, you will need to modify every client's SQLNET.ORA file to tell the client to resolve database aliases thru Names. Something like this: NAMES.PREFERRED_SERVERS = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = myserver1)(PORT = 1575)) (ADDRESS = (PROTOCOL = TCP)(HOST = myserver2)(PORT = 1575)) ) NAMES.DIRECTORY_PATH= (ONAMES) -Original Message- From: Johnson Poovathummoottil [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 11:15 To: Multiple recipients of list ORACLE-L Subject: When to go for ORACLE NAMES Server There is another thread going on about no database on a single server, I have another question to ask. We have nearly 30 databases across Sun and Win 2000 Platforms. We are finding it tedious to keep track of tnsnames.ora. While looking out for a solution we hit at ORACLE Names server. I hear it is going to give way to ORACLE Internet directory. But after reading a little I think using either would be too much of a kill for the problem. Any opinions? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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: When to go for ORACLE NAMES Server
Title: RE: When to go for ORACLE NAMES Server There is one thing to be aware of. In a very large environment, (which you may or may not have) you don't always want everyone to be able to connect to everywhere. By using tnsnames.ora files, we can control which clients are allowed to connect to which servers (yes, the same thing can be accomplished using the protocol.ora file, but we prefer it this way). ymmv -blah blah blah R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 2:37 PM To: Multiple recipients of list ORACLE-L Subject: Re: When to go for ORACLE NAMES Server Somewhat of a pain to setup for the first time, for sure. But after you get it implemented, you will never want to go back. One caveat: There is a fair amount of software around that *requires* tnsnames.ora or it won't work. Oracle Forms on unix comes to mind. Yes, Oracle's own software does not fully utilize names. This is a minor problem when compared to the benefits though. Jared On Friday 11 May 2001 10:50, Mohan, Ross wrote: if the tediousness exceeds your perception of the difficulty, do Names. if not, not. In my very limited experience, a truly robust, well-managed Names service is great, but takes some work to set up, test, and document. YMMV || -Original Message- || From: Johnson Poovathummoottil [mailto:[EMAIL PROTECTED]] || Sent: Friday, May 11, 2001 12:15 PM || To: Multiple recipients of list ORACLE-L || Subject: When to go for ORACLE NAMES Server || || || There is another thread going on about no database on || a single server, I have another question to ask. || || We have nearly 30 databases across Sun and Win 2000 || Platforms. We are finding it tedious to keep track of || tnsnames.ora. While looking out for a solution we hit || at ORACLE Names server. I hear it is going to give way || to ORACLE Internet directory. But after reading a || little I think using either would be too much of a || kill for the problem. || || Any opinions? || || || __ || Do You Yahoo!? || Yahoo! Auctions - buy the things you want at great prices || http://auctions.yahoo.com/ || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Johnson Poovathummoottil || 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: Jared Still 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: When to go for ORACLE NAMES Server
Jared, You may have just earned yourself a dinner. (And I promise you will not receive it the way you did my $0.02 recently ;-) Can you tell me more...alot more would be grand...about how Forms needs tnsnames? *thanks* Ross || -Original Message- || From: Jared Still [mailto:[EMAIL PROTECTED]] || Sent: Friday, May 11, 2001 1:43 PM || To: [EMAIL PROTECTED]; Mohan, Ross || Subject: Re: When to go for ORACLE NAMES Server || || || || Somewhat of a pain to setup for the first time, for sure. || || But after you get it implemented, you will never want to || go back. || || One caveat: There is a fair amount of software around || that *requires* tnsnames.ora or it won't work. Oracle || Forms on unix comes to mind. Yes, Oracle's own software || does not fully utilize names. || || This is a minor problem when compared to the benefits though. || || Jared || || || On Friday 11 May 2001 10:50, Mohan, Ross wrote: || if the tediousness exceeds your perception of the || difficulty, do Names. || || if not, not. || || In my very limited experience, a truly robust, || well-managed Names service || is great, but takes some work to set up, test, and document. || || YMMV || || || -Original Message- || || From: Johnson Poovathummoottil [mailto:[EMAIL PROTECTED]] || || Sent: Friday, May 11, 2001 12:15 PM || || To: Multiple recipients of list ORACLE-L || || Subject: When to go for ORACLE NAMES Server || || || || || || There is another thread going on about no database on || || a single server, I have another question to ask. || || || || We have nearly 30 databases across Sun and Win 2000 || || Platforms. We are finding it tedious to keep track of || || tnsnames.ora. While looking out for a solution we hit || || at ORACLE Names server. I hear it is going to give way || || to ORACLE Internet directory. But after reading a || || little I think using either would be too much of a || || kill for the problem. || || || || Any opinions? || || || || || || __ || || Do You Yahoo!? || || Yahoo! Auctions - buy the things you want at great prices || || http://auctions.yahoo.com/ || || -- || || Please see the official ORACLE-L FAQ: http://www.orafaq.com || || -- || || Author: Johnson Poovathummoottil || || 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: Mohan, Ross 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: When to go for ORACLE NAMES Server
Title: RE: When to go for ORACLE NAMES Server -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] We have 20+ instances this mess called PeopleSoft, so keeping track of TNSNAMES is a real tedious thing to do. Consequently we migrated to Oracle Names have loved it ever since. If your going to get on Onames, use either 7.3.4's version of 8.1.6's. 8.0.x's version has way too many bugs. I personally had the opposite experience. When I tried to set up Oracle Names, I first tried Oracle Names for Oracle NT 7.3.4. I never was successful in starting it, and when I called Oracle support the person on the phone said I've never managed to make it work either. When I tried Oracle Names 8.0 on HP-UX it worked right the very first time. If one wanted to set it up (it's not really that much more difficult than starting up a listener), I would asking someone to provide sample configuration files (i.e. names.ora and sqlnet.ora). With examples of those two files it should be easy. -- Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com
RE: When to go for ORACLE NAMES Server
Oh, you wanted to set it up on NT? I CAN'T EVEN GET 8.1.6 ONAMES *INSTALLED*, much less running! I finally just gave up and went with our development HP9000 L-class as the backup server. Erm, one other thing I just remembered: We are running 8.1.6 Networking on the HP. Since my ONAMES is 8.0.5 on OpenVMS, I didn't want to try 8.1.6 ONAMES as it's backup -- who knows what differences there might be? So, I installed 8.0.6 ONAMES on HP. Well, for some reason, after firing the 8.0.6 ONAMES backup server on the same box where 8.1.6 networking was being used, I started getting ORA-12xxx packet drop errors. Shutdown the 8.0.6 ONAMES and all's fine. H... Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Friday, May 11, 2001 14:00 To: Multiple recipients of list ORACLE-L -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] We have 20+ instances this mess called PeopleSoft, so keeping track of TNSNAMES is a real tedious thing to do. Consequently we migrated to Oracle Names have loved it ever since. If your going to get on Onames, use either 7.3.4's version of 8.1.6's. 8.0.x's version has way too many bugs. I personally had the opposite experience. When I tried to set up Oracle Names, I first tried Oracle Names for Oracle NT 7.3.4. I never was successful in starting it, and when I called Oracle support the person on the phone said I've never managed to make it work either. When I tried Oracle Names 8.0 on HP-UX it worked right the very first time. If one wanted to set it up (it's not really that much more difficult than starting up a listener), I would asking someone to provide sample configuration files (i.e. names.ora and sqlnet.ora). With examples of those two files it should be easy. -- Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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: When to go for ORACLE NAMES Server
Ross, What I was referring to was using Oracle Forms directly on Unix, *not* through iAS. iAS takes care of that stuff for you. Lesse, I tried using forms 5.x on Solaris a couple of years ago, and much to my dismay found that tnsnames.ora was *required* in order to connect to a database. This was on a box that worked just fine with ORANAMES when connecting via sqlplus or Perl. Reports had the same problem. I was troubleshooting some forms of the 6i variety on Solaris a few months ago, and since I still had the tnsnames.ora setup on that box from the previous go round with forms, I honestly don't know if Forms 6i required it or not. The trouble shooting was in native forms mode on Solaris 2.6, though the forms were moved to another box and run in iAS, which functioned just fine with ORANAMES. I don't have ORANAMES setup here at home or I would try and test this here. Jared On Friday 11 May 2001 10:45, Mohan, Ross wrote: Jared, You may have just earned yourself a dinner. (And I promise you will not receive it the way you did my $0.02 recently ;-) Can you tell me more...alot more would be grand...about how Forms needs tnsnames? *thanks* Ross || -Original Message- || From: Jared Still [mailto:[EMAIL PROTECTED]] || Sent: Friday, May 11, 2001 1:43 PM || To: [EMAIL PROTECTED]; Mohan, Ross || Subject: Re: When to go for ORACLE NAMES Server || || || || Somewhat of a pain to setup for the first time, for sure. || || But after you get it implemented, you will never want to || go back. || || One caveat: There is a fair amount of software around || that *requires* tnsnames.ora or it won't work. Oracle || Forms on unix comes to mind. Yes, Oracle's own software || does not fully utilize names. || || This is a minor problem when compared to the benefits though. || || Jared || || On Friday 11 May 2001 10:50, Mohan, Ross wrote: || if the tediousness exceeds your perception of the || || difficulty, do Names. || || if not, not. || || In my very limited experience, a truly robust, || || well-managed Names service || || is great, but takes some work to set up, test, and document. || || YMMV || || || -Original Message- || || From: Johnson Poovathummoottil [mailto:[EMAIL PROTECTED]] || || Sent: Friday, May 11, 2001 12:15 PM || || To: Multiple recipients of list ORACLE-L || || Subject: When to go for ORACLE NAMES Server || || || || || || There is another thread going on about no database on || || a single server, I have another question to ask. || || || || We have nearly 30 databases across Sun and Win 2000 || || Platforms. We are finding it tedious to keep track of || || tnsnames.ora. While looking out for a solution we hit || || at ORACLE Names server. I hear it is going to give way || || to ORACLE Internet directory. But after reading a || || little I think using either would be too much of a || || kill for the problem. || || || || Any opinions? || || || || || || __ || || Do You Yahoo!? || || Yahoo! Auctions - buy the things you want at great prices || || http://auctions.yahoo.com/ || || -- || || Please see the official ORACLE-L FAQ: http://www.orafaq.com || || -- || || Author: Johnson Poovathummoottil || || 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: Jared Still 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).
