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

  • From: Uwe Küchler <uwe@xxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 09 Oct 2012 20:43:27 +0200

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@xxxxxxxxxxxx'
> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>

--
//www.freelists.org/webpage/oracle-l


Other related posts: