Infrastructure at your Service

All posts by Pierre Sicot

Pierre Sicot
Senior Consultant

Pierre Sicot has more than fifteen years of experience in Oracle database administration, engineering, and optimization. His specialty is the installation, migration, optimization, and security of Oracle databases in production environments. Prior to joining dbi services, Pierre was consultant at Trivadis in Lausanne. He also worked at ilem Group as a database administrator and also as a Consultant for different customers. Pierre holds a engineering diploma of ESME Sudria in France. His branch-related experience covers Energy, Banking, Public Administration, etc.
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
Pierre Sicot

Oracle 18c clone PDB and Transparent Data Encryption

By | Database Administration & Monitoring | No Comments

Let’s do some tests with the Oracle 18c new feature in creating PDB clone with DBCA. Unfortunately, this feature does not work when you have TDE enabled. Just to remember, with Oracle 12.2 we had the possibility to create PDBs with dbca just from PDBseed to from unplugged PDBs: Now in version 18c we can create PDBs from existing PDBs as follows (for this test TDE is disabled): You can choose the Pluggable Database you want…

 
Read More
Pierre Sicot

ORA-12547 TNS lost contact on SLES12 and oracle 11.2.0.x

By | Database Administration & Monitoring | No Comments

On a client’s site, I have migrated successfully Oracle 12c databases from RedHat to SLES12 without any problem. I encountered a problem doing the same work with Oracle 11.2.0.3 and oracle 11.2.0.4 on SLES 12. Once I have moved the database data files, redo logs, control files and spfile to the new server, when I try to startup the database, I receive the error message: oracle@server:/u00/app/oracle/diag/ [db1] sq SQL*Plus: Release 11.2.0.3.0 Production on Thu Feb…

 
Read More
Pierre Sicot

DBVISIT from Oracle to Postgres

By | Database Administration & Monitoring | No Comments

As I regularly work on Oracle and PostgreSQL, I decided to test the replication from Oracle to PostgreSQL using the Dbvisit Replicate tool. Dbivisit Replicate does not use Oracle logminer ot triggers but its own mining processes to get the changes when they are written to the redo logs. When a change appears in the redo log, an external file called PLOG is generated and transferred to the target. The architecture is quite easy to…

 
Read More
Pierre Sicot

Grid Infrastructure Installation on SLES 12 SP1

By | Database Administration & Monitoring | 2 Comments

This week I needed to install Oracle Grid Infrastructure 12c release 1 in a SLES 12 SP1 environment. Everything worked fine until I ran the root.sh at the end of the installation. Here’s a quick description of the problem and the workaround. The root.sh script ran into error and the installation was completely unsuccessfull: oracle:/u00/app/grid/12.1.0.2 # /u00/app/grid/12.1.0.2/root.sh Performing root user operation.   The following environment variables are set as:     ORACLE_OWNER= grid     ORACLE_HOME=  /u00/app/grid/12.1.0.2…

 
Read More
Pierre Sicot

Oracle 12.2 tables, indexes new features

By | Database Administration & Monitoring | No Comments

The Oracle 12.2.0.1 version has some interesting new features  concerning tables or indexes. The first new feature is about the online table move. In 12.2 version Oracle offers now the possibility to move non-partitioned tables without blocking any DML operations. To realise this operation, we must use the ONLINE keyword and/or the UPDATE_INDEXES clause. If you remember, in the previous Oracle version, we encountered the classical ORA-01502 error. If you remember in version 12.1, we have…

 
Read More
Pierre Sicot

Postgres Barman and DMK

By | Database Administration & Monitoring | No Comments

As PostgreSQL is more and more present in our client’s infrastructure, I wanted to describe you the barman installation and configuration. Barman is the backup and recovery tool for PostgreSQL, I configured it using DMK out tool for infrastructure administrators on Oracle, MySQL, and PostgreSQL. I used two virtual severs running under RedHat Enterprise Libux 7.1, one for PostgreSQL database server (pg1) ands the second for barman (pg2). At first I install PostgreSQL 9.6 on…

 
Read More
Pierre Sicot

Oracle 12.2 and Transparent Data Encryption

By | Database Administration & Monitoring | One Comment

Since the new Oracle 12.2.0 version is released, I decided to test the Transparent Data Encryption as new features are available. The following tests have been made in a multitenant environment, DB1 and two pluggable databases DB1PDB1 and DB1PDB2. The first step consists in creating a software keystore. A software keystore is a container that stores the Transparent Data Encryption key. We define its location in the sqlnet.ora file if we need to use it…

 
Read More
Pierre Sicot

Upgrade to Enterprise Manager 13.2

By | Database Administration & Monitoring | 2 Comments

I will describe how to upgrade Enterprise Manager 13.1.0.0 to the new 13.2.0.0 version. At the beginning we have to ensure that we applied the latest PSU on the repository database. It is mandatory to apply the following patch before upgrading to Enterprise Manager Cloud Control 13.2.0.0: DATABASE PATCH SET UPDATE 12.1.0.2.160419 To install the patch you have to check the following point: – you have to use Oracle Interim Patch Installer version 12.2.0.1.8 Once…

 
Read More
Pierre Sicot

UKOUG 2016 DAY 4

By | Database Administration & Monitoring | No Comments

Today is the last day at UKOUG in Birmingham; the first session I attended this morning was presented by Julian Dyke about installing and upgrading Oracle 12c release 2 Grid infrastructure and RAC. He had the possibility to test the installation and upgrade phases at Oracle during 5 days at Oracle last spring. The following tests were done: single instance : install 12.2.0.1, create database with dbca, upgrade 12.1.0.2 to 12..2.0.1 with dbua RAC: install…

 
Read More