Re: Oracle 8i TNS Error

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 CEST