Infrastructure at your Service

Troubleshooting Archives - Page 3 of 4 - Blog dbi services

Oracle Team

Investigating Oracle lock issues with event 10704

By | Database management, Oracle | 3 Comments

By Franck Pachot . Did you ever encounter unexplained Oracle lock issues? They may be coming from unindexed foreign keys (which is worse in 11g). It’s not easy to monitor. Of course you can check Oracle locks from V$LOCKED_OBJECT, but that is a solution only for locks that remain. Some Oracle locks are there only for a short duration. How do you check which lock is acquired by a statement? Event 10704 is the solution. I’ll show…

 
Read More
Oracle Team

Troubleshooting: ORA-29283 when oracle is member of a group with read/write privileges

By | Database management | 6 Comments

Recently, I worked on an Oracle database migration for a customer and I faced a strange behavior when accessing a file stored on the file system of the Oracle database. The database has been migrated on a new server, and consolidated with existing databases. Several jobs are running into the database and need to access the file system to read or write some files. A particular file is received daily from a remote job over…

 
Read More
Oracle Team

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

By | Database management, Oracle | 12 Comments

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

 
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
Oracle Team

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
Oracle Team

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