Re: ORA-12154

"Raymond Wong" <raymond.wong_at_hk.origin-it.com> wrote in message news:8lb1ss$nh71_at_imsp212.netvigator.com...
> Dear all,
>
> Please help me out.
>
> I am new to ORACLE. I download Personal ORACLE 8i and Developer and start
> exploring.
>
> I can login as SYS using SQL Plus. I think I am connecting to some default
> database using default setting (though I change the password). Now I am
> trying to start Schema Builder and login as follows:
>
> User: SYS
> Password: mypassword
> Host: ORACLENT
>
> An error message ORA-12154: TNS: could not resolve service name
>
> I check the document and it says I should check TNSNAMES.ORA, but I cannot
> find the file. How to create one of that?

The default SID is usually ORCL.

Anyway, tnsnames.ora is usually maintained by a front-end configuration program called either SQL*Net Easy Config or Net8 Easy config. See which you have (you might even have both). Go into whatever one, or both, and enter in the information. You'll need host name which is the machine name's IP address or alias (not sure what that'll be if it's personal oracle...or if you even bother with tnsnames.ora at all in that case - I never worked w/personal oracle myself) and you'll need the SID name (ORCL or whatever your database name is.

-Matt Received on Sat Jul 22 2000 - 00:00:00 CEST