Re: Problems with Oracle Names

Have you reconfigured SQL*NET?

The defaults in the SQLNET.ORA file refer to the domain "WORLD" which you will undoubtedly want to change to whatever your domain name is.

Similarly, your TNSNAMES.ORA file will be pointing to "world". Assuming you are working on a network with either TCP/IP or SPX/IP, lauch your SQL*NET EASY CONFIGURATION and input the new aliases, database names, SIDs, IP/SPX addressing, or whatever it is that is requested.

Then try to access through sql*plus again.

BTW, these SQLNET.ORA and TNSNAMES.ORA files need to be on the client in the ORANT\NETWORK\ADMIN folder (by default, unless you've changed the pathing).

The alternative to using EASY CONFIGURATION is to simply open the two aforementioned files in notepad (in fact you'll have to do this for SQLNET.ORA). Enter in your own values based on the way the default entries are (except for the "world" bit). But don't try to view it under EASY CONFIG after this as it will tell your files are incompatible and want to save them as *.OLD or *.001 or something.

Hope this helps and answers your question.

Jonathan
Fredrik Håkansson wrote:
>
> I'm going to set up an Oracle Server with Oracle Names. With Network Manager
> I have created a Network Definition and generated the client and server
> files to the filesystem and I haven't had any problems connecting to the
> database. Then I created the Namestables, opened the Networkdefinition,
> saved it to the database and generated the client and server files again and
> distributed them. Then I restarted the server and tried to connect to the
> database from SQLPlus but I get the errormessage TNS12154 TNS could not
> resolve name. Does anyone recognize this problem or have a tip for a
> solution I'll be happy to hear it.
>
> TiA
Received on Tue Jan 27 1998 - 00:00:00 CST