Link to home
Start Free TrialLog in
Avatar of miyahira
miyahiraFlag for Peru

asked on

How many hours take an Oracle RAC implementation?

Ok, it's a dummy question, but we have some doubts about an outsourcing service.

We need in our office to implement Oracle 10gR2 RAC, two nodes in W2k3 Server 64 bits. Our two servers are in a HP Bladesystem c3000. Each one has 32 GB RAM and processor Intel Xeon E5540.

We use Oracle database from 5 years ago. We have some experience, but we are not masters.

We decided to take an outsourcing service for RAC implementation and for some external reasons it's not so easy not to hire them.

This outsourcing service has estimated about 120 hours to implement Oracle RAC. I think it's excessive. Maybe I'm wrong about it.

I know that time will depend on what we need to be done, so this is basically what we need:
(this is a translation to English, sorry for mistakes)
Note: When we talk about "migration", it means passing one instance in Oracle to Oracle RAC

a. Planning
      Collect or gather information
      Strategy and Planification for implementation and migration

b. RAC installation for production environment
      Review and evaluation for configuring W2k3 Server in 64-bits
      Installing and configuring Clusterware
      Installing and configuring ASM
      Installing and creating database in RAC of 2 nodes
      Configuring TAF (Transparent Application Failover)
      Tuning RAC

c. Data Migration and release to production
      Upgrade and consolidate 8 databases or Oracle instances to RAC (100Gb)
      Tuning database
      Testing, including conecction from .NET 1.1 or 3.5 applications using ODP.NET to database in 64-bits O/S.
      Release to production

If I distribute 120 hours for a RAC implementation, it means more or less 6 hour per day, from Monday to Friday, for 4 weeks!

So, one month for implementing Oracle RAC? Really? If I had that amount of time, I could do it by myself.
SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of miyahira

ASKER

Hi jiruiz,
No, it's not from Oracle 8 to Oracle10g. There are 8 instances in Oracle 10g that we want to pass or migrate to Oracle RAC in 10gR2 and in W2k3 Server, not Linux. That's why I assumed that 120 hours is too much.

I agree that testing and tuning is impossible to predict and could take a lot of hours. Now we are planning to use BLOB fields to store 2MB-10MB data. That could be tricky  to tune assuming that we expect to have between 3000-5000 concurrent connections.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I think anand_20703 is right