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

Foglight

By | Database Administration & Monitoring | No Comments

As many Oracle Database Administrators, I am a regular user of Oracle Enterprise Manager in order to monitor or administer my client’s databases. I am lucky because most of them have the diagnostic pack and the tuning pack :=). But we always have to be curious and discover new products. As described by my colleague Nicolas Penot, I installed Foglight: https://blog.dbi-services.com/foglight-monitoring-solution-for-databases-part-01/ https://blog.dbi-services.com/foglight-monitoring-solution-for-databases-part-02/ The installation was successful and very quick to realize, remember when you have…

Read More
Pierre Sicot

OEM 13c Repository view gc$metric_values_daily

By | Database Administration & Monitoring | No Comments

Oracle OEM 13c offers the possibility to generate reports about Oracle Database Tablespace Monthly Space Usage. The displayed information is quite useful and display a lot of information:     The report displays the details for each month and for each tablespace, but the GUI is sometimes painful: you have a nice report but many tablespaces and many numbers :=( At a client’s site, I had the following behavior: a production database had its data…

Read More
Pierre Sicot

Schema only account with Oracle 18.3

By | Database Administration & Monitoring | No Comments

With Oracle 18.3, we have the possibility to create schemas without a password. Effectively in a perfect world, we should not be able to connect to application schemas. For security reasons it is a good thing that nobody can connect directly to the application schema. A good way is to use proxy connections, in fact connect as app_user but using the psi_user password for example: Let’s create a user named app_user: SQL> connect sys@pdb as…

Read More
Pierre Sicot

PDB Snapshot Carousel Oracle 18.3

By | Database Administration & Monitoring | No Comments

A new feature with Oracle 18c is the PDB snapshot carousel. As indicated by its name a PDB snapshot is a copy of a PDB at a specific point in time. You have the possibility to create up to eight snapshots, when you reach the maximum number of snapshots, the last snapshot is over written. The snapshot carousel is obviously the name of all your PDB snapshots. We have the possibility to create automatic snapshots…

Read More
Pierre Sicot

PDB lockdown with Oracle 18.3.0.0

By | Database Administration & Monitoring | No Comments

The PDB lockdown feature offers you the possibility to restrict operations and functionality available from within a PDB, and might be very useful from a security perspective. Some new features have been added to the 18.3.0.0 Oracle version: You have the possibility to create PDB lockdown profiles in the application root like in the CDB root. This facilitates to have a more precise control access to the applications associated with the application container. You can…

Read More
Pierre Sicot

RMAN PITR recover table Oracle 12c

By | Database Administration & Monitoring | No Comments

At one client’s site, I had to restore a table someone had partially deleted one week before. Before Oracle 12c, we had to duplicate the target database to another server, and then to export and import data to the target database. But depending on the database size, it could cost a lot of time, and as nobody knew when the delete action happened, it was more practical to use the rman recover table command in…

Read More
Pierre Sicot

Upgrade EM 13.2 to EM 13.3

By | Database Administration & Monitoring | 2 Comments

As the last Enterprise Manager Cloud Control 13.3 is out since a few days, I decided to test the upgrade procedure from the Enterprise Manager Cloud Control 13.2 You have to follow some pre-requisites: First you copy the emkey : oracle@localhost:/home/oracle/ [oms13c] emctl config emkey -copy_to_repos_from_file -repos_conndesc ‘”(DESCRIPTION=(ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=em13c)(PORT=1521)))(CONNECT_DATA= (SERVICE_NAME=EMREP13C)))”‘ -repos_user sysman -repos_pwd manager1 -emkey_file /home/oracle/oms13c/sysman/config/emkey.ora Oracle Enterprise Manager Cloud Control 13c Release 2 Copyright (c) 1996, 2016 Oracle Corporation. All rights reserved. Enter Admin…

Read More
Pierre Sicot

Licensable targets and Management Packs with EM13c

By | Database Administration & Monitoring | No Comments

When you add a new target in Enterprise Manager 13c , the management packs are enabled by default. This could be a problem in case of a LMS control, and to avoid any problem, you have to  manually disable those management packs. If like me you recently have moved your database infrastructure to a new one and have to add one hundred targets, you will have to click some hundredth of times on the management…

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
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