Oracle Names and DNS 
Author Message
 Oracle Names and DNS

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



Mon, 24 May 2004 02:03:34 GMT
 Oracle Names and DNS



Quote:
>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



Mon, 24 May 2004 06:38:00 GMT
 Oracle Names and DNS

Quote:
> 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 ?

Quote:
> 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

Quote:



> >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



Mon, 24 May 2004 18:15:58 GMT
 Oracle Names and DNS
I have many Oracle Names entries with the explicit address  (xxx.xxx.xxx.xxx) and no dns entry - they work fine..
( it may not be best practice, but we had to accommodate some older netware servers that did not do DNS lookup very well)..

Quote:



>>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

-----=  Posted via Newsfeeds.Com, Uncensored Usenet News  =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
 Check out our new Unlimited Server. No Download or Time Limits!
-----==  Over 80,000 Newsgroups - 19 Different Servers!  ==-----


Tue, 25 May 2004 23:12:35 GMT
 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

Quote:

> > 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




> > >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



Wed, 26 May 2004 03:29:55 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. DNS SYSTEM SQL 7 and DNS SYSTEM SQL2000

2. DNS - DNS-Less Error

3. connecting via IP addr versus connecting via DNS name

4. client connection fails with dns name for sqlserver

5. ODBC Data Source Name (DNS)

6. DNS-Names in Replication

7. Problems with SQL-Server 2000 Active/Active Cluster accessing via DNS name

8. W95 ODBC and DNS-name

9. DNS Alias for Named Pipes and IP-Socket

10. SQL ServerName vs DNS Name over Internet Replication

11. Client connection fails with dns name for sqlserver

12. DNS and service name


 
Powered by phpBB® Forum Software