Re: Oracle 8i TNS Error

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
> > > > >
> > > > >
> > >
Received on Fri Jul 28 2000 - 00:00:00 CDT