If you have forgotten, were never given or otherwise don't have the password to an Oracle database, never fear, there is a method to accessing the database. From the local machine you must be a user in the group "ora_dba". Run "sqlplus" (the command line version) with the option "/nolog", which tells SQL*Plus not to login. At the "SQL>" prompt, type "connect / as sysdba" which ought to log you in. At that point, you can change the password for any account (sys would be a good one to change, since apparently you don't know it) using the command alter user <username> identified by "<password>";. Make sure to commit; after doing that.
Connecting to Oracle Without a Password on Windows
No TrackBacks
TrackBack URL: http://dinomite.net/cgi-bin/mt/mt-tb.cgi/189
So, if you have admin access to a windows box, or if you've been delegated authority to manage users, you've successfully owned the oracle databases running on it?
What is sad is that this is a purposefully implemented feature, not a bug to be fixed.