remidian.com

play Mount of Olives

remidian is remi visser, oracle dba contractor from the Netherlands you can browse my work related braindumps, read my resume or contact me

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)

read more →

osql switches

Some osql switches. read more →

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 →

awk

Awk dumps. read more →

dbverify in nohup

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

ls

man: NAME: ls, ls – list directory contents read more →

Microsoft SQL Server 2005 JDBC Driver (oracle GRID)

Microsoft SQL Server 2005 JDBC Driver java test program. read more →

Oracle Advisor – DBMS_ADVISOR

Some ADDM dumps. read more →

Windows handies

Windows handies read more →

11g installation on Linux (Centos)

@wip 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,