Re: Could not resolve service name ORA-12154

Oracle 7.3 is *dead* in another 4 days!

If you are on the same system as the database make sure you set ORACLE_SID, either in the registry or as environment variable. If you are not on the same system, you need to configure sqlnet, both tnsnames.ora and listener.ora. This is not done automatically for you after install.
A query in the Getting Started Manual or the Network Administrators Guide should provide sufficient answers.
In your post you provide insufficient detail for us to create your listener.ora, and tnsnames.ora for you.

Regards,
Sybrand Bakker, Oracle DBA

"Anthony Mak" <tony_at_lis.co.jp> wrote in message news:92bv9r$kq8$1_at_nnrp1.deja.com...
> Dear all,
>
> I have installed Oracle 7.3 Server on a NT 4 Server. After the
 installation,
> I tried to use the Security Manager to add some user, but I got the
 following
> error message : "ORA-12154: TNS: could not resolve service name"
>
> What is a service name and TNS?
>
> What should I need to do in this case? All I want to do is be able to add
 a
> user.
>
> Anthony
> -------------------------
> Anthony Mak (Sydney, Australia)
> anthony.mak_at_iname.com
>
> --
> -------------------------
> Anthony Mak (Sydney, Australia)
> anthony.mak_at_iname.com
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Wed Dec 27 2000 - 02:49:24 CST