WebLogic 12c 12.2.1.3 Installation & configuring for forms & reports

Hi guys

Update: 13th February 2019

Downloading the installing Oracle software could be a challenging task at times, WebLogic 12c Forms & Reports installation is NOT very different Especially if you are as usual skipping the “read me” areas)

I will try to explain the download and extraction activities related Oracle forms and reports 12c below.

Visit https://www.oracle.com/technetwork/developer-tools/forms/downloads/index.html for downloading the installation media. There are two ZIP files for Oracle forms and reports. Download both of them.

Once the files are downloaded, you need to extract both the zip files into a single folder

1st ZIP archive extracts “setup_fmw_12.2.1.3.0_fr_win64.exe” & 2nd ZIP archive extracts “setup_fmw_12.2.1.3.0_fr_win64-2.zip”. During installation,
“setup_fmw_12.2.1.3.0_fr_win64.exe” expects
“setup_fmw_12.2.1.3.0_fr_win64-2.zip”, hence, do NOT extract
“setup_fmw_12.2.1.3.0_fr_win64-2.zip”. To make it simple, for Oracle installation, move the following files to a new folder, call it “Forms_Installer_12c”

D:\Forms_Installer_12c

and copy/move both
“setup_fmw_12.2.1.3.0_fr_win64.exe” & “setup_fmw_12.2.1.3.0_fr_win64-2.zip” to this folder. Less confusing this way :)

========

One of the posts that is doing great according to a blogger’s expectation is about WebLogic 12c installation & configuring it for deploying Oracle forms/reports based applications.

Well, I totally missed the fact that Oracle periodically updates their software & missed out the current version of WebLogic 12c 12.2.1.3. It didn’t even ring a single bell when someone asked me about an error that was happening during his attempts to get 12c installed, which was specific to 12.2.1.3.

My previous post about WebLogic 12c strictly deals with version 12.2.1.0.0 for the areas of creating a new repository for WebLogic infrastructure and configuring a user domain. There are minor changes with 12.2.1.3, and those changes sure require mentions.

Prerequisites

Oracle WebLogic 12c, Oracle forms and reports require Visual C++ verion 11 preinstalled. Although the installation would proceed after showing missing prerequisites, I will NOT suggest you to take unknown risks. If possible, make sure your box is completely updated with latest Microsoft patches for the specific operating system.

This time I will take the freedom to believe that you already have Oracle 12c database installed and avoid going through the database installation procedures.

As a thumb rule, install Java JDK 8, the latest version available in a folder like C:\java\jdk or C:\JDK or D:\Jdk (the shortest path name possible).

Switch to the folder where you have downloaded the software required for Weblogic 12.2.1.3 installation and configuration from an “elevated” command prompt.

Check the below image for details:

https://i0.wp.com/simpleoracle.com/wp-content/uploads/2018/05/11.png?resize=640%2C335&ssl=1
2
3

It looks like Oracle has finally realized that 99% of the public will opt skip updates, hence they made it as default this time ;)

4

By following the classic way of naming the installation folders, you save tremendous time & efforts to locate configuration files (Especially if you are following my posts). I always choose to install the weblogic stack on D:\Weblogic\Middleware\Oracle_Home. This helps me to setup the environment next time by keeping exact path information for configuration files etc.

5
6
7
8
9
10

Select “Fusion Middleware infrastructure” (Default)

That’s all folks, your Weblogic stack is installed & you are ready to go ahead with the installation of Oracle forms and reports 12c now.

11
12
13
14
15
16a
17
18
19
20
21

Basically you shouldn’t ignore the following “Warning” about Visual C++ element. I’ve found that Visual C++ causing serious issues with OHS instance starting during my previous attempts, hence make sure you install Visual C++ recommended version is installed in the machine.

The above installation(s) should be go all smoother than previous versions & now we can move to configuring our first domain using the latest WebLogic Stack installed.

Setup repository for the domain

Suggestion(s):

  1. I suggest you totally disabling the password expiry for the entire database that you will be using for your WebLogic lab (12c). Ignoring this element could land you in difficult situations in case if you are not meticulously maintaining the password changing routines.
  2. Always invoke scripts as administrator, this provides you the elevation on Windows 7 onward Windows OS

Execute rcu.bat from the following installation path. Please note, I have installed WebLogic software onD:\Weblogic\Middleware\Oracle_Home\oracle_common\bin folder (Which is the standard way I name the installation folder, this helps me to copy much of the elements between installations, upgrade processes), so I will be executing the “rcu.bat” file from “D:\Weblogic\Middleware\Oracle_Home\oracle_common\bin”. Adjust your path accordingly.

1
2

We will choose “System Load and Product Load” which is default for our repository as well. Please note, you should use the same “rcu.bat” for dropping the repositories, if you have to at later stages.

3

For all WebLogic labs, I suggest the same password for Database and WebLogic. You can go for simple passwords like “YourName123” which satisfies “most” of the implied complexity for passwords.

4
5

If you have entered the database credentials and other details correctly, the checking should be done within no time.

Now we will create the repository for our domain. Please note, the new profile name could be anything. Instead of “DEV” which is by default assigned by Oracle, you may choose your name in that place. Make sure you note down the name of the profile somewhere for future references. Select all the components as seen with the below image.

(Please note, I have copied the images from 12.2.1.4 installation and replaced few of the images with this post as one comment mentioned that I didn’t choose MetaData Services with the old image(s) provided, so please don’t get confused. Rest of the images provided may “miss” the metadata services related information & instead of “DEV”, you may see “DEV1” at places. Please ignore)

7a
8
9
10
11
12
13

Select same password for all schema.

I have the entire setup on a SSD, hence the time to create and configure the repo could be significantly much less than over a spinning drive system.

14

That completes our repository creation. Please make sure that you note down the repository name and the password(s) somewhere for future references.

Now we will create our 1st domain with our fresh Weblogic 12c 12.2.1.3 environment. Just make sure that the JDK installation path is the 1st entry in the PATH environment variable.

Invoke “config.cmd” file as administrator from “D:\Weblogic\Middleware\Oracle_common\common\bin” folder. Adjust the path according to your installation preferences.

1

We will create a new domain for the lab now. Leave the default domain location as suggested by Oracle. Change it ONLY if you know what you are doing at this point of time.

2

For Oracle Forms and reports, the below product selection is spanned over 3 different images. Make a list of the items selected, and make sure you don’t miss any of them before proceeding to next step.

3
3a
3b

Once all elements are selected for the domain, you can proceed.

4

As a standard approach, I am using the same password for the WebLogic Administrator account, leave the suggested administrator name as “weblogic”

5
6

We’ll go for production for Domain Mode. JDK location will be automatically picked. Do not change it, unless you have a valid reason.

Now we have to supply the repository details, those we have saved during the creation of repository. The details will be cross checked prior by the configuration tool. Once after supplying the details click the “Get RCU Configuration” button.

7
8
9
10

Once the repository validations done, it’s time to select the components for your domain. Make sure the checked elements are selected for your domain as well.

11

Do not miss to select “WSMPM-MAN-SVR” for the Server Groups, failing will FAIL the configuration of the domain. I don’t know what the heck it is, I may read about it one day and update myself. For now, I suggest you select the said group from the drop down list and proceed.

12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28

Failing to select the Server Groups will land you on this page, which you don’t want! Make sure you will do the “WSMPM-MAN-SVR” Selection for the Server Groups.

29

I corrected the error at my side by dropping the repository, recreating & configuring the domain once again.

30
31

So we have created a classic domain now. We need to setup an OHS instance and setup the domain for deploying our forms based applications now.

To configure the newly configured domain, you may use the 12.2.1.2 configuration instructions as posted here

Right now, you can use my previous posts about Install Weblogic 12c and setting up OHS, forms & reports for WebLogic 12c as reference materials to setup your new classic domain or wait for me to post a followup with version specific details.

  1. https://simpleoracle.com/2016/01/05/oracle-12c-database-weblogic-forms-reports/
  2. https://simpleoracle.com/2016/01/13/oracle-12c-forms-reports-configure-for-deployments/

Hope it helps few souls out there

regards,

rajesh

10 thoughts on “WebLogic 12c 12.2.1.3 Installation & configuring for forms & reports

  1. JCDV

    Hi. Where do I get the Oracle Forms and Reports installers?
    When I go to the Oracle “official” web site to download this (https://www.oracle.com/technetwork/developer-tools/forms/downloads/index.html) I don’t see any Oracle Forms and Reports installer.
    The main title says “Oracle Forms and Reports 12c (12.2.1.3.0)
    Released August 2017”, but the installers listed there are for Oracle Fusion Middleware.
    The installers downloaded says “Oracle Fusion Middleware 12c WebLogic Server and Coherence 12.2.1.3.0” when executed.
    Am I missing something?

  2. Hi,
    Very glad to find an article which tries to explain this tedious process .. Big thanks for the effort !! it is dearly apprieciated.
    During installation I encountered however one thing (up to know ;-) ):
    While configuring the forms domain the rcu schema’s are checked on existence and I get the MDS schema not to exist.
    I guess this is due to the not-selection of the MDS option in step 4 of 8 of the RCU utility where in the screenshot the MDS is not checked.
    I reran the RCU utility to drop the repository and recreate it, now with the MDS selection (why not installing them all ?) For this I had to quit the domain creation utility as the check for the RCU schema’s was blocking the removal of the Repository.
    As I was running the RCU creation and creation to be done as system db account, some grants had to be done via sys: Grant execute on dbms_job to xxxxx_mds (using sql developer for this along the creation of the schemas)
    Restarted the domain creation utility and now it founc neathly the MDS schema.
    Hope this helps.
    Greetings.

    1. Hello Tridas, actually I have 2 posts referring to WebLogic 12c installation. The 2nd POST is for a recent version of WebLogic, must be addressing the MDS schema part. With a minor versioning, Oracle has changed much with the installation requisites :)
      Thank you for your long and wonderful comment. I am sure few others will get benefitted by the same.

      regards,

  3. M.Bilal

    Dear Sir i have faced issue during installation Fusion middle ware forms and reports.
    Installation not take the location of oracle_home. Like my weblogicinstaled in “d:\oracle\middleware\oracle_home” but when i give this path an error is occoured as inst-07319 validation of oracle home location failed. The location specified already exists and is a nonempty directory and not a valid oracle home

    1. Hello Bilal, are you typing in the name or picking up from the shown location (drop down on mouse click)?
      Well, you see these kind of errors are specific to certain conditions.
      Do let me know whether you managed get ahead.

      Regards

  4. Juma

    Hi, i’m following all the steps but for some reasons in the JDBC Test the OWSM MDS Schema is falling, here the the Connection Result Log:

    Component Schema=LocalSvcTbl Schema
    Driver=oracle.jdbc.OracleDriver
    URL=jdbc:oracle:thin:@//localhost:1521/ORCLPDB
    User=DEV_STB
    Password=**********
    SQL Test=SELECT 1 FROM DUAL

    CFGFWK-64213: Test Successful!
    CFGFWK-64213: JDBC connection test was successful.
    CFGFWK-64213: No action required.

    Component Schema=WLS Schema
    Driver=oracle.jdbc.OracleDriver
    URL=jdbc:oracle:thin:@//localhost:1521/ORCLPDB
    User=DEV_WLS_RUNTIME
    Password=**********
    SQL Test=ISVALID

    CFGFWK-64213: Test Successful!
    CFGFWK-64213: JDBC connection test was successful.
    CFGFWK-64213: No action required.

    Component Schema=OWSM MDS Schema
    Driver=oracle.jdbc.OracleDriver
    URL=jdbc:oracle:thin:@//localhost:1521/ORCLPDB
    User=DEV_MDS
    Password=**********
    SQL Test=select 1 from schema_version_registry where owner = (select user from dual)
    and (mr_type=’MDS’ and version=’12.2.1.3.0′ or comp_id=’CONSOLIDATED’ and exists (select * from schema_version_registry where mr_type=’MDS’ and version=’12.2.1.3.0′
    and owner in (select unique(table_owner) from all_synonyms where owner=(select user from dual))))

    ORA-01017: invalid username/password; logon denied

    CFGFWK-64210: Test Failed!
    CFGFWK-64210: JDBC connection test failed.
    CFGFWK-64210: Check logs for more information.

    Component Schema=OPSS Audit Schema
    Driver=oracle.jdbc.OracleDriver
    URL=jdbc:oracle:thin:@//localhost:1521/ORCLPDB
    User=DEV_IAU_APPEND
    Password=**********
    SQL Test=ISVALID

    CFGFWK-64213: Test Successful!
    CFGFWK-64213: JDBC connection test was successful.
    CFGFWK-64213: No action required.

    Component Schema=OPSS Audit Viewer Schema
    Driver=oracle.jdbc.OracleDriver
    URL=jdbc:oracle:thin:@//localhost:1521/ORCLPDB
    User=DEV_IAU_VIEWER
    Password=**********
    SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type=’IAU_VIEWER’ and version like ‘12.2.1%’

    CFGFWK-64213: Test Successful!
    CFGFWK-64213: JDBC connection test was successful.
    CFGFWK-64213: No action required.

    Component Schema=OPSS Schema
    Driver=oracle.jdbc.OracleDriver
    URL=jdbc:oracle:thin:@//localhost:1521/ORCLPDB
    User=DEV_OPSS
    Password=**********
    SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type=’OPSS’ and version like ‘12.2.1%’

    CFGFWK-64213: Test Successful!
    CFGFWK-64213: JDBC connection test was successful.
    CFGFWK-64213: No action required.

    1. Hello Juma, it looks like your DEV_MDS account has a password mismatch with the WebLogic “saved” passwords. You should try to change the saved password with the one that is used. Check whether the below posts help you.
      1. https://windows7bugs.wordpress.com/2018/01/04/weblogic-12c-admin-server-will-not-start-ora-28001-ora-28000/

      Just browse for topics with “WebLogic database password expired” or with the specific errors mentioned with the log file. Make sure your google searches contain “WebLogic 12c” keyword.
      All the best

Leave a Reply to windows7bugsCancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.