Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: can get log on to oracle 9i

Re: can get log on to oracle 9i

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 16 Dec 2005 11:03:21 +0100
Message-ID: <dnu2pi$5pv$1@news3.zwoll1.ov.home.nl>


oracle nubbie wrote:
> hello everyone, i am a student and trying to learn oracle. my problem
> is that i install oracle 9i on my computer, when i try to log on i get
> an error message saying, error, ora-12560:TNS: protocal adapter error.
> so i was wondering how can i change my user id and password so that i
> can enjoy the learning processes of oracle. i really need help badly
> totally lost at this time.
> the user id i try using was scott and password is tiger, my teacher
> say this would work but it doesn't can someone anyone please help me.
>

After you in stall Oracle, you should create an instance. If done as part of the installation process, you were asked questions about your network, and it should be ok.

For now, try this at the command line:
SET ORACLE_SID=ORCL
SQLPLUS SCOTT/TIGER

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Fri Dec 16 2005 - 04:03:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US