Infrastructure at your Service

Category Archives: Database Administration & Monitoring

Pierre Sicot

Oracle Compliance Standard

By | Database Administration & Monitoring | No Comments

In Enterprise Manager 12c, using the compliance standard results might be a good solution for DBA’s to detect security incoherences (for example a lambda user who has the sysdba role …) for their various targets. From the 12.1.0.3 version, a new column named ‘Required Data Available’ appeared in the Compliance Standard Result screen. This column defines if the data for the compliance evaluation rules for each target are in the repository or not. If the…

 
Read More
Daniel Westermann

The scripts of my DOAG 2015 session: Automated GI/RAC staging with Cobbler and VirtualBox

By | Database Administration & Monitoring | 2 Comments

I promised to upload the scripts of my session to our blog. So, here they are: create_12102_gi_rac_project.sh: This one creates the 12.1.0.2 GI/RAC project on the cobbler server finish_ora_12102_gi_rac_project.sh: This one does the configuration of the GI/RAC on the last node ora12102_gi_rac.ks: The 12.1.0.2 GI/RAC kickstart file pg940.ks: Template kickstart file for PostgreSQL 9.4 create_940_postgres_project.sh: Template project file for PostgreSQL 9.4 for creating the project on the cobbler server remove_projects.sh: A sample to delete the…

 
Read More

Instance fails to start automatically

By | Database Administration & Monitoring | No Comments

Recently at a customer I was confronted with a problem of restarting the Oracle Database 12c automatically on a Windows Server 2008 R2 x64. I installed Oracle 12.1.0.1.0 with a user of service in a domain who has member of the Group ORA_DBA. The authentication service is correctly set with the NTS parameter in the sqlnet.ora file. This Installation has been successfully but after a reboot we can see the database are not OPEN. oracle@********:C:\Users\oracle\…

 
Read More
Franck Pachot

Cloud Control 12c on your laptop

By | Database Administration & Monitoring, Oracle | No Comments

Today every DBA should have a lab on his laptop. This is where I reproduce most of cases before opening a SR, or to investigate something, to demo, to learn new features, or to prepare an OCM exam. I’ve a few basic VirtualBox VM with single instance databases (11g and 12c, SE and EE, CDB and non-CDB, etc). I’ve the RacAttack environement with a 3 nodes RAC in 12c on OEL7. But in order to…

 
Read More
Franck Pachot

set “_rowsets_enabled”=false

By | Database Administration & Monitoring, Oracle | No Comments

This 12c ‘wrong results’ issue is thoroughly described by Mike Dietrich (https://blogs.oracle.com/UPGRADE/entry/switch_off_rowsets_enabled_in) and I’ve nothing to add. This blog post is there to be used as a reference for the comment in the following recommendation that we give to our 12c customers: alter system set “_rowsets_enabled”=false comment=’see http://blog.dbi-services.com/_rowsets_enabled’ scope=both; Our best practice is to document any parameter that is set as a workaround so that it can be revert back when not needed anymore.  

 
Read More

Oracle DBA Essentials Workshop – Patchset 11.2.0.4 Available

By | Database Administration & Monitoring | No Comments

We have Upgrade our Environment Oracle DBA Essentials Workshop of release 11.2.0.3 to 11.2.0.4. From now on, you can operates the various subjects on the new release. In this article, I present you the procedure to be followed for the upgrade of your database: Update DMK to the version 14-10 Upgrade database Install Oracle Patchset 11.2.0.4 and PSU Update DMK 14-10 The first step it’s update Data Management Kit, included dmk_sql. We need to Download,…

 
Read More
Vincent Matthey

GoldenGate – Error during a register extract

By | Database Administration & Monitoring | 2 Comments

This week, I tried to install a GoldenGate environment to make some test. The installation was good and simple. Firstly I tested the normal capture mode and all worked correctly. In a second time, I wanted try to use the integrated capture mode. When arrived the time to register my extract in the database, I have received an error. GGSCI (goldengate as ggadmin@DB1) 2> register extract test database ERROR: Cannot register or unregister EXTRACT TEST…

 
Read More