Re: Oracle 8i TNS Error

When you get cannot resolve service name it is the problem with tnsnames.ora and sqlnet.ora

The points of interest are

DEFAULT.DOMAIN_NAME in sqlnet.ora ( Ex. lets say .world )

then in your tnsnames.ora you should have the same extension in tnsnames.ora against the service name (EX. ORCL.WORLD).

If the match you can connect using usename/passwd_at_ORCL, Otherwise you have to fully qualify saying username/passwd_at_ORCL.world.

In article <3981D317.FAC6C41A_at_t-online.de>,   Thomas Woisczyk <Thomas.Woisczyk_at_t-online.de> wrote:
> By the way:
> set in the sqlnet.ora file
> trace_level_client=ADMIN
> and look for the file sqlnet.log or sqlnet.trc there you can look
> how ORACLE resolves the Names.
>
> Thomas Woisczyk wrote:
>
> > Hi,
> > you can look in the Registry if ORACLE_HOME is set correct.
> > Did you connect with plus80 system/manager_at_SID in a CMD-box or with
 the OEM?
> >
> > Thomas Woisczyk
> >
> > Daniel Suarez wrote:
> >
> > > I've checked my NT Services and confirmed the listerner to be
 running. I
> > > verified the ORA files to contain the same tnsalias-names that I
 am using to
> > > attempt to connect to the database directly.
> > >
> > > I still get the same darn error message.
> > >
> > > Daniel
> > >
> > > "Thomas Woisczyk" <Thomas.Woisczyk_at_t-online.de> wrote in message
> > > news:39807539.35377C8F_at_t-online.de...
> > > > Hi,
> > > > first you should configure your network. Look at the files
 sqlnet.ora and
> > > > tnsnames.ora.
> > > > There you can find the tnsalias-names of the Databases. The
 files are in
 the
> > > > directory
> > > > "ORANT\net8\admin"
> > > > There you can also find the file listener.ora to configure your
 listener.
> > > >
> > > > Thomas Woisczyk
> > > >
> > > > Raymond Wong wrote:
> > > >
> > > > > Hi,
> > > > >
> > > > > I am a newbie too. I think it is very coincident that I have
 met this
> > > > > problem too and just fix it today.
> > > > >
> > > > > First, after you set up the listener, net service names. You
 need to
 start
> > > > > the listner by:
> > > > >
> > > > > lsnrctrl start
> > > > >
> > > > > Then you need to restart your database. This is the first
 point that I
 got
> > > > > stuck. Second, if you use OEM, I think it will ask you for
 the host
 string,
> > > > > give it the name you assigned to the database when you
 installed ORACLE,
> > > > > plus a dot and the NT's identification (you get it by right
 click on
 Network
> > > > > Neigbourhood, choose property and then the Idenfication tab
 floder).
 This
> > > > > is the second point I got stuck.
> > > > >
> > > > > "Daniel Suarez" <dsuarez_at_wishbonesystems.com> wrote in message
> > > > > news:39804f51_2_at_nntp2.nac.net...
> > > > > > I've just installed Oracle 8i on Windows NT on Intel based
 architecture.
> > > > > > This is my first installation of Oracle ever - hence a
 newbie ;o)
> > > > > >
> > > > > > I have setup the following services:
> > > > > > 1. Oracle Names Servers
> > > > > > 2. Net Service Names
> > > > > > 3. One Listener
> > > > > >
> > > > > > These services, with the exception of the Oracle Name Sever,
 are using
> > > > > > TCP/IP.
> > > > > >
> > > > > > When I try to log onto the DB that was installed with the
 Oracle
> > > > > > installation using the "Oracle Enterprise Manager Login"
 prompt I get
 the
> > > > > > following error:
> > > > > >
> > > > > > "ORA-12154: TNS: Could not resolve service name."
> > > > > >
> > > > > > I've read and re-read the documentation that come with the
 CDs but I
 am
> > > > > > completely stumped.
> > > > > >
> > > > > > Thank You for your time and all and any suggestions you may
 have
> > > > > >
> > > > > > Daniel Suarez
> > > > > >
> > > > > >
> > > >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jul 28 2000 - 00:00:00 CDT