Exploring the add-on of ACFS was a pleasure. As a pilot it has been implemented now and it looks we got ourselves a new standard which is awesome. With the slides below i would like to offer a quick demo and some suggestions for a standard.
Some months ago I have implemented an Active Passive Solution on Oracle 11gr2 for on one of the customers. Basically this was almost reliving old days where tools like HP MC Service Guard (using packages where one or more database and listener configurations are stored) or Veritas Clusterware (where and Agent controls the status of the resources being a database and or a listener). They would monitor the health of the Database/Listener, would stop and start the Database/ Listener. With the technology at hand at that point and time ( implemented 126.96.36.199 Grid Infra with ASM and 188.8.131.52 Rdbms ) it was not having all the required setups to implement anything else. Now we are 9 months further in time, standards have been adapted and we have latest Oracle version at hand ( being 184.108.40.206) so it is time for a fresh start. Besides that recently I have been asked to implement the Active Passive solution on more environments (since it does cover part off HA and it controls the monitoring of the Database/ Instance by HP-Openview).
For a couple of databases I had to install the Java Virtual Machine after the Database had been created. First attempt was using the DBCA gui to get that done so i started it and made the obvious choices to work with A Rac database , to configure the database options and selected the Database I wanted to work with ( in the list only databases showing no instances). DBCA was not so nice to me this time, telling me: “service name or Instance name not specified”. Hmm well since i knew i can do without GUI anyhow i decided to take the manual route and leave DBCA be for the moment. So lets saddle up and do it the old – still – going strong command line way .
My environment is a Linux 5 enterprise edition, my Oracle version is 220.127.116.11. My Database is a two Instance Rac Database.