Re: How to list net service names in an Oracle Names Server?

On Fri, 19 Oct 2001 19:22:00 +0200, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

>
>"Dino Hsu" <dino1.nospam_at_ms1.hinet.net> wrote in message
>news:8sa0tt45vujt3f3i4m0m28limons3uusru_at_4ax.com...
>> Dear all,
>>
>> I have created an Oracle Names Server 'NS1.home' on the server with
>> Net8 Configuration (or Net8 Manager), and created some net service
>> names. It hits me when I want to list all the net service names I have
>> added in this ONS. In Net8 Manager, Oracle Net8 Confiuration -> Oralce
>> Names Servers -> NS1.home -> Manage Data -> Net Service Names ->
>> Action, there are Query, Add, Remove, Load and an Execute button. This
>> Query allows me to enter a Net Service Name, and tells me the
>> Descriptor, but one at a time. I try to enter '*', all Descriptors are
>> listed, but no Net Service Names are shown. Anyone knows how to do
>> this? How about with 'namesctl.exe'? Where exactly are these Net
>> Service Names stored? Thanks in advance.
>>
>> Dino
>>
>
>They are stored in a database table in the user names password names
>and in a so-called checkpoint file on the server, somewhere in the
>$ORACLE_HOME/network hierarchy. The latter file definitely is readable, the
>table is not readable. (Data stored in a long column and you need to parse
>it)
>The Assistant in fact is more or less a wrapper around the namesctl program,
>described in the net8 administrators manual.
>An equivalent command to query a service_name directly in namesctl is
>query <service_name> a.smd
>It should be possible to list them all, but I don't recall the command.
>
>Hth
>Sybrand Bakker
>Senior Oracle DBA
>
>

After some efforts, I finally gained more understanding about Names Server. Several aspects with a couple of doubts are as follows: 1.region database: names servers can go with or without a region database, cache files are used in both cases, but the additional region database provides higher availability of names. 2.region vs. domain: domian names such as oracle.com, us.oracle.com and server1.us.oracle.com, etc. is for avoiding name space conflicts. Regions are used to delegate the administrative power of names to , say, countries, so that a local search is performed when a local name is specified, a remote search is only performed when a remote name is specified. However, multiple offices in the same city should be in the same region, if they share the same set of "local" names. 3.multiple regions: Every region manages one or more domains. When multiple regions are used, one region should be the root region (or administration region, but I don't find any difference between region and adm. region), all the rest regions are delegated sub-domains to them. A region delegated a domain can delegate on its sub-domains to other regions, so the structure of regions is also a hierarchy, but a different one from the correspondent domains. However, there are no region cooridnators (I mean process), but one or more names servers in every region, but only one region database in one region, so the region-to-region communication is coordinated by names servers with no problem (I suppose).
4.cache files: I suppose cache files means the checkpoint files cptcch.ora, cptreg.ora, etc.. (in $ORACLE_HOME\admin\names), unfortunately I cannot find much information in them, the names are not there. These files are not supposed to be modified, because they are automatically generated by the names server, they are overwritten on checkpoints.
5.cache replication: every names server knows all other names servers in the same region (but you have to configure it to know), which is stored in sdns.ora (or .sdns.ora in Unix). once they know one another, they mutually replicate the names, with or without the region database (it is more efficient with a region database, though). These names should be saved in some cache files, but I cannot find them, as pointed out in 4..
6.names: the "names" in a names server include net service names, global database links, aliases, and names servers. I can get the net service names by executing dump_tnsnames in the namesctl utility, which saves all net service names in tnsnames.ora. Names servers is stored in sdns.ora, as pointed out in 4.. I don't know how to get all other names. The Net Assistant -> names server -> manage data enables you to query, but not show them all. The list_objects of namesctl gives strange names, I don't know what they are. 7.authoritative or non-authoritative answers: still don't know what this means.
8.listener: the Net Assistant -> listener -> general -> register services with the names server (the equivalent PLUG_AND_PLAY_listener in listener.ora) is gone in 9i, don't know how it works and why it's gone.

The region concept is not fully explained in Net8 Administrator's Guide, I got to understand it in a technical forum document in metalink. There are still a couple of doubts there, hope those who know it can tell me. Thanks in advance.

Dino Received on Sun Oct 21 2001 - 21:09:25 CDT