Monday, August 28, 2006

Random training related thought

A thought just crossed my mind. I wonder if there is a market for short (one day) task oriented training for the sort of things that aren't normally covered in general courses.

For example I'm aware that there are training courses that mention standby databases and certainly there are courses that cover RMAN, at least for basic backup and recovery. I'm not aware of any that actually take you through setting up a standby database, with a hands on practicum, or that covers things like cloning a database with RMAN. These are things that DBAs might be required to do. Sure you can read up in the documentation and, if you are lucky enough to have the kit, try out but might there be a market for, say, a one day course in how to use RMAN to create a clone database and then convert it to a standby for the database you've cloned? Or something similar with other such tasks ("Your first RAC cluster")?

I'm sure that there have been user group and technology day type presentations on those sorts of things but these lack the hands on aspect.

Monday, August 07, 2006

Search Terms

Doug Burns recently posted in his journal a list of common search terms that people have used where his journal appeared in the results. I figured I'd post mine (according to Statcounter.com). Fortunately (or unfortunately) mine are not anywhere near as exciting as his.

Perc. Search Term
5.80% ora-07445
4.35% orapwd invalid username password
2.90% exception signal: 11 oracle
2.90% alter user sys
2.90% move tempfile oracle 8
2.90% ora-01031 sysdba
1.45% oracle password file orapwd
1.45% htmldb_public_user change password
1.45% htmldb startup
1.45% oracle 10 bind parameters ora-07445
1.45% address not mapped to object ora-07445
1.45% failed to start a managed process after the maximum retry limit
1.45% failed to start a managed process htmldb
1.45% decode(true in oracle
1.45% 9.2.0.7 patchset filename
1.45% opmnctl startall htmldb
1.45% sql number exists oracle htmldb
1.45% opmnctl: starting opmn managed processes
1.45% 3440097 oracle
1.45% shutdown immediate oracle insufficient
1.45% oracle allow normal sys login
1.45% ora-01031: insufficient privileges when startup oracle
1.45% oracle startup as sysdba
1.45% passwordfile rac
1.45% http_server retry limit
1.45% starting opmn and all managed processes
1.45% use of the orapwd file
1.45% orapwd entries
1.45% oracle datafile how to now autoextend
1.45% sqlplus nolog oracle
1.45% oracle is started but my instance isn't
1.45% sqlplus sysdba insufficient priviledge
1.45% english_united kingdom.al32utf8
1.45% oracle sql user sysdba login
1.45% ora-01017 sys as sysdba
1.45% error opw-00005
1.45% orapwd password
1.45% oracle value as column heading
1.45% sysdba
1.45% ldap 32gb
1.45% opmnctl startall ias-component
1.45% 9.2.0.7 patch set - list of bug fixes by problem type
1.45% opmn shutdown failed
1.45% setup oracle ldap
1.45% pfile processes double sessions transactions oracle
1.45% why use orapwd password file
1.45% oracle users select sysdba
1.45% http_server failed to start a managed process after the maximum retry limit
1.45% ora 07445
1.45% htmldb authentication error
1.45% orapwd password file
1.45% change oracle instance
1.45% oracle import guaranteed to work in later versions
1.45% oracle select no column headings
1.45% exception signal: 11 (sigsegv), code: 1 (address not mapped to object), addr:
1.45% oracle shutdown immediate insufficient privileges
1.45% changing remote_login_passwordfile
1.45% how to change password for sysdba on oracle
1.45% oracle opmnctl fail start solaris
1.45% oracle shutdown as sysdba


I hope the people found the answers they needed.

I wonder if, given sufficient results from a variety of Oracle blogs (and editing out the ones that are obviously spurious) during a specific time period, it might be possible to identify what sort of things people are searching for? An "Oracle Zeitgeist" perhaps?

In other news one of our major apps is getting a patching (the app, not Oracle) tommorrow. I'm nervous, always am before a patching.