Re: Installing Oracle WorkGroup Server on NT workstation and error TNS12154

osako wrote:
>
> Hello World,
>
> Has anyone been successful with installing and running WorkGroup Server 7.3
> for NT on NT workstation software (not the server version of NT)?
>

Yes. I've got it on both the workstation and servers.

> We installed the oracle server product without any error messages.
> Afterwards, everything appears to be working except for a few problems. (1)
> We get the error message "TNS12154 TNS could not resolve service name", (2)
> can not connect to the database using ODBC, and (3) can not successfully
> install the repository manager. We were successful with SQL Net Easy
> Configuration in setting up a Database Alias

Looks like a sql*net problem. Make sure the listener is up, and tnsnames.ora has been configuration properly.

>
> It is interesting to know that we can access the Oracle sample database
> from another remote workstation via SQL Plus 3.3; for example we can login,
> do a "SELECT * FROM DEMO.CUSTOMER" and able to list out the entire table.
>
> We are have used the Network Manager and Net Fetch to generate the
> Listener.ora Tnsnames.ora, and Topology.ora; we are experienced at odbc
> configurations. We are out of ideas. We think it may have something to do
> with NOT being installed on NT server software, but not sure.

No this is not the case. If so, you shouldn't even be able to connect to the database from the clients. Looks like your client's sql*net has been set up correctly, but not your own workstation. Can you ping yourself? As I say, it's more like a sql*net configuration problem.

Good Luck,
Leng. Received on Mon May 19 1997 - 00:00:00 CDT