Re: Oracle Names and DNS

> 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 Thu Dec 06 2001 - 04:15:58 CST