| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Name Server questions
Thank you Richard for the clarification of the host name (alias) that will run the well
known name servers (I was mistakenly called them "prefered" nameservers).
Listener.ora config contents (plagarized from Net8...getting started 6-16) for an instance of oracle with the sid SID and the global database name global_dbname.domain running on a listener called listener:
SID_LIST_LISTENER_NAME=
(SID_LIST =
(SID_DESC =
(SID_NAME = SID)
(GLOBAL_DBNAME = global_dbname.domain)
)
)
Sample host information for a NIS master/DNS or plain-jane tcpip client config file... /etc/hosts
666.123.123.002 a_usual_host_name oranamesrvr0
...
666.123.123.006 another_host_name oranamesrvr4
Where a_usual_host_name is the name of the machine that you are going to run the well known name server (wkns) and oranamesrvr0 is an alias that you give to that machine. Same goes for the other listing.
I said that the clients do not need software to connecct ... I misspoke (sorry). What I meant was that the clients don't need any config files (if you are using the oracle sqlnet... stuff). The client software will automatically find the well known name servers, but if you install a sqlnet.ora file, then the file must include the following line...
NAMES.DIRECTORY_PATH = (ONAMES,TNSNAMES) NOTE: If you are running the Oracle Enterprise Manager agent on a client system, it seems to want to have a tnsnames.ora file (won't properly use the nameservers). So only include the local databases in the tnsnames.ora file (and reverse the order in the path listed above).
Good luck,
SCott
Richard Woods wrote:
> Scott, Heidi:
>
>
>Received on Sun Jul 26 1998 - 11:36:56 CDT
> > Heidi,
> >
> > If you run the name server in its default mode with Oracle8, then your clients
> > should not need ANY client software to find the name server. This is achieved
> > through the dynamic discovery option (ddo) of the name server. If you configure
> > the listener properly, it will register any service that it represents (a
> > service could be a SID or another program) into the name server (this is the
> > plug and play - plug and pray part).
> >
> > Gotchas that you need to be aware of:
> >
> > 1. This stuff is only good for "simple" networks meaning one protocol.
> > 2. A name server has to be running before you start the listeners so that the
> > listerners can register their services into the nameserver on startup.
> > 3. The listeners have to be configured to look for the nameservers (there can
> > be more than one name server).
> > 4. The machines that runs the preferred(?) name server needs to have a special
> > name - on the tip of my tongue but can't get the name - something like onames0,
> > or onames2, ora onames3 (somebody help me with this).
> > 5. Name servers on 7.2 => are not as friendly to work with.
> >
> > I'm sure that there are other issues (just can't remember at this moment).
> >
> > Programmatically, you should be able to query the name server for all of the
> > services that it stores.
> >
> > If you have Oracle 8 on NT, you can use the Net8 Assistant to configure the
> > nameserver.
> >
> > For your clients, the sqlnet.ora file can be put in place so that if the
> > nameserver(s) cannot be found, they can look at a tnsnames.ora file instead.
> >
> > Hope this helps,
> >
> > SCott
> >
> > heidi wrote:
> >
> > > According to the documentation if you use the name server you don't need to
> > > have tnsnames.ora. If this is true I have the following questions:
> > >
> > > - Is the name server OracleNamesService80?
> > > - There is no names.ora file - should I create it? Where?
> > > - If I create a new database does this name server have to be refreshed? If
> > > yes, how?
> > > - Are there any other files that I should be concerned with?
> > >
> > > What I am trying to do is to hide the creation of a database in our
> > > application and allow the user to access it right away. I have found no
> > > programatic approach to this in the documentation or through the news
> > > groups. It all seems to point to a series of script files, utilities, and
> > > commands. My current method involes altering the tnsnames.ora, which may be
> > > a nightmare, especially on a network. This is all quite messy, but I have
> > > sorted it out and currently I can create a new database, but cannot use it
> > > until the ORCL service is restarted or the whole system is rebooted (not
> > > quite sure why?). As I was sifting through some documentation I came across
> > > the name server approach which may be easier to implement, but I can't seem
> > > to find the answers to my questions in the documentation.
> > >
> > > Should anyone know of even a better way, or perhaps something that I may be
> > > out-to-lunch on I would appreciate any bit of advice I can get!
> > >
> > > thank you,
> > > heidi
> >
> > ------------------------------------------------------------------------
> >
> > Scott Cote <scottcotexy_at_contractor.net>
> > Oracle DBA Consultant
> > Hive Software, Inc.
> >
> > Scott Cote
> > Oracle DBA Consultant <scottcotexy_at_contractor.net>
> > Hive Software, Inc.
> > 710 Rockcrossing Lane Work: (972) 672 - 6484
> > Allen Fax: (972) 396 - 7761
> > Tx Netscape Conference Address
> > 75002 Netscape Conference DLS Server
> > USA
> > Remember to remove the xy when replying. I had to do this due to spammers.
> > Additional Information:
> > Last Name Cote
> > First Name Scott
> > Version 2.1
 |
 |