Infrastructure at your Service

Franck Pachot

#UKOUG_TECH17

By | Oracle | No Comments
 

 Award I’ve received an award for an article I’ve written last year, the Most Read Oracle Scene Article in 2016 – Technology. I like to write for Oracle Scene magazine. It is rare today to have a magazine both available in a paper version, and also publicly available on the web. And I must say that as an author, all the people behind are doing a great work. Thanks to them and thanks for the…

Read More
Stéphane Haby

SQL Server Tips: an orphan user owns a database role

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

 A few days ago, I conduct an audit to detect all orphan’s windows accounts in a database and I was surprise to have an error during the drop user query.   The first step is to find all orphan’s windows accounts in a database USE [dbi_database] GO /*Step1: Search the orphan user */ SELECT * FROM sys.database_principals a LEFT OUTER JOIN sys.server_principals b ON a.sid = b.sid WHERE b.sid IS NULL AND a.type In (‘U’,…

Read More
Soufiane Benmalek

How to reduce the size of an LVM partition formatted with xfs filesystem on CentOS7?

By | Database Administration & Monitoring | No Comments
 

 DISCLAIMER: I know it exists other solutions to do it Pre-requisites: – a virtual machine (or not) with CentOS7 installed – a free disk or partition I use a VBox machine and I added a 5GiB hard disk We list the disk and partition to check if our new hard is added. [root@deploy ~]$ lsblk NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT sda 8:0 0 20G 0 disk ├─sda1 8:1 0 1G 0 part /boot…

Read More
Michael Hein

Naming of archivelog files with non existing top level archivelog directory

By | Database Administration & Monitoring, Database management, Oracle | No Comments
 

 In Oracle 12.2 an archive log directory is accepted, if top level directory does not exist: oracle@localhost:/u01/app/oracle/product/12.2.0/dbhome_1/dbs/ [DMK] ls -l /u02/oradata/DMK/ total 2267920 drwxr-xr-x. 2 oracle dba        96 Dec  6 05:36 arch … Now database accepts this non existing archivelog destination: SQL> alter system set log_archive_dest_3=’LOCATION=/u02/oradata/DMK/arch/arch2′; System altered. But not this: SQL> alter system set log_archive_dest_4=’LOCATION=/u02/oradata/DMK/arch/arch2/arch4′; alter system set log_archive_dest_4=’LOCATION=/u02/oradata/DMK/arch/arch2/arch4′ * ERROR at line 1: ORA-02097: parameter cannot be modified because specified value is invalid…

Read More
Daniel Westermann

No journal messages available before the last reboot of your CentOS/RHEL system?

By | Database Administration & Monitoring | No Comments
 

 As you probably noticed RedHat as well as CentOS switched to systemd with version 7 of their operating system release. This also means that instead of looking at /var/log/messages you are supposed to use journcalctl to browse the messages of the operating system. One issue with that is that messages before the last reboot of your system will not be available, which is probably not want you want.

Read More
Nicolas Jardot

DOAG 2017: Automation in progress

By | Database Administration & Monitoring, Oracle | 5 Comments
 

  A week ago, I had the chance to be speaker at the DOAG Konferenz 2017 in Nürnberg. It’s sometimes hard to find time to be at the conferences because the end of year is quite busy at customers. But it’s also important because it’s time for sharing. I can share what I’m working on about automation and patching and I can also see how other people are doing. And it was great for me…

Read More
Morgan Patou

Alfresco – Unable to move/rename a file/folder using AOS

By | Application integration & Middleware, Entreprise content management | No Comments
 

 When playing with the AOS implementation, a colleague of mine faced an interesting issue where he just wasn’t able to move or rename any files or folders. The creation and deletion were working properly but he was unable to move or rename anything when using a Network Location or a Network Drive. This environment was freshly installed with a front-end (Apache HTTPD) setup in SSL so we worked together to find out what was the…

Read More
Morgan Patou

WebLogic – SSO/Atn/Atz – 403 Forbidden, another issue

By | Application integration & Middleware, Entreprise content management | No Comments
 

 Earlier today, I posted another blog with almost the same title but the similarities stop here. The thing is that when you access your application, there aren’t much error codes possible so if there is an issue, it’s often the same generic message that is being displayed on the browser. To get some background on the issue that I will present below, we are usually setting up the WebLogic Server, enabling the SSO on the…

Read More
Morgan Patou

WebLogic – SSO/Atn/Atz – 403 Forbidden, a first issue

By | Application integration & Middleware, Entreprise content management | No Comments
 

 In a previous blog, I explained how it was possible to enable the SSO/Atn/Atz (SSO/Authentication/Authorization) debug logs in order to troubleshoot an issue. In this blog, I will show the logs generated by an issue that I had to deal with last month at one of our customers. This issue will probably not occur very often but it is a pretty funny one so I wanted to share it! So the issue I will talk…

Read More
Clemens Bleile

Transfer redo in async-mode to the Gold/Master copy of the Production DB for ACFS snapshots

By | Database Administration & Monitoring | 2 Comments
 

 If you store your databases on the cluster filesystem ACFS you may use the provided Perl-script gDBClone from OTN to clone databases or create snapshot databases. It is an interesting approach to create clones from the Production DB in minutes regardless of the production DB size. What you do is to create a standby DB from your production DB on a separate cluster and use that standby DB as a Gold/Master copy for ACFS snapshots….

Read More
Pascal Brand

How to rename an existing Fusion Middleware WebLogic Domain

By | Application integration & Middleware | No Comments
 

 Some times it happens that we need to rename an existing fusion Middleware WebLogic domain. I was asked to do such on a Fusion Middleware Reports & Forms environment. I took some time to check how this can be done and did some testing to confirm it works as expected. The difficulty is not the WebLogic Domain itself as a WebLogic domain can be created quickly but it is time consuming if the complete configuration…

Read More