Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Err 12154, please help
Look in your tnsnames.ora file. (ORACLE_HOME\net80\admin) and make sure the
name is listed there. (the tnsnames.ora on the workstation) Also try at the
server run sqlplus or vaw and do a loop back test. (log in as a user with
the name in the tnsnames.ora file. So if you have a user called Dirk with a
password of dirk and the tnsnames shows dirksdb then try connect
Dirk/dirk_at_dirksdb from a sqlplus or a vaw prompt. If that works then the
tnsnames.ora on the server is fine - doing this from the server. Copy the
tnsnames.ora from the server to the workstation and you should be good to
go.
Jim
Dirk wrote in message <779pd9$e97$1_at_news04.btx.dtag.de>...
>during I install Oracle 8 of NT4.0 oracle will create a starter database.
>In my case oracle create the database, but I can't make a connect.
>If I try to connect the system says "TNS 12154: could not resolve servie
>name".
>I installed Oracle on a other system, and I had no problems.
>
>What could I do ?????
>
>
>
>Thanks for helping
>Dirk
>
>
>
>dnerlich_at_yahoo.com
>
>
Received on Sun Jan 10 1999 - 11:59:49 CST