Quite a poor turnout I thought, in a rainy grey Slough. Here are some quick contemporaneous notes I took during the day, a little bit on the short side I’m afraid!
Auditing Recoverability – Tony Hasler
Audit//health check your backups
prohibit deletion of archived logs that have not been backed up multiple times.
recovery options:
drop & recreate tablespace
flashback
recovery from disk/tape
Block Media Recovery
I think it is a fair point that you should think in terms of recovery rather than backups.
Database Authentication – James Anthony
Hurt by comments about paid for options. I should add that James is an excellent presenter.
General authentication problems each db within an organisation has different passwords if you have a large database estate this could be 1000’s of passwords.
log into different
oracle internet directory is ldap v3 compliant can sync with 3rd party directories
uses identity management realms.
single authentication it is NOT single sign on
each connection requires a unique authentication
enterprise roles are managed within the directory
when a user log in to a pariticular instance they get the appropriate privs for that db – i.e they could have different privs in different db;s.
can be applied for logins as sysdba.
authentication – conection pooling
way round this is proxied user identity – inside the connection pool this identifies the user.
grant connect through role
modify the java connection code to put in proxy_user_name OpenProxySession
ah it’s a cost option with oracle but you can code this bit yourself
can audit who is loging in
11g Grid Control integrated in BEA?
What ASM Can Do For You – Jason Arneil
I was somewhat disappointed with my performance, I did however receive some useful feedback to incorporate into the next time I give it.
Xen Virtualisation – Martin Bach
Martin is a smart guy, he was convinced that paravirtulisation was highly performant. Oracle have a VM offering called imaginatively Oracle VM. It is the only VM on which an Oracle database is supported it is Xen based.
Xen requires modifications to the guest O/S kernel.
