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

"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 Received on Fri Oct 19 2001 - 12:22:00 CDT