Oracle Database Backup Service Configuration – java.net.UnknownHostException

In all the trials in the Oracle cloud in the past, I used the same syntax below to configure the Oracle Database Backup Service on my local servers. Last week I have decided to order the Service via shop.oracle.com. Now I am an official owner of an Oracle cloud account with a CSI :-). But back to my problem, after my account was created I got the mail with the configuration details. So far so good. Then I tried to configure the OPC package as always: oracle@bern:/u00/app/oracle/stage/ [ORCL] java -jar opc_install.jar -serviceName <my-storage> -identityDomain <my-identitydomain> -opcId ‘<my-username>’ -opcPass ‘<my-password>’ -walletDir $ORACLE_BASE/opc_wallet -libDir $ORACLE_HOME/lib -configFile $ORACLE_BASE/admin/ORCL/opc_config/opcORCL.ora Oracle Database Cloud Backup Module Install Tool, build 2016-02-04 java.net.UnknownHostException: <my-identitydomain>.storage.oraclecloud.com at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:178) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)…

Read More

Enterprise Manager 13c – How to apply Patch 22505404: WLS PATCH SET UPDATE 12.1.3.0.160419

Since the 19th of April there is a new patch set available for Weblogic servers – Patch 22505404: WLS PATCH SET UPDATE 12.1.3.0.160419. This patchset has included 116 fixes and is a generic one. The patch is listed in the Enterprise Manager 13c as recommended. OPatch has no to be updated. This patch is not an online patch, you have to shut down your running EM13c server. This blog post describes the apply of the Weblogic patch set update in an Enterprise Manager 13c environment running on a Oracle Linux server. Prepare Patch Set Update on EM13c Server The patch file has to be extracted. I have copied to file to a stage directory /u00/app/oracle/stage on the EM13c server. [oracle@solothurn…

Read More

EM13c – 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 More

Houston – 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 More