Oracle Apps DBA

Issue: In 19c database, while generating AWR report from PDB level, got the below error.  In 12cR1 - We can only generate statistics and run the Workload Repository (AWR) report from CDB level.  Since 12.2, if we want to generate statistics and run AWR report from PDB level, we have to change  awr_pdb_autoflush_enabled parameter to TRUE. Error: ERROR at line 1: ORA-20200: Database/Instance 2832289441/1 does not exist in AWR_PDB_DATABASE_INSTANCE ORA-06512: at line 27 Solution: alter session set container=ORCL; >>>>   Set the container Name alter system set awr_pdb_autoflush_enabled=true; conn system/<pwd>@orclcdb     >>>> Login into PDB database alter system set AWR_SNAPSHOT_TIME_OFFSET=1000000 scope=both;   >>> Set the arameter to avoid performance issue while generating snapshot at the same time in CDB and PDB level. exec dbms_workload_repository.create_snapshot(); SQL> @?/rdbms/admin/awrrpt.sql Console Log: SQL> show pdbs       CON_ID CON

Issue: Got the following error while setting preferred credentials for the host target ERROR: Invalid username and/or password LOG: Local Authentication failed...Attempt PAM authentication...PAM failed with error: Authentication failure Cause: For LADP kind of authentication PAM setup should be done. Solution: Make sure that PAM libraries are installed  rpm -ql pam-1.1.1-4.el6 | grep libpam.so you should see the output like below. /lib64/libpam.so.0         /lib64/libpam.so.0.82.2    If not installed, install the pam-1.1.1-4.el6 rpm and verify again. And then  as root user, do the below. cd /usr/lib64 ln -s /lib64/libpam.so.0.82.2 libpam.so cd /etc/pam.d cp sshd emagent go to $AGENT_HOME/bin backup commonenv Add the following line if [ "$LD_LIBRARY_PATH" = "" ] ; then LD_LIBRARY_PATH=/lib64 else LD_LIBRARY_PATH=:$LD_LIBRARY_PATH fi Restart Agent ./emctl stop agent ./emctl start agent

Overview: Installing a management agent in silent mode is only an alternative option to installing the agent using “Add Hosts” from console. “Add Hosts” target wizard will be useful if you want to install the same OMS version of management agent. For example, if your OMS version is 13.2, you can install only 13.2 version agent on target hosts.  If your target host OS version is not compatible with 13.2 version agent then you must go for 12.1.5 agent, this scenario will be opt for this blog. This post about install 12.1.5 agent in silent mode, High level steps: 1.        Download 12.1.0.5 agent software from OEM server. 2.        Update agent.rsp. 3.        Install the agent through agentDeploy.sh script. Download 12.1.0.5 agent software from OEM server: ./emcli setup -url=https://omsserver.domain.com:7803/em -username="sysman" -password="pwd" ./emcli login -username=sysman ./emcli sync ./emcli get_supported_platforms ./emcli

Overview  - Dataguard Broker Property – Binding One of our primary DB was down due to “ORA-00257: archiver error. Connect internal only, until freed”. As all know most of the time this is due to because of primary DB archive destination  100% full and unable to archive a redo log. Immediately we went and check, but surprisingly our primary archive destination is 95% free, and we had enough space. Unfortunately, Standby Database destination was 100% full. We cleared the space on standby db server and Issue is resolved, everyone able to connect to DB now, I can assume now that whoever reading this blog will thing that standby mode is “MAXIMUM PROTECTION MODE”, due to primary not able to transfer the redo because standby destination was full. But that’s not the case, our standby mode is “Maximum Performance mode”, so technically it should not be the case. Here is the Binding Variable comes into Play, we set to `mandatory` (default value:- optional). Why we set

Issue: 10g OEM Console disappears after clicking DB name. And noticed the below error in this location “C:\Users\Doyen\AppData\Local\Temp” EXCEPTION_ACCESS_VIOLATION (0xc0000005) occurred at PC=0x8077E76 Solution: Issue because of the permission Issue, run this console as an administrator and test

Issue: WF_DEFERRED_R & WF_DEFERRED_N Rule Set become invalid, when try to reload (add & remove the subscriber and rule set) the WF_DEFERRED queue. I was getting below error. ERROR at line 1:   ORA-24166: evaluation context APPLSYS.AQ$_WF_DEFERRED_V has errors   ORA-06512: at "SYS.DBMS_AQADM_SYS", line 7035   ORA-06512: at "SYS.DBMS_AQADM", line 549   ORA-06512: at line 7   This shows WF_DEFERRED queue is corrupted, and couldn’t process any workflow notifications. So we have to drop and recreate wf_deferred queue and queue tables. Solution: Follow Note ID : 286394.1, to rebuild wf_deferred queue.  This will solve the problem.

#!/bin/sh # Script to monitor JVM Heap Memory for the managed servers # Author : Ramasubbu Sunadaravel # Date   : 23-Aug-2016 # Usage  : sh jvm_heap_mem_mon.sh run  ## VARIABLES save_date=`date +%d_%b_%y` LOGFILE=/export/home/applmgr/oraprocs/logs HISTFILE=/export/home/applmgr/oraprocs/histfile threshold=10 MAIL_LIST=rsundaravel@yahoo.com SCRIPT=/export/home/applmgr/oraprocs/.jvm_check.py ## SCRIPTS STARTS HERE . /r11/app/FLRPRD/R12apps/EBSapps.env . $FMW_HOME/wlserver_10.3/server/bin/setWLSEnv.sh java weblogic.WLST $SCRIPT > $LOGFILE/jvm_heap_monitoring.log date '+Start Time: %m/%d/%y %H:%M:%S' >> $HISTFILE/jvm_heap_monitoring_$save_date.log cat $LOGFILE/jvm_heap_monitoring.log|grep "%" >> $HISTFILE/jvm_heap_monitoring_$save_date.log date '+End Time: %m/%d/%y %H:%M:%S' >> $HISTFILE/jvm_heap_monitoring_$save_date.log #Alert DBA's if any of the managed server heap size reached more than $threshold value current=`