UKOUG UNIX SIG 11/09/08

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s