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 10gIn 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 changesTOAD 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 foundShort 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 DBAsThanks 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 pastThis would seem to be pretty authoritative: “And on the seventh day God ended his work which He had made; and he rested on the seventh day from all his work which He had made. And God blessed the seventh day, and sanctified it; because that in it he had rested from all his work […]
Read More And on the seventh day, God fiddled with His NLS settingsGUIs like TOAD and Enterprise Manager can show this better, but they’re not always to hand. Every session active now or within the last minute is shown. set pages 9999 lines 132 col username form a20 col osuser form a20 col program form a50 col minutes form 999 alter session set nls_date_format = ‘Dy DD-Mon-YYYY […]
Read More What SQL and sessions are running?So I had: ORA-08103: object no longer exists being reported on SQL affecting one application table. But that table existed ok in dba_tables, could be described ok, and selects restricted to its indexed columns returned data ok. Suspicion was some sort of data block corruption. Rman backup logs had not reported any corrpution, but dbverify […]
Read More Data block corruption cleared with alter system flush buffer_cacheIt’s often a pain getting X windows GUIs like the Oracle Installer and DBCA to run on Micrsoft Windows PC clients. Emulators like Reflection-X, KEA-Term, and Exceed work ok, but they cost money to licence and require source media and local admin rights to install. Those things can take an age to organise in large […]
Read More Free X windows emulator for running Oracle InstallerToday had noticed that redo logs were not being applied to standby. Checking live database alert log showed errors like:
Read More Data Guard today