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

Sue

When you create the new database, you need to tell Oracle how to get there. That's done by adding an entry to your tnsnames.ora file. Copy the one for the default database (if it's there) and change the SID to point to the new database (make sure you change the alias as well). Put the new alias in as the service name and you should be able to connect.

HTH. Pete

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.

Received on Fri Sep 17 1999 - 14:50:33 CDT