Infrastructure at your Service

 
Pierre Sicot

OOW Day 2: Enjoying Oracle’s Real World Performance show

By | Technology Survey | One Comment

I have had the pleasure to go the Real World Performance presentation with the famous Tom Kyte of the Ask Tom blog, Andrew Holdsworth, Head of Oracle’s Real World Performance Team, and Graham Wood, the legendary Oracle Database performance architect. This was not a session but more a show like in a theater! Each of them had a precise role, DBA, chief of development team, system administrator, and Enterprise Manager Cloud 12c showing us in…

Read More
Pierre Sicot

OOW Day 2: Oracle Database as a Service

By | Technology Survey | One Comment

Another day in the San Francisco Bay discovering the Oracle Cloud, but without clouds in the sky :=) Today I went to a session describing a customer case study on Oracle database cloud with Enterprise Manager Cloud 12c. Prior to deploying the database cloud, UAT activities charged the DBA team for at least 3 days (implies cost). The IT team decided to implement DaaS (Database as a Service) because of: The self-provisioning feature reduces the…

Read More
Pierre Sicot

OOW Day 1: Oracle OEM Database Express 12c & Extreme Database Management

By | Technology Survey | No Comments

My second session today was about Oracle Extreme Database Management with the latest generation of database technology by Leng Leng Tan, Senior Vice President of Oracle Development. The new Oracle database 12c announced yesterday by Larry Ellison is fully integrated with Oracle Enterprise Manager 12c. The main goal is to deliver the highest service quality with lower risk and effort. There also is a new feature called Oracle Enterprise Manager Database Express 12c which is…

Read More
Jérôme Witt

OOW Day 1: Oracle 12c – Data Guard new features

By | Technology Survey | One Comment

What a sunny day at the Oracle OpenWorld in San Francisco, temperatures over 30 degrees Celsius … don’t be jealous ;=) What should I start speaking about? Oracle Entreprise Manager Cloud Control 12c? Oracle VM or Oracle Database 12c? Well, let me summarize some of the Oracle Database 12c Data Guard new features from Joseph Meeks’s session “Oracle Data Guard Zero-Data-Loss Protection at Any Distance”. Oracle Data Guard is a high available, data protection, disaster…

Read More
Pierre Sicot

OOW Day 1: Upgrading to Oracle Cloud Control 12c

By | Technology Survey | One Comment

Today, we had the chance to attend interesting sessions under a perfect sunny Californian weather :-). The first one was about best practices for an upgrade to Oracle Enterprise Manager 12c. The session described the real case of a US company with a huge infrastructure and hundreds of databases monitored by Grid Control 11g and 800 agents. They wanted to migrate to Oracle Enterprise Manager Cloud 12c and studied the different ways to realize the…

Read More
Jérôme Witt

Oracle OpenWorld 2012 – the world is not enough: Larry’s keynote on Oracle 12c, etc.

By | Technology Survey | No Comments

I am pretty sure you are wondering what Larry Ellison announced in his Oracle OpenWorld keynote, especially concerning Oracle 12c! In fact there were three major announcements, which I will cover in this posting. But first, let’s start with Fujitsu’s (Oracle Open World sponsor) announcement on a new SPARC technology. At the beginning of the session, Noriyuki Toyoki, Senior Vice President of Fujitsu Limited (which is this year the main sponsor of the OOW) introduced…

Read More
Gérard Wisson

Documentum job dm_FTIndexAgentBoot does not start anymore

By | Application integration & Middleware | No Comments

The Documentum job dm_FTIndexAgentBoot does not start anymore and we have the following job status: The job object indicated the job was in progress. In this blog posting, I will describe how to analyze and solve this issue. Analysis The Index Agent does not start automatically when the repository is started although the option start_index_agents = T in server.ini is set. When the server is started, the dm_FTIndexAgentBoot job is normally executed, but not in…

Read More
Yann Neuhaus

“ORA-01665: control file is not a standby control file”: what can I do?

By | Database management | 3 Comments

You have certainly also received this error once in you Oracle DBA career: “ORA-01665: control file is not a standby control file” while trying to create a standby database with RMAN through a full database backup. In fact, the feature itself is not very new. It exists since at least RMAN 10g, it is called the “Restore Failover”. In order to create a Data Guard configuration, you need a standby database on the standby server….

Read More
David Hueber

Linux: Disks diagnostic using smartctl

By | Operation systems | No Comments

Facing disk issues such as corruption or block defect is thankfully not happening frequently. However when it does, the diagnose may look sometimes like a real struggle. This is forgetting that disks integrate since years the S.M.A.R.T technology. Good point, it can easily be adressed in Linux command line through smartctl What is S.M.A.R.T. exactly? S.M.A.R.T., which stands for Self-Monitoring, Analysis and Reporting Technology (also called SMART), is a monitoring system for and integrated in…

Read More
Stéphane Haby

SnapManager for SQL Server: databases limitation policy

By | Database management | No Comments

I recently talked to a customer about SnapManager, its recommendation on the number of databases and about a way to prevent the creation of more than 35 databases. The NetApp recommendation is no more than 35 databases on a single volume. The reason is that SQL Server has to use 4-5 worker threads per database in order to manage the freezing and un-freezing I/O for each database. Look at this note: More information on this…

Read More
Gérard Wisson

Oracle Middleware, administration and monitoring: a day at the DOAG SIG Middleware

By | Application integration & Middleware | No Comments

I am in the train back to Basel (Switzerland) and I will try to summarize the day spent on a SIG Oracle Middleware of the DOAG (German Oracle User Group) session related to Oracle Middleware administration and monitoring. The different topics I saw were: WebLogic 11g clustering and high availability Overiew of the Cloud Control 12c (monitoring, automatization, quality management, cloud management Real User Experience Insight (RUEI): End-to-End User Monitoring and Java Diagnostic Administration and…

Read More
Stéphane Haby

SQL Server 2012: Cumulative Update 3 (CU3) now available

By | Technology Survey | No Comments

This week, the third cumulative update was made available on the Microsoft website. What is in this CU for SQL Server 2012? This CU has 36 hotfixes: 25 for the engine 1 for SSAS 4 for SSIS 6 for SSRS To have more information and download it, click here Historic of SQL Server 2012 If you update your SQL Server 2012, you will have a new build version: 11.00.2332 I will give you a quick…

Read More