Re: FW: calibrate_io, Oracle Disk Manager and ORA-56719

From: Uwe Küchler <uwe_at_kuechler.org>
Date: Tue, 09 Oct 2012 20:43:27 +0200
Message-ID: <5074704F.8040009_at_kuechler.org>



Mark,

thanks for looking up MOS, but as I stated I did that as well and none of the articles apply - we're neither on direct NFS nor ASM (doesn't seem sensible to me on a filesystem, anyway).

There are some more hints, though: Oracle 11.2.0.3 has changes in the ODM API that need a certain patchlevel for the VRTSodm package. It's not exactly my scenario but it will hit us anyway when going live with archive logging on. See:
http://www.symantec.com/business/support/index?page=content&id=TECH173597

I'll have the sysadmins install the latest patchset and then I'll try again.

Cheers,
Uwe

On 09.10.2012 19:01, Powell, Mark wrote:
> 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
>
>

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

Original text of this message