Resetting Oracle Password

Posted on 2007-08-09
Last Modified: 2013-12-19

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
svrmgrl>connect internal as sysdba
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!
Question by:inf2300
    LVL 18

    Accepted Solution

    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 :)
    LVL 17

    Assisted Solution

    Hi inf2300,

    There are quite a number of post on reseting of the oracle sys password. Check solution in

    LVL 1

    Expert Comment

    Forced accept.

    EE Admin

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
    Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now