Infrastructure at your Service

Cesare Cervini

Adding a Documentum extension into python

By | Entreprise content management | No Comments
 

 Many years ago, out of frustration by the poorness of scripting tools in Documentum, I realized a Documentum binding for python using the distutils and I remember how easy and straightforward it had been, even for someone not really into these things on a daily basis. Recently, I wanted to reuse that work but couldn’t find the source files, not that they were many, but I did not want to do it over again. Finally,…

Read More
Daniel Westermann

Scaling the EDB containers in MiniShift/OpenShift

By | Database Administration & Monitoring | No Comments
 

 When you followed the last post you should have two pgpool instances and one EDB Postgres instance running in OpenShift. pgpool is responsible for the load balancing, meaning: Send write requests to the master instance and spread read requests over all instances. In the current setup this does not make much sense as we only have one instance so in this post we will scale the setup to finally consist of one master and one…

Read More
Franck Pachot

12c upuserxt.lst, upobjxt.lst & Oracle Maintained objects/users

By | Oracle | No Comments
 

 Mike Dietrich has blogged recently about upuserxt.lst and upobjxt.lst and how to query them with external table. The first time I’ve seen those ‘.lst’ files, the default extension for sqlplus spool files, I wondered whether they were provided in ?/rdbms/admin on purpose, or if they were just some leftovers from some tests Oracle did before packaging the Oracle Home. Finally, I realized that they were there on purpose and that those ‘.lst’ are important files…

Read More
Pascal Brand

Configuring WebLogic Server 12.2.1.3 Diagnostics Framework policies and actions

By | Application integration & Middleware | No Comments
 

 Configure a Policy-action (new name for watch-notification) to send a JMX notification when the monitored WebLogic Server is having stuck threads or high memory usage. We will use a simple JMX notification listener program which can process WLDF JMX notifications. In this case, it will simply print the contents of the notification. For simplicity, we will have only two servers in the domain, AdminServer (admin-server) and Server1 (managed-server). We will configure WLDF on the Server1…

Read More
Pierre Sicot

PDB RMAN backups available after plugging in on a new CDB with Oracle 18c

By | Database Administration & Monitoring | No Comments
 

 With Oracle 18c, it is possible to use PDB rman backups created on the source CDB (they are called PREPLUGIN backups) when the PDB has been relocated to a target CDB. In my environment, my original CDB is DB18, with the PDB named pdborig. The target CDB is PSI18. The first step consist in running a rman backup on pdborig: oracle@localhost:/u00/app/oracle/ [DB18] rman target sys/manager@pdborig Recovery Manager: Release 18.0.0.0.0 – Production on Tue May 15…

Read More
Stéphane Haby

SP2 for SQL Server 2016 is available with new helpful DMVs

By | Database Administration & Monitoring, Development & Performance, SQL Server, Technology Survey | No Comments
 

 Last month (April 24, 2018), the Service Pack 2 for SQL Server 2016 was released and distributed. This Service Pack has new DMVs, already available in SQL Server 2017 RTM. In this article, I will just write few words about 2 DMVs (sys.dm_db_log_stats & sys.dm_db_log_info) and a new column (modified_extent_page_count) in the DMV sys.dm_db_file_space_usage that I presented during our last event about SQL Server 2017. I think they are really helpful for DBA. It’s also…

Read More
Franck Pachot

SQL Developer Web on the Oracle Cloud

By | Oracle | 3 Comments
 

 You like SQL Developer because it is easy to install (just unzip a jar) and has a lot of features? Me too. It can be even easier if it is provided as a web application: no installation, and no java to take all my laptop RAM… When I say no installation, you will see that you have some little things to setup here in DBaaS. That will probably be done for you in the managed…

Read More
Franck Pachot

Some ideas about Oracle Database on Docker

By | Oracle | No Comments
 

 This is not a ‘best practice’ but just some ideas about building Docker images to provide an Oracle Database. I started with the images provided by Oracle: https://github.com/oracle/docker-images/tree/master/OracleDatabase/SingleInstance and this is great to validate the docker environment. Then I customized for my needs and here are the different points about this customization.

Read More
Cesare Cervini

idql and its column output

By | Entreprise content management | No Comments
 

 idql and its column output A few days ago, I was reading an interesting blog from distinguished colleague Clemens Bleile with the title “sqlplus and its column output” (link here https://blog.dbi-services.com/sqlplus-and-its-column-output/) and I said to myself: the lucky Oracle administrators and developers have sqlplus, a rather good, out of the box command-line tool to talk to their databases. What equivalent tool do we have with Documentum ? Well, we have mainly idql, which, to put…

Read More