Troubleshooting

Kerberos SSO with Documentum D2 3.1 SP1

Last week, when I was working on how to setup the Kerberos SSO for D2 3.1 SP1, I faced some issues due to a documentation that doesn’t seem to be up to date… In fact, our version is D2 3.1(…)

Investigating Oracle lock issues with event 10704

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(…)

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

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(…)

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

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.

Oracle Database 12c New Features: Uninstaller encapsulated into installation media

Among the Oracle 12c new features there is the addition of an uninstall tool encapsulated in the Oracle database binaries. There is no more the necessity to download the deinstallation tool for Oracle products (deinstall utility). In this blog I(…)

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

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(…)

Errors while installing Oracle Database Vault on Oracle 11.2.0.3

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(…)

Processor licensing for Oracle database on VMware ESX

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(…)

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

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(…)

Mysqldump issue – SELECT command denied to user

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(…)