Re: ORA-12154: TNS:could not resolve service name

From: Gary E. Grant <ggrant_at_crl.com>
Date: Fri, 17 Sep 1999 17:04:42 -0700
Message-ID: <37E2D71A.1BF3AEA3@crl.com>

look in the initORCL.ora or related file, you should see information that tells you what the SID is. Then look in the TNSNAMES.ora file to which DB instance on which server(machine) it is related to. To test out the TNSNAMES.ora file you can use TNSPING.

Gary :-)

Gil & Sue - 2NLuv2C wrote:

> Anyone ever get this error?
>
> I log into the Default DB fine if I leave the service box blank. But what I
> did was create a new DB in the DB Configuration Assistant then tried to log
> into the new DB using all of the default accounts and received this error.
> I have tried so many combinations of what the service name is, but keep
> getting this error. I am so sick and sleepy of this. Could anyone help? I
> know there is an article on the Oracle website but it didn't help either.
>
> And exactly how do you create an ODBC driver for Oracle? What are those
> extra fields about like UserID, DB Options, etc.
>
> I wouldn't be bothering you guys if I could get my hands on a good book (all
> I have is Oracle8i for Dummies).
>
> Given:
> Oracle8i Enterprise
> NT 4 Server
> ... (what else do you need to know???)
>
> Help, thanks, please!
> Sue.

Always glad to be of service,

Gary :-)

"There is nothing more difficult to take in hand, more perilous to conduct or more uncertain in its success, than to take the lead in the introduction of a new order of things."

Niccollo Machiavelli, The Prince, 1513

Received on Fri Sep 17 1999 - 19:04:42 CDT