I have an Oracle 9i developer database on my Windows workstation. I havent used it in a couple weeks and forgot my Sysdba login password. Please advise how I can reset it or get into the database?
Your error, above, could have occurred for either or both of these two reasons:
1) You attempted to perform the above tasks as a user that is not a member of ORA_DBA group. (Check group membership via "Start -> Control Panel -> User Accounts"), or,
2) Your file, $ORACLE_HOME\network\admin\sqlnet.ora, must contain the setting:
Code:
SQLNET.AUTHENTICATION_SERVICES = (NTS)
Confirm the correctness of the above issues/settings, try again, then let us know your outcome.
Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.