OraFAQ Forum: Forms » problem in running form on oracle developer suite 10g

Home » Developer & Programmer » Forms » problem in running form on oracle developer suite 10g

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

problem in running form on oracle developer suite 10g [message #514229]

Sat, 02 July 2011 13:37

prasubh
Messages: 15
Registered: July 2011
Location: bangalore

Junior Member

i am new and developing my first oracle form.but when i am running this form.it's not running,i have installed already jinit.exe setup.Is this necessary internet connection for running forms.port no. is 8890
please tell me solution soon

Report message to a moderator

Re: problem in running form on oracle developer suite 10g [message #514235 is a reply to message #514229]

Sat, 02 July 2011 14:23

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

Senior Member
Account Moderator

Some more information (from your side) would be nice (such as operating system you use, settings you set so far, ...). Until then, check this.

Report message to a moderator

Re: problem in running form on oracle developer suite 10g [message #514250 is a reply to message #514235]

Sat, 02 July 2011 22:05

mrnaveed
Messages: 74
Registered: December 2009
Location: Pakistan

Member

What happens when you run form???

Report message to a moderator

Re: problem in running form on oracle developer suite 10g [message #514278 is a reply to message #514250]

Sun, 03 July 2011 09:46

prasubh
Messages: 15
Registered: July 2011
Location: bangalore

Junior Member

i get this url
h....//prasubh:8890/forms/frmservlet

this h is http because m unable to post link now

and the blank page....

Attachment: form.JPG
(Size: 53.63KB, Downloaded 1414 times)

Report message to a moderator

Re: problem in running form on oracle developer suite 10g [message #514279 is a reply to message #514278]

Sun, 03 July 2011 09:49

prasubh
Messages: 15
Registered: July 2011
Location: bangalore

Junior Member

i am using window xp OS and default database of oracle 10g

Report message to a moderator

Re: problem in running form on oracle developer suite 10g [message #514280 is a reply to message #514279]

Sun, 03 July 2011 09:59

prasubh
Messages: 15
Registered: July 2011
Location: bangalore

Junior Member

i have a doult please clarify me..
as internet connection is necessary for running iSQL in oracle10g
is there also need of internet for running forms 10g.

Report message to a moderator

Re: problem in running form on oracle developer suite 10g [message #514295 is a reply to message #514280]

Sun, 03 July 2011 12:56

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

If every component is installed on same computer then only localhost networking needs to be operational,

Report message to a moderator

Re: problem in running form on oracle developer suite 10g [message #514296 is a reply to message #514295]

Sun, 03 July 2011 13:09

prasubh
Messages: 15
Registered: July 2011
Location: bangalore

Junior Member

blackswan....i didn't get you properly...can you more clarify this

Report message to a moderator

Re: problem in running form on oracle developer suite 10g [message #514298 is a reply to message #514296]

Sun, 03 July 2011 13:40

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Forms requires "networking" to make connection to database.
Forms requires "networking" to allow browser to connect to any form.
LOCALHOST uses 127.0.0.1 which is sufficient for both of the above.
This requires Forms software & DB software to reside on same system.

Report message to a moderator

Re: problem in running form on oracle developer suite 10g [message #514303 is a reply to message #514298]

Sun, 03 July 2011 14:49

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

Senior Member
Account Moderator

I still don't know what you already did in order to run a form. List ALL settings you set so far.

Report message to a moderator

Re: problem in running form on oracle developer suite 10g [message #514331 is a reply to message #514303]

Mon, 04 July 2011 02:01

prasubh
Messages: 15
Registered: July 2011
Location: bangalore

Junior Member

i have window XP OS
i am running forms on localhost on the same machine on which i am developing form.
for connection:
username- scott
password - tiger
database- (it is not accepting service name ORCL default database instance "ORCL" thats why i am leaving this blank)
i am only creating a datablock using datablock wizard
then i am compiling and then runnning
and when i run this form then browser shows in url
http://prasubh:8889/forms/frmservlet
and blank browser page
i am attaching the image of browser here

Attachment: form.JPG
(Size: 53.63KB, Downloaded 1409 times)

Report message to a moderator

Re: problem in running form on oracle developer suite 10g [message #514336 is a reply to message #514331]

Mon, 04 July 2011 02:28

prasubh
Messages: 15
Registered: July 2011
Location: bangalore

Junior Member

and in command prompt it is like this

C:\Documents and Settings\prasubh1>G:\DevSuiteHome_1\jdk\bin\java -Doracle.secu
rity.jazn.config=G:\DevSuiteHome_1\j2ee\DevSuite\config\jazn.xml -Doracle.home=G
:\DevSuiteHome_1 -DORACLE_HOME=G:\DevSuiteHome_1 -jar G:\DevSuiteHome_1\j2ee\hom
e\oc4j.jar -userThreads -config G:\DevSuiteHome_1\j2ee\DevSuite\config\server.xm
l
11/07/03 12:53:07 Oracle Application Server Containers for J2EE 10g (10.1.2.0.2)
initialized
11/07/03 12:53:17 FormsServlet init():
configFileName: G:\DevSuiteHome_1/forms/server/formsweb.cfg
testMode: false

Attachment: oc4j.JPG
(Size: 95.84KB, Downloaded 1277 times)

Report message to a moderator

Re: problem in running form on oracle developer suite 10g [message #514341 is a reply to message #514331]

Mon, 04 July 2011 02:37

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

Senior Member
Account Moderator

Did you (in Forms Builder) go to Edit - Preferences - Runtime tab and set the Application Server URL to correct value?

Where is the database located? On your own computer, or somewhere on the network? Did you fix the TNSNAMES.ORA file so that it contains the database you are connecting to?

Did you check "Allow active content to run in files on My Computer"? It is set in Internet Explorer - Tools - Internet options - Advanced tab.

Did you disable firewall? Are you using a proxy?

Report message to a moderator

Re: problem in running form on oracle developer suite 10g [message #514417 is a reply to message #514341]

Mon, 04 July 2011 12:07

prasubh
Messages: 15
Registered: July 2011
Location: bangalore

Junior Member

hii...
now i have installed d2k 9i and same problem is again..everything is perfect but when i run the form ...the browser again blank..

i am doing all process in my system..i have database in my system which is ORCL and using mozilla firefox..and there is enable javascript,block pop-up already

In have set in forms>edit> application url i have set default "http://prasubh:8888/forms90/f90servlet"
and in browser "C:\Program Files\Mozilla Firefox\firefox.exe"

when i was installing d2k9i it performed successful test connection

in browser address bar the url is now
http://prasubh:8888/forms90/f90servlet?form=C:\praforms\form1.fmx&userid=SCOTT/TIGER@orcl&buffer_records=NO&debug_message s=NO&array=YES&query_only=NO&quiet=NO&RENDER=YES

and tnsnames.ora is

# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = prasubh)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

Attachment: form9i.JPG
(Size: 60.62KB, Downloaded 1127 times)

Report message to a moderator

Re: problem in running form on oracle developer suite 10g [message #514419 is a reply to message #514417]

Mon, 04 July 2011 12:26

prasubh
Messages: 15
Registered: July 2011
Location: bangalore

Junior Member

and in oc4j instance it is----
C:\Documents and Settings\prasubh1>C:\oracle\product\forms9i\jdk\bin\java -Dorg.
omg.CORBA.ORBClass=com.inprise.vbroker.orb.ORB -Dorg.omg.CORBA.ORBSingletonClass
=com.inprise.vbroker.orb.ORB -Doracle.security.jazn.config=C:\oracle\product\for
ms9i\j2ee\Oracle9iDS\config\jazn.xml -Doracle.home=C:\oracle\product\forms9i -DO
RACLE_HOME=C:\oracle\product\forms9i -jar C:\oracle\product\forms9i\j2ee\home\oc
4j.jar -userThreads -config C:\oracle\product\forms9i\j2ee\Oracle9iDS\config\ser
ver.xml
Warning: Error reading transaction-log file (/C:/oracle/product/forms9i/j2ee/Ora
cle9iDS/persistence/transaction.state) for recovery: premature end of file
Forced or abrupt (crash etc) server shutdown detected, starting recovery process
...
Recovery completed, 0 connections committed and 0 rolled back...
Oracle9iAS (9.0.2.0.0) Containers for J2EE initialized
FormsServlet init():
configFileName: C:\oracle\product\forms9i/forms90/server/formsweb.cfg
testMode: false

Attachment: oc4jj.JPG
(Size: 60.14KB, Downloaded 1189 times)

Report message to a moderator

Re: problem in running form on oracle developer suite 10g [message #514443 is a reply to message #514417]

Mon, 04 July 2011 15:09

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

Senior Member
Account Moderator

prasubh wrote on Mon, 04 July 2011 19:07

and there is enable javascript,block pop-up already

Try to allow pop-ups.

If that doesn't help, try to switch to MS Internet Explorer and see what happens.

Report message to a moderator

Re: problem in running form on oracle developer suite 10g [message #514464 is a reply to message #514443]

Mon, 04 July 2011 23:32

prasubh
Messages: 15
Registered: July 2011
Location: bangalore

Junior Member

ya something seems better but not complten MS IE.
when i am running form now it shows loading java applet then go off
and nothing haapens..
see the screen shot

Attachment: ie.JPG
(Size: 84.51KB, Downloaded 1307 times)

Report message to a moderator

Re: problem in running form on oracle developer suite 10g [message #514466 is a reply to message #514464]

Mon, 04 July 2011 23:33

prasubh
Messages: 15
Registered: July 2011
Location: bangalore

Junior Member

checkout also IE settings in screen shot

Attachment: ietools.JPG
(Size: 155.91KB, Downloaded 1280 times)

Report message to a moderator

Re: problem in running form on oracle developer suite 10g [message #514674 is a reply to message #514466]

Tue, 05 July 2011 14:52

prasubh
Messages: 15
Registered: July 2011
Location: bangalore

Junior Member

HII..
so much thanks to all of you...my forms are running properly now...
thankyou so much for your's support

Report message to a moderator

Re: problem in running form on oracle developer suite 10g [message #514679 is a reply to message #514674]

Tue, 05 July 2011 15:04

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

Senior Member
Account Moderator

OK, so what did you do in order to solve the problem? If you could list all steps, I'm sure people will find it useful in the future.

Report message to a moderator

Re: problem in running form on oracle developer suite 10g [message #514731 is a reply to message #514679]

Wed, 06 July 2011 02:52

prasubh
Messages: 15
Registered: July 2011
Location: bangalore

Junior Member

again i have just set path for browser IE then it was running but still its not running on mozilla firefox...
and steps are same as earlier define
thanks littlefoot.

Report message to a moderator

Previous Topic:	Form Conversion
Next Topic:	Dynamically passing where condition

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 16 12:27:08 CDT 2024