So i noticed logrotate process is chewing a lot of CPU on a brand new Hardware (Oracle Database Appliance) tail /var/lib/logrotate.status "/u01/app/oracle/diag/crs/zsc-oda0-0/crs/trace/oifcfg_45354.trm" 2018-11-29 "/u01/app/12.2.0.1/oracle/rdbms/audit/+ASM1_ora_89696_20190201115423042224143795.aud-20190209.gz-20190215.gz-20190217.gz" 2019-2-20 "/u01/app/12.2.0.1/oracle/rdbms/audit/+ASM1_ora_65203_20181209123013319320143795.aud-20190209.gz-20190215.gz-20190217.gz-20190220.gz-20190226.gz" 2019-3-5 "/u01/app/12.2.0.1/oracle/rdbms/audit/+ASM1_ora_77256_20190122165831610096143795.aud-20190209.gz-20190215.gz-20190217.gz-20190220.gz" 2019-2-26 "/u01/app/12.2.0.1/oracle/rdbms/audit/+ASM1_ora_66149_20180615010539814998143795.aud-20190209.gz-20190215.gz-20190217.gz-20190220.gz-20190226.gz-20190305.gz" 2019-3-13 cp/rm/backup the /var/lib/logrotate.status file logrotate -vf /etc/logrotate.conf (Manually run logrotate) Main culprit (For my case), "/u01/app/12.2.0.1/oracle/rdbms/audit". As you can see it is rotating all … Continue reading “Intricacy”of logrotate (HIGH CPU)
ORA-16664/ORA-12514 Dataguard
So you've decided to you dataguard broker to manage your Primary and Standby. Everything was fine and dandy until you enabled the the configuration. Primary Standby the logs are shipping, and applying. PRIMARY database, set linesize 150 select inst_id,status,error from gv$archive_dest where dest_id=2; return the status as "VALID" Yet, when you run show configuration; (Primary) … Continue reading ORA-16664/ORA-12514 Dataguard
RMAN – install_driver(Oracle) failed: Attempt to reload DBD/Oracle.pm aborted
Recently I came across this issue while migrating our metrics and targets from Enterprise Manager 12c to Enterprise Manager 13c. Pretty much every backup jobs schedule from EM13c console for this particular node is failing with following error message. install_driver(Oracle) failed: Attempt to reload DBD/Oracle.pm aborted. Compilation failed in require at (eval 15) line 3. … Continue reading RMAN – install_driver(Oracle) failed: Attempt to reload DBD/Oracle.pm aborted
EM 13.2 Linux Repo setup failed
Linux RPM Repository Server Setup failed with generic error message on EM web console. Internal error in EM Patch Advisor CAUSE: A possible bug in EM Patch Advisor. ACTION: Report this issue to Oracle Support. Under /u01/app/oms132/gc_inst/em/EMGC_OMS1/sysman/log/emoms.log 2019-01-08 21:10:53,082 [RJob Step287428] FATAL jobs.GetULNChannels logp.251 - Internal error in EM Patch Advisor CAUSE: A possible bug … Continue reading EM 13.2 Linux Repo setup failed
gDBClone “GOLD” image and Snapshot database creation
PSA: gDBClone utility is developed by Oracle (Ruggero Citton) to simplify database cloning for non-production instances leveraging ACFS snapshots feature. Download gDBClone-3.0.2-92.noarch.rpm (as of 24Aug2018) export PATH=$PATH:/opt/gDBClone tree /opt/gDBClone/ /opt/gDBClone/ ├── gDBClone └── lib ├── gDBClone_AcfsUtils.pm ├── gDBClone_Clone.pm ├── gDBClone_DBConvert.pm ├── gDBClone_GetDBConnection.pm ├── gDBClone_Inventory.pm ├── gDBClone_LoggingAndTracing.pm ├── gDBClone_passwd.jar ├── gDBClone_PFile.pm ├── gDBClone_Queries.pm ├── gDBClone_Snap.pm ├── … Continue reading gDBClone “GOLD” image and Snapshot database creation
Simple Apex Apps using REST Data Services
Create Module Create Template Create Handler Following query will return RMAN Backup Duration in seconds format for latest RMAN job with backup_runs as ( select operation, status, object_type, start_time, end_time, to_char(start_time,'MM/DD/YYYY HH24:MI:SS') as char_start_time, to_char(end_time,'MM/DD/YYYY HH24:MI:SS') as char_end_time from v$rman_status where operation in ('RMAN','BACKUP') and OBJECT_TYPE like '%DB%' and STATUS = 'COMPLETED' and start_time = … Continue reading Simple Apex Apps using REST Data Services
Multiple Tomcat servers configuration
Parent Tomcat - apache-tomcat-9.0.12 Child Tomcat - <instance_name>-tomcat tar -xvzf apache-tomcat-9.0.12.tar.gz under /u02/tomcat, it will create apache-tomcat-9.0.12 directory cp -R apache-tomcat-9.0.12.tar.gz dev-tomcat (Create child instance directory from Parent) /u02/tomcat/dev-tomcat Keep only bin,conf,logs,temp,webapps, and work, also remove all the files from /u02/tomcat/dev-tomcat/bin and ADD setenv.sh vi /u02/tomcat/dev-tomcat/bin/setenv.sh export CATALINA_OPTS="$CATALINA_OPTS-Xms256m" export CATALINA_OPTS="$CATALINA_OPTS-Xmx1024m" export CATALINA_OPTS="$CATALINA_OPTS-XX:MaxPermSize=512m" At this point … Continue reading Multiple Tomcat servers configuration
Leveraging Linux Patching with Enterprise Manager 13.2
I will have my Enterprise Manager server and Linux Packages Repository Server on two different hosts. (It doesn't have to but my EM server and database is running on ODA X7-2-S so it is a little tight on storage) em-host Enterprise Manager Software, EM database repo-host Linux Repository EM 13.2 Installed and EM 13.2 agent … Continue reading Leveraging Linux Patching with Enterprise Manager 13.2
EBS RAC One Node on Oracle Database Appliance
I will be creating Oracle Home on Oracle Database Appliance bare metal infrastructure. Soruce Database Tier – run adpreclone.pl dbTier Soruce Application Tier – run adpreclone.pl appsTier Database Migration to Oracle Database Appliance (Single >>> RAC OneNode) create oracle_home using odacli odacli create-database -n ADT -cl OLTP -s odb16 -dh dce00acd-ea37-4949-8e60-d49b767dfceb -y RACONE -r ACFS … Continue reading EBS RAC One Node on Oracle Database Appliance
Oracle Journey 