Infrastructure at your Service

Troubleshooting Archives - Page 3 of 4 - Blog dbi services

Franck Pachot

Franck Pachot: Oracle is hanging? Don’t forget hanganalyze and systemstate!

By | Database management, Oracle | 11 Comments

sqlplus / as sysdba oradebug setmypid oradebug unlimit oradebug hanganalyze 3 oradebug dump ashdumpseconds 30 oradebug dump systemstate 266 oradebug tracefile_name Your Oracle database – production DB, of course – is hanging. All users are blocked. You quickly check the obvious suspects (archivelog destination full, system swapping, etc.) but it’s something else. Even you, the Oracle DBA, cannot do anything: any select is hanging. And maybe you’re even not able to connect with a simple…

 
Read More
Stéphane Savorgnano

SQL Server 2012 SP1: Sixth Cumulative Update (CU6) available

By | Technology Survey | No Comments

Some days ago, Microsoft published the sixth Cumulative Update (CU6) for Microsoft SQL Server 2012 Service Pack one, two months after the fifth one. As usual, if this Cumulative Update solves an issue you are facing, install it quickly – otherwise, do not install it and just have a look at it. Which issues are covered by this CU6? It is a small CU, it contains only 23 Hotfixes, mainly for the Engine and Analysis…

 
Read More
Grégory Steulet

Errors while installing Oracle Database Vault on Oracle 11.2.0.3

By | Database management | 2 Comments

During one of my last consulting missions, I had to install Oracle Database Vault on an existing Oracle environment. It clearly was not a straigthforward process, since I experienced some weird errors such as: ORA-28003: password verification for the specified password failed, ORA-20001: Password length less than 8, and ORA-01917: user or role ‘LBACSYS’ does not exist. After having a look at several log files, I found the root causes of this error. Below, you…

 
Read More
Michael Schwalm

Processor licensing for Oracle database on VMware ESX

By | Hardware & Storage | 2 Comments

In this post, I would like to share with you what I have learned about Oracle licensing particularities on a virtualization infrastructure (software partitioning) based on VMware ESX. Recently, I faced an Oracle licensing problem on a VMware ESX cluster on which I had to find a workaround in order to make the hardware comply with the customer’s licensing model. Without entering in details, the customer had a VMware cluster with three nodes and had…

 
Read More
Stéphane Savorgnano

SQL Server 2012 SP 1: Third Cumulative Update (CU3) available

By | Technology Survey | No Comments

Three weeks ago, Microsoft published the third Cumulative Update (CU3) for Microsoft SQL Server 2012 Service Pack one. As usual, if this Cumulative Update solves an issue you are facing, install it quickly – otherwise, do not install it. Which issues are covered by this CU3? It contains 38 Hotfixes: 27 for the Engine 8 for SSAS 3 for SSRS To have more details or information about these hotfixes, click here. Historic of SQL Server 2012…

 
Read More
Grégory Steulet

Mysqldump issue – SELECT command denied to user

By | Database management | No Comments

During one of my last MySQL mission, I encountered a “security error” with mysqldump. The mission was about migrating a MySQL database from one box to another MySQL version and from Windows to Linux with different users. In order to do that, I used mysqldump. During the import of the data, I got the following warning: ERROR 1449 (HY000) at line 1860: The user specified as a definer (‘cdadmin’@’%’) does not exist Following the migration,…

 
Read More
Michael Schwalm

Bug on Oracle 11.2 “ORION FAILS WITH ORA-27061″: Patch available!

By | Application integration & Middleware | No Comments

In march 2011, my colleague Gregory Steulet published an article about Simulating and testing I/O performances with Orion. In this article, he wrote about a bug concerning Orion on Oracle 11.2, reported in Oracle bug number 9104898: “ORION FAILS WITH ORA-27061: WAITING FOR ASYNC I/OS FAILED”. Trying to compare performances of storage devices on a virtual machine between a classical and a paravirtual storage adapter, I experienced the same error when using large IOs. I…

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

Oracle Enterprise Manager 12c – Database Target remains in Pending state (SLES x86_64 target)

By | Database management | No Comments

Last month I was confronted to a very interesting and strange problem while deploying a Cloud Control 12c infrastructure. One of my monitored server was a SuSE Linux Enterprise Server (SLES) 64 bits on which a 11.2.0.3 Oracle database was installed. The x86_64 cloud control 12c agent has been deployed on this server with the standard Cloud Control 12c agent deployment procedure (not the scope of this post). However despite several trials to configure the…

 
Read More