Re: Oracle 8i TNS Error

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