End-Date all users from a Cloned 11i EBS Production Database Accept SYSADMIN

One off my customer wanted me to clone there live environment which was on 11.5.10.2 to a new environment called crmt. I was also asked to end date all the users accept sysadmin and Raf Hussain.

I managed to complete the clone in 2 day's which I though was pretty good. The next step was to end date all the users in fnd_user table accept SYSADMIN and RAF HUSSAIN. I used the following sql to end date the users and leave only sysadmin and Raf Hussain to have access to crmt environment.



Caution:
Before updating any tables through SQL*Plus, recommend you perform a backup of your system or backup the table to be updated using the following statement: SQL>CREATE TABLE FND_BKP AS SELECT * FROM FND_USER

update FND_USER set END_DATE = sysdate-1
where user_name not in ('SYSADMIN','RAF HUSSAIN')

Use TAR to backup Oracle 10g Home

Take a backup of the Oracle_Home using TAR on Linux

Command to use

tar cvfz dbcopy.tar.gz db_rac.10.2.0