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 !
Printable View
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.
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
use orapwd utility
what has that got to do with anything?Quote:
Originally Posted by knitty
Quote:
Originally Posted by davey23uk
orignial poster wanted a work around for the lost password for sys, and what he suggested is an alternative..
rgds
abhay
you should check your sqlnet.ora and change the authetication to NTSQuote:
Originally Posted by Jiangxi
rgds
abhay