remi's adventures in the database realm

Manually triggering Metric Collection (clearing -tablespace- Alerts)

oracle / grid  February 19th, 2008

Manually triggering metric collection in Oracle Enterprise Manager (GRID control)

read more →


osql switches

mssql  January 30th, 2008

Some osql switches. read more →


Increase idle time for OMS frontend sessions

oracle / grid  January 28th, 2008

Some additional configuration directives. read more →


Remove SQL Server database from single-user mode

mssql  January 23rd, 2008

Braindump of a session where I had to remove a SQL Server database from single-user mode. read more →


Batch SQL statements in parallel (multiple) sessions

oracle / dba util  January 18th, 2008

So it was decided ‘this batch’ had to be done ‘this weekend’. Thousands of SQL statements some of them would take minutes others hours… And MAKE SURE it’s finished monday. read more →


Really delete (’corrupt’) Agent from OMS repository

oracle / grid  January 17th, 2008

Here’s how to overcome ORA-20206 in Oracle GRID environment, agent status unclear… read more →


Clearing Alerts in Oracle GRID Control

oracle / grid  November 12th, 2007

Here’s how to clear alerts from the Oracle GRID manually. read more →


invalid objects after clean ctxsys installation (oracle text)

oracle  November 9th, 2007

The following objects are invalid after a clean ctxsys install. read more →


awk

*nix / os commands  October 13th, 2007

Awk dumps. read more →


dbverify in nohup

oracle / scripts  October 9th, 2007

Suffering from corruption in your database, it is nearly just as challenging as in real life… read more →