Tuesday, 22 February 2022

tar -cvzf - apps tier

 cd /apps/PROD

ls

applcsf  EBSapps.env  fs1  fs2  fs_ne  nohup.out  pairsfile  webgate11g 

Mention full directory where you wanted to take the backup in screen or tmux.

nohup tar -czvf /bkp/appstier.tar.gz *

nohup: ignoring input and appending output to 'nohup.out'

---DB home 
cvzf

cd /u01/app/oracle/product/19.0.0.0

nohup tar -cvzf  /stage/vijp/tar/DB_OH_clone_vijp_1Jan23.tar.gz dbhome_1 &

xzvf

cd /data/vij/product/19.0.0.0

nohup tar -xzvf /stage/vijp/tar/DB_OH_clone_vijp_1Jan23.tar.gz dbhome_1 &


--apps tier
--on source

cd /prdapps/vijp/apps/fs1

nohup tar -cvzf /stage/CLONE/1Jan23/vijp_EBSapps_run_1Jan23.tar.gz EBSapps &


--on target

/sitapps/REISIT/apps/fs1

$ nohup tar -xzvf //stage/CLONE/1Jan23/vijp_EBSapps_run_1Jan23.tar.gz EBSapps &

$ jobs

[1]+  Running                 nohup tar -xzvf 



Sunday, 20 February 2022

EBS - R12.2 install_group_num should be always 1

 -----------At this point it updates install_group_num to 0 (Zeor


select oracle_username, install_group_num from APPS.fnd_oracle_userid

where read_only_flag='U';

If it is 0 , update below.


update fnd_oracle_userid

set install_group_num = 1

where install_group_num = '0'

and read_only_flag = 'U';


--------------


SQL Shared Area - BIND MISMATCH