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

 It generally means your TNS names is not setup correctly. Under Oracle 7.3 it would be found under

   %ORACLE_HOME%\network\admin\tnsnames.ora

Under 8.1.5i you should read:

   Net8 Administrator's Guide - I:\DOC\NETWORK.815\A67440\CH6.HTM

 and specificly section:

   file:///I:/DOC/NETWORK.815/A67440/ch6.htm#448222

Note: I:\ is my CD with Oracle 8.1.5 installation, please substitute with your oracle home directory (eg C:\Oracle\)

In article <O7YoG0TA$GA.276_at_cpmsnbbsa02>,   "Gil & Sue - 2NLuv2C" <cuaresma_a_at_email.msn.com> 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.
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat Sep 18 1999 - 00:12:41 CDT