• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2817
  • Last Modified:

Resetting Oracle Password

Hello!

I've been beating my head against the wall trying to reset the password for an Oracle 8.1.5 database.  I've tried the following and this seems to be the consensus on how it should be done.

 You have to go to server machine and logon as OS user
that has installed Oracle (it belongs to DBA group or something like this).
After that you can
C:\>svrmgrl
svrmgrl>connect internal as sysdba
connected
Now try to change the SYS password:
svrmgrl>alter user sys identified by manager;
If this runs successful you will be able to logon

svrmgrl>connect sys/manager as sysdba

However I still get prompted for a password! I'm logged in  with an account that is a domain admin and a member of the ORA_DBA group.  

Please help!
0
inf2300
Asked:
inf2300
2 Solutions
 
rbrookerCommented:
have a look in your sqlnet.ora file, if there is something like :
sqlnet.sqlnet.authentication_services = ( some values here )

if there is, comment this line out and try again.

good luck :)
0
 
NicksonKohCommented:
Hi inf2300,

There are quite a number of post on reseting of the oracle sys password. Check solution in http://www.experts-exchange.com/Database/Oracle/Q_20570762.html?sfQueryTermInfo=1+password+reset+sy

Cheers,
NicksonKoh
0
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now