Home » Developer & Programmer » Forms » Error at running forms in oracle form 10g
Error at running forms in oracle form 10g [message #260816] Tue, 21 August 2007 00:52 Go to next message
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?
Re: Error at running forms in oracle form 10g [message #260829 is a reply to message #260816] Tue, 21 August 2007 01:36 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: Error at running forms in oracle form 10g [message #261198 is a reply to message #260829] Wed, 22 August 2007 02:23 Go to previous messageGo to next message
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?
Re: Error at running forms in oracle form 10g [message #261589 is a reply to message #261198] Thu, 23 August 2007 01:48 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: Error at running forms in oracle form 10g [message #261645 is a reply to message #261589] Thu, 23 August 2007 03:41 Go to previous messageGo to next message
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!
./fa/2943/0/
  • Attachment: 11.bmp
    (Size: 1.10MB, Downloaded 9991 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 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Are you running an Application Server or a Developer Server?

David
Re: Error at running forms in oracle form 10g [message #262213 is a reply to message #261880] Sat, 25 August 2007 03:26 Go to previous messageGo to next message
mmrz
Messages: 29
Registered: August 2007
Junior Member
Developer Server
Re: Error at running forms in oracle form 10g [message #262412 is a reply to message #262213] Mon, 27 August 2007 00:04 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Then why are you using port 1588 instead of 8888?

David
Re: Error at running forms in oracle form 10g [message #262499 is a reply to message #262412] Mon, 27 August 2007 05:22 Go to previous messageGo to next message
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?
Re: Error at running forms in oracle form 10g [message #262608 is a reply to message #262499] Mon, 27 August 2007 21:12 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: Error at running forms in oracle form 10g [message #262661 is a reply to message #262608] Tue, 28 August 2007 00:53 Go to previous messageGo to next message
mmrz
Messages: 29
Registered: August 2007
Junior Member
All my Parameteres are the same as you mentioned!
Re: Error at running forms in oracle form 10g [message #262684 is a reply to message #262661] Tue, 28 August 2007 01:19 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What do you get in your browser when you run 'test' from within the Forms Builder?

David
Re: Error at running forms in oracle form 10g [message #264221 is a reply to message #262684] Sun, 02 September 2007 02:39 Go to previous messageGo to next message
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.
Re: Error at running forms in oracle form 10g [message #264585 is a reply to message #264221] Mon, 03 September 2007 20:25 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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 Go to previous messageGo to next message
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 1119 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 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Can you run the 'test' form from within the Forms Builder?

David
Re: Error at running forms in oracle form 10g [message #307675 is a reply to message #260816] Wed, 19 March 2008 07:34 Go to previous messageGo to next message
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 903 times)
Re: Error at running forms in oracle form 10g [message #307690 is a reply to message #307675] Wed, 19 March 2008 08:53 Go to previous messageGo to next message
Littlefoot
Messages: 19289
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"?
Re: Error at running forms in oracle form 10g [message #307702 is a reply to message #307690] Wed, 19 March 2008 10:23 Go to previous messageGo to next message
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

Re: Error at running forms in oracle form 10g [message #307752 is a reply to message #307702] Wed, 19 March 2008 15:50 Go to previous messageGo to next message
Littlefoot
Messages: 19289
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.
Re: Error at running forms in oracle form 10g [message #307773 is a reply to message #307752] Wed, 19 March 2008 18:33 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: Error at running forms in oracle form 10g [message #307865 is a reply to message #307773] Thu, 20 March 2008 03:46 Go to previous messageGo to next message
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



Re: Error at running forms in oracle form 10g [message #307931 is a reply to message #307865] Thu, 20 March 2008 07:17 Go to previous messageGo to next message
Littlefoot
Messages: 19289
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.
Re: Error at running forms in oracle form 10g [message #308109 is a reply to message #307931] Fri, 21 March 2008 03:54 Go to previous messageGo to next message
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

Re: Error at running forms in oracle form 10g [message #308118 is a reply to message #308109] Fri, 21 March 2008 04:56 Go to previous messageGo to next message
Littlefoot
Messages: 19289
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.
Re: Error at running forms in oracle form 10g [message #451329 is a reply to message #264585] Wed, 14 April 2010 01:28 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 19289
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?
Re: Error at running forms in oracle form 10g [message #451347 is a reply to message #451345] Wed, 14 April 2010 02:25 Go to previous messageGo to next message
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
Re: Error at running forms in oracle form 10g [message #451356 is a reply to message #451347] Wed, 14 April 2010 03:11 Go to previous messageGo to next message
Littlefoot
Messages: 19289
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.

./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?
Re: Error at running forms in oracle form 10g [message #451362 is a reply to message #451356] Wed, 14 April 2010 03:19 Go to previous messageGo to next message
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)
)
)
Re: Error at running forms in oracle form 10g [message #451372 is a reply to message #451362] Wed, 14 April 2010 04:06 Go to previous messageGo to next message
Littlefoot
Messages: 19289
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
LF
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.
Re: Error at running forms in oracle form 10g [message #451470 is a reply to message #451329] Thu, 15 April 2010 00:33 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: Error at running forms in oracle form 10g [message #456864 is a reply to message #451470] Wed, 19 May 2010 17:57 Go to previous messageGo to next message
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 884 times)
Re: Error at running forms in oracle form 10g [message #457318 is a reply to message #456864] Sun, 23 May 2010 20:28 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: Error at running forms in oracle form 10g [message #457394 is a reply to message #457318] Mon, 24 May 2010 03:53 Go to previous messageGo to next message
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
Re: Error at running forms in oracle form 10g [message #459701 is a reply to message #457394] Tue, 08 June 2010 01:34 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Adriana,

Have you solved your problem?

David
Re: Error at running forms in oracle form 10g [message #459884 is a reply to message #459701] Tue, 08 June 2010 13:29 Go to previous messageGo to next message
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
Re: Error at running forms in oracle form 10g [message #565776 is a reply to message #260816] Thu, 06 September 2012 11:18 Go to previous messageGo to next message
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.
Re: Error at running forms in oracle form 10g [message #566839 is a reply to message #565776] Thu, 20 September 2012 03:20 Go to previous message
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
Previous Topic: Change the language of the textbox
Next Topic: Form 10g 11i to R12 Date Issue
Goto Forum:
  


Current Time: Tue Jul 22 02:51:14 CDT 2014

Total time taken to generate the page: 0.17654 seconds