Re: How to recover any SYSDBA user?


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?

.

Relevant Pages

  • Re: something magic about SYS.LINK$ ?
    ... > Maxim Demenko wrote: ... > I shouldn't be able to get any of the sys.%$ tables, ... passwords for the accounts. ... With a SYSDBA privileged account these ...
    (comp.databases.oracle.server)
  • Re: something magic about SYS.LINK$ ?
    ... A little further hunting shows that there are only 2 of the sys.$ ... passwords for the accounts. ... With a SYSDBA privileged account these ... if O7_dictionary_accessibility is set to false, so never had an idea to verify it... ...
    (comp.databases.oracle.server)
  • Re: [9fans] Problems setting up a cpu/auth/file server
    ... Should I assign passwords to sys and adm? ... no, you should login as the user you want to be the hostowner, ...
    (comp.os.plan9)
  • How to recover any SYSDBA user?
    ... 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.... ...
    (comp.databases.oracle.server)