The concept of a “Recycle Bin” plays a crucial role in data recovery and management. This feature, introduced in Oracle 10g, is akin to the recycle bin in Windows or the trash in macOS, providing a safety net for data that has been deleted. This article, we will discuss the recycle bin in Oracle, How […]
Login flow in R12.2 and basic troubleshooting
R12.2 is the latest Release of Oracle E-business Suite Products. Here we will be discussing the Login flow in R12.2 and how to troubleshoot login issues in R12.2 Login flow in R12.2 Here is the processing in terms of URL(Login HTTP headers) When the EBS login works OK, the browser will be redirected to various […]
How To Retrieve Instance Metadata from Server
We can retrieve Instance Metadata like OCID, Display Name, Region, Availability Domain, Fault domain, Compartment OCID, Instance shape, Subnet CIDR, etc in three ways. Using oci-metadata #oci-metadata Instance details: Display Name: tech Region: uk-london-1 Canonical Region Name: us-ashburn-1 Availability Domain: DSdu:US-ASHBURN-1-AD-3 Fault domain: FAULT-DOMAIN-1 OCID: ocid1.instance.oc1.us-ashburn-1.abwgiljrfu6w22gihsxj4h6m6ybabv3mb23edmqhj4kamvv2sdodk7voplfq Compartment OCID: ocid1.compartment.oc1..aaaaaaaamlbsubwajqyvzyrqas6e6sbl3iqp55u6yloyxmg4muaks5xvxbuq Instance shape: VM.Standard2.1 Image ID: ocid1.image.oc1.uk-london-1.aaaaaaaavrftjg3fa2uw5ndqin3tjme3jc4vpxnsysoxetlswsr6aqlfwurq […]
How to delete the archive logs in Oracle
Archive logs keep accumulating and we need to put things in place to delete them on a regular basis. We should not be deleting the archivelog from the filesystem directly as the Oracle Database is not aware of that and space is not released in the Flash recovery area Let’s see a few commands on […]
How to check block corruption in Oracle database and Fix it
Types of Corruption in Oracle There are two types of corruption. a. Physical corruption: This happens generally due to media corruption. In this case, the block does have an invalid checksum. It may contain zero. This is generally the result of infrastructure issues like media, network, and memory. RMAN block recovery can be used to […]
How To Backup Database To Cloud Object Storage Using DBCLI
We have automatic backup in DBCS which is managed by Oracle. The customer does not have any control over the bucket and we dont have enough flexibility. we can schedule the custom backup using dbcli to our bucket in our tenancy This will give more control over the backup and we can do replication to […]