Infrastructure at your Service

Category

Database Administration & Monitoring

Oracle Team

EM13c Gold Agent Image

By | Database Administration & Monitoring | 3 Comments

One of the most interseting new feature in Enterprise Manager 13c is the Gold Agent Image. This new feature will simplify the agent management. The first thing to do is to create a Gold Agent image, from the setup menu , select Gold Agent Image: Then select Manage All Images: Select Create Enter the image name, a description and the platform name, then submit: Your gold image is created: Before to subscribe an agent, we…

Read More
Oracle Team

EM13c and Management Pack Annotations

By | Database Administration & Monitoring, Database management | One Comment

Enterprise Manager 13c offers a new feature allowing displaying the management packs used by a feature. To enable the Management Pack Annotations, you select Enable Annotations from the Setup Menu –> Management Pack: From now on your menus are filled up with acronyms more or less comprehensive, from a performance page on a target database:   From now on your menus are filled up with acronyms more or less comprehensive, for example from a performance…

Read More
Oracle Team

Enterprise Manager 13c and BI Publisher

By | Database Administration & Monitoring | One Comment

In Enterprise Manager 12c, if you need to display the database storage, from the report menu you have the following possibilities: From now on, with Enterprise Manager 13c, this possibility does not exist anymore in the report menu, you have to use the BI publisher feature. If during the EM13c installation phase, you choose not to configure BI publisher, you will see the following message while trying to access the BIP page: If you have…

Read More
Stéphane Haby

SQL Server 2016: Extended Events are more powerful as Trace Flag for Backups and Restores

By | Database Administration & Monitoring | No Comments

Before SQL Server 2016, we use Trace Flag to display information about backup and restore operations like the 3004, 3014, 3213 or 3604. Here a link to the MSDN with a great SQL Server trace flag list SQL Server 2016 provides 2 new Extended Events: backup_restore_progress_trace database_backup_restore_throughput backup_restore_progress_trace will give detailed information during the backup process and restore operation database_backup_restore_throughput will provide different throughput about backup/restore process Create an Extended Event for Backup & Restore…

Read More
Oracle Team

GoldenGate Studio 12.2 – Create repository

By | Database Administration & Monitoring | One Comment

In a previous blog I explained you how to install GoldenGate Studio. This time the goal is to describe how to create the repository required by GoldenGate Studio. Oracle provides a tool to create all the repository data required by GoldenGate Studio. Its name is RCU for Repository Creation Utility. Create repository The first step is to go to the folder GOLDENGATESTUDIO_HOME/oracle_common/bin. In this folder there is the RCU executable. Launch it: [email protected]:/u04/app/goldengate/product/ggstudio122/oracle_common/bin/ [DB1] ./rcu…

Read More
Stéphane Haby

SQL Server: Now Cumulative Updates (CU) need to be install!

By | Database Administration & Monitoring | No Comments

 Since this year, Microsoft recommends to install Cumulative Updates (CU) like Service Packs (SP) In the past, Microsoft always recommended to apply the Service Packs and security fixes for SQL Server. Cumulative Updates were applied only if you had a specific problem in order to resolve it. Now, we need to follow a new rule: “ Microsoft recommends ongoing, proactive installation of SQL Server CUs as they become available: SQL Server CUs are certified to…

Read More