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
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...Received on Mon Jul 24 2000 - 00:00:00 CEST
> 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?
>
>