Three weeks ago I have ordered the Oracle Database Backup Service. The registration via shop.oracle.com was easy, minutes later after I have entered my credit card details and pressed the submit button, I got the login information via email and Oracle has given me a new CSI number. Some time later I took a look in My Oracle Support, my new CSI was added but in state PENDING. Now I clicked on the button to Request Access. This message cames up, this is the normal procedure when you buy a product at at Oracle and when you get a new CSI. I clicked on Accept Responsability. Afterwards the button below has changed to Request Access. And now I am administrator…
Read MoreCategory: Oracle Tools
Enterprise Manager 13c – How to apply p23095307: enterprise manager for oms plugins 13.1.1.0.160429
Patch 23095307 is the newest system patch for the Enterprise Manager 13c family. This patch will be applied with the new patch tool OMSPatcher (see blog post http://dbakevlar.com/2016/05/em13c-applying-system-patches-with-the-oms-patcher from @dbakevlar for details). To apply this patch, the OMS has to be stopped. Prerequisites OMS 13.1.0.0.0 OMSPatcher 13.6.0.0.1 – I have installed it in directory /u00/app/oracle/product/em13cr1/OMSPatcher URL / Username / Password from your EM13c Weblogic AdminServer (emctl status oms -details) Patch 23095307 is unzipped and available in a local directory, in my case it’s in /u00/app/oracle/stage oracle@solothurn:/u00/app/oracle/product/em13cr1/OMSPatcher/ [oms13101] ./omspatcher version OMSPatcher Version: 13.6.0.0.1 OPlan Version: 12.1.0.2.2 OsysModel build: Wed Oct 14 06:21:23 PDT 2015 OMSPatcher succeeded. The newest OMSPatcher can be downloaded according the My Oracle Support Note How to upgrade…
Read MoreEM13c – Database Monitoring Template with DB Alert Log Metric
The new DB Alert Log metric Since the Oracle Enterprise Manager database plugin version 12.1.0.4, there is a new metric “DB Alert Log” available. This metric replaces the existing “Alert Log” metric. The benefit of the new plugin is if an ORA error is detected multiple times in the database alert log based on same error stack, it will be de-duplicated and only one metric alert is generated. Oracle’s recommendation is to replace this metric on the database targets – Changes to the Metric Alert Log Monitoring in Database Plug-in 12.1.0.4 and later (Doc ID 1587020.1). How to create such metrics and many more is very well described in Kellyn Pot’Vin blog post serie http://dbakevlar.com/2013/08/em12c-enterprise-monitoring-part-i/ The old metric Alert Log: The new metric DB…
Read MoreHouston – we have deleted all SYS DBMS_SCHEDULER Jobs !
Bad, bad PL/SQL…. A customer of me has executed a simple script to cleanup DBMS_SCHEDULER jobs and programs for an application. Unfortunately he did as user SYS. The content of the SQL script: BEGIN FOR JOB IN (SELECT * FROM USER_SCHEDULER_JOBS) LOOP DBMS_SCHEDULER.DROP_JOB(JOB_NAME => JOB.JOB_NAME, FORCE => TRUE); END LOOP; FOR PROG in (select * from USER_SCHEDULER_PROGRAMS) LOOP DBMS_SCHEDULER.DROP_PROGRAM(PROGRAM_NAME => PROG.PROGRAM_NAME, FORCE => TRUE); END LOOP; END; / All the Oracle internal maintenance jobs and programs like the AUTO_SPACE_ADVISOR_PROG, GATHER_STATS_PROG, FILE_WATCHER_PROGRAM are deleted. SQL> SELECT owner,job_name 2 FROM dba_scheduler_jobs 3 ORDER by job_name; no rows selected SQL> SELECT owner,program_name 2 FROM dba_scheduler_programs 3 ORDER by program_name; no rows selected On a 12.1.0.2 single instance database on Linux are per default…
Read MoreOracle Enterprise Manager 13c – Tail your Logfiles
This are my favorite aliases for Enterprise Manager 13c troubleshooting. Just replace $ORACLE_BASE with your own installation directory and add these aliases in your .profile/.bash_profile. Here is the URL to the Oracle documentation: http://docs.oracle.com/cd/E63000_01/EMADM/logging.htm#EMADM11796 – and feel free to create your own aliases e.g. for the *.OUT logfiles. Oracle Management Server alias taem=’tail -f -n 50 $ORACLE_BASE/product/gc_inst/em/EMGC_OMS1/sysman/log/emctl.log’ alias taeo=’tail -f -n 50 $ORACLE_BASE/product/gc_inst/em/EMGC_OMS1/sysman/log/emoms.log’ NodeManager alias tanm=’tail -f -n 50 $ORACLE_BASE/product/gc_inst/user_projects/domains/GCDomain/nodemanager/nodemanager.log’ Weblogic AdminServer alias taad=’tail -f -n 50 $ORACLE_BASE/product/gc_inst/user_projects/domains/GCDomain/servers/EMGC_ADMINSERVER/logs/EMGC_ADMINSERVER.log’ alias tagc=’tail -f -n 50 $ORACLE_BASE/product/gc_inst/user_projects/domains/GCDomain/servers/EMGC_ADMINSERVER/logs/GCDomain.log’ Weblogic EMGC_OMS1 Managed Server alias taom=’tail -f -n 50 $ORACLE_BASE/product/gc_inst/user_projects/domains/GCDomain/servers/EMGC_OMS1/logs/EMGC_OMS1.log’ Weblogic BIP Managed Server alias tabi=’tail -f -n 50 $ORACLE_BASE/product/gc_inst/user_projects/domains/GCDomain/servers/BIP/logs/BIP.log’ OHS alias taha=’tail -f -n 50 $ORACLE_BASE/product/gc_inst/user_projects/domains/GCDomain/servers/ohs1/logs/access_log’ alias taho=’tail -f -n 50 $ORACLE_BASE/product/gc_inst/user_projects/domains/GCDomain/servers/ohs1/logs/ohs1.log’
Read More