Home » Developer & Programmer » Forms » oracle 10g form running
oracle 10g form running [message #341522] Tue, 19 August 2008 03:44 Go to next message
sabbi.sandhu
Messages: 5
Registered: August 2008
Location: ludhiana
Junior Member
hi every one,

i have installed oracle 10g database and 10g form successfully
i develop a form in 10g but i m unable to run it in browser
i have made all settings that one should
when i run it, explorer is opening but blank
Re: oracle 10g form running [message #341525 is a reply to message #341522] Tue, 19 August 2008 03:56 Go to previous messageGo to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
did you start the OC4J instance?

did you point the forms to the database home (copy tnsnames.ora, sqlnet.ora, listener.ora - only if both are installed on the same machine)

if the answer to any of the above is no then search for it..
Re: oracle 10g form running [message #341568 is a reply to message #341525] Tue, 19 August 2008 06:29 Go to previous messageGo to next message
sabbi.sandhu
Messages: 5
Registered: August 2008
Location: ludhiana
Junior Member
WHERE TO COPY (copy tnsnames.ora, sqlnet.ora, listener.ora )
YEA I HAVE INSTALLED BOTH ON SAME MACHINES



AND HOW TO point the forms to the database home


Re: oracle 10g form running [message #341602 is a reply to message #341568] Tue, 19 August 2008 08:52 Go to previous messageGo to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
both the homes (developer suite and database) have these three files (search from the OS).

Replace the files of the developer home with those of the database home so the developer will connect to the database when you enter username and password.

After doing this when you have created a form before running it (Ctlr+R) start the OC4J instance 10_suite->forms->start OC4J instance and things should work fine..
Re: oracle 10g form running [message #341608 is a reply to message #341568] Tue, 19 August 2008 09:04 Go to previous messageGo to next message
blueF
Messages: 22
Registered: August 2008
Location: gulf
Junior Member

so your datebase is local. you need to chech the tnsnames.ora and listiner.ora from database,you should know the home of yr database. go there,under folder admin you will find the both files of *.ora. just make sure the ORACLE_SID and ORACLE_GLOBAL.

Then, go to your application which is Oracle Developer Suite - oracle_home . you must check the tnsname.ora

good luck
Re: oracle 10g form running [message #341661 is a reply to message #341608] Tue, 19 August 2008 17:32 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Consider using the environment variable 'tns_admin' to point to one copy of 'tnsnames.ora'. This will save you having to maintain each copy separately.

David
Previous Topic: how to send an email
Next Topic: List Box after populate_list() behaviour
Goto Forum:
  


Current Time: Mon Feb 03 09:52:43 CST 2025