Re: Get list of databases

Bert Bear wrote:

> Karsten,
>
> As for LDAP .vs. ONAMES, he needs a solution today (not someday over the
> rainbow).
>
> As for problems parsing the ONAMES configuration file, the nice thing is
> there would be only one file to parse (e.g. don't have the problem or
> sometimes being qualified and sometimes not, some use SERVICE_NAME and some
> don't, etc.). There would be consistency within the file (as OEM/ONAMES
> writes/builds the file (not a person - normally).
>
> As for a consultant, he should get an Oracle consultant. If it was me,
> great. If it is you, great. If it is someone else, great. The bottom line
> is he needs someone who knows Oracle and the web (e.g. generating HTML/XHTML
> code from a program, doing CGI/SSI code, etc.).
>
> Bertram Moshier
> Oracle Certified Professional 8i and 9i DBA
>
> http://www.bmoshier.net/bertram
>
> "Karsten Farrell" <kfarrell_at_belgariad.com> wrote in message
> news:84WC9.118$BC.16746549_at_newssvr14.news.prodigy.com...
> > However, you can have a similar problem with ONAMES. You can have
> > multiple net service names there as well. Besides, there are some white
> > papers at Oracle that say ONAMES is going away, to be replaced by
> > LDAP-style naming. Of course, since ONAMES is still in 9i, maybe those
> > Oracle employees didn't know what they were talking about.
> >
> > Did you suggest he get *an* Oracle consultant ... or one named Bertram? ;)
> >
> > Bert Bear wrote:
> > > Van,
> > >
> > > This is one of the MAIN REASONS I strongly suggested to him they ONAMES
> > > (Oracle Centralized Naming) on their network. I also suggest the
> company
> > > get an Oracle consultant.
> > >
> > > Bertram Moshier
> > > Oracle Certified Professional 8i and 9i DBA
> > >
> > > http://www.bmoshier.net/bertram
> > >
> > >
> > > "Van Messner" <vmessner_at_bestweb.net> wrote in message
> > > news:uto3okcnb4c9c6_at_corp.supernews.com...
> > >
> > >>It might not be that easy. Across the whole network there may be
> multiple
> > >>tnsnames.oras. Some might use service_name some might use SID some may
> > >
> > > have
> > >
> > >>qualified net service names (SNEAKERS.mycompany.com ) and some may be
> > >>unqualified. Even this works and allows you to connect using JACK as
> the
> > >>connect string in SQL*Plus. So parsing could get complicated.
> > >>
> > >>SNEAKERS, JACK =
> > >> (DESCRIPTION =
> > >> (ADDRESS_LIST =
> > >> (ADDRESS = (PROTOCOL = TCP)(HOST = ERCF)(PORT = 1521))
> > >> )
> > >> (CONNECT_DATA =
> > >> (SERVER = DEDICATED)
> > >> (SERVICE_NAME = sneakers)
> > >> )
> > >> )
> > >>
> > >>"Bert Bear" <bertbear_at_NOSPAMbertbear.net> wrote in message
> > >>news:XiTC9.1433$Aq2.504205332_at_newssvr30.news.prodigy.com...
> > >>
> > >>>Robert,
> > >>>
> > >>>First, I think you are using the term "Oracle service" correctly.
> > >>
> > > Oracle
> > >
> > >>in
> > >>
> > >>>Getting to Know Oracle8i Release 2 (8.1.6) Part Number A76962-01 uses
> > >>
> > > the
> > >
> > >>>term Oracle database service to refer to an Oracle database
> instance/SID
> > >>>(before 8i) and Oracle database service_name (for parallel server/RAC)
> > >>
> > > in
> > >
> > >>8i
> > >>
> > >>>and beyond.
> > >>>
> > >>>The TNSNAMES.ORA is (normally) in the $ORACLE_HOME/network/admin
> > >>>subdirectory (for Window since you mentioned .NET). The structure of
> > >>
> > > the
> > >
> > >>>TNSNAMES.ORA file is in the documentation.
> > >>>
> > >>>Basically, though, what you want to put into the combo box is the
> > >>
> > > connect
> > >
> > >>>descriptors. You find those in the file by parsing for <connection
> > >>
> > >>string>
> > >>
> > >>>= (DESCRIPTION An example (9.2.0.1.0) is:
> > >>>
> > >>>SNEAKERS =
> > >>> (DESCRIPTION =
> > >>> (ADDRESS_LIST =
> > >>> (ADDRESS = (PROTOCOL = TCP)(HOST = ERCF)(PORT = 1521))
> > >>> )
> > >>> (CONNECT_DATA =
> > >>> (SERVER = DEDICATED)
> > >>> (SERVICE_NAME = sneakers)
> > >>> )
> > >>> )
> > >>>
> > >>>In this case, you would look for the name SNEAKERS (SNEAKERS =
> > >>
> > >>(DESCRIPTION
> > >>
> > >>>= ... )) by parsing for = (DESCRIPTION. This only helps you if all the
> > >>>service names are in the TNSNAMES.ORA file. Additionally, this will
> > >>
> > > also
> > >
> > >>>work ONLY if everyone using the combo box has the same TNSNAMES.ORA
> file
> > >>
> > >>as
> > >>
> > >>>you. If they don't then your connection string and theirs won't match.
> > >>>
> > >>>As I previously said (see prior message): You should look at using
> > >>
> > > ONAMES
> > >
> > >>>and creating the combo box from the ONAMES configuration file (NOT
> > >>>TNSNAMES.ORA). Should you decide NOT to go with ONAMES, then you need
> > >>
> > > to
> > >
> > >>>provide all the TNSNAMES.ORA information on the webpage for each Oracle
> > >>>service.
> > >>>
> > >>>I would be happy to consult on this topic with your company (and my
> > >>>(non-inclusive) rates are reasonable).
> > >>>
> > >>>Bertram Moshier
> > >>>Oracle Certified Professional 8i and 9i DBA
> > >>>
> > >>>http://www.bmoshier.net/bertram
> > >>>
> > >>>Service Naming
> > >>>An Oracle database can span multiple instances over multiple computers,
> > >>>making the database service a distributed service.
> > >>>
> > >>>Prior to Oracle8i, an Oracle database service was identified by an
> > >>
> > > Oracle
> > >
> > >>>System Identifier (SID). The SID was also used internally by the
> > >>
> > > database
> > >
> > >>as
> > >>
> > >>>pointer to the System Global Area (SGA). Clients connected to a
> database
> > >>>instance by specifying the SID in the connect descriptor. This naming
> > >>
> > >>scheme
> > >>
> > >>>did not distinguish services from instances.
> > >>>
> > >>>In Oracle8i, a new naming schema has been implemented. Because an
> Oracle
> > >>>database can span over multiple computers, both the service as a whole
> > >>
> > > and
> > >
> > >>>each of its instances are specified.
> > >>>
> > >>>A database is now identified by its service name with the SERVICE_NAMES
> > >>>parameter in the initialization file. SERVICE_NAMES specifies the name
> > >>
> > > of
> > >
> > >>>the highest-level view of Oracle database service, which may span
> > >>
> > >>instances
> > >>
> > >>>and/or nodes. SERVICE_NAMES is defaulted to the global database name, a
> > >>
> > >>name
> > >>
> > >>>comprised of the database name (DB_NAME) and domain name (DB_DOMAIN).
> > >>>
> > >>>Database instances are identified by an instance name with the
> > >>
> > >>INSTANCE_NAME
> > >>
> > >>>parameter in the initialization file. INSTANCE_NAME corresponds to the
> > >>
> > > SID
> > >
> > >>>of the instance.
> > >>>
> > >>>Connect descriptors used by clients should be configured with the
> > >>>SERVICE_NAME (singular, not plural) parameter to connect to an Oracle8i
> > >>>database.
> > >>>
> > >>>Optionally, the connect descriptor can also be configured with the
> > >>>INSTANCE_NAME parameter to connect to a particular instance of the
> > >>
> > >>database.
> > >>
> > >>>This may be useful if you have an Oracle Parallel Server with multiple
> > >>>instances.
> > >>>
> > >>>
> > >>>
> > >>>"Robert Vabo" <rvabo_at_msn.com> wrote in message
> > >>>news:3ddbe156_at_news.wineasy.se...
> > >>>
> > >>>>I'm sorry about the cross post. Its just that I have been asking
> > >>>
> > >>>questions,
> > >>>
> > >>>>searching etc. for about a week without getting any answers.
> > >>>>
> > >>>>Why am I interested in listing up Oracle Services (or whatever they
> > >>>
> > > are
> > >
> > >>>>called)
> > >>>>HOW TO GET THE ENTRIES IN THE TNSNAMES.ORA FILE!! so I can fill a
> > >>>
> > > Combo
> > >
> > >>>with
> > >>>
> > >>>>it ?
> > >>>>
> > >>>>Oracle does it themselves when you use Net Assistant!
> > >>>>
> > >>>>--
> > >>>>Regards
> > >>>>Robert Vabo
> > >>>>Gecko AS
> > >>>>www.gecko.no
> > >>>>
> > >>>>"Robert Vabo" <rvabo_at_msn.com> skrev i melding
> > >>>>news:3ddb83a0_at_news.wineasy.se...
> > >>>>
> > >>>>>How can I use .NET to retrieve a list of all Oracle services on my
> > >>>>
> > >>>network
> > >>>
> > >>>>?
> > >>>>
> > >>>>>--
> > >>>>>Regards
> > >>>>>Robert Vabo
> > >>>>>Gecko AS
> > >>>>>www.gecko.no
> > >>>>>
> > >>>>>
> > >>>>
> > >>>>
> > >>>
> > >>
> > >
> > >
> >

Forget ONAMES. Oracle has already announced its demise.

Daniel Morgan Received on Thu Nov 21 2002 - 11:39:05 CST