文章存档
相关博文
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
分类： oracle
2010-06-24 18:59:52
打开asm文件出错：
dzywdata/dzywdb/onlinelog/redo1_3 open err:oxa-1000 oci error -1 occurred at file api/sql/execute.c:123.
ora-15056: additional error message
ora-17503: ksfdopn:dgopenfile05 failed to open file dzywdata/dzywdb/onlinelog/redo1_3
ora-17503: ksfdopn:2 failed to open file dzywdata/dzywdb/onlinelog/redo1_3
ora-15064: communication failure with asm instance
ora-06512: at "sys.x$dbms_diskgroup", line 96
ora-06512: at line 1
error - oci_error, no such file or directory
对应的sql应该是：begin dbms_diskgroup.open(:1, :2, :3, :4, :5, :6, :7); end;
大概的使用模式是这样的：
using the internal package dbms_diskgroup
declare
filetype varchar2(50); filename varchar2(50);
filesz number; blksz number; hdl number; plksz number;
data_buf raw(4096);
begin
filename := ' test1_datadg1/test1/spfiletest1.ora';
dbms_diskgroup.getfileattr(filename,filetype,filesz, blksz);
dbms_diskgroup.open(filename,'r',filetype,blksz, hdl,plksz, filesz);
dbms_diskgroup.read(hdl,1,blksz,data_buf);
dbms_output.put_line(data_buf);
end;
/
目前还没有查找出为什么出现这个问题！
哎，等待详细测试，关键我没办法继续测试了。
dzywdata/dzywdb/onlinelog/redo1_3 open err:oxa-1000 oci error -1 occurred at file api/sql/execute.c:123.
ora-15056: additional error message
ora-17503: ksfdopn:dgopenfile05 failed to open file dzywdata/dzywdb/onlinelog/redo1_3
ora-17503: ksfdopn:2 failed to open file dzywdata/dzywdb/onlinelog/redo1_3
ora-15064: communication failure with asm instance
ora-06512: at "sys.x$dbms_diskgroup", line 96
ora-06512: at line 1
error - oci_error, no such file or directory
对应的sql应该是：begin dbms_diskgroup.open(:1, :2, :3, :4, :5, :6, :7); end;
大概的使用模式是这样的：
using the internal package dbms_diskgroup
declare
filetype varchar2(50); filename varchar2(50);
filesz number; blksz number; hdl number; plksz number;
data_buf raw(4096);
begin
filename := ' test1_datadg1/test1/spfiletest1.ora';
dbms_diskgroup.getfileattr(filename,filetype,filesz, blksz);
dbms_diskgroup.open(filename,'r',filetype,blksz, hdl,plksz, filesz);
dbms_diskgroup.read(hdl,1,blksz,data_buf);
dbms_output.put_line(data_buf);
end;
/
目前还没有查找出为什么出现这个问题！
哎，等待详细测试，关键我没办法继续测试了。
给主人留下些什么吧！~~