91.9k views
2 votes
How to change system password in oracle 19c

User Immortal
by
6.7k points

1 Answer

0 votes

Final answer:

To change the system password in Oracle 19c, log in to SQL*Plus as a user with DBA privileges and use the ALTER USER command to set the new password for the system account. Ensure all necessary services or applications are updated with the new password.

Step-by-step explanation:

To change the system password in Oracle 19c, the process typically involves using the SQL*Plus or SQL Developer command-line utility. You will need to have the necessary privileges to alter the system password. Here is a general guideline on how to do this:

  • Log into SQL*Plus as a user with DBA privileges, for example, as sys user.
  • Use the ALTER USER command to change the system password. Execute the following command:

Replace new_password with the password that you want to set for the system account. It is important to follow strong password conventions for database security.

After altering the password, make sure to update any scripts, services, or applications that utilize the system account with the new password to ensure they continue to function correctly.

User Woong
by
6.5k points