I will shift your local oracle database and apex to oracle cloud

Prepare the local database for the transfer:

• Backup the existing database to ensure you have a backup in case of any issues during the transfer.
• Create the .dmp file of the local database using the Oracle Data Pump Export utility.

Store the .dmp file in Oracle Cloud Infrastructure (OCI) Object Storage:

• Create a new bucket in OCI Object Storage for the .dmp file.
• Upload the .dmp file to the bucket.

Import the .dmp file into the Oracle Cloud database:

• Create a new database instance in the Oracle Cloud if you haven't already done so.
• Use the Oracle Data Pump Import utility to import the .dmp file into the Oracle Cloud database.
• Verify that the data has been imported correctly by running SQL queries against the cloud-based database.

Configure network security settings:

• Ensure that the necessary ports are open in the cloud security group to allow access to the cloud-based database.
• Configure the firewall to allow incoming connections from the local machine to the cloud-based database.

Test the transfer:

• Perform tests on the cloud-based database to ensure everything has been transferred correctly and the data is accessible and usable.