Skip navigation.

Michael Dinh

Syndicate content Thinking Out Loud
Michael T. Dinh, Oracle DBA
Updated: 15 hours 17 min ago

Don’t use %NOTFOUND with BULK COLLECT

Sun, 2014-04-13 16:54

I was working on a script for the ultimate RMAN backup validation and hoping to submit the article for an Oracle conference.

To my chagrin, one version of the script was failing for one condition and the other version would failed for another condition.

Basically, the script was very buggy.

The objective is to create a RMAN script to validate 8 backupset at a time.

I decided to use Bulk Collect and Limit clause.

Currently there are only 6 backupset.

ARROW:(MDINH@db01):PRIMARY> create table t as SELECT * FROM V$BACKUP_SET WHERE incremental_level > 0;

Table created.

ARROW:(MDINH@db01):PRIMARY> select recid from t;

     RECID
----------
       609
       610
       611
       612
       613
       614

6 rows selected.

ARROW:(MDINH@db01):PRIMARY>

Using LIMIT 8 with only 6 records would result in ZERO records returned.

ARROW:(MDINH@db01):PRIMARY> r
  1  DECLARE
  2    CURSOR c_level1 IS
  3      SELECT recid FROM t WHERE incremental_level > 0;
  4    TYPE t_level1 IS
  5      TABLE OF c_level1%ROWTYPE INDEX BY PLS_INTEGER;
  6    l_level1 t_level1;
  7    l_str VARCHAR2(1000);
  8  BEGIN
  9    OPEN c_level1;
 10    LOOP
 11      FETCH c_level1 BULK COLLECT INTO l_level1 LIMIT 8;
 12      FOR i IN 1..l_level1.COUNT
 13      LOOP
 14        l_str := l_str||l_level1(i).recid||',';
 15      END LOOP;
 16      EXIT WHEN c_level1%NOTFOUND;
 17      l_str := 'validate backupset '||RTRIM(l_str,',')||';';
 18      dbms_output.put_line(l_str);
 19    END LOOP;
 20    CLOSE c_level1;
 21  EXCEPTION
 22    WHEN others THEN RAISE;
 23* END;

PL/SQL procedure successfully completed.

Why not output the results before EXIT WHEN clause?  Works just fine.

ARROW:(MDINH@db01):PRIMARY> r
  1  DECLARE
  2    CURSOR c_level1 IS
  3      SELECT recid FROM t WHERE incremental_level > 0;
  4    TYPE t_level1 IS
  5      TABLE OF c_level1%ROWTYPE INDEX BY PLS_INTEGER;
  6    l_level1 t_level1;
  7    l_str VARCHAR2(1000);
  8  BEGIN
  9    OPEN c_level1;
 10    LOOP
 11      FETCH c_level1 BULK COLLECT INTO l_level1 LIMIT 8;
 12      FOR i IN 1..l_level1.COUNT
 13      LOOP
 14        l_str := l_str||l_level1(i).recid||',';
 15      END LOOP;
 16      l_str := 'validate backupset '||RTRIM(l_str,',')||';';
 17      dbms_output.put_line(l_str);
 18      EXIT WHEN c_level1%NOTFOUND;
 19    END LOOP;
 20    CLOSE c_level1;
 21  EXCEPTION
 22    WHEN others THEN RAISE;
 23* END;
validate backupset 609,610,611,612,613,614;

PL/SQL procedure successfully completed.

But what happens where there are ZERO rows in the table?

ARROW:(MDINH@db01):PRIMARY> delete from t;

6 rows deleted.

ARROW:(MDINH@db01):PRIMARY> 
ARROW:(MDINH@db01):PRIMARY> r
  1  DECLARE
  2    CURSOR c_level1 IS
  3      SELECT recid FROM t WHERE incremental_level > 0;
  4    TYPE t_level1 IS
  5      TABLE OF c_level1%ROWTYPE INDEX BY PLS_INTEGER;
  6    l_level1 t_level1;
  7    l_str VARCHAR2(1000);
  8  BEGIN
  9    OPEN c_level1;
 10    LOOP
 11      FETCH c_level1 BULK COLLECT INTO l_level1 LIMIT 8;
 12      FOR i IN 1..l_level1.COUNT
 13      LOOP
 14        l_str := l_str||l_level1(i).recid||',';
 15      END LOOP;
 16      l_str := 'validate backupset '||RTRIM(l_str,',')||';';
 17      dbms_output.put_line(l_str);
 18      EXIT WHEN c_level1%NOTFOUND;
 19    END LOOP;
 20    CLOSE c_level1;
 21  EXCEPTION
 22    WHEN others THEN RAISE;
 23* END;
validate backupset ;

PL/SQL procedure successfully completed.

ARROW:(MDINH@db01):PRIMARY>

Error! I was doing something fundamentally wrong.

Finally, I figured it out. Use COUNT=0 versus %NOTFOUND;

ARROW:(MDINH@db01):PRIMARY> r
  1  DECLARE
  2    CURSOR c_level1 IS
  3      SELECT recid FROM t WHERE incremental_level > 0;
  4    TYPE t_level1 IS
  5      TABLE OF c_level1%ROWTYPE INDEX BY PLS_INTEGER;
  6    l_level1 t_level1;
  7    l_str VARCHAR2(1000);
  8  BEGIN
  9    OPEN c_level1;
 10    LOOP
 11      FETCH c_level1 BULK COLLECT INTO l_level1 LIMIT 8;
 12      FOR i IN 1..l_level1.COUNT
 13      LOOP
 14        l_str := l_str||l_level1(i).recid||',';
 15      END LOOP;
 16      EXIT WHEN l_level1.COUNT=0;
 17      l_str := 'validate backupsets '||RTRIM(l_str,',')||';';
 18      dbms_output.put_line(l_str);
 19    END LOOP;
 20    CLOSE c_level1;
 21  EXCEPTION
 22    WHEN others THEN RAISE;
 23* END;
validate backupset 609,610,611,612,613,614;

PL/SQL procedure successfully completed.

ARROW:(MDINH@db01):PRIMARY> delete from t;

6 rows deleted.

ARROW:(MDINH@db01):PRIMARY> 
ARROW:(MDINH@db01):PRIMARY> r
  1  DECLARE
  2    CURSOR c_level1 IS
  3      SELECT recid FROM t WHERE incremental_level > 0;
  4    TYPE t_level1 IS
  5      TABLE OF c_level1%ROWTYPE INDEX BY PLS_INTEGER;
  6    l_level1 t_level1;
  7    l_str VARCHAR2(1000);
  8  BEGIN
  9    OPEN c_level1;
 10    LOOP
 11      FETCH c_level1 BULK COLLECT INTO l_level1 LIMIT 8;
 12      FOR i IN 1..l_level1.COUNT
 13      LOOP
 14        l_str := l_str||l_level1(i).recid||',';
 15      END LOOP;
 16      EXIT WHEN l_level1.COUNT=0;
 17      l_str := 'validate backupset '||RTRIM(l_str,',')||';';
 18      dbms_output.put_line(l_str);
 19      END LOOP;
 20    CLOSE c_level1;
 21  EXCEPTION
 22    WHEN others THEN RAISE;
 23* END;

PL/SQL procedure successfully completed.

I knew the article Best practices for knowing your LIMIT and kicking %NOTFOUND by Steven Feuerstein existed, but was not able to find it at the time.

One more thing to leave you with before I go. Bulk Collect will NEVER raise a NO_DATA_FOUND exception.


Don’t use %NOTFOUND with BULK COLLECT

Sun, 2014-04-13 16:54

I was working on a script for the ultimate RMAN backup validation and hoping to submit the article for an Oracle conference.

To my chagrin, one version of the script was failing for one condition and the other version would failed for another condition.

Basically, the script was very buggy.

The objective is to create a RMAN script to validate 8 backupset at a time.

I decided to use Bulk Collect and Limit clause.

Currently there are only 6 backupset.

ARROW:(MDINH@db01):PRIMARY> create table t as SELECT * FROM V$BACKUP_SET WHERE incremental_level > 0;

Table created.

ARROW:(MDINH@db01):PRIMARY> select recid from t;

     RECID
----------
       609
       610
       611
       612
       613
       614

6 rows selected.

ARROW:(MDINH@db01):PRIMARY>

Using LIMIT 8 with only 6 records would result in ZERO records returned.

ARROW:(MDINH@db01):PRIMARY> r
  1  DECLARE
  2    CURSOR c_level1 IS
  3      SELECT recid FROM t WHERE incremental_level > 0;
  4    TYPE t_level1 IS
  5      TABLE OF c_level1%ROWTYPE INDEX BY PLS_INTEGER;
  6    l_level1 t_level1;
  7    l_str VARCHAR2(1000);
  8  BEGIN
  9    OPEN c_level1;
 10    LOOP
 11      FETCH c_level1 BULK COLLECT INTO l_level1 LIMIT 8;
 12      FOR i IN 1..l_level1.COUNT
 13      LOOP
 14        l_str := l_str||l_level1(i).recid||',';
 15      END LOOP;
 16      EXIT WHEN c_level1%NOTFOUND;
 17      l_str := 'validate backupset '||RTRIM(l_str,',')||';';
 18      dbms_output.put_line(l_str);
 19    END LOOP;
 20    CLOSE c_level1;
 21  EXCEPTION
 22    WHEN others THEN RAISE;
 23* END;

PL/SQL procedure successfully completed.

Why not output the results before EXIT WHEN clause?  Works just fine.

ARROW:(MDINH@db01):PRIMARY> r
  1  DECLARE
  2    CURSOR c_level1 IS
  3      SELECT recid FROM t WHERE incremental_level > 0;
  4    TYPE t_level1 IS
  5      TABLE OF c_level1%ROWTYPE INDEX BY PLS_INTEGER;
  6    l_level1 t_level1;
  7    l_str VARCHAR2(1000);
  8  BEGIN
  9    OPEN c_level1;
 10    LOOP
 11      FETCH c_level1 BULK COLLECT INTO l_level1 LIMIT 8;
 12      FOR i IN 1..l_level1.COUNT
 13      LOOP
 14        l_str := l_str||l_level1(i).recid||',';
 15      END LOOP;
 16      l_str := 'validate backupset '||RTRIM(l_str,',')||';';
 17      dbms_output.put_line(l_str);
 18      EXIT WHEN c_level1%NOTFOUND;
 19    END LOOP;
 20    CLOSE c_level1;
 21  EXCEPTION
 22    WHEN others THEN RAISE;
 23* END;
validate backupset 609,610,611,612,613,614;

PL/SQL procedure successfully completed.

But what happens where there are ZERO rows in the table?

ARROW:(MDINH@db01):PRIMARY> delete from t;

6 rows deleted.

ARROW:(MDINH@db01):PRIMARY> 
ARROW:(MDINH@db01):PRIMARY> r
  1  DECLARE
  2    CURSOR c_level1 IS
  3      SELECT recid FROM t WHERE incremental_level > 0;
  4    TYPE t_level1 IS
  5      TABLE OF c_level1%ROWTYPE INDEX BY PLS_INTEGER;
  6    l_level1 t_level1;
  7    l_str VARCHAR2(1000);
  8  BEGIN
  9    OPEN c_level1;
 10    LOOP
 11      FETCH c_level1 BULK COLLECT INTO l_level1 LIMIT 8;
 12      FOR i IN 1..l_level1.COUNT
 13      LOOP
 14        l_str := l_str||l_level1(i).recid||',';
 15      END LOOP;
 16      l_str := 'validate backupset '||RTRIM(l_str,',')||';';
 17      dbms_output.put_line(l_str);
 18      EXIT WHEN c_level1%NOTFOUND;
 19    END LOOP;
 20    CLOSE c_level1;
 21  EXCEPTION
 22    WHEN others THEN RAISE;
 23* END;
validate backupset ;

PL/SQL procedure successfully completed.

ARROW:(MDINH@db01):PRIMARY>

Error! I was doing something fundamentally wrong.

Finally, I figured it out. Use COUNT=0 versus %NOTFOUND;

ARROW:(MDINH@db01):PRIMARY> r
  1  DECLARE
  2    CURSOR c_level1 IS
  3      SELECT recid FROM t WHERE incremental_level > 0;
  4    TYPE t_level1 IS
  5      TABLE OF c_level1%ROWTYPE INDEX BY PLS_INTEGER;
  6    l_level1 t_level1;
  7    l_str VARCHAR2(1000);
  8  BEGIN
  9    OPEN c_level1;
 10    LOOP
 11      FETCH c_level1 BULK COLLECT INTO l_level1 LIMIT 8;
 12      FOR i IN 1..l_level1.COUNT
 13      LOOP
 14        l_str := l_str||l_level1(i).recid||',';
 15      END LOOP;
 16      EXIT WHEN l_level1.COUNT=0;
 17      l_str := 'validate backupsets '||RTRIM(l_str,',')||';';
 18      dbms_output.put_line(l_str);
 19    END LOOP;
 20    CLOSE c_level1;
 21  EXCEPTION
 22    WHEN others THEN RAISE;
 23* END;
validate backupset 609,610,611,612,613,614;

PL/SQL procedure successfully completed.

ARROW:(MDINH@db01):PRIMARY> delete from t;

6 rows deleted.

ARROW:(MDINH@db01):PRIMARY> 
ARROW:(MDINH@db01):PRIMARY> r
  1  DECLARE
  2    CURSOR c_level1 IS
  3      SELECT recid FROM t WHERE incremental_level > 0;
  4    TYPE t_level1 IS
  5      TABLE OF c_level1%ROWTYPE INDEX BY PLS_INTEGER;
  6    l_level1 t_level1;
  7    l_str VARCHAR2(1000);
  8  BEGIN
  9    OPEN c_level1;
 10    LOOP
 11      FETCH c_level1 BULK COLLECT INTO l_level1 LIMIT 8;
 12      FOR i IN 1..l_level1.COUNT
 13      LOOP
 14        l_str := l_str||l_level1(i).recid||',';
 15      END LOOP;
 16      EXIT WHEN l_level1.COUNT=0;
 17      l_str := 'validate backupset '||RTRIM(l_str,',')||';';
 18      dbms_output.put_line(l_str);
 19      END LOOP;
 20    CLOSE c_level1;
 21  EXCEPTION
 22    WHEN others THEN RAISE;
 23* END;

PL/SQL procedure successfully completed.

I knew the article Best practices for knowing your LIMIT and kicking %NOTFOUND by Steven Feuerstein existed, but was not able to find it at the time.

One more thing to leave you with before I go. Bulk Collect will NEVER raise a NO_DATA_FOUND exception.


Automating DataPump Export

Tue, 2014-03-04 18:21

Please click link here to read my blog at Pythian.


Automating DataPump Export

Tue, 2014-03-04 18:21

Please click link here to read my blog at Pythian.


My Notes on How to Deploy a Four-Node Oracle RAC 12c Cluster

Sat, 2014-03-01 16:53

Great post from Oracle on How to Deploy a Four-Node Oracle RAC 12c Cluster in Minutes.

Just a few notes to for me to remember and share.

From the section:

Import the Oracle VM Templates You Downloaded

4.  From the Oracle VM Manager GUI, import the template files by providing both URLs for the same import session. The import process will take several minutes; be patient.

I used the URL below:

http://192.168.56.3/Files/OVM_OL6U4_X86_64_12101DBRAC_PVM-1of2.tbz

http://192.168.56.3/Files/OVM_OL6U4_X86_64_12101DBRAC_PVM-2of2.tbz

I was not able to resolve the error below and resulted in starting over which seems to be a lot easier:

(03/01/2014 11:21:17:639 AM) Async operation failed on server: ovm-srv.oow.com. 
Object: cfgFile_0004fb0000140000695d90a4276bae98, PID: 4592, Server error message: 
Command: (gtar xjf /OVS/Repositories/0004fb00000300008eb0bd4e4e626f9e/Templates/0004fb0000140000695d90a4276bae98/tmp/OVM_OL6U4_X86_64_12101DBRAC_PVM-2of2.tbz --no-same-owner -C 
/OVS/Repositories/0004fb00000300008eb0bd4e4e626f9e/Templates/0004fb0000140000695d90a4276bae98/tmp) failed: (2)

(03/01/2014 12:01:55:918 PM) Async operation failed on server: ovm-srv.oow.com. 
Object: cfgFile_0004fb00001400000b8fcc4468321f9b, PID: 3436, Server error message: 
Command: (gtar xjf /OVS/Repositories/0004fb00000300008eb0bd4e4e626f9e/Templates/0004fb00001400000b8fcc4468321f9b/tmp/OVM_OL6U4_X86_64_12101DBRAC_PVM-2of2.tbz --no-same-owner -C 
/OVS/Repositories/0004fb00000300008eb0bd4e4e626f9e/Templates/0004fb00001400000b8fcc4468321f9b/tmp) failed: (2)

To monitor the progress for Oracle VM Templates import

[root@ovm-srv log]# pwd
/var/log
[root@ovm-srv log]# tail -20f ovs-agent.log
[2014-03-01 13:22:50 4675] INFO (notification:47) Notification sent: {ASYNC_PROC} progress PID 4675
[2014-03-01 13:22:51 3528] INFO (notificationserver:139) Sending notification: {ASYNC_PROC} progress PID 4675
[2014-03-01 13:23:05 4675] DEBUG (base:269) async call complete: func: import_template pid: 4675 status: 0 output: {'ISO': {}, 'VirtualDisk': {'88e5f08a354d4080beb281cb26867189.img': 'Oracle12101DBRAC_x86_64-xvdb.img', 'b20f6be7783e4a30aa54242be750ad28.img': 'System.img'}}
[2014-03-01 13:23:05 4675] INFO (notification:47) Notification sent: {ASYNC_PROC} exit PID 4675
[2014-03-01 13:23:05 3528] INFO (notificationserver:139) Sending notification: {ASYNC_PROC} exit PID 4675
[2014-03-01 13:23:05 5247] DEBUG (service:74) call start: get_template_config('0004fb00000300000341ed14e9d56e82', '0004fb0000140000ed58fccc09717f56')
[2014-03-01 13:23:05 5247] DEBUG (service:76) call complete: get_template_config
[2014-03-01 13:23:06 5249] DEBUG (service:74) call start: set_template_config('0004fb00000300000341ed14e9d56e82', '0004fb0000140000ed58fccc09717f56', {'uuid': '0004fb0000140000ed58fccc09717f56', 'bootloader': '/usr/bin/pygrub', 'vif': ['bridge=xenbr0', 'bridge=xenbr1'], 'guest_os_type': 'default', 'name': '0004fb0000140000ed58fccc09717f56', 'OVM_description': 'Import URLs: [http://192.168.56.3/Files/OVM_OL6U4_X86_64_12101DBRAC_PVM-1of2.tbz, http://192.168.56.3/Files/OVM_OL6U4_X86_64_12101DBRAC_PVM-2of2.tbz]', 'vif_other_config': [], 'OVM_simple_name': 'OVM_OL6U4_X86_64_12101DBRAC_PVM-1of2.tbz', 'on_poweroff': 'destroy', 'vfb': ['type=vnc,vncunused=1,vnclisten=127.0.0.1,keymap=en-us'], 'on_crash': 'restart', 'on_reboot': 'restart', 'vcpus': 1, 'cpu_weight': 27500, 'OVM_os_type': 'None', 'memory': 2048, 'cpu_cap': 0, 'maxvcpus': 1, 'disk': ['file:/OVS/Repositories/0004fb00000300000341ed14e9d56e82/VirtualDisks/b20f6be7783e4a30aa54242be750ad28.img,xvda,w', 'file:/OVS/Repositories/0004fb00000300000341ed14e9d56e82/VirtualDisks/88e5f08a354d4080beb281cb26867189.img,xvdb,w'], 'OVM_domain_type': 'xen_pvm', 'bootargs': ''})
[2014-03-01 13:23:06 5249] DEBUG (service:76) call complete: set_template_config
[2014-03-01 13:23:06 5250] DEBUG (service:74) call start: storage_plugin_list('oracle.ocfs2.OCFS2.OCFS2Plugin', {'status': '', 'admin_user': '', 'admin_host': '', 'uuid': '0004fb00000900004515f6d9e4e54dc2', 'total_sz': 0, 'admin_passwd': '******', 'storage_desc': '', 'free_sz': 0, 'access_host': '', 'storage_type': 'FileSys', 'alloc_sz': 0, 'access_grps': [], 'used_sz': 0, 'name': '0004fb00000900004515f6d9e4e54dc2'}, {'status': '', 'uuid': '0004fb0000050000f1d01e9ab13f1d81', 'backing_device': '/dev/mapper/SATA_VBOX_HARDDISK_VB779d125b-dd512e48_', 'ss_uuid': '0004fb00000900004515f6d9e4e54dc2', 'size': '68719476736', 'free_sz': '64145588224', 'state': 2, 'access_grp_names': [], 'access_path': '/dev/mapper/SATA_VBOX_HARDDISK_VB779d125b-dd512e48_', 'name': 'fs_OVMRepo'}, {'fr_type': 'Directory', 'fs_uuid': '0004fb0000050000f1d01e9ab13f1d81', 'file_sz': 0, 'ondisk_sz': 0, 'file_path': '/OVS/Repositories/0004fb00000300000341ed14e9d56e82/VirtualDisks', 'name_pattern': 'b20f6be7783e4a30aa54242be750ad28.img'}, False)
[2014-03-01 13:23:06 5250] INFO (storageplugin:109) storage_plugin_list(oracle.ocfs2.OCFS2.OCFS2Plugin)
[2014-03-01 13:23:06 5250] DEBUG (service:76) call complete: storage_plugin_list
[2014-03-01 13:23:06 5251] DEBUG (service:74) call start: storage_plugin_list('oracle.ocfs2.OCFS2.OCFS2Plugin', {'status': '', 'admin_user': '', 'admin_host': '', 'uuid': '0004fb00000900004515f6d9e4e54dc2', 'total_sz': 0, 'admin_passwd': '******', 'storage_desc': '', 'free_sz': 0, 'access_host': '', 'storage_type': 'FileSys', 'alloc_sz': 0, 'access_grps': [], 'used_sz': 0, 'name': '0004fb00000900004515f6d9e4e54dc2'}, {'status': '', 'uuid': '0004fb0000050000f1d01e9ab13f1d81', 'backing_device': '/dev/mapper/SATA_VBOX_HARDDISK_VB779d125b-dd512e48_', 'ss_uuid': '0004fb00000900004515f6d9e4e54dc2', 'size': '68719476736', 'free_sz': '64145588224', 'state': 2, 'access_grp_names': [], 'access_path': '/dev/mapper/SATA_VBOX_HARDDISK_VB779d125b-dd512e48_', 'name': 'fs_OVMRepo'}, {'fr_type': 'Directory', 'fs_uuid': '0004fb0000050000f1d01e9ab13f1d81', 'file_sz': 0, 'ondisk_sz': 0, 'file_path': '/OVS/Repositories/0004fb00000300000341ed14e9d56e82/VirtualDisks', 'name_pattern': '88e5f08a354d4080beb281cb26867189.img'}, False)
[2014-03-01 13:23:06 5251] INFO (storageplugin:109) storage_plugin_list(oracle.ocfs2.OCFS2.OCFS2Plugin)
[2014-03-01 13:23:06 5251] DEBUG (service:76) call complete: storage_plugin_list
[2014-03-01 13:23:06 5252] DEBUG (service:74) call start: storage_plugin_listFileSystems('oracle.ocfs2.OCFS2.OCFS2Plugin', {'status': '', 'admin_user': '', 'admin_host': '', 'uuid': '0004fb00000900004515f6d9e4e54dc2', 'total_sz': 0, 'admin_passwd': '******', 'storage_desc': '', 'free_sz': 0, 'access_host': '', 'storage_type': 'FileSys', 'alloc_sz': 0, 'access_grps': [], 'used_sz': 0, 'name': '0004fb00000900004515f6d9e4e54dc2'}, True)
[2014-03-01 13:23:06 5252] INFO (storageplugin:109) storage_plugin_listFileSystems(oracle.ocfs2.OCFS2.OCFS2Plugin)
[2014-03-01 13:23:07 5252] DEBUG (service:76) call complete: storage_plugin_listFileSystems
[2014-03-01 13:23:07 5259] DEBUG (service:76) call start: discover_pool_filesystem
[2014-03-01 13:23:07 5259] DEBUG (service:76) call complete: discover_pool_filesystem
For error Unable to launch the application:

unable

Modify Security Level to Medium Add to the Exception Site List: https://192.168.56.3

JavaControlPanel

Try again:

rac1


My Notes on How to Deploy a Four-Node Oracle RAC 12c Cluster

Sat, 2014-03-01 16:53

Great post from Oracle on How to Deploy a Four-Node Oracle RAC 12c Cluster in Minutes.

Just a few notes to for me to remember and share.

From the section:

Import the Oracle VM Templates You Downloaded

4.  From the Oracle VM Manager GUI, import the template files by providing both URLs for the same import session. The import process will take several minutes; be patient.

I used the URL below:

http://192.168.56.3/Files/OVM_OL6U4_X86_64_12101DBRAC_PVM-1of2.tbz

http://192.168.56.3/Files/OVM_OL6U4_X86_64_12101DBRAC_PVM-2of2.tbz

I was not able to resolve the error below and resulted in starting over which seems to be a lot easier:

(03/01/2014 11:21:17:639 AM) Async operation failed on server: ovm-srv.oow.com. 
Object: cfgFile_0004fb0000140000695d90a4276bae98, PID: 4592, Server error message: 
Command: (gtar xjf /OVS/Repositories/0004fb00000300008eb0bd4e4e626f9e/Templates/0004fb0000140000695d90a4276bae98/tmp/OVM_OL6U4_X86_64_12101DBRAC_PVM-2of2.tbz --no-same-owner -C 
/OVS/Repositories/0004fb00000300008eb0bd4e4e626f9e/Templates/0004fb0000140000695d90a4276bae98/tmp) failed: (2)

(03/01/2014 12:01:55:918 PM) Async operation failed on server: ovm-srv.oow.com. 
Object: cfgFile_0004fb00001400000b8fcc4468321f9b, PID: 3436, Server error message: 
Command: (gtar xjf /OVS/Repositories/0004fb00000300008eb0bd4e4e626f9e/Templates/0004fb00001400000b8fcc4468321f9b/tmp/OVM_OL6U4_X86_64_12101DBRAC_PVM-2of2.tbz --no-same-owner -C 
/OVS/Repositories/0004fb00000300008eb0bd4e4e626f9e/Templates/0004fb00001400000b8fcc4468321f9b/tmp) failed: (2)

To monitor the progress for Oracle VM Templates import

[root@ovm-srv log]# pwd
/var/log
[root@ovm-srv log]# tail -20f ovs-agent.log
[2014-03-01 13:22:50 4675] INFO (notification:47) Notification sent: {ASYNC_PROC} progress PID 4675
[2014-03-01 13:22:51 3528] INFO (notificationserver:139) Sending notification: {ASYNC_PROC} progress PID 4675
[2014-03-01 13:23:05 4675] DEBUG (base:269) async call complete: func: import_template pid: 4675 status: 0 output: {'ISO': {}, 'VirtualDisk': {'88e5f08a354d4080beb281cb26867189.img': 'Oracle12101DBRAC_x86_64-xvdb.img', 'b20f6be7783e4a30aa54242be750ad28.img': 'System.img'}}
[2014-03-01 13:23:05 4675] INFO (notification:47) Notification sent: {ASYNC_PROC} exit PID 4675
[2014-03-01 13:23:05 3528] INFO (notificationserver:139) Sending notification: {ASYNC_PROC} exit PID 4675
[2014-03-01 13:23:05 5247] DEBUG (service:74) call start: get_template_config('0004fb00000300000341ed14e9d56e82', '0004fb0000140000ed58fccc09717f56')
[2014-03-01 13:23:05 5247] DEBUG (service:76) call complete: get_template_config
[2014-03-01 13:23:06 5249] DEBUG (service:74) call start: set_template_config('0004fb00000300000341ed14e9d56e82', '0004fb0000140000ed58fccc09717f56', {'uuid': '0004fb0000140000ed58fccc09717f56', 'bootloader': '/usr/bin/pygrub', 'vif': ['bridge=xenbr0', 'bridge=xenbr1'], 'guest_os_type': 'default', 'name': '0004fb0000140000ed58fccc09717f56', 'OVM_description': 'Import URLs: [http://192.168.56.3/Files/OVM_OL6U4_X86_64_12101DBRAC_PVM-1of2.tbz, http://192.168.56.3/Files/OVM_OL6U4_X86_64_12101DBRAC_PVM-2of2.tbz]', 'vif_other_config': [], 'OVM_simple_name': 'OVM_OL6U4_X86_64_12101DBRAC_PVM-1of2.tbz', 'on_poweroff': 'destroy', 'vfb': ['type=vnc,vncunused=1,vnclisten=127.0.0.1,keymap=en-us'], 'on_crash': 'restart', 'on_reboot': 'restart', 'vcpus': 1, 'cpu_weight': 27500, 'OVM_os_type': 'None', 'memory': 2048, 'cpu_cap': 0, 'maxvcpus': 1, 'disk': ['file:/OVS/Repositories/0004fb00000300000341ed14e9d56e82/VirtualDisks/b20f6be7783e4a30aa54242be750ad28.img,xvda,w', 'file:/OVS/Repositories/0004fb00000300000341ed14e9d56e82/VirtualDisks/88e5f08a354d4080beb281cb26867189.img,xvdb,w'], 'OVM_domain_type': 'xen_pvm', 'bootargs': ''})
[2014-03-01 13:23:06 5249] DEBUG (service:76) call complete: set_template_config
[2014-03-01 13:23:06 5250] DEBUG (service:74) call start: storage_plugin_list('oracle.ocfs2.OCFS2.OCFS2Plugin', {'status': '', 'admin_user': '', 'admin_host': '', 'uuid': '0004fb00000900004515f6d9e4e54dc2', 'total_sz': 0, 'admin_passwd': '******', 'storage_desc': '', 'free_sz': 0, 'access_host': '', 'storage_type': 'FileSys', 'alloc_sz': 0, 'access_grps': [], 'used_sz': 0, 'name': '0004fb00000900004515f6d9e4e54dc2'}, {'status': '', 'uuid': '0004fb0000050000f1d01e9ab13f1d81', 'backing_device': '/dev/mapper/SATA_VBOX_HARDDISK_VB779d125b-dd512e48_', 'ss_uuid': '0004fb00000900004515f6d9e4e54dc2', 'size': '68719476736', 'free_sz': '64145588224', 'state': 2, 'access_grp_names': [], 'access_path': '/dev/mapper/SATA_VBOX_HARDDISK_VB779d125b-dd512e48_', 'name': 'fs_OVMRepo'}, {'fr_type': 'Directory', 'fs_uuid': '0004fb0000050000f1d01e9ab13f1d81', 'file_sz': 0, 'ondisk_sz': 0, 'file_path': '/OVS/Repositories/0004fb00000300000341ed14e9d56e82/VirtualDisks', 'name_pattern': 'b20f6be7783e4a30aa54242be750ad28.img'}, False)
[2014-03-01 13:23:06 5250] INFO (storageplugin:109) storage_plugin_list(oracle.ocfs2.OCFS2.OCFS2Plugin)
[2014-03-01 13:23:06 5250] DEBUG (service:76) call complete: storage_plugin_list
[2014-03-01 13:23:06 5251] DEBUG (service:74) call start: storage_plugin_list('oracle.ocfs2.OCFS2.OCFS2Plugin', {'status': '', 'admin_user': '', 'admin_host': '', 'uuid': '0004fb00000900004515f6d9e4e54dc2', 'total_sz': 0, 'admin_passwd': '******', 'storage_desc': '', 'free_sz': 0, 'access_host': '', 'storage_type': 'FileSys', 'alloc_sz': 0, 'access_grps': [], 'used_sz': 0, 'name': '0004fb00000900004515f6d9e4e54dc2'}, {'status': '', 'uuid': '0004fb0000050000f1d01e9ab13f1d81', 'backing_device': '/dev/mapper/SATA_VBOX_HARDDISK_VB779d125b-dd512e48_', 'ss_uuid': '0004fb00000900004515f6d9e4e54dc2', 'size': '68719476736', 'free_sz': '64145588224', 'state': 2, 'access_grp_names': [], 'access_path': '/dev/mapper/SATA_VBOX_HARDDISK_VB779d125b-dd512e48_', 'name': 'fs_OVMRepo'}, {'fr_type': 'Directory', 'fs_uuid': '0004fb0000050000f1d01e9ab13f1d81', 'file_sz': 0, 'ondisk_sz': 0, 'file_path': '/OVS/Repositories/0004fb00000300000341ed14e9d56e82/VirtualDisks', 'name_pattern': '88e5f08a354d4080beb281cb26867189.img'}, False)
[2014-03-01 13:23:06 5251] INFO (storageplugin:109) storage_plugin_list(oracle.ocfs2.OCFS2.OCFS2Plugin)
[2014-03-01 13:23:06 5251] DEBUG (service:76) call complete: storage_plugin_list
[2014-03-01 13:23:06 5252] DEBUG (service:74) call start: storage_plugin_listFileSystems('oracle.ocfs2.OCFS2.OCFS2Plugin', {'status': '', 'admin_user': '', 'admin_host': '', 'uuid': '0004fb00000900004515f6d9e4e54dc2', 'total_sz': 0, 'admin_passwd': '******', 'storage_desc': '', 'free_sz': 0, 'access_host': '', 'storage_type': 'FileSys', 'alloc_sz': 0, 'access_grps': [], 'used_sz': 0, 'name': '0004fb00000900004515f6d9e4e54dc2'}, True)
[2014-03-01 13:23:06 5252] INFO (storageplugin:109) storage_plugin_listFileSystems(oracle.ocfs2.OCFS2.OCFS2Plugin)
[2014-03-01 13:23:07 5252] DEBUG (service:76) call complete: storage_plugin_listFileSystems
[2014-03-01 13:23:07 5259] DEBUG (service:76) call start: discover_pool_filesystem
[2014-03-01 13:23:07 5259] DEBUG (service:76) call complete: discover_pool_filesystem
For error Unable to launch the application:

unable

Modify Security Level to Medium Add to the Exception Site List: https://192.168.56.3

JavaControlPanel

Try again:

rac1