Infrastructure at your Service

dbi services BLOG

Welcome to the dbi services Blog! This IT blog focuses on database, middleware, and OS technologies such as Oracle, Microsoft SQL Server & SharePoint, EMC Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on our blog postings.

Daniel Westermann

Can I do it with PostgreSQL? – 6 – Server programming

By | Database Administration & Monitoring | No Comments
 

 Today we’ll continue this series with another topic: What does PostgreSQL provide when it comes to server programming, that is: Writing functions and triggers to support your application? In Oracle you can either use PL/SQL or Java, in MariaDB you can use stored procedures written in SQL, MS SQL Server provides Transact SQL and with DB2 you can write stored procedures in a host language or SQL.

Read More
Mouhamadou Diaw

Switchover and Failover with Dbvisit 8

By | Database Administration & Monitoring | No Comments
 

 In this blog we will talk about how to do a switchover and how to do a failover. We suppose that dbvisit is already installed and that a standby database is already configured. Our instance is named DBPRIMA. Switchover SWITCHOVER is the fact to change database role. The primary becomes the standby and the standby becomes the primary. This can be useful for many reasons. Before performing a switchover, we have first to send archived…

Read More
Mouhamadou Diaw

Creating standby database with Dbvisit 8

By | Database Administration & Monitoring | No Comments
 

 The new version of Dbvisit standby is now released. In this blog we are going to see how to install dbvisit 8 and how to create a standby database. For the installation after downloading the software, just uncompress it and then run the install-dbvisit command under the installer directory. The installation process is divided in 2 parts. 1- Core Components (Dbvisit Standby Cli, Dbvnet, Dbvagent) –On both servers 2- Dbvserver console installation. Just note that…

Read More
Daniel Westermann

Can I do it with PostgreSQL? – 5 – Generating DDL commands

By | Database Administration & Monitoring | No Comments
 

 From time to time it is very useful that you can generate the DDL commands for existing objects (Tables, Indexes, whole Schema …). In Oracle you can either use the dbms_metadata PL/SQL package for this or use expdp/impdp to generate the statements out of a dump file. What options do you have in PostgreSQL? Note: We’ll not look at any third party tools you could use for that, only plain PostgreSQL.

Read More
William Sescu

Oracle 12c DataGuard – Insufficient SRLs reported by DGMGRL VALIDATE DATABASE VERBOSE

By | Database Administration & Monitoring | No Comments
 

 I have setup a DataGuard environment and followed the instructions from Oracle to create the Standby Redo Logs. The Standby Redo Logs have to be the same size as the Online Redo Logs. If not, the RFS process won’t attach Standby Redo Logs, and you should have at least one more of the Standby Redo Log Group as you have for your Online Redo Log Group per Thread. For my single instance, this should be…

Read More
Franck Pachot

Encryption in Oracle Public Cloud

By | Database Administration & Monitoring | 2 Comments
 

 Oracle Transparent Data Encryption is available without option on the Oracle Public Cloud: Standard Edition as well as Enterprise Edition (EE, EE-HP EE-EP, ECS). More than that, the DBaaS enforces TDE for any user tablespace even when not specifying in the CREATE TABLESPACE. It you are not familiar with TDE key management (wallets) then you have probably encountered ORA-28374: typed master key not found in wallet. Rather than another tutorial on TDE I’ll try to…

Read More
Morgan Patou

Documentum story – Authentication failed for Installation Owner with the correct password

By | Entreprise content management | No Comments
 

 When installing a new Remote Content Server (High Availability), everything was going according to the plan until we try to login to DA using this new CS: the login using the Installation Owner (dmadmin) failed… Same result from dqMan or any other third party tools and only the iapi or idql sessions on the Content Server itself were still working because of the local trust. When something strange is happening regarding the authentication of the…

Read More
William Sescu

Oracle 12c – Finding the DBID – The last resort

By | Database Administration & Monitoring | No Comments
 

 The DBID is a very important part for Oracle databases. It is an internal, uniquely generated number that differentiates databases. Oracle creates this number automatically as soon as you create the database. During normal operation, it is quite easy to find your DBID. Whenever you start your RMAN session, it displays the DBID. oracle@oel001:/home/oracle/ [OCM121] rman target / Recovery Manager: Release 12.1.0.2.0 – Production on Mon Nov 28 10:32:47 2016 Copyright (c) 1982, 2014, Oracle…

Read More
Morgan Patou

Documentum story – Download failed with ‘Exceeded stated content-length of 63000 bytes’

By | Entreprise content management | No Comments
 

 At one of our customer, we were in the middle of a migration process of some docbases from 6.7 to 7.2. A few days after the migration, we started seeing some failures/errors during simple download of documents from D2 4.5. The migration has been done using the EMC EMA migration tool by some EMC colleagues. The strange thing here is that these download failures only applied to a few documents, far from the majority and…

Read More