calibrate_io, Oracle Disk Manager and ORA-56719

From: Uwe Küchler <uwe_at_kuechler.org>
Date: Tue, 9 Oct 2012 15:57:39 +0200
Message-ID: <4bd494aaa47ae5bfdbe4cb86b9d90209.squirrel_at_mx1bln1.prossl.de>



Dear fellows of the Oracle,

I recently ran into a problem when trying to execute the I/O calibration. Environment: Oracle 11.2.0.3.0, Solaris 10 (SunOS 5.10 Generic_147440-12 sun4u sparc SUNW,SPARC-Enterprise).

Here's what happened:

Error starting at line 2 in command:
DECLARE
  lat INTEGER;
  iops INTEGER;
  mbps INTEGER;
BEGIN
  --DBMS_RESOURCE_MANAGER.CALIBRATE_IO(<NUM_DISKS>, <MAX_LATENCY>,iops, mbps, lat);

  DBMS_RESOURCE_MANAGER.CALIBRATE_IO (16, 20, iops, mbps, lat);
  DBMS_OUTPUT.PUT_LINE ('max_iops = ' || iops);
  DBMS_OUTPUT.PUT_LINE ('latency = ' || lat);
  dbms_output.put_line('max_mbps = ' || mbps);
end;
Error report:
ORA-56719: Error spawning or communicating with calibration slave
ORA-06512: at "SYS.DBMS_RMIN", line 463
ORA-06512: at "SYS.DBMS_RESOURCE_MANAGER", line 1302
ORA-06512: at line 7


The few hits on MOS point to bugs or scenarios that don't apply to this environment.
BUT: We use Oracle Disk Manager (ODM) on VxFS.

Has anyone had similar experiences? Suggestions, aside from contacting support or setting max_pmbps manually?

Cheers,
Uwe
--

http://oraculix.wordpress.com/
https://twitter.com/oraculix

--

http://www.freelists.org/webpage/oracle-l Received on Tue Oct 09 2012 - 15:57:39 CEST

Original text of this message