-
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 !
-
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.
-
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.
-
on windows you need to be in the ORA_DBA group
set ORACLE_SID=blah
sqlplus / as sysdba
-
oracle is in ORA_DBA group and lcoal administrators group, but i still got:
ORA-01031: insufficient privileges
what else i can check ? Thx.
-
hi...just try to logout and login as oracle
-
then you aren't in the ORA_DBA group or your sqlnet.ora has something wrong in int
-
-
Originally Posted by knitty
use orapwd utility
what has that got to do with anything?
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|