Q
Problem solve Get help with specific problems with your technologies, process and projects.

Multiple instances of Oracle Financials on similar hardware

With regards to the question that was asked about a single instance of Oracle Financials, how important is to to have the multiple instances of Oracle Fincials on similar hardware (exact replica of production server)?
There are two major requirements that affect the answer:

What is the desired application availability? If you have global, 24X7 production, you will want a distributed system, probably featuring RAC (Real Application Clusters), which at one time was called parallel server. If you are unsure of the availability you need, ask yourself or your operations management personnel what the cost of the system being down at any time. Then ask your financial management what the dollar cost would be if you could not process orders/shipments/payments for a period of time. Can the users tolerate an outage over night? For a couple of days? How adept are your DBAs at database/application troubleshooting?

What is the cost of lost data? This will help drive your backup and recovery plans. If your system fails, and an hour (or days) transactions are lost, what is the cost for manual recovery/rekeying data and transactions lost? Whatever the availability required is, you will want a carefully planned (and tested) backup and recovery plan.

These questions are separate from the production/development/test instance question. You always want AT LEAST one development instance, although best practice for Oracle Apps is to have (1) stand-alone patch database (2) development (3) test and (4) production. How you actually work depends on your software configuration control practices, and your tolerance for pain. Allowing developers to test in production or to add programs, change applications setting into production without complete testing is a receipe for disaster.

This was last published in November 2003

Dig Deeper on Oracle server hardware decisions

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close