Infrastructure at your Service

Cesare Cervini

A Graphical Overview of a Repository

By | Entreprise content management | No Comments

As the saying goes, “A Picture Is Worth A Thousands Words”. I’d add “And A Simple Graph Is Worth A Long, Abstruse List of Numbers”. And of words too, so let’s show off a little bit: Interested ? Then, please read on. It happens not so infrequently that we wish we could quickly plot a few numbers to have a look at their overall trend. The usual procedure is to output the numbers into a…

Read More
Jérôme Dubar

5 mistakes you should avoid with Oracle Database Appliance

By | Database Administration & Monitoring | One Comment

Introduction It has been 5 years I’m working on ODA and I now have a quite good overview of the pros and the cons of such a solution. On one hand, ODA can greatly streamline your Oracle Database environment if you understand the purpose of this appliance. On the other hand, ODA can be your nightmare if you’re not using it as it supposed to be used. Let’s discover the common mistakes to avoid from…

Read More
Nicolas Penot

Foglight: Monitoring solution for databases [Part 02]

By | Database Administration & Monitoring | No Comments

Foglight is a powerful and all in one monitoring solution to monitor various IT infrastructure assets like databases, servers, applications and so on. Whenever you need to monitor a special assets like an Oracle database, a Windows server, a Tomcat server or any other component you can do so by adding a Cartridges. A Cartridges is like a plugin for a specific technology. As we already seen how to install Foglight in a previous article…

Read More
Michael Hein

How to fix OUI-10022 error on an ODA

By | Database Administration & Monitoring | No Comments

When manually upgrading Grid Infrastructure on an ODA according to MOS note 2379389.1 it has to be done as grid user. This can fail with OUI-10022 error which indicates that Oracle inventory is corrupt. But when trying an “opatch lsinventory” as oracle and as grid user these commands succeeded, so inventory seems to be ok. It turned out that the locks subdirectory of the oracle inventory was not writable for the grid user. After making…

Read More
David Barbarin

SQL Server 2019 availability groups – Introduction to R/W redirection

By | Database Administration & Monitoring, Database management, SQL Server | 3 Comments

writeThis is a second write-up about SQL Server 2019 CTP2.0 and availability group new features. This time the interesting one is about READRWRITE redirection capabilities. A couple of months ago, I wrote about SQL Server 2017 and new read-scale capabilities and listener management challenges regarding the operating system. Indeed, there are some scenarios where including listener will not as easy as we did with common ones on the top of Windows operation system. A list of…

Read More
Jérôme Dubar

Reimaging an old X3-2/X4-2 ODA

By | Database Administration & Monitoring, Oracle | No Comments

Introduction X3-2 and X4-2 ODAs are still very capable pieces of hardware in 2018. With 256GB of RAM and at least 16 cores per node, and with 18TB RAW disk capacity as a standard these appliances are far from obsolete even you probably don’t have any more support on the hardware from Oracle. If you own several ODAs of this kind, hardware support may not really be a problem. If something fails, you can use…

Read More
Hervé Schweitzer

Short summary of my PGCONF.EU 2018 conference

By | Database Administration & Monitoring | No Comments

So it’s nearly the end of the conference, where I met lot’s of people from the Postgres community, customers, EDB partner and also contributor/developer of Postgres. During the 3 days I had also the chance to follow many technical sessions and I will give you a short feedback of my preferred sessions. If you want to have the details of the sessions go the conference website https://www.postgresql.eu/events/pgconfeu2018/schedule Tour de Data Types: VARCHAR2 or CHAR(255)? Very…

Read More
Pascal Brand

How to change oam-config.xml to adapt to Oracle Access Manager configuration change

By | Application integration & Middleware | No Comments

After upgrading the Oracle Access Manager from 11.1.2.3 to 12.2.1.3, I extended the WebLogic Domain with User Messaging Services to be able to use the Forget Password feature. The Oracle Support note ID 2302623.1 gives a good example how to do. Oracle Access Manager 12cps3 (OAM 12.2.1.3.0) Sample Application Demonstrates Forgot Password Flow Using Multi Factor Authentication REST APIs ( Doc ID 2302623.1 ). But the OAM AdaptiveAuthenticatorPlugin was missing the UmsClientUrl property and without…

Read More
Pascal Brand

Node Manager not starting after using unpack to install a WebLogic domain on a remote machine.

By | Application integration & Middleware | No Comments

Created a domain using the config.sh script that is using several hosts. The pack and unpack command has been used to install the domain on the remote servers. The pack command:cd $FMW_HOME/oracle_common/common/bin ./pack.sh -domain=/u02/config/domains/workshop_domain \ -template=/home/weblogic/workshop/lab_DomainCreation/workshop_template.jar \ -template_name=workshop_template \ -managed=trueThe new created jar file was copied on the remote server and the unpack command run:cd $FMW_HOME/oracle_common/common/bin ./unpack.sh -domain=/u02/config/domains/workshop_domain \ -template=/home/weblogic/workshop/lab_DomainCreation/workshop_template.jarStarting the node manager failed due to the DemoIdentity Java KeyStore file missing. This one was…

Read More