As many of you know a cloning is one of the most DBA time consuming operations. For the first few times an Apps DBA may enjoy it. However, after the 20th cloning it becomes a boring routine.
For some time I have been interested to get the EBS cloning process 100% automated and I must admit that for many customers we have been quite successful with the process; saving them tons of DBA boring hours ;)
If you have tried to automate EBS cloning then you definitely know that you can’t get through without hacking and customizing the Oracle-provided Rapid Clone utility. One of the areas we should “hack” the code to make it running in batch scripts is the services startup bit. The problem is that by default straight after Rapid Clone is completed Oracle starts all the services on the Apps node and until now there wasn’t a way to change it. There are many reasons why you wouldn’t start Apps processes straight after Rapid Clone is completed. Among them are APPS user password change (this is typical operation for cloning), SSO integration, CM/CR disabling etc.
R12.1.2 brings on board a small but very nice feature. From now on, Rapid Clone will ask you if you would like to start services at the end of Rapid Clone call:
Do you want to startup the Application Services for EBSPRD? (y/n) [y] : n
How great is this? Now we can specify that we don’t want to starup services and run after cloning steps before we are ready to start the environment.
My best regards to all Apps DBAs around,
Yury
7 Comments. Leave new
That’s certainly preferable to commenting lines out of adcfgclone.pl; I was glad to see this feature. :-)
Thank you John for following up. Stay tuned more staff will come.
BTW: You have a good blog too.
Yury
Is there a context file variable to set this? If you are doing 100% automated, you want to be able to provide ‘N’ to this prompt – is that possible in 12.1.2?
Cheers
[…] little while ago, Yury Velikanov at Pythian blogged about a new feature in the RapidClone tool for EBS 12.1.2. In summary, Apps DBAs finally have the option to disable the startup of application […]
You can run “expect” scripts to interact with the autoconfig shell scripts to pass parameters back and forth to automate the “no” at the end of “do you want to startup”
Hi,
Does anybody finally reach to automate cloning process?
Database tier at least?
If so, please share it.
update the adcfgclone.pl to to ask to skip the startup of servvice during clone
# flag used to skip running starting of services
my $isSkipStartingServices = “true”;