Connecting to Oracle Without a Password on Windows

| 1 Comment | No TrackBacks

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.

No TrackBacks

TrackBack URL: http://dinomite.net/cgi-bin/mt/mt-tb.cgi/189

1 Comment

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.

Leave a comment

Pages

About this Entry

This page contains a single entry by Drew Stephens published on December 4, 2007 7:56 AM.

Disconnecting: Corrupted MAC on input. was the previous entry in this blog.

Custom Weather Radar Images is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.