System and Sys User Password Problem?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: System and Sys User Password Problem?

  1. #1
    Join Date
    Sep 2003
    Posts
    8

    Question System and Sys User Password Problem?

    How can I change the passwords for the two users System and Sys if i've forgot them both

    Cheers,

    Nick

  2. #2
    Join Date
    Sep 2002
    Posts
    376
    If 8i, connect as internal for which it won't ask the password
    If 9i connect ' / as sysdba'

    But you should belong to dba group at the OS level.

    Alter user sys identified by superuser;
    Alter user system identified by superboss;

  3. #3
    Join Date
    Jul 2002
    Posts
    335
    Originally posted by bang_dba
    If 8i, connect as internal for which it won't ask the password
    If 9i connect ' / as sysdba'

    But you should belong to dba group at the OS level.

    Alter user sys identified by superuser;
    Alter user system identified by superboss;

    Forgotten?! Could you use orapwd as well?

  4. #4
    Join Date
    Jan 2003
    Location
    Denver
    Posts
    152
    They never wrote them down here on the Windows instance.

    8i connect internal WANTED a password.

    orapwd util did not work UNTIL I avoided term services and went local on the box then the new password got me in.

  5. #5
    Join Date
    Jan 2001
    Posts
    3,131
    Am I the only one that is very skeptical when I read posts like this?
    This happens a LOT lately, either we have a lot of DBA's that need some Ginko ASAP or I am calling bullsh*t.

    MH
    I remember when this place was cool.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width