Monthly Archives: May 2007

Listener passwords: always for 9i, never for 10g

Posted on 24 May 2007 by Andrew Fraser

My rule of thumb: For 9i and below: always set a listener password (= change from default) For 10g and above: never set a listener password (= leave at default) And here’s why: 9i and below Without a listener password … Continue reading →

Posted in Security, SQL*Net | 6 Comments

plan_table changes

Posted on 23 May 2007 by Andrew Fraser

In versions 10g, plan_table exists as a public synonym of the global temporary table sys.plan_table$. That is all created automatically at database create time and when a database is upgraded to 10g (creation is in catplan.sql, which is called from … Continue reading →

Posted in Performance tuning | 4 Comments

Fix for TOAD error ORA-02404: specified plan table not found

Posted on 23 May 2007 by Andrew Fraser

TOAD can report error “ORA-02404: specified plan table not found” when trying to display execution plans: Two options to fix: Run script toadprep.sql. This creates the table toad_plan_table, among other things, and is meant to be run by a user … Continue reading →

Posted in Performance tuning | 49 Comments

Quick SQL Server Training for Oracle DBAs

Posted on 2 May 2007 by Andrew Fraser

Short SQL Server Training course uploaded in MS-Word format.. Also same in pdf format. It’s a bit dated now – is for SQL Server version 7.0 – but still relevant. I’ll update for version 2005 and convert to html format … Continue reading →

Posted in SQL server | 2 Comments

10.2.0.3 patch fails if database word size had ever been changed in the past

Posted on 2 May 2007 by Andrew Fraser

Thanks to Chris Carr for pointing out this: If you are upgrading or patching to 10.2.0.3 and the word size is different to the word size when the database was created the upgrade will fail with an ora-600. This applies … Continue reading →

Posted in Bugs | 3 Comments