I have downloadet FormspiderBetaR2.exe and am now attempting installation into an Oracle 11.1 EE 2-node RAC database.
The installer has been running the statement below for more than 1 hour now at 99.9% CPU. Is this normal?
declare v_applicationName_tx varchar2(255) := 'FormspiderIDE'; v_cl clob; v_objectRecord_tt api_application.tt_importObjects; begin bdf_application_api.applicationdelete(in_application_oid=>bdf_application_qry.getid(v_applicationName_tx), in_cascade_yn=>'Y'); dbms_lob.createtemporary(v_cl,true); select v_xml_cl into v_cl from t_temp_application ; bdf_etl.load(in_bdf_xml=>xmltype(v_cl), in_importOption_cd =>bdf_constant_etl.importAsNewApplication, in_projectOption_cd=>bdf_constant_etl.etlcreateOrReplace, in_applicationOption_cd=>bdf_constant_etl.etlcreateOrReplace, in_importObjects_tt=>v_objectRecord_tt); commit; end;
asked 18 Jul '11, 03:58
Kim Berg Hansen
Thanks for your feedback, we are investigating your problem. Installer shouldn't took that long, it doesn't take more than 10-15 minutes, so most probably your installation has failed. To be honest, this is the first time we saw an infinite loop (most probably) problem in our installer. The first thing we distinguish in your environment is "Oracle 11.1 EE 2-node RAC". We suspect on this configuration. We are going to analyze your situation and try to figure out what went wrong. We will let you know when we find solution to your problem.
Meanwhile, I suggest you to try installer on a non-RAC environment for now.
answered 18 Jul '11, 05:19
Kibeha,until we solve this problem, (and it looks like a tricky one) I suggest you that you test Formspider online. You can sign up for an account at www.formspideronline.com. Formspider Online comes with an online database schema that you can start developing with immediately. You can use your favorite PL/SQL editor to connect to your online schema.
answered 18 Jul '11, 23:08
Yalim K. Gerger ♦♦