Changing Username / Password for the Oracle Database Account

After a hierarchy has been created, change the Username and Password using one of the following procedures.

If $ORACLE_HOME is on shared (or replicated) storage (common in active-passive configurations):

1. 
   
2. On the system where the Oracle database resource is operational, edit the LifeKeeper configuration file /etc/default/LifeKeeper and add the following line to the file:

   LK_ORA_NICE=1

   Do exactly the same on each system in the cluster that has the Oracle resource defined.

3. Use sqlplus to change the Oracle user’s password.

   SQL> ALTER USER {username} IDENTIFIED BY {newpassword};

4. From the LifeKeeper GUI, right-click on the Oracle Database resource hierarchy, then select Change Username / Password.

5. Input Username and select Next.

6. Input Password and select Next.

7. Select the database user role and click Apply. Username and Password will be updated after validating.

8. Select Done.

9. Edit the LifeKeeper configuration file on all cluster nodes and make the following change:

   LK_ORA_NICE=0
   

If $ORACLE_HOME is on local storage and each node in the cluster has its own copy of $ORACLE_HOME (common in active-active configurations):

1. 
   
2. On the system where the Oracle database resource is operational, edit the LifeKeeper configuration file /etc/default/LifeKeeper and add the following line to the file:

   LK_ORA_NICE=1

   Do exactly the same on each system in the cluster that has the Oracle resource defined.

3. Use sqlplus to change the Oracle user’s password.

   SQL> ALTER USER {username} IDENTIFIED BY {newpassword};

4. From the LifeKeeper GUI, right-click on the Oracle Database resource hierarchy, then select Change Username / Password.

5. Input user name to use instead temporarily such as sys into Username and select Next.

6. Input Password and select Next.

7. Select the database user role and click Apply. Username and Password will be updated after validating.

8. Select Done.

9. Put the Oracle database resource “In Service” on one of the backup systems.

10. Once the database is running on the backup system, use sqlplus to change the Oracle account password.

    SQL> ALTER USER {username} IDENTIFIED BY {newpassword};

    When making this password change, use the new password that was set in Step 2. This process resets the security tokens in $ORACLE_HOME.

11. Put the database “In Service” on each node in the cluster and repeat Step 8.

12. Once the passwords have been changed on all cluster nodes, put the Oracle database back “In Service” on the desired node.

13. From the LifeKeeper GUI, right-click on the Oracle Database resource hierarchy, then select Change Username / Password.

14. Input Username and select Next.

15. Input Password and select Next.

16. Select the database user role and click Apply. Username and Password will be updated after validating.

17. Select Done.

18. Edit the LifeKeeper configuration file on all cluster nodes and make the following change:

    LK_ORA_NICE=0

Copyright © 2024 SIOS TECHNOLOGY CORP.