OraFAQ Forum: Forms » Error at running forms in oracle form 10g

Home » Developer & Programmer » Forms » Error at running forms in oracle form 10g

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error at running forms in oracle form 10g [message #260816]

Tue, 21 August 2007 00:52

mmrz
Messages: 29
Registered: August 2007

Junior Member

I start OC4J Instance but when I run the form in 10g, it should be open on the web page but the error(can not open page) shows to me, How can I solve the problem?

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #260829 is a reply to message #260816]

Tue, 21 August 2007 01:36

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Please post an 8-bit graphic image of the error panel, or transcribe the error code and error message into your reply.

David

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #261198 is a reply to message #260829]

Wed, 22 August 2007 02:23

mmrz
Messages: 29
Registered: August 2007

Junior Member

Dear David,
Unforunatly, I am beginner in oracle form. would you please tell me where can I find the error code in it?

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #261589 is a reply to message #261198]

Thu, 23 August 2007 01:48

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

You said in your first post "the error(can not open page) shows to me". Please tell us the error code and the exact error message.

Is this the first form that you have run?

David

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #261645 is a reply to message #261589]

Thu, 23 August 2007 03:41

mmrz
Messages: 29
Registered: August 2007

Junior Member

My application able to connect to the data base succesfully but the web page shows me like the attached file, I mean the application is not able to run on the web page!
/forum/fa/2943/0/

Attachment: 11.bmp
(Size: 1.10MB, Downloaded 14174 times)

[Updated on: Thu, 23 August 2007 21:27] by Moderator

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #261880 is a reply to message #261645]

Thu, 23 August 2007 23:07

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Are you running an Application Server or a Developer Server?

David

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #262213 is a reply to message #261880]

Sat, 25 August 2007 03:26

mmrz
Messages: 29
Registered: August 2007

Junior Member

Developer Server

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #262412 is a reply to message #262213]

Mon, 27 August 2007 00:04

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Then why are you using port 1588 instead of 8888?

David

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #262499 is a reply to message #262412]

Mon, 27 August 2007 05:22

mmrz
Messages: 29
Registered: August 2007

Junior Member

Dear David,
Thank you for your pay attention.Could you please tell me How I can change the port?

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #262608 is a reply to message #262499]

Mon, 27 August 2007 21:12

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Look at http://download.oracle.com/docs/cd/B14099_19/web.1012/b14032/appA001.htm#CHDDABGJ which has a pointer to ORACLE_HOME/install/portlist.ini

Mine contains:

Oracle Developer Suite HTTP port = 8889
Oracle Developer Suite JMS port = 9240
Oracle Developer Suite RMI port = 23910
Oracle HTTP Server Diagnostic port = 7200
Reports Services bridge port = 14011
Reports Services discoveryService port = 14021

What do you have in yours?

David

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #262661 is a reply to message #262608]

Tue, 28 August 2007 00:53

mmrz
Messages: 29
Registered: August 2007

Junior Member

All my Parameteres are the same as you mentioned!

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #262684 is a reply to message #262661]

Tue, 28 August 2007 01:19

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

What do you get in your browser when you run 'test' from within the Forms Builder?

David

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #264221 is a reply to message #262684]

Sun, 02 September 2007 02:39

mmrz
Messages: 29
Registered: August 2007

Junior Member

Sorry for my late reply!
for running a test form(Form Developer/Run a Form on the Web) I entered the scott as a Userid and Webport=1521 or 8888 but nothing will be run and no message show to me.

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #264585 is a reply to message #264221]

Mon, 03 September 2007 20:25

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Sorry to take so long in fixing your problem but I hadn't installed Forms 10g until last week. And until I had to suffer the same problems as others I didn't have to correct answer.

In Internet Explorer, go to Tools -> Internet Options, Connections, LAN Settings, Advanced, and in Exceptions add the prefix for your local machine (for example, ';mypc.*') to the end of the list.

The name 'mypc' should have been created in the 'tnsnames.ora' file during the Forms 10g installation - check it.

This will fix the problem of the form not opening when it is started from within the Forms Builder.

David

[Updated on: Mon, 03 September 2007 20:25]

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #271089 is a reply to message #264585]

Sat, 29 September 2007 02:58

ahmad_uaf
Messages: 68
Registered: March 2006
Location: Pakistan

Member

Dear David i 've also some prolbem when am running the form with in the Form Builder.
I am using Oracle Developer Suite 10g R2.
The Error is :

Plz help me out the problem.
Best Regards,
Ahmad

Attachment: error.JPG
(Size: 89.65KB, Downloaded 2051 times)

[Updated on: Thu, 04 October 2007 02:06] by Moderator

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #272103 is a reply to message #271089]

Thu, 04 October 2007 01:17

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Can you run the 'test' form from within the Forms Builder?

David

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #307675 is a reply to message #260816]

Wed, 19 March 2008 07:34

dillango
Messages: 145
Registered: January 2008

Senior Member

Dear all,

This is the first form developing in 10G DS Forms[32 bit]version 9.0.4.0.19.

When I run the form from the Form builder, I am getting the error as attached.

Any help please

Ilango

Attachment: sample.GIF
(Size: 72.16KB, Downloaded 1770 times)

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #307690 is a reply to message #307675]

Wed, 19 March 2008 08:53

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

So, OC4J is started. Did you go to Internet Explorer - Tools - Internet Options - Advanced tab - Security section - "Allow active content to run in firles on My Computer"?

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #307702 is a reply to message #307690]

Wed, 19 March 2008 10:23

dillango
Messages: 145
Registered: January 2008

Senior Member

Mr.Littlefoot,

It is perfectly working now.
How can I run the same form without opening the form builder? I mean through IE.

I have menu module program developed in Forms6i. I need to convert into 10g. I am getting the help from searching this forum. Is there any shortcut and simple way?

Thanks a lot
Ilango

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #307752 is a reply to message #307702]

Wed, 19 March 2008 15:50

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

You'll need to install Application Server (Forms and, possibly, Reports services) and deploy your application on the web. Doing so, you'll be able to run it via internet browser.

As far as I can tell, there's no shortcut to do that. There are links to the documentation here; I remember I posted them recently, so - search the board or go directly to the documentation section of the Oracle Technology Network and find it yourself.

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #307773 is a reply to message #307752]

Wed, 19 March 2008 18:33

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Go to 'Start', then through your Oracle Forms Developer sub-menu and select 'Run a Form on the Web'. It will invoke something like 'C:\DevSuiteHome_1\tools\web\html\runform.htm'.

Have good look at this file. You can create something similar to start your application or you could also just save the address that exists in your browser to your browser's 'favourites' and click on it to start your Form (but remember that OC4J would have to be running on your PC at the time).

David

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #307865 is a reply to message #307773]

Thu, 20 March 2008 03:46

dillango
Messages: 145
Registered: January 2008

Senior Member

Thanks Mr.David and Mr.Littlefoot.

Mr.David said

"(but remember that OC4J would have to be running on your PC at the time"

When I deploy the application to the clients (We have around 75 users), Is it necessary all the clients
also has to have OC4J running?

Ilango

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #307931 is a reply to message #307865]

Thu, 20 March 2008 07:17

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Application deployed on the web means that users will have to have an internet browser (MS Internet Explorer, for example). At the first use of the application, they should install Java Initiator and that should be all - no additional software of any kind is necessary (for example, you don't have to install any Oracle product on their computers).

They (users) will access the application which runs on Application Server and access data stored on the Database Server.

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #308109 is a reply to message #307931]

Fri, 21 March 2008 03:54

dillango
Messages: 145
Registered: January 2008

Senior Member

Thank you Mr.Littlefoot.

I have one final clarification in this regard. Atpresent Our existing setup is 2 tier architecture (Client - Server)which running Oracle 8i and Forms 6i.

When we upgrade it to 10G DS, will it work both database and Applications in one server itself?

For your information, our transaction is not much for time being.

Regards, ILANGO

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #308118 is a reply to message #308109]

Fri, 21 March 2008 04:56

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It is possible to install both Application and Database server onto a single machine, but - as far as I can tell - it is better to install them separately.

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #451329 is a reply to message #264585]

Wed, 14 April 2010 01:28

etcf1123
Messages: 5
Registered: April 2010

Junior Member

I didnt see the name 'mypc'. Instead these are shown in the file tnsnames.ora:

# tnsnames.ora Network Configuration File: E:\app\Administrator\product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

IMZ350 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = imz350.ust.hk)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = imz350)
)
)

IMZ335 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = imz335.ust.hk)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = imz335)
)
)

Which name are you referring to?

And I couldnt find the exceptions part under LAN settings in connection.

[mod-edit] color removed.

[Updated on: Wed, 14 April 2010 13:32] by Moderator

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #451345 is a reply to message #451329]

Wed, 14 April 2010 02:15

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Note that you are continuing a 2-years old discussion.

Are you trying to help, or do you have a problem?

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #451347 is a reply to message #451345]

Wed, 14 April 2010 02:25

etcf1123
Messages: 5
Registered: April 2010

Junior Member

I have a problem too!

I'm using IE 7 and when I tried to run form after opening OC4J, the browser closed and the following appeared in OC4J:

10/04/04 20:00:49 FormsServlet init<>:
configFileName: C:\DevSuiteHome_1/forms/server/formsweb.cfg
testMode: false

I have also enabled active content to run on my computer in the configuration but the same error occured

What is wrong!?

Thanks

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #451356 is a reply to message #451347]

Wed, 14 April 2010 03:11

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

etcf1123

And I couldnt find the exceptions part under LAN settings in connection.

You didn't search well.

/forum/fa/7701/0/

etcf1123

Which name are you referring to?

David

add the prefix for your local machine (for example, ';mypc.*') to the end of the list.

The name 'mypc' should have been created in the 'tnsnames.ora' file during the Forms 10g installation

I guess that David is talking about the "host" part.

What are your firewall settings? Did you allow pop-ups to ... well, pop-up?

Attachment: exceptions.PNG
(Size: 21.77KB, Downloaded 10623 times)

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #451362 is a reply to message #451356]

Wed, 14 April 2010 03:19

etcf1123
Messages: 5
Registered: April 2010

Junior Member

Yes I did allow pop-ups.

What should I fill in proxy address and port then??
Is it TCP and 1521?

IMZ350 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = imz350.ust.hk)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = imz350)
)
)

IMZ335 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = imz335.ust.hk)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = imz335)
)
)

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #451372 is a reply to message #451362]

Wed, 14 April 2010 04:06

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I guess that David is talking about the "host" part.

"host" <> "tcp" <> "port"

Quote:

(ADDRESS = (PROTOCOL = TCP)(HOST = imz350.ust.hk)(PORT = 1521))

However, as it doesn't seem to be your local computer, perhaps it isn't the main cause of your problems (or solution). What is? I don't know; forms run well on my IE 7 / Win XP SP 3.

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #451470 is a reply to message #451329]

Thu, 15 April 2010 00:33

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I wrote above "LAN Settings, Advanced, and in Exceptions". There is an 'Advanced' tab between 'LAN' and 'Exceptions'.

Try ';imz*.ust.hk' in the exceptions.

David

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #456864 is a reply to message #451470]

Wed, 19 May 2010 17:57

adrianabrinza
Messages: 3
Registered: May 2010

Junior Member

Hello!
I'm new on www.orafaq.com, and I'm new in Oracle Forms, too...
I installed the Oracle Developer Suite 10g 10.1.2.0.2, and a database first, of course... so I tried to run the test form, but I got an error which I think is because the Internet Explorer Browser ...
I followed the steps that David specified at one time, but it still doesn't work.
I attached the errors I got when I ran my form test. Can you help me, please???

Attachment: Run Forms.pdf
(Size: 524.23KB, Downloaded 2596 times)

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #457318 is a reply to message #456864]

Sun, 23 May 2010 20:28

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

In the 'Exceptions' you do not type the 'quote'.

Also try running your browser with 'Bypass proxy server for local addresses' 'checked'.

The 'restore' feature of a browser typically does not restart the Forms session. You need to start Forms in a new browser session. I recommend that you start the Forms session by pressing the 'run' button from within the Forms Builder.

Remember to close all browser windows when you change any of its settings.

David

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #457394 is a reply to message #457318]

Mon, 24 May 2010 03:53

adrianabrinza
Messages: 3
Registered: May 2010

Junior Member

David,
I've tried to follow your instructions, but no changes ... when I run the test form, the same error appears ...

Thanks for your fast reply!

Adriana

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #459701 is a reply to message #457394]

Tue, 08 June 2010 01:34

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Adriana,

Have you solved your problem?

David

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #459884 is a reply to message #459701]

Tue, 08 June 2010 13:29

adrianabrinza
Messages: 3
Registered: May 2010

Junior Member

Not yet! I chose to develop an application in Oracle Discoverer for my final paper study case, but I intend to resolve somehow the Forms configuration. I'll tell you, anyway!

All the best,
Adriana

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #565776 is a reply to message #260816]

Thu, 06 September 2012 11:18

albortapak
Messages: 2
Registered: September 2012
Location: Brazil

Junior Member

David when i do ctrl r on oracle forms, the web broser stuck and show ORACLE FORMS, i cannot see my forms, i already started the oc4j, configured internet options(allow active content to run in files on my computer, exception from Proxy Settings), i have installed oracle suite developer 10g (10.1.2.0.2) on windows 7, iexplorer 9, oracle client 11g and nothing fix my problem, what can i do?, thanks in advance.

Report message to a moderator

Re: Error at running forms in oracle form 10g [message #566839 is a reply to message #565776]

Thu, 20 September 2012 03:20

Hiro_ZA
Messages: 6
Registered: August 2008

Junior Member

sorry to resurrect a thread started so long ago, but i am having a very similiar issue and the topic describes my problem.

I have Oracle Forms Builder 9.0.2.7.0
I can modified and compile my forms just fine. I can deploy to our webserver just fine and they run on taht web server fine.
but i cannot run the forms on my local machine. I started the OC4J instance
if i leave the "PREFERENCES --> RUNTIME --> Application Server URL" as is (set to default) then i get an IE window opening with a local URL and the main window just says "ORACLE FORMS". after a few seconds, IE closes and nothing further happens.

If I change the App Server URL to point to our UAT App server, then i get the Oracle 10g background and app loading, but it crashes with message that its unable to find my FMX. But i put the path in FORMS90_PATH in registry.

please help

Report message to a moderator

Previous Topic:	Change the language of the textbox
Next Topic:	Form 10g 11i to R12 Date Issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 10:50:04 CDT 2024