Re: Oracle 8i TNS Error

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 Thu Jul 27 2000 - 00:00:00 CDT