foalabs

Oracle EBS Lift and Shift from On-Premises to Oracle Cloud OCI using EBS Cloud Manager-Part 2 (Advance Provisioning) In one of the previous post I have shown how to use the EBS cloud manager to take backup from the On-Premises EBS environment. https://www.funoracleapps.com/2022/12/oracle-ebs-lift-and-shift-from-on.html Now with the help of EBS Cloud Manager we are going to provision the EBS Environment. 1) Lets go to backups and select appropriate compartment. We can observe that the EBS environment backup is available on Portal of EBS Cloud Manager. We will create Select Provision Environment. 2) Once the provision is selected, we are direct to a interactive page to provide required information. I have provided these values based on my environment. Installation details: Compartment Name Network Profile EBS Environment Name on Cloud Make sure we select the Tab for Provision from Object Storage. Provide the Backup Encryption password and the apps password from source system. Also en...

Issue Concurrent Manager Scheduler/Prereleases Manager status is System Hold, Fix Manager in Oracle Apps R12 Error: Issue Concurrent Manager "Scheduler/Prereleases Manager" Show   System Hold, Fix Manager Solution: select control_code    from fnd_concurrent_queues    where concurrent_queue_name = 'FNDSCH'; It will show 'H' as output 1. Take the backup of table fnd_concurrent_queues table create table fnd_concurrent_queues_DDMMYYY as select * from fnd_concurrent_queues; 2. Please run the following SQL statement : SQL> update fnd_concurrent_queues set control_code = null where concurrent_queue_name = 'FNDSCH'; SQL> commit; 3. Wait for few minutes before checking, the manager should be working fine. If you like please follow and comment

Migrate a Oracle Database 12.2 on OCI Compute VM We have oracle database backup pieces from a PROD Database. We need to restore and make it migrate on OCI Compute VM. As the DB size(50GB) is small and a custom Database I am using manual method this time. For this I have setup a Compute VM for  DB on OCI. Steps: 1) The compute instance was launched with Oracle linux 7.9 from OCI console. 2) I have attached a 200 GB block storage to have a file system /u01. pvcreate /dev/sda   Physical volume "/dev/sda" successfully created. [root@funebscustdb ~]# pvs   PV         VG Fmt   Attr PSize   PFree     /dev/sda       lvm2 ---   200.00g 200.00g [root@funebscustdb ~]# vgcreate vol_db1 /dev/sda   Volume group "vol_db1" successfully created [root@funebscustdb ~]# vgs   VG       #PV #LV #SN Attr   VSize     VFree       vol_db1   1   0   0 wz--n- <200.00g ...