Infrastructure at your Service

Morgan Patou

Documentum – RCS 7.3 – Issue with projections?

By | Entreprise content management | No Comments
 

 In the last two blogs I posted, I mentioned that I was working on silent installations with CS 7.3 (in HA). The “issue” (it’s more like a common mistake) I will describe in this blog is linked to the HA installation. You can face that using the silent or GUI installation, it doesn’t matter.   To replicate this behavior, it’s pretty simple: so basically on the first Content Server, I installed a Global Registry and a few…

Read More
Morgan Patou

Documentum – RCS 7.3 – dm_server_config cannot contain dash

By | Entreprise content management | No Comments
 

 As mentioned in this blog, I was recently installing a new 7.3 P05 environment. Actually, this environment was in HA and it was the first silent installation of a Remote Content Server for me. I already created a lot of blogs related to issues with the CS 7.3 but since this was my first RCS 7.3 installation, I was kind of expecting to face some issues… I wasn’t disappointed!   So let’s start with the…

Read More
Morgan Patou

Documentum – CS 7.3 – Issue with dmqdocbroker

By | Entreprise content management | No Comments
 

 Beginning of this month, I was building a new environment in 7.3 P05 (using silent installation but this isn’t relevant here) and I found a strange behaviour from the dmqdocbroker so I wanted to share that. You will see below an error message “Input has special characters …”. This is specific to the CS 7.3 for which we opened a SR with EMC/OTX some months ago (beginning of this year during the first CS 7.3…

Read More
Daniel Westermann

Be careful when putting the Oracle ADR on xfs, or better 4K sector format drives

By | Database Administration & Monitoring | No Comments
 

 Today, after we did a fresh setup of a Grid Infrastructure cluster (12.1.0.2.170814) we faced two issues reported in the alert.log of the ASM instances (in fact you would see the same for the alert logs of any instance in that configuration but we did not had any other instance up and running at that time): This: ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [/disk00/app/grid/diag/asm/+asm/+ASM2/metadata/INC_METER_SUMMARY.ams], [0], [4], [], [], [], [], [], [], [], [] ORA-27072:…

Read More
David Barbarin

SQL Saturday Toulouse 2017: SQL Server on Linux – Slide deck

By | Technology Survey | No Comments
 

 #SQLSatToulouse was definitely a great event. Firstly, a big thanks to the organization team (@Guss and @Fredg_31) as well as all the sponsors and attendees (without whom this kind of event would not be possible). As promised, here the slide deck of my session “Introduction to SQL Server on Linux for DBAs“. It was for me a great moment of sharing. Thanks to all!  

Read More
Arnaud Berbier

DOAG IMC Day 2017

By | Application integration & Middleware | No Comments
 

  This year and before taking part to the DOAG in Nuremberg as a referent – Yes I will present at the DOAG this year – I had the opportunity to attend the DOAG IMC Day in Berlin. It was the SIG IMW dedicated to the infrastructure and operating system. It was my first time in Berlin Very nice city. The event was well organized at the DOAG “Diensleistung”. All the facility was there. So…

Read More
Franck Pachot

Active Data Guard services in Multitenant

By | Oracle | No Comments
 

 A database (or the CDB in multitenant) registers its name as the default service. When a standby database is on the same server, or same cluster, you have no problem because this database name is the db_unique_name which is different between the primary and the standby(s). In multitenant, in addition to that, each PDB registers its name as a service. But the PDB name is the same in the primary and the standby database. This…

Read More
Franck Pachot

impdp content=metadata_only locks the stats

By | Oracle | No Comments
 

 With Oracle you can learn something every day. Today, preparing a migration to 12.2, I found all tables had locked statistics. I learned that it is the expected behavior since 10.2 when importing metadata_only including statistics, to avoid that the automatic job gathering comes and replaces the stats by ‘0 rows’.

Read More
Franck Pachot

12c dbms_stats.gather_table_stats on GTT do not commit

By | Oracle | No Comments
 

 In my UKOUG OracleScene article on 12c online statistics and GTT I mentioned the following: A final note about those 12c changes in statistics gathering on GTT. In 11g the dbms_stats did a commit at the start. So if you did gather stats after the load, you had to set the GTT as ON COMMIT PRESERVE ROWS. Or you just vacuum what you’ve loaded. That has changed in 12c. If you now choose to do…

Read More
Franck Pachot

When PDB name conflicts with CDB name

By | Business Intelligence, Oracle | No Comments
 

 Going to multitenant architecture is not a big change. The administration things (DBA, monitoring, backups) connect to the CDB and the application things connect to the PDB. Without the multitenant option, it is still recommended to go to the CDB architecture. The non-CDB is deprecated and the multitenant architecture brings interesting features. People often ask how to name the CDB and the PDB, especially when they have naming rules or policies in the company. My…

Read More