Infrastructure at your Service

Mouhamadou Diaw

EDB Failover Manager 3.0 and PostgreSQL 10.1

By | Database Administration & Monitoring | 3 Comments
 

 Edb Failover Manager edb-efm30 is now released and supports PostgreSQL 10.1. Efm is an EDB tool which can be used to perform a switchover and a failover in a PostgreSQL standby environment. In this blog we are going to see how we can install and configure efm in a standby environment. We suppose that the standby is already confugured and is running. We also have not configured any VIP. I just use 3 virtual machines…

Read More
Franck Pachot

18c new Lost Write Protection

By | Oracle | 4 Comments
 

 There are many layers between the Oracle Database pwrite() calls and the physical sector written on disk: filesystem, logical volume, SAN or NAS, with a lot of smart software running for Virtualisation, Compression, Snapshotting, Synchronisation… Are you sure that the changes you made to your data is actually persisted on disk, completely and without any corruption? In case of bug or crash in the storage layer, it may happen that only part of the changes…

Read More
Stephane Biehler

Error accessing D2: Error while fetching repositories

By | Application integration & Middleware | No Comments
 

  After patching our D2 we ran into an error we never had before. After all, it’s only a patch. But as you know, patching D2 means recreating the war file and deploying it again. As well as setting up again all the customs you made… Well this time we had a popup when accessing the D2 interface, which said “Error while fetching repositories”. That means D2 wans’t even able to load the list of…

Read More
Stephane Biehler

Error starting D2 4.5 on Tomcat 8 No class found: JSAFE_SecureRandom

By | Application integration & Middleware | No Comments
 

  When installing D2 and launching the tomcat server you can have an error on a missing lib: JSAFE_SecureRandom. Here’s the trace you can have: 2018-01-17 17:32:19 [DEBUG] [localhost-startStop-1] – c.e.c.d.contents.D2FileCleaningTracker : Init D2FileCleaningTracker with /pkgs/dms-tomcat/D2_TOMCAT_HOME/temp/D2FileCleaningTracker_D2.ser 2018-01-17 17:32:20 [ERROR] [localhost-startStop-1] – c.emc.d2fs.dctm.servlets.D2HttpServlet : LoadOnStartup – java.lang.NoClassDefFoundError: com/rsa/jsafe/JSAFE_SecureRandom 2018-01-17 17:32:20 [ERROR] [localhost-startStop-1] – c.emc.d2fs.dctm.servlets.D2HttpServlet : {} java.lang.NoClassDefFoundError: com/rsa/jsafe/JSAFE_SecureRandom at com.documentum.fc.client.security.impl.InitializeKeystoreForDfc.execute(InitializeKeystoreForDfc.java:46) [dfc.jar:na] at com.documentum.fc.client.security.internal.KeystoreMgr.initForDfcWithDefaultPolicy(KeystoreMgr.java:71) [dfc.jar:na] at com.documentum.fc.client.security.impl.IdentityManager.initFromKeystore(IdentityManager.java:139) [dfc.jar:na] at com.documentum.fc.client.security.impl.IdentityManager.<init>(IdentityManager.java:41) [dfc.jar:na] at com.documentum.fc.impl.RuntimeContext.<init>(RuntimeContext.java:52) [dfc.jar:na] at com.documentum.fc.impl.RuntimeContext.<clinit>(RuntimeContext.java:185) [dfc.jar:na]…

Read More
David Hueber

ODA migration challenges: Non-OMF to OMF + 11.2.0.3 to 11.2.0.4

By | Database Administration & Monitoring | One Comment
 

 To do some application and performances tests, I had to copy a database from a third party Linux server to an ODA X7-2M. Looks pretty simple on the paper, but 2 small challenges came into the game. The first was that of course the source database was in Non-OMF while ODA works fully in OMF. The second was that the source database is running 11.2.0.3 which is not supported and cannot be installed on the…

Read More
Pierre Sicot

ORA-12547 TNS lost contact on SLES12 and oracle 11.2.0.x

By | Database Administration & Monitoring | No Comments
 

 On a client’s site, I have migrated successfully Oracle 12c databases from RedHat to SLES12 without any problem. I encountered a problem doing the same work with Oracle 11.2.0.3 and oracle 11.2.0.4 on SLES 12. Once I have moved the database data files, redo logs, control files and spfile to the new server, when I try to startup the database, I receive the error message: oracle@server:/u00/app/oracle/diag/ [db1] sq SQL*Plus: Release 11.2.0.3.0 Production on Thu Feb…

Read More
Franck Pachot

18c, Cloud First and Cloud Only features: think differently

By | Database Administration & Monitoring, Oracle | One Comment
 

 Remember the times when the Oracle Software features were the same on all platforms? Where Oracle databases could be ported to any relevant platform? Where we were able to try any feature, freely, by downloading the latest release software? Now we need to think differently. Because: The new software is released on Cloud first The major new features will never be available on-premises The Cloud here means the Oracle Cloud – not AWS, not Azure,…

Read More
Franck Pachot

A free persistent Google Cloud service with Oracle XE

By | Cloud, Oracle | One Comment
 

 In a previous post I’ve listed several free online services which run an Oracle XE so that you can test your SQL easily. You may want use Oracle XE further, with full access to the database and its host, and still from a web browser. You probably have a Google account. Then you also have a Virtual Machine on the Google Cloud (0.5 vCPU / 1.70 GB RAM boostable to 1 vCPU / 3.75 GB)…

Read More
Franck Pachot

PDB upgrade from 12c to 18c

By | Oracle | No Comments
 

 Oracle 18c is out, in the Oracle Cloud, and the first thing I do with a new version is testing how long it takes to upgrade a previous version PDB by unplug/plug. Faster upgrade should be the benefit of having a slim dictionary where the system objects are reduced to metadata links and data links. However, it looks like upgrading the PDB dictionary still takes the same time as upgrading the CDB$ROOT. The idea is…

Read More