Re: ORA-12154

Hi,

Thank you. So, do I need to 'create' it?

I am not familiar with ORACLE. My questions are:

1. Is there a default database (I guess so), and where are its physical files (I think one database has at least one tablespace, i.e. SYSTEM, and one tablespace has at least one physical file)?
2. Is there a default service name for the default database, and what is it?

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:964245085.592.1.pluto.d4ee154e_at_news.demon.nl...
> Tnsnames.ora exists in
> %ORACLE_HOME%\network\admin
> The default service name is usually Oracle not ORACLENT.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> "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?
> >
> >
>
>
Received on Sun Jul 23 2000 - 00:00:00 CEST