Oracle crash on SG 11.17 RAC

[lallemand_3]

Hi all,

since we came from Solaris to an HP-UX platform for one of our database we have a big problem with Oracle.
In fact, when there is lot of activity in the database, one of the instance is evicted. We also note that Oracle is taking a lot of time in synchronizing himself (buffer cache CR).
We made a lot of tests with our DBAs and the last one is terrible with HP-UX.
The test is :
- creating a table with one milion lines in one instance (5 seconds)
- when the creation is ok, the second instance has to synchronize SGAs through Cache Fusion and it takes 40 seconds
DBAs take these tests from metalink.

We make the same test on Solaris and on Linux : the two instances take the same times :
- 10 seconds between the 2 Solaris nodes
- 5 seconds between the 2 Linux nodes

The tests were made from Oracle 9.2.0.1 to Oracle 9.2.0.7 with always the same thing.
HP-UX is B.11.23 on Superdome with SG 11.17 with CFS for RAC.
Interconnect is a dedicated VLAN (100FD with no autonogeg).
Is anyone of you knows something about this problem ? Is it a Cache Fusion problem on HP-UX ?

Thanks a lot in advance.

Sebastien

[IT_2007]

How much memory and swap available on HP server? Did you check kernel parameters like dbc_pct_max and dbc_pct_min etc.. Tell us some more information.

Thanks,
Srini

[Steven E. Protter]

Shalom,

Thats a pretty slow NIC card for a superdome.

Lets check for all kinds of bottlenecks:

http://www.hpux.ws/system.perf.sh

Other ideas:
1) Were all data migration steps taken whne moving the data?
2) kmtune output
3) We're ll required OS patches installed for Oracle?

SEP

[lallemand_3]

Each productions servers have 48Gb memory and 20 CPUs each.
In order not to perturb production, the tests were made on 2 CPUs and 4Gb Memory servers.
Kernel parameters are join with this mail.

[IT_2007]

check network settings if you are using 100FD with Auto negotiation off or 1000FD autonegotiation on ?
also check syslog.log for any errors.

Increase dbc_max_pct =10

Thanks,
Srini