Results 1 to 6 of 6

Thread: DBA Password!!

  1. #1
    Join Date
    Aug 2003
    Posts
    1

    Question Unanswered: DBA Password!!

    Hi ppl....

    I need to know what is the default password of DBA user. Also, plz tell me if somebody forgot the DBA pwd then how to retrieve / reset DBA password in oracle 8/8i ?? This is urgent, as i just forgot my pwd.... stpidity!!!

    Raheel.

  2. #2
    Join Date
    Jul 2003
    Posts
    3
    Hi

    The default password for "sys" user is change_on_install.
    If u forget ur dba passward ,u can recreate the password file by using
    "Orapwd" command.basically oracle maintains its dba passwords in password file.

    Muthu.

  3. #3
    Join Date
    Jul 2003
    Posts
    3
    Hi

    The default password for "sys" user is change_on_install.
    If u forget ur dba passward ,u can recreate the password file by using
    "Orapwd" command.basically oracle maintains its dba passwords in password file.

    Muthu.

  4. #4
    Join Date
    Sep 2003
    Posts
    3

    Re: DBA Password!!

    Originally posted by OraGenius
    Hi ppl....

    I need to know what is the default password of DBA user. Also, plz tell me if somebody forgot the DBA pwd then how to retrieve / reset DBA password in oracle 8/8i ?? This is urgent, as i just forgot my pwd.... stpidity!!!

    Raheel.
    - use svrmgrl and 'connect internal'
    - alter user 'user_name' identified by 'new_password'

    This will create a new password for a given user.

    regards.

  5. #5
    Join Date
    Jul 2003
    Location
    US
    Posts
    314

    Arrow Password

    Hi
    Here is it how it goes

    When u install Oracle, it creates 2 users : SYS and SYSTEM
    SYS has password : change_on_install
    SYSTEM has password : manager

    From what I think, u need the SYS password. In all possibilties the DBA would have changed the SYS password.
    U could use orapwd to create a new password file, if u have sufficient rights to write in the directory.

    Let me know if you need to know specifics of the same.
    Thanx and Regards
    Aruneesh

  6. #6
    Join Date
    Sep 2003
    Posts
    1

    The default password for sys is not working

    Hi, I have installed Oracle 9i on win xp but the default password for sys account which was supposed to be change_on_install is not working.... please help what else should I check before doing sqlplus.
    thanks.

Posting Permissions

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