Ameer Khan

So I received the above error while dropping the bucket in OCI object storage. As the error reports there is files which are either being uploaded into the bucket or those files are stuck somewhere. As in our case there was no files were getting uploaded when I received the above error. To find out… Continue Reading

In this post I will show how to create database in oracle 19c using silent mode. Usually we create database graphically by calling database creation utility known as DBCA.But due to different reasons you may not have the possibility to install it graphically. So I will show how to create a database using DBCA in… Continue Reading

In this topic I would show simple steps of starting & stopping of EBS R12 database and application. Environment details :- Application Version R12.1.3 Database Version 11.2.0.4 OS RHEL 7.7 DB SID PRODTEST Application OS User Prodtestappl Database OS  User prodtestdb R12 install base /backup/prodtest Important facts to remember: – To start up R12 instance, first… Continue Reading

Oracle Database 19c Software Installation On Oracle Linux 7 using silent mode          Download Software Oracle Database 19c (19.3) Software (64-bit) The objective of creating this post is sometimes we face difficulties in database binaries installation and database creation graphically. So to mitigate the problem I will show how to do the software installation through command… Continue Reading

In this topic I will show how to easily mount an object storage as a file system in any linux system. In this case I am using a machine that is running on OEL 7 Step 1. Firstly, we will need to create a bucket in OCI. The steps of bucket creation is given in this… Continue Reading

In this topic I will show how to create an object storage in OCI  In OCI there are two kind of object storage available. To create an object storage in OCI Click on Create bucket Provide details for bucket creation. Take a note of namespace value. So the bucket is now created, we can now… Continue Reading

In this topic I would explain how to upload files from on premise machine to oracle cloud using CLI. Many customers like to place their on premise backup into cloud object storage for various reasons. In this post I would share the steps of how to upload the files into OCI object storage. Step 1… Continue Reading

One of the most widely used features in Autonomous Database on Shared Infrastructure (ADB-S) today is the ability to clone your database. This feature enables you to clone your source database easily and create another environment which can be used for development or testing purpose. There are three types of cloning methods available in ADB such as… Continue Reading

We often require to add additional block volume in OCI instance for different requirements. In this post I will show how to do this. Step 1. First Login to OCI console Step 2. Navigate to Block Storage à Block Volumes à Create Block Volume Step 3. Fill in the required information such as  Step 4. Once volume creation is… Continue Reading

Scenario:- While trying to disable archivelog, following error is reported. ORA-38781: cannot disable media recovery – have guaranteed restore points Solution:- Current environment details :- SQL> alter database noarchivelog; alter database noarchivelog * ERROR at line 1: ORA-38781: cannot disable media recovery – have guaranteed restore points Lets see what oerr utility says about this ora… Continue Reading