Search this site

142days until
Oracle10g Desupport

posts

Subscribe to posts

Oracle ASM 11gR2

posted 19 Feb 2010 04:25 by Alan Nolan-Davies

Using Oracle Enterprise Manager Grid Control 10.2.0.5 is not able to see the ACFS volumes and mount points that have been introduced with Oracle ASM 11.2.0.1.0
11gR2 ASM Viewed with 11gR2 DB Console

11gR2 ASM Viewed with 10g Grid Control
The 2 images above show that you will need to use 11gR2 DB Console when managing your Oracle ASM 11.2 

| Attachments: asm11gR2_10205_Grid.JPG asm11gR2_11201_Console.JPG

Oracle Infrastructure at New Data Centre

posted 10 Dec 2009 04:08 by Alan Nolan-Davies

This is a simplified overview of my Oracle Infrastructure

The Office Zone will host the Oracle Enterprise Manager and Oracle Internet Directory Apps.

Oracle10gR2 and Oracle11gR2 Databases will be hosted on the Database Grids in each Zone.




| Attachments: Oracle_Hosts.jpg ~$$Oracle_Hosts.~vsd

Oracle11g Grid Infrastructure

posted 21 Sep 2009 06:36 by Alan Nolan-Davies

Thanks to a very timely release I am able to install Oracle11g Release 2 in the new datacentre that I am currently working on.



Oracle11g Release 2 now incorporates a Grid Infrastructure Product.

Oracle Grid Infrastructure 11.2 which incorporates Oracle Clusterware and Oracle ASM in a single Oracle_Home.

The design is for a Oracle Database Grids in the Data Centre and this move to a Grid Infrastructure installation whocul make things considerably easier.

| Attachments: splashscreen.bmp

Oracle Management Infrastructure

posted 25 Jun 2009 08:16 by Alan Nolan-Davies   [ updated 25 Jun 2009 08:35 ]

The Oracle Management Infrstructure consists of 3 components.
 

Oracle Enterprise Manager Grid Control

This consists of one or more Oracle Management Servers(OMS) and a repository database.
It communicates to Oracle Agents which are installed on each host in the Grid.
 

Oracle Internet Directory

This resides in an Oracle Application Server in the Infrastructure install.
Replication of this directory is possible and like the OMS more than one OID can use the same database repository.
 

Oracle Recovery Manager Catalog

Unlike the 2 above the RMAN Catalog only requires only an Oracle Database to live in.
No additonal software is required other than the Oracle Database software.
 

| Attachments: Oracle_EP02.png

Oracle Infrastructure Architect

posted 23 Jun 2009 02:33 by Alan Nolan-Davies

Currently I am working on designing the Oracle Infrastructure for a new Datacentre.
 
My plan is to use the Oracle stack as designed by Oracle to provide an industry standard enviroment with certified Oracle Configurations.
 
This will mean deploying Oracle Enterprise Manager Grid Control, Oracle Internet Directory, Automatic Storage Management, Real Application Clusters, Oracle Configuration Manager and Oracle Virtual Machine.
 
(acronym version)
This will mean deploying OEM Grid Control, OID, ASM, RAC, OCM and Oracle VM.
 

| Attachments: Oracle_Infrastructure1.png

Munich

posted 4 Jun 2009 04:40 by Alan Nolan-Davies

I spent a couple of days for a client in Munich working with a software house over there on an app that they provide to my client.
 
For reference I thought I'd write a few notes here.
 
The train from the airport to the central station takes about 40 minutes and is very easy to use. Buy a 10 Euro Ticket which will cover you to use the entire public transport system for the whole day.
 
In fact we bought two tickets for the 2 days and you just need to stamp the ticket on it's first use of the day.
 
There's no barriers to have to put the tickets through so just put it in your pocket and use the trains, underground and trams.
 
There is a 40 Euro on the spot fine if you get caught travelling without a valid ticket.
 
The hotels were around the Central Station and the shops around Marienplatz.
 

| Attachments: iPhone 151.jpg

The Search for a new role

posted 21 Apr 2009 03:24 by Alan Nolan-Davies   [ updated 21 Apr 2009 03:45 ]

I'm an Oracle DBA that has primarily contracted in the Investment Banking world.

Given today's economic climate this has not been an easy sector in which to pick up a new role.

I'm using Jobserve and increasingly LinkedIn to find a new role.

But for the last few years I have been taken on because someone already at the client knew me and recommended me for the role.

My last client was very much as surprise as the team that I went to work with remembered me from the Implementation of a Post Trade application at one of their clients, over 15 years ago (it seems that I make a lasting impression).

Prior to that I was hired by a client that had already used me twice before and the role before that one was a client that I had turned down in favour of another role, but they remembered me from the interview 18 months before.

So I will be finishing at my current client today, then I have an Oracle SOA Data Integration Workshop tomorrow.

But after that ??

New PC - Novatech Richochet

posted 6 Mar 2009 04:26 by Alan Nolan-Davies   [ updated 6 Mar 2009 04:36 ]

I've had to buy a new PC to replace the office computer which never did perform to the required standards. As I built it myself there also wasn't anyone to blame.

This time I have gone for a powerful desktop box built by Novatech.

It may not be a very small and attractive looking box, but as long as it can handle running Oracle Databases and iTunes as well as other apps at the same time, then I will be very happy.

Hopefully this spec will keep things running for a few years.
  • Intel Quad Core (4 Processors'ish)
  • 4GB Memory
  • 500GB Hard Drive
  • DVD writer
  • ATI HD 4850 512MB PCI-E Graphics

| Attachments: richochet.jpg

Email Alert Management using Gmail and Twitter

posted 5 Mar 2009 01:36 by Alan Nolan-Davies   [ updated 28 Jul 2009 07:08 ]

Despite the fact that production Oracle DBA's are required to be on call 24 hours a day it's not usual to equip them with a Blackberry or other device that could assist them in this task.

So I've had to be inventive with finding solutions that will warn me of issues with the Oracle Environment.

Fortunatley most clients have now moved to using Grid Control to monitor and manage their Oracle Infrastructures and luckily these have been allowed to send emails to external email accounts (long may it stay that way).
 
28-Jul-2009
 
A further update on this as O2 my iPhone provider in the UK is now sending text message alerts from Twitter free of charge.

So I now also have text message notification for Oracle Enterprise Manager Alerts.

For no charge I now have instant notification of alerts to my phone.
GMAIL
  1. Create an account on GMAIL
  2. set preferences on Grid Control to send emails to gmail account
  3. Create filters on GMAIL to forward "interesting" alerts to own email account.
  4. configure schedules in Grid Control to use new email address.
  5. Gmail can be used for analysis of alerts using search and labels.
(I also use an Apple MobileMe account to Push emails to my iPhone - but this is not a free service)

So for example if an ORA-00257 (Archiver Error) appears in an email it will forward the mail to my push email and I am notified immediatley.

Twitter
  1. Create an account on Twitter
  2. Set Twitter account to have protected updates.
  3. Create an account on Twittermail
  4. set preferences on Grid Control to send emails to Twittermail account
  5. configure schedules in Grid Control to use new email address.
  6. Monitor using Twitter - I use Tweetie on my iPhone

Twitter

posted 9 Feb 2009 01:57 by Alan Nolan-Davies

Twitter will become one of the most valuable tools in use today.

Although primarily a social networking tool, the uses in a business context are increasingly obvious to me.

For example imagine sending a status update automatically from a batch job to a Twitter feed.

The feed could be open to all or protected, but those who want to monitor progress need only to subscribe to that user and the need for email updates disappears.

All those release emails that are sent out to ever increasing mail groups are replaced by a subscription based service.

The large amount of emails that are generated by Grid Control and other monitoring tools can be set to tweet rather then email.

Although I must admit when I originally started using Twitter I followed various Subject Matter Experts on Oracle, but am now following entertaining celebraties too ;-)

| Attachments: twitter-hashclouds.jpg

‹ Prev    1-10 of 19    Next ›