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.
LVL 1
miyahiraAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
I really can't comment on RAC setup but wanted to comment that the 120 hours is probably man-hours not linear hours.

At times there will probably be three to five people working in parallel on the effort.  So for every actual hour, you will be charged three to five hours labor.

I'm thinking I would want at least a week (probably more or a complex database/system) if you called me in off the street to just perform a simple database upgrade.  

You would probably want me around when you were performing the check-out after I was done so tack on another day or two.
0
vishal68Commented:
I see one major flaw in your plan. Normally for this kind of a migration, I would keep two phases. What I mean is, I will migrate all the databases to RAC and release the system for testing by it team and end users for a period of at least one week in first phase. This will bring out any issues with the application and RAC, issues with migration if any.After that I will clean up the system and do a second migration for production release.

Is this plan( in terms of tasks) defined by you or the external source. If defined by you, check with the external source they may be planning for multiple phase approach, that will justify the 120 hours.

HTH
Vishal
0
jiruizCommented:
I don't want compare Oracle in Linux versus Oracle in windows but my experience is clear: It's easier install Oracle 10gR2 RAC in Windows than in Linux but ...

With Oracle support I try to install Clusterware 11.2 in a three nodes RAC in Linux Red Hat 5.5 64 bits and Oracle Database 10gR2 with ASM. There was a lot of problems with the creation of instance with DBCA and with the creation scripts. We went backwards and remove every Oracle product. After that we install Clusterware 10.2 with a various known problems. And after the rest. Total: 8 hours. But ...

The hell was the SO configuration. ASM disk with multipathing and a lot of requirements with the IPs, the disks, etc. Total: 4 days. This work was made for another team with a lot of work in anothers systems but I think, in effective work, this take a few hours.

In windows this phase is very mucha easier. I think, your problem is migrate form Oracle 8!!! Nor the size nor the connections but I think there are a lot of differences between Oracle 8 and Oracle 10g and maybe there is where you'll spend more time, maybe those 120 hours
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

miyahiraAuthor Commented:
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.
0
AnandCommented:
miyahira,
You have 8 x 10g standalone databases.
Step A,B are quite fine.
As vishal pointed out, step C should be Standalone Databases migration to RAC databases(with or without consolidation as required) and Release for UAT(User Acceptance Testing) for 1 week.
Step D - resolve the issues identified by during Testing.
Step E - Go Live - this is exclusively minimum 5 working days.(8 databases , migrate to RAC and release to users in phases.eg. 2 databases a day.
Step F - Users Verify the production with their Test Scenarios and Sign off
This is a well organised plan with minimized Risk levels. 120Hours is properly sized quote i strongly believe. that too plan goes as expected without any unforeseen/unexpected surprises.
Irrespective of the platform(could be linux,could be sun solaris , could be windows...), RAC is an implementation with specialist area. Even though Oracle provided many GUI utilities for RAC setup, there is no surprise if the implementation faces delays/surprises.Classic Examples are like, it can stuck at detecting ocr, voting or ASM partitions itself preventing to move forward. Database creation in RAC mode can create a database on a single node only and fail at replicating the instance on 2nd node. And if at all RAC environment goes in to restart cycle(i.e, RAC starts failing over the other node thinking that the 1st node is down and vice versa.) , then one support call with oracle can consume the whole week without any producivity. Considering this type of RUNTIME complexities, the given quote is quite good.

For your 2nd question , i.e, u can do it yourself, the answer is if you are lucky and all goes well , you might pass through certain stages. But once u r hit with one complex problem, you will be stuck needing some experienced person's rescue... that is the reality.
I am not trying to project the RAC implementation as complex and rocket science. To put in one single statment 'IT IS AS EASY AS COMPLEX'.
This post is as per your given 8 production databases also
happy RACing.


0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jiruizCommented:
I think anand_20703 is right
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.