From my experience for some Database Administrators / sites it still seem to be more tough / hardcore to use the command line instead of using tools that could do the same for you only with a lot less effort. And maybe that is also regarded to be a risk cause it is so easy. Well my thoughts on this is that a healthy mix on the use Gui – tools and command lines should be an asset to every administrator. And indeed before even starting debate when using the Gui of course you should always know what you are doing .. but then again that is always the case is it not ?
Creating an Rac manually – using DBCA.
Personally i think that the DBCA tool is your best way forward if you are creating a new Rac environment. Of course this tool also has also its limits ( such as on a 4 Node environment it will by default set your cluster_database_instances default to 4 even when you build only a two node Rac) but in general it is best way to work cause not only will create the Database , and the instances on the various Nodes but it also adds the information to the 11G Grid infrastructure ( the Cluster ware ). And for documentation purposes you can / should also always generate the create scripts in a default ( for me always /opt/oracle//admin/create) directory.
Yesterday i had to support a colleague who decided to create a two node RAC by hand . Indeed even when i suggested to him that using the DBCA would be helpful and fast in his actions it was his call to do it all by hand. But then he got stuck in the process with various actions.
If you decide to do a create manually ( as they say maybe you should try to not use the Gui just cause it is written in this blog). I think following steps are important:
- Work accurately ( setting up init oras , one for single Instance – Db) add the Instance specific information (in my case undo tablespace and local_listener ) were needed. Create spfile from that pfile.
- Start – create the single instance-db in full with the spfile.
- Once the single instance is alive start alter your spfile:
- alter system set cluster_database=true scope = spfile:
- alter system set instance_number= 1 scope = spfile sid=”instance1″ ;
- alter system set instance_number= 2 scope = spfile sid=”instance2″ ;
- alter system set thread = 1 scope = spfile sid=”instance1″ ;
- alter system set thread = 2 scope = spfile sid=”instance2″ ;
- Add at least the 3 redo groups to the second thread( alter database add logfile thread 2 group x:)
- set up the remote_listener with the scan listener
- alter system enable thread 2 ;
- Add a Taf service.
- As a check stop and start and stop both instances manually to see if the database is shared as it should be between the two instances.
- Add the information to the cluster:
srvctl add database -d DB -o /opt/oracle/product/oracleVersion
srvctl add instance -d DB -i DB1 -n Node1 srvctl add instance -d DB -i DB2 -n Node2
srvctl modify instance -d DB -i DB1 -s +ASM1 srvctl modify instance -d DB -i DB2 -s +ASM2
srvctl add service -d DB -s DB_TAF.domain -r DB1,DB2 srvctl start database -d DB srvctl start service -d DB -s DB_TAF.domain
Ok, are you still with me , do i rest my case here that it is a lot of work to do this the manual way ? And that these steps can be very lets say error prone if you do not work 100% accurate..
Yesterdays event where indeed not successful at first . Amongst other issues He got :
PRCR-1079 : Failed to start resource ora.db.db
CRS-5017: The resource action “ora.db.db start” met the following error:
ORA-29760: instance_number parameter not specified
Once again Google was our friend it showed post of a fellow blogger with regard to a Mos note:
MOS note ‘ORA-29760: instance_number parameter not specified’ When Starting the Database with Srvctl [ID 749515.1].
After that . Things worked .
Bottom-line of this story ? Plain and simple use the right and easiest tool for the Job you need to do. If that is a Gui there is no dishonor in that . If you decide to go manual create , make sure you work accurately hmm and have Google available for when things come up during the process.
Happy Reading ,