Re: Get list of databases

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3DDD1A36.97B944CA_at_exesolutions.com...
> 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
>
>

Daniel,

OID (LDAP) isn't the end all to be all - YET! A couple of points:

1. A client can't use it concurrently with many of the previous Oracle versions (7.3.4, 8.0.5, 8.1.6, 8.1.7, etc.) I point you to:

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=FOR&p_id=83157.996

where it says, in part:

>5. Can OID be used concurrently with 7.3.4, 8.1.6 and 8.1.7 databases?

> According to the certification matrix, which you can access on MetaLink
> under Product Lifecycle, OID does not work concurrently with different
> database versions on the platforms you specified. On Sun SPARC
> Solaris 2.6, OID 2.1.1 is certified with 8.1.7, and OID 2.0.6 is certified
> with 8.1.6. On IBM Dynix 4.4.6, OID 2.0.6 is certified with 8.1.6. Older
> pre-LDAP clients will continue to rely on some pre-LDAP name-lookup
> (onames, tnsnames, etc).

[Quoted] [Quoted] The original posting did NOT specify which Oracle versions the person was using. I have clients still using Oracle 7.3.4 in production! My suggestion of ONAMES would support 7.3.4 through 9i database services, as [Quoted] the original poster might be using these database versions.

The above document (83157.996) also goes on to state:

> Depending on the scale of your Oracle Names implementation (how far
> along you are) and other timing factors, you may want to begin with
> ONames and migrate to LDAP." While I'm not trying to get off the
> hook of missing the ONAMES desupport notice, clearly for those
> using Oracle 9i and below ONAMES has value (especially for those
> starting out and can later migrate to LDAP).

Please notice the key sentences: "you may want to begin with ONames and [Quoted] [Quoted] migrate to LDAP." and "clearly for those using Oracle 9i and below ONAMES has value (especially for those starting out and can later migrate to LDAP)." Clearly, the original poster would be in this situation as his company is using Oracle 9i and below and can later migrate to LDAP.

> Along with the LDAP system, Oracle Names will provide compatibility
> features which will enable it to synchronize with the data in the OiD, and
> provide that data to pre-LDAP clients in the network. Deploying OID
> for NET8 is free of charge.

Please notice the key sentence: "Oracle Names will provide compatibility features which will enable it to synchronize with the data in the OiD, and provide that data to pre-LDAP clients in the network" As I read it, ONAMES still has a place (remembering the original posting didn't specify which Oracle database level and it might be 7.X).

To be honest, I missed the desupport notice for ONAMES, but I would still have recommended ONAMES to the original poster. While the mesage would have been different, my recommendation (unless all the databases are 9i, as one version of OID still doesn't cover all of 8X versions let along 7.X) would still be the same. I'm not a bleeding edge type of guy, unless the client desires bleeding edge!! I believe in inclusive solutions (not inclusive rates :-) ).

On the other hand, I didn't miss the desupport notice for Oracle 9i (http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_data base_id=NOT&p_id=190435.1). It is NOT going to stop me from using Oracle 9i, 8i, or even 7.3.4 on my OS/2 Warp server system. Hell, I have one client still using Oracle 7.3.4 (Windows/NT not OS/2 Warp Server)! The past is always around us.

Bertram Moshier
Oracle Certified Professional 8i and 9i DBA

http://www.bmoshier.net/bertram Received on Thu Nov 21 2002 - 21:53:45 CET