Re: Oracle Names and DNS

Try this setup for NT/W2k:

Edit your hosts file (located in winnt\system32\drivers\etc) with notepad.exe

Add your machine name there. TNSNAMES/LISTENER.ORA will resolve based on this before looking to an outside DNS server. Don't use the .world for this entry.

like this:

DNSNAME                        IP ADDRESS
localmachineDNSname           1.2.3.4
remotemachineDNSname          1.2.3.5

The hosts file is the local DNS resolution for NT/W2k/Linux/Unix.

Do this edit on both client and server. Then each one will resolve to local Hosts file. Oracle over Net8 should work fine. Make sure the TNSNAMES on client and LISTENER on server have correct DNS name entry that matches HOSTS file.

Lmhosts is the local netbios name entry, only Microsoft specific - wont work with Oracle at all. Oracle uses TCP/IP, not NETBEUI/Netbios names. Never use the Netbios name at all, it could be totally different from the DNS name. Remember this if you ever use Oracle Enterprise Manager. It uses DNS too for finding nodes.

KC

burdakov_at_vesco.ru (Aleksey Burdakov) wrote in message news:<9292180b.0112060215.28eb1357_at_posting.google.com>...
> > You *must* use *any* dns mechanism with Oracle Names, as it won't
> > allow you to store hardcoded ip-addresses.
>
> Name resolution in Windows networks can be done 1) via NetBIOS names
> (via broadcasting, WINS services or both) or 2) via DNS (DNS services,
> hosts, lmhosts), or both 1) and 2). If there is no DNS service
> installed on the networks, a name will be tried to be resolved via
> NetBIOS. That's what Microsoft says.
> So, if I get it right, Oracle Names queries DNS api directly, and
> ignores NetBIOS resolution method ? Could you explain this issue in
> more details ?
>
> > The client won't find any Oracle Names servers if they are not defined
> > in the names.preferred_servers section in sqlnet.ora
>
> According to the Oracle's Administration Guide DNS will give the the
> feature of "automatic" Oracle Names server location. Suppose we don't
> need it and can define the server address explicitly.
> So, on the client side in sqlnet.ora I have defined the following
> string:
>
> NAMES.PREFERRED_SERVERS =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = dream3000)(PORT = 1575))
> )
>
> This client can locate server "dream3000" via NetBIOS. Is DNS
> neccessary for Oracle Client in order to locate Oracle Names server,
> or NetBIOS is enough ?
>
> For example, this client can locate and connect Oracle Server via TNS.
> Below is the tnsnames.ora file:
>
> STORAGE2.WORLD =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = dream3000)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = storage2)
> )
> )
>
>
> Best Regards,
>
> Aleksey Burdakov
>
> Sybrand Bakker <oradba_at_sybrandb.demon.nl> wrote in message news:<e68t0u4up309ar21rld1hasnodjdhiskss_at_4ax.com>...
> > On 5 Dec 2001 10:03:34 -0800, burdakov_at_vesco.ru (Aleksey Burdakov)
> > wrote:
> >
> > >Some questions concerned with Oracle Names 8.1.7:
> > >
> > >In case a networks with a NT server has no domain defined for it, and
> > >has no DNS service, what should I place in Oracle configuration files
> > >in order to make the Oracle Names Service work ?
> > >
> > >How should I configure Net8 8.1.7 client ? Should I place "world"
> > >instead of the domain name ? If I get it right, in the case when DNS
> > >is absent, a client could not automatically find Names Server via DNS,
> > >and I have to explicitly define it providing NT server name and
> > >default port 1575.
> > >
> > >Best Regards,
> > >
> > >Aleksey Burdakov
> >
> > If you don't have a DNS domain and no DNS service, you should setup
> > lmhosts on a server and use the appropiate directives on the clients
> > lmhosts to import the server lmhosts
> > The lmhosts file is located in %WINNT%\system32\drivers\etc
> > Further instructions are in the file.
> > You *must* use *any* dns mechanism with Oracle Names, as it won't
> > allow you to store hardcoded ip-addresses.
> > The client won't find any Oracle Names servers if they are not defined
> > in the names.preferred_servers section in sqlnet.ora
> >
> > Hth
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address
Received on Fri Dec 07 2001 - 13:29:55 CST