Re: Oracle Names

Gee, guess I'm not the most competent person to help you with your problem, because I'm trying to implement ONames Server without any success so far on the Windows NT environment...:( Anyway, here are few ideas, that might help you.

-What is the version of sql*net you are using? AFAIK Dynamic Discovery of services is supported since v2.3. (???) if I remember correctly.

-Your database listener has to know somehow, that there's a names server connected to the network, so in the database server there has to be either preferred.names_server parameter in the sqlnet.ora file or you must use namesctl reorder_ns to create file oracle_home\net80\names\sdns.ora. In case you are using reorder_ns, your names server(s) must have ip-aliases like oranamesrvr0 and use port 1575 for network listening, so namesctl utility can automatically find them.

Cheers,
Juhan

Mike wrote:
>
> Hi Subject Matter Experts,
>
> I am new to Oracle DBA work, my field being unix system administration.
> Recently, I was tasked with installing Oracle Names server in a
> mixed oracle environment, i.e., 7.3.4, 8.0.4, 8.0.5 etc... I got
> this job since I'd been to oracle classes and am now a "DBA".
> Well, I know and you know it ain't that easy junior!!! Anyway --
>
> As of right now I have had success with using the names server to
> register the services on the oracle 7/8 databases (where one host
> has both 7 and 8, with the 7 db(s) using the 8 listener), and on
> straight 8 databases (all versions). This is a Test and Integration
> environment, which is why we are all over the oracle version map.
>
> However, I cannot get a straight 7 db to register with the names
> server (8.0.5). The only way to get them into the names server
> is to manually add them, not a good solution for us...
>
> Is this an oracle problem, or did I not do something right?
>
> This is what I've done so far:
>
> Relinked everything in the 7 database.
> Attempted to register manually though lsnrctl.
> Tried numerous modifications to the sqlnet.ora and listener.ora file.
> Reread everything I can get my hands on concerning oracle names...
>
> I'm at my wits end...
> Any suggestions, comments appreciated...
>
> --
> Please remove ".nojunkmail" from my
> address before replying............
Received on Tue May 04 1999 - 10:52:16 CDT