OraFAQ Forum: Forms » Migrating Form6i to Forms9i

Home » Developer & Programmer » Forms » Migrating Form6i to Forms9i

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

Migrating Form6i to Forms9i [message #129835]

Tue, 26 July 2005 21:33

kate99
Messages: 24
Registered: July 2005

Junior Member

We have an application using Forms6i (includes Menus and Reports) and 8i database. We want to migrate it to Forms 9i. We have Developer Suite 10g(9.0.4), and installed Rapid Application Development.

I used the Migration Assistant to convert a few fmb files for testing. They were successfully converted and compiled. My problem is (it's a very basic question) I don't know how to deploy the web-based runtime.

I know Developer 9i doesn't have client-server runtime. And I read some documents on how to deploy a web-based application.
It seems after compilation, I need to add the application to the formsweb.cfg, then I should be able to run the application on a browser with the http://computername:port/forms90/f90servlet?config-application. For example, my computer name is ri1273, port is 7778, and application is test1; the address would be http://ri1273:7778/forms90/f90servlet?config-test1.
Is that concept correct? My problem is I don't know the port number. Is it the one I use for the http listener? I have configured a listener, but I don't think I have a http listener. How to configure one? Embarassed

Embarassed

Thanks,
Kate

Report message to a moderator

Re: Migrating Form6i to Forms9i [message #129840 is a reply to message #129835]

Tue, 26 July 2005 22:37

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

Senior Member
Account Moderator

Your are pretty close. All DS machines work through port 8888. All AS machines work through port 7778. So you should use http://ri1273:8888/forms90/f90servlet?config=test1 - note the two changes '8888' and '=' (which I assume was a typo).

You also have to start the OC4J instance. This will take 30 seconds to a minute the first time that it runs on a PC as there is a great deal of initialisation to be done.

David

Report message to a moderator

Re: Migrating Form6i to Forms9i [message #129869 is a reply to message #129840]

Wed, 27 July 2005 01:37

kate99
Messages: 24
Registered: July 2005

Junior Member

Thanks, David,

I started the OC4J instance; then tried http://ri1273:8888/forms90/f90servket?config=test1, but it still didn't work (DNS host name resolution failed). Did I miss something? or did something wrong?

In formsweb.cfg, I put:
[test1]
form=start.fmx
at the end of the file. I also specified the form location in default.env.

Kate

Report message to a moderator

Re: Migrating Form6i to Forms9i [message #129875 is a reply to message #129869]

Wed, 27 July 2005 01:52

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

Senior Member
Account Moderator

Okay, let's crawl before we walk. Don't put the forms path in the default.env, please use the FORMS90_PATH in the registry. That way ALL the Oracle 9 products know where the forms live. Change the REPORTS_PATH to point to the reports, and UI_ICON to point to the 'ico' files. When updating the registry put your entries before the entries placed there by Oracle.

"NOTE: The D:\oracle\OraHomeDeveloper\forms90\server\default.env file can be used to change the server characteristics independently of the registry entries. However, the registry entries are those that are used by the Form and Report builders."

In your [test1] put a few more lines:
separateFrame=True
form=start.fmx
userid=usr/@dbn
width=850
height=650
colorScheme=Titanium
align=baseline
webformsTitle="My Personal 9i"
Logo=no
Background=NO

Starting from the 'Start' icon navigate to the Forms entries, start the OC4J so that it uses the new registry entries and then try running the 'TEST' form provided by Oracle.

Once you have that going, you should be able to get the 'test1' configuration running.

David

[Updated on: Wed, 27 July 2005 01:53]

Report message to a moderator

Re: Migrating Form6i to Forms9i [message #129899 is a reply to message #129875]

Wed, 27 July 2005 03:59

kate99
Messages: 24
Registered: July 2005

Junior Member

David,

I did as you told, but I still got the 'DNS Host name resolution failed' result. So, I start looking up documents about HTTP Server. Here's an embarrassing question: do I have to setup Application Server to run the form? I thought Developer Suite includes the runtime engineer?

Thanks,
Kate

Report message to a moderator

Re: Migrating Form6i to Forms9i [message #130044 is a reply to message #129899]

Wed, 27 July 2005 20:27

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

Senior Member
Account Moderator

No ... you only need to set up the Developer Server.

[I will add more details a bit later.]

Okay ... make sure that your 9i tnsnames.ora contains your databases (search this forum for 'ifile' ... it is a neat trick to maintain the 9i file the same as the 6i file).

In Internet Explorer, go to Tools -> Internet Options, Connections, LAN Settings, Advanced, in Exceptions add the prefix for the various application servers followed by an asterisk ('*'), eg. ';our_as.*'. Also make sure your local machine is in the Exceptions.

Tell us if these changes help solve your problem.

David

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

Report message to a moderator

Re: Migrating Form6i to Forms9i [message #130256 is a reply to message #130044]

Fri, 29 July 2005 01:01

kate99
Messages: 24
Registered: July 2005

Junior Member

The tnsnames.ora has the database name.
I tried the Exceptions in the LAN Settings, I didn't get the DNS Host error this time, but I got 'the page cannot be displayed' screen. Sad

Sad

Report message to a moderator

Re: Migrating Form6i to Forms9i [message #130265 is a reply to message #130256]

Fri, 29 July 2005 01:54

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

Senior Member
Account Moderator

Okay ... please paste the url that is on the screen.

I assume that you have rebooted your PC since you installed Forms 9 - please confirm.

In the exceptions also put in 127.0.0.1.

You have got OC4J running - please confirm. Can you get open the 'test.fmb' and run it via the 'start' menu options - please confirm.

David

Report message to a moderator

Re: Migrating Form6i to Forms9i [message #130277 is a reply to message #130265]

Fri, 29 July 2005 02:42

kate99
Messages: 24
Registered: July 2005

Junior Member

Thanks! David,

I don't understand what you mean by 'open the 'test.fmb' and run it via the 'start' menu options'. I can open the test.fmb in the Forms Builder, but how to run it via 'start'?

I used Program -> Run Form in the Forms Builder, and got a different port number. Mine is 8892! Then I used 8892 instead of 8888 in the url, I got the Forms Service started, but I also got the FRM-40010 error. So I guess I need to fix the fmb?

Do I need to start OC4J instance everytime I run the application?

Kate

Report message to a moderator

Re: Migrating Form6i to Forms9i [message #130280 is a reply to message #130277]

Fri, 29 July 2005 02:51

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

Senior Member
Account Moderator

You are running Forms 9i.

From the 'start' icon in the bottom left of most Windows PC screens there is the menu 'Start > Programs > Oracle 9i > Forms Developer > Run a Form on the Web'.

It should be above to the 'Start OC4J Instance' menu item.

I would suggest stopping and restarting the OC4J each time you have a problem. To make this easier copy the menu shortcuts to your 'quick start' line which is typically at the bottom of your screen.

David

Report message to a moderator

Re: Migrating Form6i to Forms9i [message #130284 is a reply to message #130277]

Fri, 29 July 2005 03:03

kate99
Messages: 24
Registered: July 2005

Junior Member

ok, I added the path of the form in default.env, and it solved the FRM-40010 error, but I got ORA-12541: TNS:no listener... I've configured a listener in Forms9i, and have the listener.ora in the forms9i directory.

Report message to a moderator

Re: Migrating Form6i to Forms9i [message #130289 is a reply to message #130284]

Fri, 29 July 2005 03:09

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

Senior Member
Account Moderator

Please don't put the forms path in the default.env, only put it in the Forms9i home of the registry.

How many oracle homes do you have? Which is the current home?

David

[Updated on: Fri, 29 July 2005 03:10]

Report message to a moderator

Re: Migrating Form6i to Forms9i [message #130296 is a reply to message #130289]

Fri, 29 July 2005 03:35

kate99
Messages: 24
Registered: July 2005

Junior Member

There are four Oracle homes in my machine: 8i database (client), 9i database (client), Developer Suite 6i, and Developer Suite 9i. The application I run uses DS9i.

Why not put the path in default.env? I put it in forms9i registry, but got frm-40010. Then putting it in default.env fixed the problem I think (though get another problem). Razz

Razz

Report message to a moderator

Re: Migrating Form6i to Forms9i [message #130508 is a reply to message #130296]

Sun, 31 July 2005 18:39

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

Senior Member
Account Moderator

If you put the paths in the default.env then the Form Builder can't see the libraries and objects associated with your form during the build and compile process.

In your registry, you have four homes. What is number 1? What is number 2? What is number 3? What is number 4? What is the number of the default home?

David

Report message to a moderator

Re: Migrating Form6i to Forms9i [message #130525 is a reply to message #130508]

Sun, 31 July 2005 20:13

kate99
Messages: 24
Registered: July 2005

Junior Member

Happy Monday!

My home1 is 9idatabase (that's the default).
Home2 is 6iDS, home3 is 8idatabase, and home4 is 9iDS.

Maybe I can put the path on both the registry and default.env?
So that I won't get the frm-40010 error, and the form builder can see the libraries and objects.

Thanks,
Kate

Report message to a moderator

Re: Migrating Form6i to Forms9i [message #130530 is a reply to message #130525]

Sun, 31 July 2005 20:27

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

Senior Member
Account Moderator

G'day Kate ... humour me ... in the 'ALL_HOMES' in the register what's the numbers for the 'LAST_HOME' and HOME_COUNTER.

David

Report message to a moderator

Re: Migrating Form6i to Forms9i [message #130531 is a reply to message #130530]

Sun, 31 July 2005 20:36

kate99
Messages: 24
Registered: July 2005

Junior Member

last_home is 4
home_counter is 5.

Report message to a moderator

Re: Migrating Form6i to Forms9i [message #130532 is a reply to message #130531]

Sun, 31 July 2005 20:53

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

Senior Member
Account Moderator

Okay .. you have five Oracle homes ... numbered HOME0 through HOME4. Go to each and check the Oracle_Home_Name and Oracle_Home directory name.

The LAST_HOME points to the default home, which in your case would be the one pointed to by HOME4 (this is the last of the 5 homes you have defined).

I have this feeling that you may have installed one of the pieces of Oracle software twice, which is a really BAD idea. As I believe you are modifying the right files but in the wrong 'home'.

Please list here the home number, the Oracle_Home_Name, and the Oracle_Home for each them.

David

Report message to a moderator

Re: Migrating Form6i to Forms9i [message #130533 is a reply to message #130532]

Sun, 31 July 2005 21:18

kate99
Messages: 24
Registered: July 2005

Junior Member

Yes, I installed 9idatabase twice. I deinstalled 9idatabase before I installed it the second time (though there are still folders and files not automatically deleted, and I just left them there).

Here's the list of oracle home in the registry:
(I pressume home number is ID)
Home0 -
ID: 0, oracle_home: d:\oracle\ora92, oracle_home_name: OraHome92
Home1 -
ID: 1, oracle_home: c:\oracle\ora92, oracle_home_name: orahome921
Home2 -
ID: 2, oracle_home: c:\oracle\ora6i, oracle_home_name: orahome6i
Home3 -
ID: 3, oracle_home: c:\oracle\ora817, oracle_home_name: OraHome817
Home4 -
ID: 4, oracle_home: c:\oracle\oraform9, oracle_home_name: oraform9

All_home -
default_home: OraHome92, home_counter: 5, last_home: 4

Report message to a moderator

Re: Migrating Form6i to Forms9i [message #130535 is a reply to message #130533]

Sun, 31 July 2005 21:58

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

Senior Member
Account Moderator

Kate,

Have you been able to run your 6i Web Listener satisfactorily? Either now or previous to installing 9i?

David

Report message to a moderator

Re: Migrating Form6i to Forms9i [message #130536 is a reply to message #130535]

Sun, 31 July 2005 22:18

kate99
Messages: 24
Registered: July 2005

Junior Member

I don't think I ran forms6i with web listener, I ran it with ifrun60.exe. And it worked well. But, I just tried to run forms6i again (I don't remember if I've tried it since I installed forms9i), it got the same error message as when I tried to run forms9i! The error is ORA-12224: TNS: no listener. The error code with forms9i is ORA-12541: TNS: no listener.

Report message to a moderator

Re: Migrating Form6i to Forms9i [message #130541 is a reply to message #130536]

Sun, 31 July 2005 22:46

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

Senior Member
Account Moderator

In which order did you install 6i forms and reports, and 9i forms and reports? They must be installed in the order reports then forms, otherwise the forms won't run!! Smile

Smile

To 'uninstall' Oracle 6i or 9i quickly, easily, and actually cleaner than using Oracle Uninstall. Go to the C:/oracle/ora92 (for example) and delete all the files that exist below it. Then install back into the same directory using the same Oracle Home.

David

Report message to a moderator

Re: Migrating Form6i to Forms9i [message #130542 is a reply to message #130541]

Sun, 31 July 2005 23:13

kate99
Messages: 24
Registered: July 2005

Junior Member

David,

I used the Oracle Universal Installer to install Developer Suite with Rapid Application Development. I guess the order of installation should be right?

Should I do anything with listener? In Services (Control Panel), I only see Oracleoraform9ClientCache, Oracleorahome6iClientCache80, OracleOraHome817ClientCache, and OracleOraHome92ClientCache. I don't see any TNSListener or HTTPServer. There's listener.ora in the forms9i home directory. Amd the 9idatabase and 8idatabase have no problem with connection. Thanks again for the help.

Kate

Report message to a moderator

Re: Migrating Form6i to Forms9i [message #130653 is a reply to message #130542]

Mon, 01 August 2005 18:33

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

Senior Member
Account Moderator

Unfortunately, no. You must be extremely careful when installing the reports server after the forms server as common files will lose their forms settings. Doing it in the other order does not remove the reports settings.

David

Report message to a moderator

Re: Migrating Form6i to Forms9i [message #130672 is a reply to message #130653]

Mon, 01 August 2005 22:01

kate99
Messages: 24
Registered: July 2005

Junior Member

David,

The TNS no listener problem is solved! It's really the tnsname matter. Though the form is still not running properly, at least it can be started. Thank you very much for your help.

Kate

Report message to a moderator

Re: Migrating Form6i to Forms9i [message #133425 is a reply to message #130653]

Fri, 19 August 2005 00:41

amtul
Messages: 8
Registered: March 2005

Junior Member

Hello
got similar problem but i have compiled forms in 9i using developer suite 9i and it is running in the browser with URL

http://oisserv:8888/forms90/f90servlet?form=c:\ois\ois_application\welcome.fmx

Now what to do next to deploy this form on the intranet throgh application server .David could u please answer.
this is really urgent . thanx in advance

amtul

Report message to a moderator

Re: Migrating Form6i to Forms9i [message #133427 is a reply to message #133425]

Fri, 19 August 2005 01:00

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

Senior Member
Account Moderator

Look at my message '129875' in this thread (use Ctrl-F to find it). The way I define an application is to create an entry (eg. 'test1') in the formsweb.cfg. This removes the path, etcetera from the URL line, and gives everyone a standard look and feel. You will see in the other posts the 'config=' construct, it is much better than using the full URL.

For running on the 9iAS, if the AS is on the same operating systems and hardware as your DS then you do not need to recompile and regenerate the 'fmx' files. But if you have a typical installation where the AS box is running different hardware and operating system then you need to copy the 'fmb' file to it and recompile and regenerate the 'fmx'. Put the various components into the config files and use the 7778 port of the AS to run your application.

David

Report message to a moderator

Re: Migrating Form6i to Forms9i [message #133600 is a reply to message #133427]

Fri, 19 August 2005 22:47

amtul
Messages: 8
Registered: March 2005

Junior Member

Hello David
Thanx for quick response. I have done changes in formsweb.cfg and is working fine.I have Oracle9iAS on the same machine but it is using port 7777.

http://oisserv.ois:7777

i did not understand which components u r refering to to put in config files. would u please elaborate the procedure because i am new to application server .
Thanx in advance
amtul

Report message to a moderator

Previous Topic:	Show multiple records
Next Topic:	Can I use commit at block level

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 03:59:36 CDT 2024