Announcements

Oracle training based on real-time expertise as per industry standards. Upcoming batch details are here.

View batch schedule

Free Oracle mock interview. Register using the link.

Register

#DBAchallenge: submit your questions.

Ask questions
Swipe for more →
Browse by Topic
Latest Posts

    Wednesday, July 24, 2024

    Can I have sys password and password file password different?

    Can I have sys password and password file password different?


    Ans: Yes 

    If you create the password file with a password different than the sys password, that'll be the password you use to connect as sysdba over a network (the password in the password file is used for sysdba connections)

    Facts about sys user password and password file

    1. SYS password is defined at the time of database creation 

    - Same password will be used to create password file 

    2. We can change the sys user password using SQL command 

    SQL> alter user sys identified by <password_1>;

    3. We can create a password file with a password other than sys user password

    orapwd file=orapw<SID> password=<password_2>

    4. It is best practice to keep both sys user and password file password to be same 


    5. Changing the sys password using alter user will automatically update the password file

    - Where as creating the password file with new password will not update the sys password inside database.  


    More details about the sys user password and password file password refer the below docs 

    Problem to connect as SYSDBA
    https://asktom.oracle.com/ords/f?p=100:11:0::::P11_QUESTION_ID:670117794561

    sys password change and orapwd file
    https://asktom.oracle.com/ords/f?p=100:11:::::P11_QUESTION_ID:1792735500346727875

    Regards,
    Mallikarjun / Vismo Technologies
    WhatsApp: +91 9880616848 / +91 9036478079
    Cell: +91 9880616848 / +91 9036478079
    Email: mallikarjun.ramadurg@gmail.com / vismotechnologies@gmail.com / info@vismotechnologies.com

    🌟 Proud to be an Oracle ACE Pro! 🚀

    🌟 Proud to be an Oracle ACE Pro! 🚀 I’m excited to share my official Oracle ACE Profile with the Oracle community. 👨‍💻 Mallikarjun ...