Re: new to oracle

"DJ" <nospamplease_at_goaway.com> wrote in message news:UZ5Vb.907$cb7.6554_at_newsfep4-glfd.server.ntli.net...
>
> "ron" <ronaldl._at_flymail.fm> wrote in message
> news:c02k4p$12pe6e$1_at_ID-28118.news.uni-berlin.de...
> > Hi I am a student studying SQL and Oracle so I downloaded oracle version
> > 8.1.7 and installed it on my computer. Now here is the problem. I can't
> get
> > into it. I gave the database the name orac, the sid is orac, and the
> system
> > account password is manager. However on the password screen no matter
what
> I
> > use, I always get invalid username/password; logon denied. So what is
the
> > default password and user name?
> > Thanks Ron
> >
> >
>
> what tool are you using to connect
>
> try this
>
> open up a dos window
>
> set ORACLE_SID=orac
> sqlplus system/manager
>
> does that let you in?
>
> if not error message please

cut and paste of what I did

D:\Documents and Settings\Ronald>set oracle_sid=orac

D:\Documents and Settings\Ronald>sqlplus system/manager

SQL*Plus: Release 8.1.7.0.0 - Production on Sat Feb 7 15:46:54 2004

(c) Copyright 2000 Oracle Corporation. All rights reserved.

ERROR:
ORA-12560: TNS:protocol adapter error

Enter user-name: orac
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error

Hi, maybe I should have mentioned I'm trying to run this in Windows XP Pro. I was reading through the documentation and found a ref to Scott and tiger so I used them and I could get in. However, after I did as you suggested I now get the same error message and cannot get in with scott and tiger. Good job I set a restore point in windows xp pro so if the worse comes I can always go back and restore before I installed it and use scott and tiger.

Thanks Ronald Received on Sat Feb 07 2004 - 09:55:38 CST