Re: How to recover any SYSDBA user?

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 29 Jun 2006 14:37:20 -0700
Message-ID: <1151617040.575065.46490@y41g2000cwy.googlegroups.com>

Michael Walther wrote:
> I don't know how this happened by I think I have a Oracle 9.2 database
> that has no user with SYSDBA role anymore - no SYS, SYSTEM, etc.... I
> have passwords for all of them and can log on as "Normal" but get
> "ORA-01031: insufficient privileges" as soos as I specify:
> connect system/manager as sysdba
>
> Any help / creative idea is appreciated!
> Michael

Mr. Morgan used to recommend dropping the DBA role. You haven't done anything whacky have you?

Did you password file get clobbered? Received on Thu Jun 29 2006 - 16:37:20 CDT