Re: Installation of Oracle 9i personal editions for windows xp

On 16 Feb 2006 12:14:20 -0800, "novice" <amitnanda_at_gmail.com> wrote:

>HI
>
>About 2 months ago I installed Oracle 9i personal edition on my laptop
>having windows xp home edition. I followed instructions; downloaded the
>zip files into disk1, disk2 , disk3 , unzipped them, ran the
>installation successfully.
>
>I was working fine on SQL for some 15 days. Now when I'm trying to log
>in, I can't proceed. The system doesnot recognize any username/password
>combination.
>

what error? ora-1017? ora-1031? what username?

>Is it possible that the s/w expires some days after installation?

No, it doesn't.
>
>While I was downloading , I wondered why oracle would offer free
>software to download?

Why do companies like Mickeysoft, Oracle, and Quest offer free software. Because eventually you are going to buy it!

>
>Or am I doing something wrong?
>
>Any help would be greatly appreciated......thanks a ton.

fire up a dos box.
issue
set oracle_sid=<the sid of your database, defaults to ORCL> type sqlplus /nolog<return>
type connect / as sysdba<return>
this should get you in
Now type
alter user <username of any user for which you don't remember the password> identified by <new password without quotes>

That should be all.

BTW: Please read at least the Getting Started Manual (and the Concepts Manual).

--
Sybrand Bakker, Senior Oracle DBA