8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Oracle Forms and Reports Services 12c Configuration Notes


Peng Sun said...

Thanks for the useful article.
I confirmed that something different:
1. version of jacob: 1.18-M2
2. Sign jacob.jar with a Self Signed Certificate
Add Manifest Entries into Custom Jar Files;
Sign the jar file;
Export the Public Key Certificate;
Import the Public Key Certificate into the client JRE.
(Doc ID 1583119.1, 1596871.1, 2065434.1)

Jacob Madsen said...

Minor error: it's "formsweb.cfg", not "formsweb.conf"

Tim... said...

Hi Jacob.

Thanks for the feedback. Obviously my brain wasn't engaged. :) It's corrected now.

Cheers

Tim...

Mike said...

Good info, thanks!
At the bottom, for restarting OHS, I thought that opmnctl is not in 12c.

Mike said...

Are the jacob-project files required, or is this nice to have? I don't see this in Oracle's docs. Will it actually get used if I add it?

Tim... said...

Hi.

Whoops. Restart was wrong. I've corrected it. If you've seen my create domain guide you would have seen the real commands. :)

Forms works without jacob.jar, but if you want the Webutil functionality you need it.

Cheers

Tim...

Carlos V said...

Thanks a lot
This articule is very usefull

Martin said...

Theank you very much for this tutorial. I thought that it will be a huge problem to migrate from 11 to 12 but it looks quite similar. I let you know how my deplyment will be processed. You could describe the most differences between versions which are worth to emphasis.
The first impresson is to put RCU based on database and I am on the metalink how to resolve problems with changing passwords.

Tim... said...

Hi.

- Differences: Hardly anything.
- RCU: If you *never* overwrite your DB, putting it in the main DB is fine. If you ever refresh your Dev/Test DB using RMAN clones, you will overwrite the RCU data. In that case, the RCU must be in a little separate instance.

Cheers

Tim...

Marcin said...

So I figured out that whithout backup of your RCU data you are in trouble.
Because rcu script create only chemas and infrastructure and config.sh script put data into it.
So there is impossible to recreate RCU data without creating the new domain again.
Once more thank you for these articles about Oracle Application Middleware.

Marcin said...

In chapter Key Mappings
Is it ok the path:
$FR_INST/config/FormsComponent/forms/admin/resource/US/fmrweb.res ?
In my opion, it should be
$FR_INST/admin/resource/US/fmrweb.res

There is no directory $FR_INST/config
respectively:
$FR_INST/config/FRComponent/frcommon/guicommon/tk/admin/uifont.ali
shoud be
$FR_INST/guicommon/tk/admin

Marcin said...

Do you read (Doc ID 2070183.1), there is warning:
- IMPORTANT NOTE!!! 12c Forms (12.2.1.0.0) requires JACOB 1.18-M2. This the only supported version of jacob with 12.2.1.0.0 Forms.

Tim... said...

Hi.

If you look up the comments you will see this is already mentioned. When I get time I will work through the JACOB issue already raised and path issues you raised. I don't know when.

Cheers

Tim...

Tim... said...

Hi.

I've gone through a clean installation of 12.2.1.2 today. I think some of the paths have changed a little as they don't match what I had, or what was in 11g. I think I've gone through the lot now, including fixing some issues with JAR signing.

Cheers

Tim...

Marcin said...

RCU - form multiple developers
Do you know how to implement RCU on the developers worstations. Which database shoud they use?
Do I have to create completly different RCU only for developers whith different RCU prefix, or they shoud obtain access to my server RCU installaton?

Tim... said...

Hi.

Each installation will need its own RCU (unique prefix). They can't share. Since the prefix is unique, multiple can all reside in the same database if you want. If the RCU is lost, the installation is toast, so you need it somewhere safe.

Cheers

Tim...

Marcin said...

Example if I have 30 developers it gives 30x5(schemas)=150 extra schemas, 30x4(tablespaces=120 extra tablespaces. How to manage this infrastructure. Mabye I miss something and this solution is not so ridiculous as it looks like.
Cheers

Tim... said...

Hi.

First, Forms Building for 12c doesn't need a full installation. It can be installed in standalone mode, so you don't need an RCU for every developer.

https://oracle-base.com/articles/12c/standalone-forms-builder-12c-installation-on-windows-1221

Even if you did, they are small schemas (tablespaces), so I don't see why this is a problem.

Cheers

Tim...

Marcin said...

OK But I need also copile Reports. so the option Standalone Forms Builder is useless.

Marcin said...

Do you know Tim how to patch it. Separately or together, I mean Weblogic Server and Forms and Reports.
Now there is the new version 12.2.1.3 and I plan to patch it from 12.2.1.2, and documentation which I found is relevant to Forms Only.

Tim... said...

Hi.

I did a full install and migrated. I didn't "patch" the existing one. I suggest you check the documentation.

Cheers

Tim...

Tim... said...

Hi.

Then you need the repositories.

Cheers

Tim...

Marcin said...

Tim do you know something about putting Reports on the seperate host. How to do it? Is it neccessary to also install WLS infrastructure?

Tim... said...

Hi.

I've never set it up that way. We always have them on the same machine. I'm sure it's possible, but I'm not the person to ask about the setup. :)

The FRS Product Manager (Michael Ferrante) answers questions on the Oracle Forms Forum. He's the man to ask.

Cheers

Tim...

VC said...

Hi Tim,
Thanks a lot for your very useful articles.
Is it possible to migrate RCU schemas from one database to another?
Cheers
VC

Tim... said...

Hi.

I'm sure it is, but I've never done it. If you can't find the answer from Google I would raise a SR with Oracle Support to ask for guidance.

Cheers

Tim...

Otmane said...

thanks a lot for this ,guide.
I recently used it for a frech install, most of the job is done except some minor issue that i guess would be resolved after a little diggin.
thanks again

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.