Infrastructure at your Service

 
Cesare Cervini

Customizing Oracle WebLogic wlst

By | Application integration & Middleware | No Comments

As stated in Oracle’s documentation, the WebLogic Scripting Tool, or wlst for short, can be extended by adding functions in 2 non mutually exclusive places: any file located in $WL_HOME/common/wlst any file located in $WL_HOME/common/wlst/lib/ Files must have the .py extension and will be automatically loaded by wlst when it starts. In the first alternative, the script files will be included in the current wlst session’s namespace and can directly be invoked by their name….

Read More
Cesare Cervini

HtmlAdaptorServer, A JMX Agent with HTML Presentation for WebLogic

By | Application integration & Middleware | No Comments

In this article, I presented a little utility based on the SimpleHTTPServer jython module to visualize into an HTML page a WebLogic server’s configuration and run-time mbeans. I also mentioned that there are lots other tools out there for this purpose, albeit more aimed at run-time monitoring rather than viewing the configuration mbeans. Here, I’d like show another such tool, actually a java package to install in the target JVM. As such, it is a…

Read More
Cesare Cervini

The new WebLogic remote-console

By | Application integration & Middleware | No Comments

An interesting new project that started a few months ago is the WebLogic Remote Console. Its main advantage is that it allows to edit a domain’s configuration with no need for a running console application as it connects directly to the remote administration server. The console application does actually not need to be deployed any more, not even on demand, though it costs nothing to left it so configured. It exists in 2 flavors: a…

Read More
Cesare Cervini

dctmping, A Documentum Repository Checker Utility

By | Enterprise content management | No Comments

When working with containers, the usual trend is to make them as compact as possible by removing any file or executable that is not used by what is deployed in it. Typically, interactive commands are good candidates not to be installed. Sometimes, this trend is so extreme that even simple utilities such as ping or even the less pager are missing from the containers. This is generally fine once a container reaches the production stage…

Read More
Stéphane Haby

SQL Server SCOM: Many perf.perfHourly and State.StateHourly tables in OperationManagerDW

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

By a customer, the SCOM’s Database OperationManagerDW growth fast and becomes very big. To see what’s happens, in SSMS (SQL Server Management Studio), I right-click on the database open Reports>Standard Report> Disk Usage by Top Tables: You have many interesting reports with SSMS and I advise you to use it. In my case the “Disk Usage by Top Tables” report displays me many perf.perfHourly and State.StateHourly tables with a _guid(): After reading some blog’s, the…

Read More
Stéphane Haby

SQL Server: How to compare Server and Database Collation

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

Sometimes during an SQL Server audit, I check the collation of the server and the databases but every time separately. The goal of this blog is to give you a script to have both and compare it. First step is to have the server collation and the code page. The code page will help to see if the character set is the same. For example, for us, the 1252 is Latin/Western European and the 1258…

Read More
Karsten Lenz

De-Ubuntu Ubuntu

By | Operation systems | No Comments

Canonical is consistently promoting Snap Integration in the Ubuntu world with all its market power. However, many do not like this development with Ubuntu. But what options do you still have as an Ubuntu user if you don’t necessarily want to change the distribution? I’ll show you how to run Ubuntu 20.04 with Flatpak instead of Snap and get rid of the data-collecting packages. Many switch to Linux because dealing with privacy in other operating…

Read More
Stéphane Haby

SQL Server: Analysis of SCOM Warning on the Health Check

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

Sometimes, it’s hard to find how to analyze a Warning in the SCOM Interface and correct the problem. By a customer, we install new instances in SQL Server 2019 and change the version of SCOM. All new servers have a warning on the Health. The first step in the SCOM interface is to go to the SQL Server Roles: On this step, the most important is to open the Health Explorer and not double-click or…

Read More
Karsten Lenz

Rancher installation on RHEL 8 compatible Linux

By | Docker, Kubernetes | No Comments

This Blog is about the installation of Rancher Community on a RHEL 8 compatible Linux, for this Blog i choose AlmaLinux 8.4, but i will also work on Rocky Linux 8.4 Release Candidate. Base is an AlmaLinux / Rocky Linux minimal installation on a VMWare Host for all nodes, using the same configuration with 4vCPU and 4GB RAM. A small comaprsion of RHEL 8 and the alternatives can be found in my other blog her:…

Read More
Stéphane Haby

SQL Server Tips: Get back permissions lost for mount points!

By | Database Administration & Monitoring, SQL Server | No Comments

Recently by a customer, we are facing the case to lose all mount points on a secondary node in a HA SQL Server AlwaysOn infrastructure due to a big problem on the Datacenter. We need to build from scratch all mount points for the Data, Log and Tempdb. After multiple researches, I didn’t find how to give back correctly the permission for the SQL Server account on these mount points. The disk environment is very…

Read More
Pascal Brand

Oracle Internet Directory or Oracle Access manager 12.2.1.4 fails to install on Red Hat Linux8

By | Application integration & Middleware, Oracle | No Comments

Recently I had to install Oracle Internet Directory (OID) and Oracle Access Manager (OAM) both in 12.2.1.4 on a Red Hat 8 for new QA and PRODUCTION environments. The installation of the OID 12.2.1.4 failed on packages prerequisites check. It complained about missing packages that do not exist anymore in Red Hat 8 or in Oracle Linux 8 either. Checking for compat-libcap1-1.10; Not found. Failed Checking for compat-libstdc++-33-3.2.3-x86_64; Not found. Failed Both compat-libstdc++-33-3.2.3-x86 and compat-libcap1-1.10…

Read More
Clemens Bleile

Parameterized Views with SYS_CONTEXT in Oracle. How can the optimizer peek values?

By | Oracle | No Comments

There was a dicsussion a couple of years ago about a mssing feature in Oracle that the Optimizer is not peeking values when SYS_CONTEXT is being used in a predicate. I.e. specifically when using SYS_CONTEXT in Views to simulate passing parameters to views. See the following links concerning this topic: https://connor-mcdonald.com/2016/10/20/taking-a-peek-at-sys_context https://blog.jooq.org/2016/10/20/be-careful-when-emulating-parameterised-views-with-sys_context-in-oracle https://community.oracle.com/ideas/15826 E.g. take the example of Connor McDonald here: [email protected]@PDB1> create table t ( x varchar2(10), y char(100)); Table created. [email protected]@PDB1> [email protected]@PDB1> insert…

Read More