5 Resolving User Credential Issues after Database Restore
User incompatibilities may introduce security holes or prevent access to the network by administrators. Inconsistencies among users are not considered a threat to the database, however. Review each user difference carefully to ensure that the restoration will not impact security or accessibility.
5.1 Restoring a Deleted User
Figure 5-1 Testuser

5.2 Keeping a Restored user
Note:
If this procedure fails, contact My Oracle Support (MOS).- Establish a GUI session on the NOAM server by using the VIP IP address of the NOAM
server. Open the web browser and enter the following url
http://<Primary_NOAM_VIP_IP_Address>
. - Navigate to Administration, Access
Control, and then Users.
- Select the user and click Change Password.
- Enter a new password and click Continue.
5.3 Removing a Restored User
Note:
If this procedure fails, contact My Oracle Support (MOS).- Establish a GUI session on the NOAM server by using the VIP IP address of the NOAM
server. Open the web browser and enter the following url
http://<Primary_NOAM_VIP_IP_Address>
. - After restoration delete user:
- Navigate to Administration, Access Control, and then Users.
- Select the user and click Delete.
- Click Ok to confirm.
5.4 Restoring a Modified User
Before the backup and archive files were created, the passwords for these users are changed.
Figure 5-2 Test user

Before Restoration:
Verify access to an user with administrator permissions. Contact every impacted user and let them know that their password will be changed while this maintenance is being done.
After Restoration:
All users in this category should log in and have their passwords reset. To reset a user's password, follow the instructions in My Oracle Support (MOS).
5.5 Restoring an Archive that does not contain a Current User
These users have been created after the creation of the backup and archive file. The user will be deleted by system restoration of that file.
Figure 5-3 Test user

If the user no longer exist, do not perform any additional steps. The user is permanently removed.
Note:
If this procedure fails, contact My Oracle Support (MOS).- Notify affected users before restoration:
- Contact each user that is affected before the restoration and notify them that you will reset their password during this maintenance operation.
- Log in to the NOAM VIP:
- Establish a GUI session on the NOAM server by using the VIP IP address
of the NOAM server. Open the web browser and enter the following url
http://Primary_NOAM_VIP_IP_Address>
.
- Establish a GUI session on the NOAM server by using the VIP IP address
of the NOAM server. Open the web browser and enter the following url
- Navigate to Administration, Access
Control, and then Users. Under each
affected user, record the following:
- Username
- Account status
- Remote Auth
- Local Auth
- Concurrent Logins Allowed
- Inactivity Limit
- Comment
- Groups
- After restoration:
- Establish a GUI session on the NOAM server by using the VIP IP address
of the NOAM server. Open the web browser and enter the following url
http://<Primary_NOAM_VIP_IP_Address>
.
- Establish a GUI session on the NOAM server by using the VIP IP address
of the NOAM server. Open the web browser and enter the following url
- After Restoration recreate affected user and required group:
- Navigate to Administration, Access control, and then Users.
- Click Insert and recreate the user using the data collected in step 4 and click OK.
- Repeat step 5 to recreate additional users and groups.
- After restoration reset the passwords.