Re: Oracle 9i on Windows 98: Who is user 'P08'?

"Stefan Lasiewski" <flarg_at_flarg.org> wrote in message news:<S0bP9.476786$WL3.125867_at_rwcrnsc54>...
> Hi there,
>
> I just installed Oracle Personal Edition 9.0.1.1.0 on my Win98 machine. I
> went with all the defaults, and told the installer to create a database for
> me. Everything seemed to install fine, and I wrote down the global name,
> SID, etc.
>
> I start the database via the Windows menu "Start: Programs: Oracle: Database
> Administration: Start Oracle9i Database". Type in the password, and
> everything starts fine.
>
> Then I go to the Oracle 9i Navigator. I see an icon that says "Local
> Database", so I click on it, and it says "Invalid username/password". Note:
> This is the first time that I have ever visited this database.
>
> I right click on "Local Database", and I see that this icon has a "Username:
> P08" and an obscured password.
>
> I have no idea who "PO8" is, the installer never mentioned anything about
> this user, I can't find any information about this user in the docs, and I
> have no idea what the password should be.
>
> I've tried the following passwords, but none of these work:
>
> PO8 (and p08, po8, pO8, etc).
> tiger (since that's what 'scott' uses)
> demo
> password
> test
> manager
> change_on_install
> "" (blank)
>
> What is the password? Who is this "PO8" user? It seems that P08 is a generic
> name for "Personal Oracle 8", but I'm using 9i, and Oracle 8 has never been
> installed o this machine.
>
> Thanks for your help,
>
> -= Stefan Lasiewski

I am not familiar with Personal Oracle on Win 9x and what gets installed by default but one way out of your situation would be to login as SYS/change_on_install and verify if user PO8 exists in the database. If he exists then you can reset his password by,

SQL> alter user PO8 identified by new_password;

Regards
/Rauf Sarwar Received on Sat Dec 28 2002 - 13:17:09 CST