Infrastructure at your Service

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

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. [email protected]********:C:\Users\oracle\…

Read More
Oracle Team

Cloud Control 12c on your laptop

By | Database Administration & Monitoring, Oracle | No Comments

By Franck Pachot . 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 environment with a 3 nodes RAC in 12c on OEL7….

Read More
Matthieu Munch

Oracle Data Integrator – The EL-T tool from Oracle

By | Business Intelligence | One Comment

Oracle Data Integrator is the ETL tool that Oracle has developed to enter into the world of Business Intelligence. Taking advantage of its incredible experience in database managing, Oracle has created an ETL tool that is flexible to use, powerful and that allows the integration of data coming from another sources.  Agility of use Oracle Data Integrator uses various types of graphical interfaces during all stages of data flow creation. Here is an example of…

Read More
Oracle Team

Linux Serververwaltung mit Puppet leichtgemacht

By | Operation systems | No Comments

Mit Puppet die Linux-Server verwalten   Sind mehrere Linux-Server vorhanden, dann entsteht sofort ein Aufwand die unzähligen Konfigurationen ( ntp, chrony, dns, users, groups, services etc.) zu administrieren. Jeder Administrator möchte möglichst alle Server auf die gleiche Weise konfiguriert haben, die gleichen Konfigurationen. Puppet ist ein Werkzeug um genau diese Tätigkeiten zu automatisieren. Das erfolgt mit Manifesten (Definitionen). Die Funktionalität ist vergleichbar mit Policys in der Windowswelt. Diese Manifeste beschreiben den soll Zustand des Systems,…

Read More
Middleware Team

Software architecture vs code representation

By | Development & Performance | No Comments

Tuesday the 10th of November I attended a public lecture at Swiss Java User Group in ZĂĽrich. Topic of the pretension was to describe and address challenges any project manager can encounter, when reflexion switches from perspective of software architecture to real coding implementation. Presentation was essentially based on Java language, but in fact applicable to any other language. So first, presenter shared project experiences he has got with some customers, and pointed weaknesses of…

Read More
Oracle Team

set “_rowsets_enabled”=false

By | Database Administration & Monitoring, Oracle | No Comments

By Franck Pachot . 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…

Read More
Stéphane Haby

JournĂ©es SQL Server (JSS) 2015 Ă  Paris – Sessions & Sponsoring

By | Technology Survey | No Comments

Faisant suite Ă  la première annonce de David Barbarin sur les journĂ©es SQL Server du 30 novembre et 1er dĂ©cembre, j’ai le plaisirs de vous inviter Ă  venir nous voir Ă©galement Ă  notre stand. Effectivement, comme l’annĂ©e passĂ©e, nous sommes heureux d’ĂŞtre Ă  nouveau sponsors GOLD de l’Ă©vĂ©nement et seront placĂ©s comme le schĂ©ma ci-dessous vous le montre. N’hĂ©sitez pas Ă  venir nous rencontrer sur notre stand! Nous aurons Ă©galement le privilège d’animer 2 sessions…

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
Stéphane Haby

SQL Server 2016: IF EXISTS is included in the DROP command

By | Development & Performance, Technology Survey | No Comments

With SQL Server 2016, I’m nicely surprised by the addition of IF EXISTS directly in the T-SQL command DROP. Before this new option, all queries are written with IF EXISTS (SELECT * FROM sys….) DROP object. I have quickly tested just for 2 drop commands(See List of available objects below): one for a table one for a column in a table

Read More