Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Oracle 10g Express
- Thread starter getjbb
- Start date
I am assuming 10g Express on a windows machine.
Since you are the administrator (presumed) make sure that you are a member of the ORADBA group. If memory serves this is true for administrators by default.
Then you can always login without a valid password, as the system will fail your credentials, and then check to see if you're a member of ORADBA. If you are, it will grant you access anyway.
Since you will now be logged in as a DBA, use a standard "alter user" statement to reset the sys password.
Regards
Tharg
Grinding away at things Oracular
Since you are the administrator (presumed) make sure that you are a member of the ORADBA group. If memory serves this is true for administrators by default.
Then you can always login without a valid password, as the system will fail your credentials, and then check to see if you're a member of ORADBA. If you are, it will grant you access anyway.
Since you will now be logged in as a DBA, use a standard "alter user" statement to reset the sys password.
Regards
Tharg
Grinding away at things Oracular
- Status
Similar threads
- Locked
- Question