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? "Offending" statement: 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; |
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. Thanks again Serkan Kasapbasi Thanks for the answer, Serkan. Just want to let you know, that I have previously attempted an installation in our "sandbox" - this sandbox is an 11.1 non-RAC that is a Dataguard copy of the production environment, but in snapshot-standby mode so we can try out stuff in it. I killed that installation attempt after 3 hours. I guessed it could be because it was a DG copy, so therefore I tried in the RAC source environment. If I can find a non-11.1 environment I shall attempt an installation there :-)
(18 Jul '11, 05:28)
Kim Berg Hansen
|
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. Thanks, Yalim - will do :-) At some point I probably will attempt a Linux installation on my 11.2 laptop environment, but that will wait until I have a bit more time... /Kim
(19 Jul '11, 01:01)
Kim Berg Hansen
We are about to release a Linux installer. I will let you know when it is out.
(28 Jul '11, 23:19)
Yalim K. Gerger ♦♦
|