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

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 set, any ‘oracle’ account on any machine (even a client) can stop and change listeners […]

Read More Listener passwords: always for 9i, never for 10g
May 24, 2007

6 Comments

plan_table changes

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 catproc.sql and u*.sql scripts in $ORACLE_HOME/rdbms/admin). In versions 9i and below, plan_table is not created […]

Read More plan_table changes
May 23, 2007

4 Comments

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

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 with DBA privileges. or Change TOAD to use the same plan table (= plan_table) that […]

Read More Fix for TOAD error ORA-02404: specified plan table not found
May 23, 2007

53 Comments

Quick SQL Server Training for Oracle DBAs

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 when I get the chance. I produced that for a 1.5 day training course to […]

Read More Quick SQL Server Training for Oracle DBAs
May 2, 2007

3 Comments

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

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 even if the wordsize has been changed in an interim upgrade i.e. 8.1.7 32bit upgraded […]

Read More 10.2.0.3 patch fails if database word size had ever been changed in the past
May 2, 2007

3 Comments