Re: ORA-12154

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: 2000/07/24
Message-ID: <8lhec0$b0l$1_at_porthos.nl.uu.net>#1/1


Have you tried to leave the Host field empty? PO8 has some defaults, and I think one of the is to register the default database, so that you wont have to specify the hostname.
Saves you configuring networks whereas everything is on one machine... ;) Nomore tns-12xxx errors.

Default logins:
sys/change_on_install (use for administrative tasks only) system/change on install (use for management tasks only) scott/tiger (if any demoes installed).

Use system to create more users.

--
Kind Regards,
Frank
"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 Mon Jul 24 2000 - 00:00:00 CEST

Original text of this message