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;

asked 18 Jul '11, 03:58

Kim%20Berg%20Hansen's gravatar image

Kim Berg Hansen
111
accept rate: 0%


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
Formspider Product Manager

link

answered 18 Jul '11, 05:19

Serkan%20Kasapbasi's gravatar image

Serkan Kasap...
763
accept rate: 27%

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.

link

answered 18 Jul '11, 23:08

Yalim%20K.%20Gerger's gravatar image

Yalim K. Gerger ♦♦
1914
accept rate: 20%

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 ♦♦
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×7

Asked: 18 Jul '11, 03:58

Seen: 2,631 times

Last updated: 28 Jul '11, 23:19


© Copyright Gerger 2017