Ameer Khan

While installing Autonomous Health Framework (AHF) on Oracle Linux 7 in azure vm, we faced the below error [root@az-psdvdb1 u01]# ./ahf_setup AHF Installer for Platform Linux Architecture x86_64 AHF Installation Log : /tmp/ahf_install_223200_6496_2023_01_11-23_33_23.log Starting Autonomous Health Framework (AHF) Installation AHF Version: 22.3.2 Build Date: 202212190711 PERL : /bin/perl [ERROR] : AHF-00074: Perl Modules not found :  Data::Dumper After going through the installation… Continue Reading

The Oracle and KPMG Cloud Threat Report identifies the key risks and challenges that organizations are facing as they implement and maintain cloud solutions. Securing an organization’s data and maintaining compliance require a security-first approach to culture and infrastructure, with a clear understanding of the shared responsibilities required for cloud security. Traditional Data Security Approaches… 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

Shell Script to run preclone on appstier vi /backup/appspreclone.sh #!/bin/bash. /RUP10F/apps/apps_st/appl/APPSUAT_ccuine18.env   #This is apps env filecd /RUP10F/inst/apps/UAT_ccuine18/admin/scriptsperl adpreclone.pl appsTier <<EOF   #Provide apps password as per your envappsuatEOF $ chmod 775 /backup/appspreclone.sh Now schedule it in crontab crontab -e 1 0 * * * /backup/appspreclone.sh 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

Shell Script to run preclone on dbtier vi /backup/dbpreclone.sh #!/bin/bash. /RUP10F/db/tech_st/11.2.0/UAT_ccuine18.env   #This is database env file.cd /RUP10F/db/tech_st/11.2.0/appsutil/scripts/UAT_ccuine18perl adpreclone.pl dbTier <<EOF   appsuat   # Provide apps password as per your envEOF $ chmod 775 /backup/dbpreclone.sh Now schedule it in crontab crontab -e 0 0 * * * /backup/dbpreclone.sh 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

Issue : While registering a database as a target in OEM 13c the agent was failing during start with following error  ‘Availability Evaluation Error’ Solution:- To resolve the issue make I followed the following steps in following order . Run this from db target server which you are trying to add as a target in OEM… Continue Reading

No ADR homes are set Recently for one my customer, I upgraded database from 12c to 19c. So after upgrade when I tried to use adrci utility It showed me “No ADR base is set” message [oracle@oda02 ~]$ adrci ADRCI: Release 19.0.0.0.0 – Production on Sun Nov 20 12:12:58 2022 Copyright (c) 1982, 2019, Oracle and/or its… Continue Reading

By default oracle stores audit data in system tablespace. Most of the customers tend to keep it in default tablespace but as a best practice its best to move the AUD$ table in a non system tablespaces. Step 1:-To find out existing tablespace of AUD$ table:- SQL> select owner,segment_name,segment_type,tablespace_name,bytes/1024/1024 as Size from dba_segments where segment_name=’AUD$’; OWNER           SEGMENT_NAME         SEGMENT_TYPE       TABLESPACE_NAME       Size—————… Continue Reading