Purging SYSAUX tablespace (Purging AWR reports)
Dump below is of a session clearing the sysaux tablespace. read more →
Restore SQL Server database with TSQL
Recently I had troubles restoring a database in my SQL Server 2005 instance (SP3). I used the ‘wizard’ in the SQL Server Enterprise manager but after I got the message ‘restore completed successfully’ the database hung in ‘Restoring’ state, blocking connections. read more →
freaking hilarious incident…
**** production DB issue
User ID :****
Phone :+****
Location :****
PC nr :****
Software/hardware :****
Problem & TS :
A job hangs in ****,
Job name: ****
User would like to be called back on the phone number provided if more information is needed.
User said he cannot explain it to me because its too difficult to understand and i wouldnt understand anything anyways.
**** production DB issue
copy from call ticket 600-01-12184003 with incident ticket 600-02-6637739
hey team,
talked with **** **** about this problem and she assigned it to your team.
Can you please take a look at it?
Thank you
Manually triggering Metric Collection (clearing -tablespace- Alerts)
Manually triggering metric collection in Oracle Enterprise Manager (GRID control)
Increase idle time for OMS frontend sessions
Some additional configuration directives. read more →
Remove SQL Server database from single-user mode
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
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
Here’s how to overcome ORA-20206 in Oracle GRID environment, agent status unclear… read more →
Clearing Alerts in Oracle GRID Control
Here’s how to clear alerts from the Oracle GRID manually. read more →
invalid objects after clean ctxsys installation (oracle text)
The following objects are invalid after a clean ctxsys install. read more →
dbverify in nohup
Suffering from corruption in your database, it is nearly just as challenging as in real life… read more →
Microsoft SQL Server 2005 JDBC Driver (oracle GRID)
Microsoft SQL Server 2005 JDBC Driver java test program. read more →
mailx
man: NAME: mailx, mail – interactive message processing system read more →
Make Joomla! multi sites enabled.
Replace $JOOMLA_HOME/configuration.php with the file below and ‘off you go’, the Joomla! codebase can now serve multiple websites. read more →
Next,
