DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: How to login without sys passowrd ?

  1. #1
    Join Date
    Jan 2007
    Posts
    22

    How to login without sys passowrd ?

    We have Oracle 10G running on windows 2003 server, and we are not figour out what was the password , wondering if there is anyway to work around ? We are login as local system administrators on the box. Thanks !

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Login into the target server as ORACLE; assuming ORACLE is the O/S account that installed Oracle software and also that this account belongs to dba group.
    export target ORACLE_SID
    export target ORACLE_HOME
    sqlplus /nolog
    conn sys as sysdba
    When prompted for password just hit Enter key.
    At this point in time you are in and you can just alter user sys identifies by "YOURNEWPASS".
    Good luck.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Jan 2007
    Posts
    22
    Thanks, PAB,

    1) i got " export is not recognized command", be aware of that it's Windows 2003 server, not unix/linux system.

    2) i do log on as "oracle", but got error "ORA-01031: insufficient privileges", how am i able to check if "oracle" belongs dba group ? How do assign an OS account to Oracle as dba member ?

    Thanks.

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    on windows you need to be in the ORA_DBA group

    set ORACLE_SID=blah
    sqlplus / as sysdba

  5. #5
    Join Date
    Jan 2007
    Posts
    22
    oracle is in ORA_DBA group and lcoal administrators group, but i still got:

    ORA-01031: insufficient privileges

    what else i can check ? Thx.

  6. #6
    Join Date
    Oct 2007
    Posts
    114
    hi...just try to logout and login as oracle

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    then you aren't in the ORA_DBA group or your sqlnet.ora has something wrong in int

  8. #8
    Join Date
    Oct 2007
    Posts
    16
    use orapwd utility

  9. #9
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    Quote Originally Posted by knitty
    use orapwd utility
    what has that got to do with anything?

  10. #10
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Quote Originally Posted by davey23uk
    what has that got to do with anything?

    orignial poster wanted a work around for the lost password for sys, and what he suggested is an alternative..

    rgds
    abhay
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

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