FW: calibrate_io, Oracle Disk Manager and ORA-56719

From: Powell, Mark <mark.powell2_at_hp.com>
Date: Tue, 9 Oct 2012 17:01:43 +0000
Message-ID: <1E24812FBE5611419EFAFC488D7CCDD112152948_at_G5W2734.americas.hpqcorp.net>

Forgot to copy list.

-----Original Message-----

From: Powell, Mark
Sent: Tuesday, October 09, 2012 1:01 PM
To: 'uwe_at_kuechler.org'
Subject: RE: calibrate_io, Oracle Disk Manager and ORA-56719

Are you using Direct NFS? Is this on an ASM instance? I found a couple of Oracle support notes. The first seems to match your error fairly well. It lists a patch.

ORA-56719:IO Calibrate Error When Using Direct Nfs [ID 1449848.1] ORA-56719 Error Running Calibrate_io Procedure [ID 1495378.1]

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of "Uwe Küchler" Sent: Tuesday, October 09, 2012 9:58 AM
To: oracle-l
Subject: calibrate_io, Oracle Disk Manager and ORA-56719

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Oct 09 2012 - 19:01:43 CEST