You may have heard the rumors about upgrading to Forms 11g R2. How all you need is a quick recompile of your 10g forms. I of course was skeptical since I’ve heard rumors like this before… “It’s just a minor upgrade”, “Just run the migration wizard and you’re done”
This time I can happily report that it is TRUE.
Last week we successfully upgraded about 700 forms to 11g R2 in about a WEEK including all installs and infrastructure configuring.
I installed Weblogic 10.1.3.5 and Forms 11g R2 standalone (Installs to download here) on a VM machine of Windows 2008 R2 – 64 bit (See post for how to do the installation) and recompiled our 10.1.2.3 Forms application. I completed all installations, configuration of files, registry editing, signing of the jar files, HEBREW SUPPORT configuration and upgraded the 10g application. The whole deal took about 1.5 days and only because I ran into a silly bug. (which I tell you how to avoid in this post)
In general the only issues we ran into while compiling and upgrading the Forms were “nit picky”. 10g did not really care if we had a piece of code that was not supported on the web or small inconsistencies in the code . Now forms 11g gets aggressive.
If a form does not compile, it’s best to check the following:
1) Does the Form call graphics? (no longer supported in 11g)
2) Does it calls to unsupported triggers, properties or code? (For example calling OLE2 without using webutil)
3) Does it have inconsistencies in datatypes such as a character fields that are assigned to a number in packages?
4) Does it have inconsistencies between package specs and bodies?
5) Notice – The names of icons have gotten SUPER case sensitive meaning that if you have an icon mia.GIF it is not equal to mia.gif and will not show up.
Truth is, I was shocked at how smooth it went! From about 700 forms only about 12 had issues to fix.
We then did performance testing of the 10.1.2.3 in production as we have it today as a baseline. The Forms 10.1.2.3 system on VM Windows 2003 Sp2 – 32 bit had about 75 concurrent users before form sessions started crashing and response times of those who were already connected became intolerable.
Then came time to test Form 11g R2. We started running the tests and we were amazed. Not only did we reach the limit of the testing license 250 users. But the performance was faster than the current production system with 70 users. The 250 users did not even begin to scratch the surface the performance did not degrade by a millisecond. Basically the system will go from 12 production servers in 10g to 3 in Forms 11g !! What a pleasure it will be to do maintenance. I can not stress enough- put the installation on 64 bit. I have another customer who installed Forms 11g R2 on 32 bit and it was nowhere near our performance.
As a consultant who has gone through some VERY painful migrations this one was really a pleasant surprise. So if the new features in Forms 11g R2 are not enough to WOW you into upgrading your forms then just think of the performance and reduced maintenance advantages! I have not been this happy to enter an upgrade project in years
You can also join my Webinar with ODTUG and Grant Ronald of Oracle tomorrow for more tips and tricks on modernizing your forms application. Register HERE.
Have any of you begun your migration? Share thoughts and tips….
Mia





Efrat
Apr 1, 2012 -
Mia,
The blog is wonderful!
I am so exited, it’s like to have a huge hug.
Thanks a lot for your help,
Efrat
Najeeb
Jun 6, 2012 -
Mia,
We have upgraded our server,now i would like to integrate with Javascript ,i would like to have a pop up alert in the notification area based on some external event.Can you give me some suggesitions on this.
Regards,
Najeeb.m
Oracle Forms Info
Jun 6, 2012 -
Hi Najeeb,
To begin using Javascript with Oracle Forms I suggests you start here.
http://st-curriculum.oracle.com/obe/forms/11g/jsinteg/formsjsinteg/setup.htm
Its a great step by step tutorial.
Good Luck,
Mia
Prateek Sachan
Aug 9, 2012 -
We did in Nucleus Software Noida India for one of our customers and since last 4 months are struggling with FRM-92104 and hang issues. Any insights will be really helpful. Abosultely no other issues encountered.
Oracle Forms Info
Aug 9, 2012 -
Do you have 2 weblogic Oracle Forms servers in a cluster?
Prateek Sachan
Aug 10, 2012 -
Nopes, we dont have cluster. We are using OHS in front of our WLS_FORMS and WLS_REPORTS. Earlier we thought the error will have something to do with a bug or incorrect configuration of HTTP Server. But when we tried using application directly with WLS_FORMS port, the same problem persisted. Hence, it looks to be something related to FORMS only.
Don Juan de Marco
Nov 9, 2012 -
I, on the other hand, happen to have 2 Oracle forms servers, not in a cluster, but on the same server using different ports. Also, we have a total of 4 servers (each with 2 forms servers and also with 2 reports servers as well).
Prateek Sachan
Aug 10, 2012 -
Last night we have applied a merge patch 14037368. I am going to keep a watch on the behaviour now. I am sure hang issues will be minimized but am still skeptical about FRM-92104 error
Tommy Yuen
Jan 4, 2013 -
It has been a while since you applied the patch. How was it? Any good?
My system showing FRM-92104 from time to time. Need a way out. Thanks.
prasanth vegesna
Sep 4, 2012 -
As said above graphics are not supported in forms 11g,is thier any work around to make the graphics work in oracle 11g.
Please let us know as we have encountered compilation problems while performing the migration.
Oracle Forms Info
Sep 5, 2012 -
Hi Prasanth ,
Graphics was actually not officially supported from version 9 of Oracle Forms. In this version of forms you could no longer develop NEW graphics for your applications BUT it did not have trouble compiling forms that had graphics. In Forms version 10g there was a way to run the existing Oracle graphics in your application in a client server way. But Oracle stated that the future was to convert all graphics to Java beans. They even supplied a demo of such in the Forms 10g demo pack that can be downloaded from OTN. From Forms 11g they have officially stopped supporting Oracle Graphics. All graphs and graphics code must be must be removed from the fmb or it will not compile. Today there are many graphic options to incorporate into your forms. Any graph java bean that exists can be embed in a form. But to get you started you can checkout these links:
http://www.oracle.com/technetwork/developer-tools/forms – Graph bean demo for 11g
http://forms.pjc.bean.over-blog.com/ – Java bean example website
http://www.oracle.com/technetwork/developer-tools/jdev/adf-dvt-graph-howto-082848.html – ADF graph beans
Good Luck!
If you are coming to Open World. I would be happy to discuss this with you further.
Mia
Ashwani
Oct 2, 2012 -
Hi,
We are migrating from 10g window based servers to 11g weblogic linux based server. I am able to compile the code successfully . My problem is when I am running one form, its throwing 06508 error , but I am not really not understanding why its throwing this error. Do you have some simple tools or utility to migrate form to 11g…
Thanks in Advance
Ashwani
Oracle Forms Info
Oct 2, 2012 -
Hi Ashwani,
The error 6508 means that the Forms is not able to find one of its PLL’s library code at runtime.
This usually is a problem with the Forms_path environment variable.
There are several tools that can be used to facilitate the migration to 11g process. The most common one is PITSS (www.pitss.com) it can generally help facilitate the migration process but to be honest the error you are getting would still occur if you use an automatic tool since the environment at runtime will still need to be configured. You can see my post on how to install 11g for details.
Good Luck,
Mia
Ashwani
Oct 2, 2012 -
Hi Mia,
Thanks alot for your quick reply, ok I think this is problem with environement, I am new thats why, actually I set this variable just now while compiling the form as below
export FORMS_PATH=/ikea/ptagplus/pp100/bin
As all my forms and pll are at this path, but I am still getting the same error, should I recompile the libraries as well after setting this path. Or I need to set this path some where else… please help
//ashwani
Ashwani
Oct 9, 2012 -
Hi Mia,
I am still facing the same issue, Form_path is set I have checked in default.env. I put customised msg in form , then I found that its throwing error while calling one specific program unit….. but every thing seems ok with that program unit, Can you please help me on this….
J
Nov 20, 2012 -
HI!
What is the different between 10g and 11g by the memory usage? How many memory need the “base” 11g and the “base”10g system? Any how many memory need it by 10,20,…100 users?
Regards, Jani
Oracle Forms Info
Nov 20, 2012 -
Hi Jani,
It really depends on so many factors that this is not really something I can answer in a post.
To determine sizing one must know
1) What O/S you are running
2) What version
3) what are the system parameters CPU, Processor, RAM
4) About the Forms application – Are the fmb size large or small? Do Forms have multiple windows, canvases? Do they have many java beans? Graphical elements? Did they use design standards?
5) How many total users will be running the system? How many concurrent users will you have.
In any case I usually suggest installing an 11g r2 test server and deploy your application here then run load testing. If you want intformation about the performance improvement I got at one of my clients you can read about it here
Prateek Sachan
Nov 21, 2012 -
Jani,
The best way is to check what is the minimum requirement as per the installation guides and then size the environment (hardware resources) incrementally according to (1) load, (2) application type and (3) Application usage patterns which is best achieved by performing load tests.
Regards,
Prateek Sachan
ISS, NSEL, Noida, INDIA
+91-120-4031400 (Ext. 1765)
abdurrahman
Mar 25, 2013 -
hi,
only problem i am having as at now is that i was able to call the forms application in 11g.
1) i can not navigate from the front page to any other page.
2) i did a recompilation and got this error message
Compiling CENTERWINDOW.pll
Forms 11 (Form Compiler) Version 11.1.1.6.0 (Production)
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
PL/SQL Version 11.1.0.7.0 (Production)
Oracle Procedure Builder V11.1.1.6.0 – Production
Oracle Virtual Graphics System Version 11.1.1.6.0 (Production)
Oracle Multimedia Version 11.1.1.6.0 (Production)
Oracle Tools Integration Version 11.1.1.2.0 (Production)
Oracle Tools Common Area Version 11.1.1.6.0
Oracle CORE 11.1.0.7.0 Production
Compiling library CENTERWINDOW…
Invalidating Procedure Body SHOWWINDOW……
Invalidating Procedure Body CENTERWINDOW……
Compiling Procedure Body SHOWWINDOW……
ERROR 49 at line 9, column 20
bad bind variable ”
ERROR 49 at line 9, column 20
bad bind variable ”
ERROR 103 at line 9, column 21
Encountered the symbol “GLOBAL” when expecting one of the following:
. ( ) , * @ % & = – + at in is mod remainder not rem =>
or != or ~= >= <= and or like like2
like4 likec as between from using || indicator multiset
member submultiset
The symbol “.” was substituted for “GLOBAL” to continue.
ERROR 49 at line 10, column 20
bad bind variable ”
ERROR 103 at line 10, column 21
Encountered the symbol “GLOBAL” when expecting one of the following:
. ( ) , * @ % & = – + at in is mod remainder not rem =>
or != or ~= >= <= and or like like2
like4 likec as between from using || indicator multiset
member submultiset
The symbol “.” was substituted for “GLOBAL” to continue.
ERROR 0 at line 0, column 0
Automatic recompile of Procedure Body CENTERWINDOW failed
ERROR 49 at line 9, column 20
bad bind variable ”
ERROR 49 at line 9, column 20
bad bind variable ”
ERROR 103 at line 9, column 21
Encountered the symbol “GLOBAL” when expecting one of the following:
. ( ) , * @ % & = – + at in is mod remainder not rem =>
or != or ~= >= <= and or like like2
like4 likec as between from using || indicator multiset
member submultiset
The symbol “.” was substituted for “GLOBAL” to continue.
ERROR 49 at line 10, column 20
bad bind variable ”
ERROR 103 at line 10, column 21
Encountered the symbol “GLOBAL” when expecting one of the following:
. ( ) , * @ % & = – + at in is mod remainder not rem =>
or != or ~= >= <= and or like like2
like4 likec as between from using || indicator multiset
member submultiset
The symbol “.” was substituted for “GLOBAL” to continue.
ERROR 0 at line 0, column 0
Automatic recompile of Procedure Body CENTERWINDOW failed
ERROR 0 at line 3, column 3
Statement ignored
Compiling Procedure Body CENTERWINDOW……
ERROR 49 at line 9, column 20
bad bind variable ”
ERROR 49 at line 9, column 20
bad bind variable ”
ERROR 103 at line 9, column 21
Encountered the symbol “GLOBAL” when expecting one of the following:
. ( ) , * @ % & = – + at in is mod remainder not rem =>
or != or ~= >= <= and or like like2
like4 likec as between from using || indicator multiset
member submultiset
The symbol “.” was substituted for “GLOBAL” to continue.
ERROR 49 at line 10, column 20
bad bind variable ”
ERROR 103 at line 10, column 21
Encountered the symbol “GLOBAL” when expecting one of the following:
. ( ) , * @ % & = – + at in is mod remainder not rem =>
or != or ~= >= <= and or like like2
like4 likec as between from using || indicator multiset
member submultiset
The symbol “.” was substituted for “GLOBAL” to continue.
Closing library CENTERWINDOW…
Compilation errors on SHOWWINDOW:
PL/SQL ERROR 0 at line 3, column 3
Statement ignored
Failed to generate library.
FRM-30312: Failed to compile the library.
the procedure generating this error message is this
PROCEDURE CenterWindow(wind in varchar2) IS
mdi_H Number;
mdi_W Number;
f_H number;
f_W number;
wnd window:=find_window(wind);
BEGIN
mdi_H:=to_number(:Global.heigth);
mdi_W:=to_number(:Global.width);
f_H:=to_number(Get_Window_Property(wnd,HEIGHT));
f_W:=to_number(Get_Window_Property(wnd,WIDTH));
Set_Window_Property(wnd,Y_POS,(mdi_H-f_H)/2.0);
Set_Window_Property(wnd,X_POS,(mdi_W-f_W)/2.0);
END; please what can i do>
Aarif
May 14, 2013 -
Hi Mia,
Your information is wonderful provided related to forms.I am migrating form 6i to 11g..I’ve do all the configuration in default.env,formsweb,tnsnames,registry.dat..But main problem is it that when when I run a new form it display icons on the form but when I run a migrated form It is not able to show the icons while i configure /forms/java in the necessary and icons are displaying when i run a new form created in 11g..Kindly suggest me and mail me on my id…..
I really need it..
Regard
Muhd.Aarir
Oracle Forms Info
May 15, 2013 -
Hi Aarif,
Are you running the icons in a Jar file that is download using the archive parameter of the formsweb.cfg or as icon files?
If you have icon image files then you must check – What is the path to the icon files? Is that same icon path written in the registry.dat file?
Thanks,
Mia
Aarif Ahmad
May 16, 2013 -
Thanx mia 4 ur reply..ya i’ve checkd the path..the problm is only in migrated form that toolbar contains the iconic button and cudnt be displayed in the toolbar while wen i create a new form in 11g,it displays icons…..formsweb is co figured properly……
Oracle Forms Info
May 26, 2013 -
Are the icon files the same name?
Forms 11g is case sensitive for icon names.
Ashwani
Jun 3, 2013 -
Problem with JVM after deploying new JAR in Weblogic
Hi,
We have written new JAR, imported into oracle forms and deployed on the server, But we are facing problem right now like when ever we are trying to hit JAVA code functionality, JVM is going down and its throwing “Cannot communicate with JVM Controller” error. We have already tried with memory increase option for JVM… do you any suggestions.
can you help me, if any body have seen such error.
//ashwani
Sreepathi das (@sreepathidas)
Aug 27, 2013 -
Hi Mia ,
We had migrated around 600 Forms and reports from Forms 9i to 11g this week.
Now we are having some problem with Virtual Directory.
In 9i we generate all our reports (pdf / html) into a directory something like d:repdir and we create a virtual directory for this and we were able to open the document by mentioning the virtual directory name.
We are unable to create the same virtual directory in 11g R2.
Can you please help us?
Oracle Forms Info
Aug 27, 2013 -
Sure just checkout my post
http://oracleformsinfo.com/2013/08/27/adding-a-virtual-directory-alias-in-oracle-form-11g/
Good Luck
Sreepathi das (@sreepathidas)
Aug 28, 2013 -
Thanks Mia ,
Its working.
In 10g, virtual directories are accessed like
http://localhost:8889/forms/vir_dir/filename.html
but in 11g, the address is entirely different.
we need to use http server port and no need to go through forms.
http://localhost:8888/vir_dir/filename.html
karst333
Nov 19, 2013 -
Which software are you using for load testing?
Rakesh
Dec 8, 2013 -
Hi Mia,
I am new to forms. I have installed Weblogic server and forms 11g on my laptop(64bit).
Followed the procedure and configured forms and reports 11g as you mentioned in your document.
I have created a simple test form, compiled it successfully, but unable to run it. I am getting this error:
FRM-10142: HTTP listener is not running on at port 7001. Please start the listener or check your runtime preferences.
Could you please help me resolving this issue.
Thanks,
Rakesh
Akın Özer
Jan 17, 2014 -
Hi,
I’ll ask you a question.What kind of oracle forms clusters are the advantages and disadvantages?
Thank you for your answers.
Oracle Forms Info
Jan 28, 2014 -
Actually, there is a new white paper discussing Oracle Traffic Director which is a load balancer for Oracle Forms. This would probably be the most effective way to do load balancing for Oracle Forms systems. Good Luck!
Here is the link to the white paper:
http://www.oracle.com/ocom/groups/public/@otn/documents/webcontent/2104634.pdf
joao
Feb 20, 2014 -
hello and thanks for sharing your tips.
how did you did the tests that reach the 250 licences? Did you used any special software?
Oracle Forms Info
Feb 26, 2014 -
There are a few options for testing Oracle Forms mainly based on your price point. If this is of interest I can send you a short list and the plus and minus of each to email
Moustafa
May 4, 2014 -
I am interested to get list of tools that might be used to conduct performance testing for oracle forms.
Oracle Forms Info
May 6, 2014 -
Hi Moustafa,
Lets take this offline.
Please contact me at [email protected] to discuss.
Mia
Rakesh
Mar 6, 2014 -
Hi Mia,
We migrated to Oracle Forms 11g from 10g. I have installed Oracle Forms 11g in a VM application server(production server) in a development mode. Migrated all the forms to the new server and compiled them. Trying to start weblogic admin server as a windows service, but unable to do so. Can you please advice?
Thanks,
Rakesh
Oracle Forms Info
Mar 7, 2014 -
Hi Rakesh,
This is a good topic for a blog post someday but you can checkout this Oracle Support note.
NOTE:1060058.1 – How to Install MS Windows Services For FMW 11g WebLogic Domain Admin and Managed Servers
Ted martin
Mar 12, 2014 -
This weblog post has helped address my concerns about our current “Oracle 11g” upgrade/migration project. We were actually told by a third-party company that we needed to use their proprietary Forms upgrade product to get to 11g; I was able to convince the decision-makers to at least wait until we had a running version of Forms 11g and tried our own “recompile”
Disclosure: I started working with “Oracle Forms” in 1987 in London England – when I was sent on training, the training material still referred to IAD (SQL*Forms developer) and IAP (might be wrong on that one…been a long time). This is about when Oracle decided to brand it as “SQL*Forms”. This was when DEC VAX/VMS was big and Oracle themselves built everything on VMS (the sql*plus set commands are all based on how VMS worked…e.g. SET VERIFY ON/OFF was a VMS command to let you show or disable display of variable replacements in the next command or DCL script.)
Anyway, thanks and I have shared this with my Boss as well as your recent ODTUG info.
Ted
Michael Ferrante
Mar 13, 2014 -
Ted,
First, I want to say “Thank you” for being a loyal Oracle Forms user for all these years. I am convinced that it has been our loyal following that has kept the product a valuable family member for so long. We hope to keep it in the family for many more years.
Second, let me apologize in advance for the wordy posting that will follow below. I think this information might be helpful to some of you.
Regarding your comment about a third-party telling you that you “NEEDED” to use their product to upgrade, well all I can say to that is, hmmmm. I can only hope that you misunderstood what they were suggesting. I can tell you that Oracle Forms would not have been so successful over the years if we required our customers to go out and purchase someone else’s product in order to upgrade. That said, there are some third-party companies with great utilities for make upgrading even easier than it already is. As with all cases, how difficult upgrading will be depends on many factors. Here are just a few examples:
1. What version do you currently have and to which version are you upgrading? The larger the difference in versions between the two, the more work it will be on your part. This is one reason why we encourage you to always be no further back than the current version -1. Of course having you on the latest is preferred for many reasons I won’t go into here.
2. What is your level of knowledge with Oracle Forms? If you are new to Forms and have been tasked with upgrading (this is just an example) Forms 3 to Forms 11, well this might be an interesting learning exercise for you. However, if you are a seasoned Oracle Forms user and you are tasked with moving from v10 to 11, you can probably have this done in a minimal amount of time.
3. Does your current Forms application run in a browser? If not, there may be some extra steps for you. Moving from character mode or client/server requires additional steps because several of the character or client/server features do not have context in a web environment. It is very important (very) that people upgrading from versions 6.0.8 and older, read (yes I said read) the “Upgrading Guide for Oracle Forms 6i to Oracle Forms 11g” before starting. Reading it after you start won’t help much 😉
http://docs.oracle.com/cd/E24269_01/doc.11120/e24478/toc.htm
4. And so on….
My point is that in ALL cases, the only utilities that is required is your own brain and possibly your ability to read a document.
Please do not mention any names here, but I would be interested in knowing who the third-party was that told you their utility/product was required. Feel free to contact me via email if you agree to share.
For anyone interested, the latest supported Forms version is 11.1.2.2 (as of this writing). Most older versions are no longer supported. Premier support for 11gRelease1 (11.1.1) ends this June.
As for what’s coming…. We have some really cool new features planned for the future versions of Oracle Forms. We are working tirelessly on the new version(s) in hope that we can deliver a more stable, more feature filled, improved performing, and more user friendly Oracle Forms. But most importantly, we hope to deliver a “familiar” Oracle Forms that you can upgrade to just as easy as ever before – “recompile and go”.
Michael Ferrante
Oracle Forms Product Management
Follow me on Twitter @OracleFormsPM
Andy
Mar 20, 2014 -
Mia,
Thanks for the post, very encouraging.
Were the 700 forms all part of the same application, or multiple applications? If multiple applications, how many Weblogic Managed Servers do you have?
Are the 3 Forms servers going to be clustered, or each specific to their own applications, or components?
Thanks
Andy
Oracle Forms Info
Apr 1, 2014 -
Hi Andy,
They now have over 850 forms which are 3 subsystems but they are all interlinked so they have 1 managed server.
They had the 3 servers behind a load balancer so not officially clustered but the external load balancer did the trick. They have since expanded to 1300 users so they now have 5 production servers. All have duplicated versions of the Forms system. Feel free to contact me directly if you need any architecture advice.
Mia
Dean Thomas
Mar 26, 2014 -
Wondering if someone can help with a configuration issue during 10g-11g conversion. The issue is how the Forms menu and record status is displayed. It looks like a minor issue but due to the additional space it take up, it would require us to re-design several hundred forms if not resolved. please see image of the problem at http://biatech.com/test/Oracle_10_11_conversion.jpg Thanks in advance.
Oracle Forms Info
Mar 26, 2014 -
Hi Dean,
What is the value of the useSDI parameter in your Formsweb.cfg file?
This is what controls what window the menu should be on.
USESDI (Web Forms Runtime)
Description Use single document interface (SDI) system of window management during a Web Forms Runtime session. There is no multiple document interface (MDI) root window. MDI toolbars exist in parent windows and menus will be attached to each window. Calls to the FORMS_MDI_WINDOW constant returns NULL as the MDI window handle when usesdi=YES.
Dean Thomas
Mar 26, 2014 -
useSDI=yes, changed it to null solved my issue. thank you very much.
Oracle Forms Info
Apr 2, 2014 -
Happy to help
Dean Thomas
Mar 26, 2014 -
WOW, useSDI=yes and setting to null resolved my issue. A two week problem solved in 11 minutes.. Thanks so much.
Oracle Forms Info
Mar 26, 2014 -
Happy to help
Dean Thomas
Apr 11, 2014 -
Here is what I have working for Oracle 11g on Windows
Manual startup of ClassicDomain by calling the file startWebLogic.cmd
http://domain:7003/console gets me to Weblogic Console which works, Forms & Reports both work, but cant get to http://domain:7003/EM. I get a 404 error
Since forms and reports working, I decided to move on, next problem I’m running into is trying to create a windows service to start up the ClassicDomain, instead of having to manually click on the startWebLogic.cmd file and leaving that command window open. Got service to install called “beasvc_ClassicDomain_AdminServer” it starts up successfully. However I can only get to the http://domain:7003/console Weblogic Control Panel. Forms & Reports are not available and I get 404 error.
Below was the bat file used to create the service CreateService.bat
SETLOCAL
set DOMAIN_NAME=ClassicDomain
set USERDOMAIN_HOME=C:OracleMiddlewareuser_projectsdomainsClassicDomain
set SERVER_NAME=AdminServer
set WL_HOME=C:OracleMiddlewarewlserver_10.3
set WLS_USER=”USERNAME”
set WLS_PW=”PASSWORD”
set JAVA_VENDOR=Sun
set JAVA_HOME=c:Program FilesJavajdk1.7.0_45
set PRODUCTION_MODE=true
set MEM_ARGS=-Xms512m –Xmx512m
call “%WL_HOME%serverbininstallSvc.cmd”
ENDLOCAL
Oracle Forms Info
Apr 15, 2014 -
If you are looking to create services you must look at this note on Oracle support:
NOTE:1060058.1 – How to Install MS Windows Services For FMW 11g WebLogic Domain Admin and Managed Servers
Michel Turcot
May 9, 2014 -
Good afternoon Mia,
I hope this finds you well;
I cannot say how much your post has help me, from the ‘dummy’ page to the ‘shopping list’ page and now here.
Thank you also to the many who have supplied pertinent information to this important discussion.
That being said, i would like to address a comment made by Mr. Michael Ferrante in early march of this year…
”
My point is that in ALL cases, the only utilities that is required is your own brain and possibly your ability to read a document.
”
Mr. Ferrante, I am from Canada and you must understand that in a bilingual country, both at the provincial and the federal level, our applications must be translated, and the only document i can read and understand is the following…
Oracle enhancement requests…14155931 TranslationHub for Win 64 bits.
Please, in a proactive way let me know when i will be able to use 64bits Translation hub?…All of Canada’s 64 bitters must count on this.
Thank you and all the best for you Mia,
Michel
oracleformspm
May 13, 2014 -
Michel,
I’m not exactly sure I understand what my comment has to do with you needing Translation Hub. If I recall correctly, the context of the discussion was around what was needed to upgrade from Forms 10 to 11. My comment simply said that you should need nothing more than to regenerate with the v11 compiler. No change in code should be required in most cases. Simply regenerate and run.
To relate this to OTH, if you are already using v10 (as an example) and your application has been previously translated and is working correctly in v10, my expectation is that you have translated versions of each of your modules. These modules should simply need to be regenerated (as I previously mentioned) with the v11 compiler in order to run them in the v11 environment. There should be no need to run the modules through OTH again. The only reason, of which I am aware, that you might need to use OTH again would be if you have made application changes. However this would have nothing to do with the original discussion, which I recall to be “What is needed to upgrade from 10 to 11″.
Regarding OTH on 64bit Windows, this is already possible using the current version of OTH (available on Oracle Technology Network). Although OTH is a 32bit product, it will install and work on 64bit Windows. It does however require a 32bit installation of Oracle Forms of your target version (i.e. version 11.1.2).
Although not supported at this time, it is likely that if you are using version 11 of Forms you can convert your modules to XML and use a third party tool to perform your translations/conversions. This would eliminate the need for OTH. Keep in mind this is just speculation on my part, as I have not yet investigated whether or not this can be successfully accomplish. It does however seem very possible. Again, this method is currently not Oracle supported and should only be considered in cases where assistance from Support will not be needed for this operation.
Thank you for your feedback.
Michel Turcot
May 10, 2014 -
Good afternoon again Mia,
In my last post i should have mention…
Oracle Doc ID 1486409.1
instead of
Oracle enhancement requests…14155931
My mistake,
Regards,
Michel
Muhammad Rehan Qadri
May 20, 2014 -
We have recently upgraded to Oracle 11gR2 following your post and it almost worked as a charm except one issue for which I need your guidance.
After upgrading to 11gR2 outputs of our certain report in PDFs is getting jumbled up . I have followed the “BUG:16046595 – PDF OUTPUT GENERATED BY 11.1.2.1 ARE NOT CORRECT” Note [ID 1522543.1] but that is not applicable to 11.1.2.2 i.e. our report version. Same patch is probably not available for 11.1.2.2 on Windows [See Doc ID: 1625612.1]
Please advice for resolution as we are badly stuck on this issue only.
oracleformspm
May 20, 2014 -
A patch for Windows 32 is currently being assembled for Reports 11.1.2.2. If you need this patch or one for a different platform, I encourage you to contact Oracle Support with all the information so they can request your needs to the development team. If you feel that this is an urgent issue, then contacting Oracle Support will be your best way to getting a solution quickly.
Muhammad Rehan Qadri
May 22, 2014 -
Thanks. Just wanted to confirm that the problem do exist in 11.1.2.2. I’ve contacted Oracle Support with the issue but the diagnosis is not concluded yet i.e. executing the patch and issue resolved. Also wanted to connect with an experience person like you and get the idea how much time it takes to get the similar issue sorted out.
Thanks for the prompt response anyways.
Thomas
Apr 10, 2015 -
Oracle 11G DB needs to write a file onto the weblogic server sitting on a different machine.
l_file := utl_file.fopen( ‘Virtual Directory’, ‘some_file_name.txt’, ‘W’ );
utl_file.put_line( l_file, ‘Here is some text’ );
utl_file.fclose( l_file );
Virtual Dir works if its writing locally, but when changed to a shared folder with “full writes permission for everyone” across the network, I get this error.
ORA-29283: invalid file operation
ORA-06512: at “SYS.UTL_FILE”, line 536
ORA-29283: invalid file operation
ORA-06512: at “X_IMPS.testxls_17Y”, line 8
ORA-06512: at line 2
Checking the DB services, I see them running as Local System, I tried starting them up as a specific user, but then DB fails to start up.
Please help, thanks.
Mazhar Ehsan
Feb 9, 2015 -
Hi friends,
I have installed and configured weblogic 1.3.6 and Dev Suite 11g R2
on a Win 2008 Server R2 – 64 Bit
I am able to start Web Logic Admin Server and Web logic Server WLS-FORMS
Now I am trying to run my first form but the Run-Form-Debug and the Run-Form are not running the form on the web browser.
The web browser (I am using chrome) is throwing the following error:
——————————————————————————————-
This webpage is not available
The webpage at http://localhost:64149/0FnRww3uo4SiIouZTxiXINc5zOJSwJzWDSlz4WrvNnrNruka might be temporarily down or it may have moved permanently to a new web address.
Error code: ERR_ACCESS_DENIED
——————————————————————————————-
Note that the test form is running fine on http://:9001/forms/frmservlet
Please help. It is very disappointing not able to run a form after a huge exercise of installing all the required successfully.
Thanks in advance
Oracle Forms Info
Feb 10, 2015 -
Hi Mazhar,
If I understand you correctly, you wish to use the new server from your Forms builder buttons. You will need to go to the Forms developer menu to Edit -> Preferences and there it asks you for the URL of the server. Here you put the URL of the new server you have set up. It should then use this URL when running Forms from the builder.
Thanks,
Mia
Mazhar Ehsan
Feb 10, 2015 -
Hi Mia,
Thanks for your reply. Keep up the good blog.
The issue was resolved after I added the localhost and 127.0.0.1 as exceptions in Lan Settings -> Proxy Setting
There was no problem with the values in the Edit -> Preferences settings. They were setup correctly.
Dean
Apr 16, 2015 -
Oracle 11g Database needs to write a file to a “full permission” directory on the weblogic server located on a different machine.
CREATE OR REPLACE PROCEDURE schema.procname IS
l_file utl_file.file_type;
BEGIN
l_file := utl_file.fopen( ‘DEST_DIR’, ‘somefile.txt’, ‘W’ );
utl_file.put_line( l_file, ‘Here is some text’ );
utl_file.fclose( l_file );
END;
/
CREATE OR REPLACE DIRECTORY
DEST_DIR AS
‘\IP_ADDRESStemp_dir';
If the directory is local to the DB server, it works, but when its a network location it fails. I see that all Oracle DB services are running as Local System.
seo
Jul 2, 2015 -
Hello Web Admin, I noticed that your On-Page SEO is is missing a few factors, for one you do not use all three H tags in your post, also I notice that you are not using bold or italics properly in your SEO optimization. On-Page SEO means more now than ever since the new Google update: Panda. No longer are backlinks and simply pinging or sending out a RSS feed the key to getting Google PageRank or Alexa Rankings, You now NEED On-Page SEO. So what is good On-Page SEO?First your keyword must appear in the title.Then it must appear in the URL.You have to optimize your keyword and make sure that it has a nice keyword density of 3-5% in your article with relevant LSI (Latent Semantic Indexing). Then you should spread all H1,H2,H3 tags in your article.Your Keyword should appear in your first paragraph and in the last sentence of the page. You should have relevant usage of Bold and italics of your keyword.There should be one internal link to a page on your blog and you should have one image with an alt tag that has your keyword….wait there’s even more Now what if i told you there was a simple WordPress plugin that does all the On-Page SEO, and automatically for you? That’s right AUTOMATICALLY, just watch this 4minute video for more information at. Seo Plugin
Photo Booth Rental Virginia Beach
Jul 9, 2015 -
I really like what you guys are up too. This type of clever work and coverage! Keep up the good works guys I’ve added you guys to my personal blogroll.
Cheap Nike Free Run
Jul 11, 2015 -
Cheap Nike Free RunYou should also be working at increasing the force of
your jump. Cheap Nike Free Run
Cheap Nike Air MaxTwo hundred seventy miles (434 kilometers)north of the Kenai, on a hillside just west of Fairbanks, the Parks
Loop Stand appears to the unschooled eye to be thriving.
But Juday, who has worked in this grove of hundred foot
tall (30 meter tall) white spruce for 15 years, knows practically every tree’s biography and he
is concerned. Heavier, wetter snowfalls have broken off
branches and crowns. Cheap Nike Air Max
Drag Racing Hack
Jul 17, 2015 -
A really prime quality hack that twists the usual Pokémon components simply sufficient to keep the
sport refreshing.
Falcolmol
Jul 18, 2015 -
cialis 10 mg effectiveness sort by
http://cialis-withoutadoctorsprescriptions.com – cialis without a doctor’s prescription which is better cialis or cialis
cialis without a doctor’s prescription – info on cialis
cialis 10 mg 4 tablet it is currently
MillieVes
Jul 19, 2015 -
female viagra usage
http://viagra-withoutdoctorprescriptions.com – viagra without a doctor prescription viagra vs viagra prices gb.php?id=
viagra without a doctor prescription – buy viagra from a us certified pharmacy lowest prices
fake viagra
Darleen Choulnard
Jul 20, 2015 -
Quick Payday Loans No Faxing If you require very easy to get
Fast Quick Loans so that you can protect your wellbeing, then will allow you
to buy one quickly, efficiently along with complete confidence
Darleen Choulnard so it will not come being a surprise
if malaysia also ought to head for more restrictions to be sure the financial
and property markets continue to become sustainable.
Deepak
Sep 22, 2015 -
Hi Experts
I have oracle forms 6i installed on sun solaris,but I am planning to use Linux.So I need to upgrade 6i forms in solaris to 11g forms in Linux.
But instead of upgrading to forms 11g, can I upgrade forms to Oracle APEX. As migrating to oracle APEX seems very easy to me.
So please provide any kind of suggestion on this.