Red Hat Cluster vs Oracle RAC - need advice
992990Feb 24 2013 — edited Mar 1 2013Hi DBA Gurus,
I`m unix Sysadmin and I need Your advice concerning Oracle Cluster. I`m not so experienced so I need Your support.
In my work we have multiple different database instances:
a) Standalone servers
b) Red Hat Linux Clusters with Oracle Database
but no Oracle RAC`s.
At the moment we have a project which use *1 Oracle standalone server(2CPUs, 96GB ram)* with *4 Oracle Instances* and aproximately *30users(80-250GB)* connected to application servers.
Right now we are using only 3 application servers and I observed 100CPU usage on the database for time longer that 3-4hours. DBA told me that application generating such a high usage of the CPU.
At the moment we have only 3 applications servers connected to that server, but what will happend if I will connect next 26 ? I`m affraid that DB server will stop working...
I asked our DBA for solution which can give us more performance and stability, I suggested to use Oracle RAC with 3 nodes. He told me that Oracle RAC generating more problems than help and he will not agree for that. Is it true ? Is there any chance to build a performance/availability cluster without Oracle RAC ? It seems that for this project database tunning will not solve the problem because we have multiple huge schemas. What kind of solution should I implement for this ? I`m pretty sure that Red Hat Cluster with Oracle database will not solve a problem with Oracle performance.
This is serious problem for me...
I count on Your help...
regards
Dlugi