Re: Which do I start first NAMESCTL or LSNRCTL ?

If using OracleNames, you must run up the TNS listener (via lsnrctl) on the network definition database server before starting names as the nameserver uses a TNS connection to get the network definition (unless using ROSFILE). All other listeners can be started before or after nameservers.

I'm in the process of configuring 150 unix servers for sqlnet 2. Each has about 2 or 3 databases on it. Using OracleNames means we don't have to propagate tnsnames.ora to each server each time we create a new database. In that respect it's a lot better.

...However, I find OracleNames and the Oracle Network Manager bug-ridden to the point of considering Homicide. The worst one to date is with oracle network manager (3.0) having a limitation of 64 nodes. Apparently 3.1 which fixes this is shipped with oracle 7.3 but I'm on 7.2

The other bug that you might want to beware of if using OracleNames is that the "checkpoint files" don't work. These are supposed to allow you to restart a nameserver if the network definition database is down. The implications of this is that the server with this database has to be up all the time or at least before a nameserver is restarted.

...and one final warning, avoid Solaris 2.3 with sqlnet 2. It doesn't like hostnames.

Cheers,

John Butcher
Frustrated DBA.

In article <31eb94a6.1377793_at_n5.gbso.net>, Chuck Hamilton <chuckh_at_dvol.com> writes
>dmausner_at_brauntech.com (Dave Mausner) wrote:
>
>>In article <DuA2yH.1vn_at_boss.cs.ohiou.edu>,
>> austby_at_mail.ctenet.com (A Ustby) wrote:
>>>Which do I start first NAMESCTL or LSNRCTL ?
>>>
>>>
>>
>>they are configured as different TCP ports and do not depend on each other.
>>you can therefore start them in either order.
>>
>>Dave Mausner, Managing Consultant, Braun Technology Group, Chicago.
>>
>
>I'm curious. Do you find a names server easier to work with than
>configuration files? We haven't tried a names server yet. We put our
>tnsnames and sqlnet.ora files on a Netware file server accessible to
>all users instead and really haven't had much trouble.
>--
>Chuck Hamilton
>chuckh_at_dvol.com
>
>Never share a foxhole with anyone braver than yourself!
 

-- 
John Butcher