How to change system password for Oracle 9i

Posted on 2004-11-24
Last Modified: 2008-02-20
I have an Oracle 9i server. I want to change the "system" password for the same and I am not aware of the old password.

Please suggest how I can do the same.

Question by:anandabrata
    LVL 12

    Expert Comment

    Do you have any user with DBA privileges? If you have one, then login and change the system password..

    alter user system identified by new_password;

    Author Comment

    I do not have any user with dba permission. But I have heard that the "sys" user has dba priviliges. I am not sure incase sys and system are the same user. And even if they are not then is the default password of the sys user change_on_install.

    I tried sys/change_on_install as sysdba ..the same is also not being accepted at prompt. Isn't there any other way to resolve this issue.
    LVL 12

    Accepted Solution

    sys - default password is change_on_install
    system - manager

    If you can login as sys (or any user with dba privileges) then it's easy to change the password for system user...

    Else,if you are using a password file, then you can change it. Following are the links :

    Else, ask someone who has the sys login information...

    Expert Comment


    You know need to have SYS password if your loging from same server where database is installed.

    if its windows:
    Start->Run-> sqlplusw /nolog
    SQL> connect / as sysdba
    SQL> aler user system identified by manager;
    SQL> connect system/manager

    if its unix:
    oracle$ sqlplus /nolog
    SQL> connect / as sysdba
    SQL> aler user system identified by manager;
    SQL> connect system/manager

    Velu N

    Expert Comment

    Hi use this statement:
    >conn sys / as sysdba

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
    Creating and Managing Databases with phpMyAdmin in cPanel.
    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…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    754 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

    20 Experts available now in Live!

    Get 1:1 Help Now