Oracle EBS cloning

[vondutch9]

Hi,

 I have a customer running Oracle EBS ver 11.5.10.2 with Oracle database 9.2.0.8. The application and database tier are hosted on two different physical servers. The application server is HP PA-RISC server running HPUX 11.11 and database server is running HPUX 11.23 on Itanium microprocessor.

 The customer want to implement GST so want to test the changes before deployment to the production. Thus we  have to create a dev/staging environment with data being cloned from production. How can I go about it? Please note that the dev/staging environment also will have two separate servers.

 Also do I need the same capacity in terms of CPU and memory in the dev/staging environment or it can be a scaled down version of the server also.

 I appreciate your help on this.

Thanks
Regards,
Ashish

[ErmanArslansOracleBlog]

Hi Ashish,

If you will need to test the performance of both application and database bound processes , then you have to use a same hardware in the dev/staging environment.
Operating system vendor and version also need to be the same. Having same OS in the dev environment also brings you te opportunity to test patces and upgrades in the clone environment.
Periodically updating the dev/staging environment by taking new clones , is also important..
This will bring you the opportunity to test scenarios which may be caused by problematic data, or perfomance problems caused by loading of new data..

On the other hand; if you just test some plsql, reports or some forms to make sure it is working as expected(without a need to check the performance of them), then you gave go for a scaled down dev/staging environment..  But again, use the same OS vendor and versions in the dev site.. If you dont use the same OS in the target , your cloning operations will be hard for you.

So, It is up to you and depends on your needs..

Lastly, you can use the following document for cloning ;
Cloning Oracle Applications Release 11i with Rapid Clone (Doc ID 230672.1)