Re: What does it mean: ORA-12154?

When you connect to a DB using Sql*Net, you need:

	Username
	Password
	Database Connector

If your DB is local you need only username and password, but if it's in another Server, you also need a Database Connector.

For example, in Sql*Plus you can connect to a remote DB using:

        connect system/manager_at_server

Oracle searches the word server in the file tnsnames.ora (usualy in the directory ORACLE_HOME/network/admin or ORACLE_HOME/net8/admin). In this file there are an entry for server where you can see the tcp/ip address, the
SID of the DB, the port number and other things important to stablish the connection.

Your error message indicates that Oracle dont found the entry "server" in tnsnames.ora !!!!

NOTE: Sometimes, when you specify server as a database connector, Oracle searches in tnsnames.ora the word server.xxxxx (usualy xxxx=world). You cold see this in the file sqlnet.ora located in the same directory of tnsnames.ora. If exists are an entry default_domain=xxxxx then when you use server as database descriptor, oracle uses server.xxxxx.

										Albert Borrull
										SGO Software, S.L.
										<aborrull_at_sgosoft.com>

olvachis <olvachis_at_email.msn.com> escribió en artículo <uORy2hij9GA.73_at_upnetnews02.moswest.msn.net>...
> I've just installed Oracle 8 on NT. But I can't to access it: all the
 time I
> get
> "ORA-12154; TNS: could not resolve service name". What does it mean?
> And what should I do to avoid it?
> Thanks in advance,
> Oleg V. Chistyakov
>
>
>
>
>
  Received on Tue Jun 09 1998 - 00:00:00 CDT