2

I need to change some old databases SYS password because of security. I'm not DBA of these databases. I don't know if I will change SYS password what it will be happen.

What are the risks of changing oracle SYS password? What will be happen and how can I back to old password if I get some error?

I don't know current passwords, just I have root passwords of database machines(RAC / 2 machines).

Thank you.

3

There should not be any problems. Nobody should use this password for application purposes. In case of RAC cluster do not forget to change the password on each node. This password is not stored in the database but in local node's password file.

Unless you use Oracle Data Guard (physical replication). For some reason having the same password on each side is not sufficient and you must copy the amended password file to the other site too.

  • 2
    Tou will need to update any automated tasks that connect to this database using that credential. Typically there are cron scripts, scheduled jobs from Enterprise Manager etc etc that connect to the DB using the sys credential. – Andrew Brennan Jul 27 '16 at 12:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.