+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 10 of 11
  1. 10-31-2007 02:25 PM #1
    Jiangxi
    Jiangxi is offline Junior Member
    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 !
    Reply With Quote Reply With Quote
  2. 10-31-2007 02:42 PM #2
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,484
    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.
    Reply With Quote Reply With Quote
  3. 10-31-2007 05:40 PM #3
    Jiangxi
    Jiangxi is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  4. 10-31-2007 06:41 PM #4
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,323
    on windows you need to be in the ORA_DBA group

    set ORACLE_SID=blah
    sqlplus / as sysdba
    Reply With Quote Reply With Quote
  5. 10-31-2007 07:37 PM #5
    Jiangxi
    Jiangxi is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  6. 10-31-2007 10:42 PM #6
    reeshe
    reeshe is offline Member
    Join Date
    Oct 2007
    Posts
    114
    hi...just try to logout and login as oracle
    Reply With Quote Reply With Quote
  7. 11-01-2007 04:19 AM #7
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,323
    then you aren't in the ORA_DBA group or your sqlnet.ora has something wrong in int
    Reply With Quote Reply With Quote
  8. 11-01-2007 02:14 PM #8
    knitty
    knitty is offline Junior Member
    Join Date
    Oct 2007
    Posts
    16
    use orapwd utility
    Reply With Quote Reply With Quote
  9. 11-02-2007 04:30 AM #9
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,323
    Quote Originally Posted by knitty
    use orapwd utility
    what has that got to do with anything?
    Reply With Quote Reply With Quote
  10. 11-02-2007 04:39 AM #10
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    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"
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules

 Click Here to Expand Forum to Full Width