Hi,
I'm new to Oracle DBA stuff, and have been attempting to install an Oracle 9i database on my machine. The installation was sucessful, however I think I may have mucked something up in the last stage of the install where it has a window for changing passwords and locking users.
I have tried to log into my new database (it is called 'db2'), but can't do so as any user with DBA type privileges.
I have tried the following:
- unsuccessfully logged on as system/manager and it says that this account is locked.
- unsuccessfully logged on as sys/change_on_install and it says "ORA-28009: connection to sys should be as sysdba or sysoper"
- unsuccessfully logged on as sysdba/sysdba and it says invalid password/username.
- unsuccessfully logged on as sysoper/sysoper and it says invalid password/username.
- successfully logged on as scott/tiger
The only thing I modified before clicking 'ok' at the user window after the install is that I put two ticks in the columns beside 'SYSTEM' and typed 'manager' as the password for this......(my guess is that one of these ticks were to lock this user - hmm silly me...)
Can anyone tell me how I can somehow recover or reset the SYSTEM password (or unlock this user)/ or advise me on what I am doing wrong? Any help / advice would be appreciated!!
Start Free Trial
