Install Oracle 12c forms & reports, database, weblogic server

Hi guys

Update 8th November 2019

Guys, I have different threads towards specific version of Weblogic 12c & Oracle Forms and Reports installation, configuration(s). Please refer the thread specific to the version of Weblogic & Oracle Forms & Reports that you are trying to install.

Update 23rd October 2016

I was trying to answer one of the comments and realized that my database schemas those were created during repo creation were with expired passwords and the “WebLogic Admin Server” will not start. So, you are advised to setup your 12c database with no password expiry, no complex passwords etc (as far you are using the environment for development)



If for some reasons you cannot update your Windows 10 box, minimum make sure that you have Visual C++ 2012 package installed, which will provide you the much needed “MSVCR110.dll”, without which the Apache HTTP server will not start on Windows. This workaround is not at all an excuse for not patching your Windows box using update services.

Update: 03rd June 2016

I’m revisiting few of the claims which were true during the early builds of Windows 10, however not anymore having the same issues with the latest build & after cumulative updates. My Windows 10 boxes run the following build with all updates in place.


I’ve enabled the IPV6 protocol by deleting the explicit key that I created under TCPIP6 parameters & once after restarting the boxes, was able to start all the weblogic services and OHS instance successfully. However, I have made the following change

Pointed all the servers, “Admin Server”, “WLS_FORMS” and “WLS_REPORTS” to the hostname, instead of leaving the listening address empty. Eg: rajesh-pc. As I mentioned and re-iterating, whole the exercises described are those worked in my lab environment. Any attempts to use them at a production environment could prove you WRONG and disastrous situations may arise by not following Oracle’s guidelines.

This time, I will try to explain how you can setup few 12c products for your testing and developing needs in Windows 10, Microsoft’s latest desktop operating system  (The same should be applicable for Windows 8.1 as well)

My scenario

  1. OS: Windows 10 64bit Professional
  2. Memory: 16gb
  3. Processor: i7
  4. Storage: Around 4.6 TB (4 Disks)

Software downloads required for the setup

  1. Oracle database 12c
  2. JDK
  3. Middleware aka Weblogic Server 12c
  4. Forms and reports 12c

You can download the above software packages from Oracle’s repositories

Why Oracle Database 12c?

Unfortunately, Weblogic server 12c doesn’t support database versions below, which will require an existing 11g R2 ( to be upgraded. This upgrade (patch, full installation) is only available for customers with valid support subscriptions, hence the best option available is installing Oracle 12c database in order to setup Weblogic 12c with Forms and Reports 12c

Part 1 – Oracle database 12c Installation

The software package you download will have 2 zip files & You must extract both the zip files to a single folder


For example, as you could see with the above image, I have two zip files for the Oracle database and have created a folder called “Installer”. I extracted  the 1st zip file inside the “Installer” folder (by pointing to the extract folder explicitly, else usually the unzip utility will create a folder within “Installer” with the zip filename. Make sure once after the extraction, under “Installer” folder, you have ONLY ONE folder called “database”


Now extract the 2nd zip file to “Installer” folder, and Windows will merge the folders and finally you should see within “database” folder items as listed below


Failing to follow the above will fail your attempts to install the database. You will see few images below those are due to extracting zip files into different folders

Execute the setup.exe


You don’t have Oracle support, so uncheck the “I wish to…” and smile at the warning that Oracle never forgets to display


Recently I realized that creating a database once after the Oracle software installation gives me more options to setup archive logs, automated backups etc. So I will proceed with “Install software Only” option


Add the languages you want to use with the database


Oracle has a new approach with who starts the Oracle software in Windows environments and I think it is better to have a dedicated user to start the Oracle services, which provides better security. I created a user called “Oracle” and my password is:


Old fashioned, I prefer the database installation path to start with “Oracle”, hence I chose “D:\Oracle” for the installation. You can accept the default and proceed with the installation


Now, comes the errors related to “missing” files, which are due to the wrong extraction method I have mentioned by the beginning of this post. You get a number of read errors for files with strange names…


Once you extracted the files as suggested into a single folder, the Oracle database software installation should progress without giving any kind of errors, keep accepting the JAVA security prompts


Very easy, no hacking at all involved with the installation. Usually a novice (and ME) could get confused reading Oracle’s documents asking the user to extract the zip files to a single folder ;)

Once the software installed, use DBCA to create a new database.

Update Part 1a (1st of March 2017)

Sorry guys, I started getting couple of inquiries about the database parameters for repository database used by 12c Middleware & as I followed multiple documents to setup my environment, didn’t feel that I should exclusively add the database parameterization with my initial post. So, I am adding it with the post for your references


“Oracle” strongly suggests that the repository for Middleware should have “AL32UTF8” as the character set. Hence, while creating the database, please make sure you select the same for your repo database. If you are migrating a legacy application that has issues with this particular character set, I suggest you create a smaller size database exclusively for the Middleware repo and create another database for your application that uses a different character set.

Part 2 – JDK Installation

Download and install JDK 8 (Preferably to a folder like C:\Java, D:\JDK) etc. Shortest the path will help you to easily configure many things at later stages. If you have earlier versions of JRE for some specific reasons, deselect JRE from the feature listing


Part 3 – Weblogic 12c Installation

Once again, Weblogic 12c doesn’t require any specific hacks for installation in Windows 10. Switch to the folder from command prompt where you downloaded “fmw_12.” and call java to install the package. Please check the below image for details

(I’m leaving the images untouched, so that you will able to see possible errors we can make while typing in commands)


As usual you will skip the updates


Structuring Oracle Home is going to be a logical call, if you are familiar with Oracle’s suggested folder structure, go with it. Usually I install Weblogic in a folder like C:\Weblogic or D:\Weblogic


Now select the first option, Fusion Middleware Infrastructure


Skip the below, and the installation should be completing within few minutes time without making any errors.


Part 4 – Forms & Reports 12c Installation

Forms 12c allows a stand-alone installation, however, our requirement is to deploy applications through weblogic server. Hence we will be doing the standard installation processes facilitating the application deployments.


As usual We will skip auto updates


Make sure you select the same folder where you installed WebLogic server for “Oracle Home”


Select Forms and reports deployment


It could take a while until the installation is completed. Usually the total installation process never errors out. I hope the same for you also :)


Part 5 – Create a REPO(?!)

As I mentioned earlier, I am not a Weblogic geek, Oracle says a database repo is required for Weblogic 12c, so I created one as per their instructions & I suggest you better do that as well ;)

Browse to your “D:\Weblogic\Middleware\Oracle_Home\oracle_common\bin” folder and execute rcu.bat file as “Administrator”


The creation of repo is pretty straight forward


Make sure your database & listener services already started and you can TNSPING, connect to the instance using SQL etc, to insure that the repo creation will NOT fail

Fill in your database instance details (Service name, host name, PORT etc)


If the utility could establish a connection to the database, you will be taken to rest of the configurations in next steps.


By default when you are trying to create your 1st repository (for each new domain, you must create a new repo, there were claims that someone managed to use the same repo with his 2nd domain as well, however, 1st domain being offline) You will be offered to create a new prefix, by default ‘DEV’. You can change it to JON, MARTA or PROD according to your requirement. Just make sure that you note it down or remember it while configuring your forms and reports instance at later stages

Select the components as seen with the image below (The selected are mandatory to configure forms & reports domains)


Use a single password for all the schemas those will be created as a part of the repo creation. I have used the same password across 12c products. For a lab, it is okay, however when you are deploying the solution for production environment, follow the recommendations for passwords. I created a password like “Abcprod123”, it has CAPITAL letter, lowercase letters & numbers


That’s all, you have created a new repo for your new domain that you will create later.

Part 6 – Configure your forms & reports domain.

Most important

Make sure your PATH environment variable has your JDK\bin folder as the first value, else you will NEVER manage to get your forms and reports builders configured properly, Oracle has made sure of it ;)

Check the below images and cross check your computer’s PATH value


You can start the “config.cmd” either from the start menu or from the “D:\Weblogic\Middleware\Oracle_Home\oracle_common\common\bin” folder (Please change the path according to your installation preferences, for example I opted “D:\WebLogic” for my WebLogic server installation and rest of the paths were created automatically during the installation process)


Select the default “Create a new domain”. You will see that “base_domain” folder is selected by default, which you can change according to your requirement.


Select the component for your domain (Select all the components listed with the image below)


You will be provided a window showing your current domain name, physical location etc


Leave the Weblogic account name as “weblogic” & supply an Alpha Numeric password for the account


Select Production & keep the JDK pointed towards your specific JDK installation, which is automatically selected.


Now you have to supply the repo details you have created earlier. Make sure you are not making mistakes with supplying the details & click “Get RCU Configuration”


You can proceed to next level only once after populating the RCU Configurations, if errors you will not able to proceed


Make sure all the listed elements hare having same Service, HOST, PORT names and the password columns are automatically filled. If any one of the listed row has different value, cancel the installation. It means you made some mistakes while creating the repo.


Once the repo connectivity confirmed, you will be provided a number of components those you could configure as the part of the forms & reports configuration.

Select the components as shown with the image below


Accept the defaults for Administration Server


Next screen you should be shown two components


Accept the defaults


You need to add the “AdminServer” from the left pan “Servers” to the node under “Machines”


This page, as we select OHS as a component, you should add one OHS instance using the Add Button and give it a meaningful name like “ohs1” or “ohs_1”. Make sure the Component Type is “OHS”


You may enter localhost as Listen address for the ohs instance in the next page.


Now add the “ohs1” component from the “System Components” to “Machines” Node


Click the “Create” button to start configuring the forms & reports domain


Once the configuration is over, you will be provided a confirmation screen as seen below. Don’t close this window. We need to perform few more stuffs prior finishing the configuration, said you can close this window by clicking the “Finish” button, just make sure that you have copied the URL, and the foot note shown by the bottom of the window. That note clearly asks you to execute a specific command using WebLogic Scripting Tool, for OHS


Start the node manager from your newly created domain\bin folder (Check the below image for details)


Now, you need to start the weblogic server. When prompted, supply your weblogic username and password


Logon to the WebLogic Admin server console and start the WLS_FORMS & WLS_REPORTS servers, this will trigger setting up much of the start menu components for your installed products, else missing.

Keep monitoring the weblogic server window, Once the server enters into RUNNING mode, you will notice that items are getting added to “Oracle FMW 12c Domain -base_domain” Start Menu folder.


Now you have to start the Weblogic scripting tool & run the instructions provided with the last Window of forms and reports configuration


Please see the below image(s) for details


OHS instance should get activated and updated without any issues by the end of the process.

Now you can close the last window of forms & reports configuration and access Weblogic console & Enterprise Manager through the following URL(s)

http://localhost:7001/console & http://localhost:7001/em


You can use the EM console to start your OHS instance (OPMN depreciated) as well. Once started, the OHS instance will be configured to start automatically.

Now We will create the Node Manager Service for Windows. Please check the below image for details


I’ve used “NSSM – the Non-Sucking Service Manager” to create the Weblogic Admin Server Service. You can download NSSM from here. Issue a command like nssm.exe install “WebLogic Admin Server” will popup a GUI where you can select the “….\Oracle_Home\user_projects\domains\base_domain\bin\startWebLogic.cmd” as the executable for the service.


Now, we will configure the last element in this configuration section, Reports Tools instance so that you can start using the report developer 12c. From Weblogic Scripting Tool Console, you can create a new tool instance. Please refer the below image for details.


Restart the WLS_REPORTS server using Weblogic Admin console and the reports tool will be configured once after the WLS_REPORTS enters RUNNING status

While the Forms developer could be invoked from the Start Menu folder “Oracle FMW 12c Domain -base_domain”, calling reports builder is pretty awkward. You have to browse to “…\Oracle_Home\user_projects\domains\base_domain\reports\bin\” and execute the batch file “rwbuilder.bat”. Better, you create a shortcut for the batch file on your desktop.

So, that concludes the 1st level installation and configuration of 12c database, WebLogic, forms & reports. I will get back to the thread, with details about how to configure forms and reports elements and deploy modules at a later time.

Updated 8th November 2019

I just realized that I never linked the configurations thread with this post and doing it right now. You can access the thread that explains how to setup/configure Weblogic Classic Domain for deploying Oracle Forms & Reports application through the below link

Configure Classic Domain for deploying Oracle Forms & Reports Applications

Hope you will find the above useful for your 12c installation attempts

for Windows7bugs


33 thoughts on “Install Oracle 12c forms & reports, database, weblogic server

  1. Puranjit Lodh

    Very Useful. If we want to breakup the installation on two machines. Like Oracle database 12c on one and Weblogic Server and Oracle forms & reports on the other, where we have to make the adjustment so that Forms and Reports can communicate with database on other machine?

    1. Hello Puranjit
      My earlier reply was quite short, sorry for that. Actually I was kinda busy with some stuffs. If you are familiar with Weblogic 10.3.6, 12c didn’t change much, other than increased complexities to get it configured.
      It is always advisable to have the database running from a different server, that’s how you reduce the clutter. Just make sure that you have both server’s host files having entries for each other, do ping to insure that both machines respond to each other.
      Once you confirmed the connectivity, all you need to do is to either copy the tnsnames.ora file from the database server to Weblogic’s tns location or editing the existing tnsnames.ora and adding the entries manually. Though IPV6 is getting adapted and Oracle confirms 12c has better IPV6 handling, I will suggest you disabling the IPV6 on both servers, cleaning DNS servers by removing the IPV6 entries for the servers prior deploying applications. I’ve came across multiple situations when the weblogic server fail to start WLS_FORMS and WLS_REPORTS services failing to start due to IPV6, mainly after a restart.
      OPMN is depreciated with 12c, hence don’t miss the OHS instance part :). Do ping me in case if you hit a brick wall. I will see how I can help



  2. Hi Rajesh

    I Installed oracle 12c on My laptop Windows 10 64 Bit with8 Gb Ram.

    When I am trying to install From and Reports , Screen appears and immediate after 1 min clean-up appears and close the screen. I tried many a times but unable to Install it .

    Is oracle 12 Forms and reports are compatible with Windows 10 64 Operating System


    1. Hello Sanjay
      The total installation procedures listed with the post are strictly for Windows 10 64Bit OS. The few possibilities I see in your case are:
      Existing Oracle inventory information for previous failed attempts, and the installer is rolling back. Identify the installation inventory, delete it and try to re-install Oracle forms and reports
      Possibility of a corrupt download installation package. Download again and try.
      If the both above didn’t resolve, I will suggest you to do a factory reset for Windows 10 from “PC setting” and give it another try. Please be aware, when you do a factory reset, your installed software will be discarded and Windows 10 will as good as a fresh install.



  3. Marcelo

    Hello, I excuse my English :) I am using a translator .

    I followed your every step and I got up the server but when you get up in the MS server = > OHS1 mistake and not shoot me started.

    open missed a step in configuring the server http ohs ?

    thanks for everything.

    1. Hello Marcelo
      Updated: 25th October 2016
      The main reason for OHS instance not starting on Windows 8/10 OS could be due to missing Visual C++ 2012 package. Please make sure that you have the latest Windows OS patches installed. Please refer the beginning of the post to understand the effects of missing C++ package in details.

      The most common error I have experienced with OHS1 start was due to node manager. Please try the following:
      If you have created node manager windows service, DELETE the service after stopping it.
      Start the node manager service from an elevated CMD prompt
      Open another CMD and start the OHS instance from the DOMAIN_HOME location
      eg: %DOMAIN_HOME%/bin/startComponent.bat ohs1

      If the above starts the ohs1 instance, the Windows service you have created using the suggestions with my POST should be the culprit. Please use the “NSSM – the Non-Sucking Service Manager” to recreate the node manager service once again.

      All the best


  4. Hi Marcelo

    It looks like node manager issue ONLY. Please try to start the node manager as I have recommended with my earlier comment. Please update me if you still have issues.


    1. Hello Marcelo

      As I mentioned with my earlier comments, it looks like you are having issues with node manager. Please stop the node manager windows service, start the manager using the .cmd file and try to start OHS instance. It should resolve your issues


  5. piks

    while creating domain getting the below error

    java.lang.Exception: CFGFWK-64038: The app-svc-name “wsm-pm” must have target. CFGFWK-64038: The app-svc-name “wsm-pm” must have target. CFGFWK-64038: Provide a valid target

    could you pls help

    1. Hey there
      Please provide me the complete details about the OS on which you are trying to setup 12c environment
      List of other issues you had while trying to install 12c components
      I may able to help you better having above said details.


  6. piks

    Hi Thanks

    That worked ,have redirected it to admin server.
    but could you please tell me how to give the Application server URL in run time preferences. i tried it by reset to default but not working.

  7. Balaji R

    I have installed the database, weblogic infrastructure,Oracle Forms & Reports.I am notable to install the repo as I am getting ora-12557error. Jugling around the Oracle Home is not working.
    Any Ideas.

  8. Balaji

    I get an error while trying to install the repository and not able to connect to the database since there are two homes.

    how did you over come this. Please help.

    1. Hello Balaji
      Please check whether the environment variable PATH has jdk installation location as first entry, followed by 12c home. Refer the image and confirm. I had some other installation once after the weblogic installation, so don’t get confused :)
      PATH variable

  9. Balaji Rayampettai

    Thanks, I have installed Infrastructure in a different machine. Was able to install Forms & Reports.. installed a RCU database. After configuring the Forms & Reports, the database connectivity is not working. Any ideas.

    thanks and regards,

    1. You have to copy the tnsnames.ora file from your database network/admin folder to your \user_projects\domains\base_domain\config\fmwconfig folder. For example, see my weblogic domain location “D:\Weblogic\user_projects\domains\base_domain\config\fmwconfig”
      You can setup TNS_ADMIN as environment variable as well, which may cause some unexpected complications. I suggest the simple copy of tnsnames.ora file to above said location. Try and let me know.

  10. Balaji

    Super, it works now, now the reports builder is not opening when click on it. How to make it work?
    I had to create short cut in the Programs Menu.

  11. Balaji Rayampettai


    please add the steps to do a test run of a simple test form to run on the applet..

    The formsweb.cfg is different from the version I am familiar with..
    I am familiar with 9iAS but this one is little confusing…

  12. Rama

    HI ,

    I am new to oracle Forms 12c.

    I have installed required softwares for Oracle 12c, & Oracle forms 12c.

    I have below settings in my system.


    Operating System: windows 8

    I have started Nodemanager, admin console then WLS_FRM managed server respectively.

    While I am starting Forms it is showing error ” FRM-10039 Unable to Startup the Form Builder. ”

    Please assist me to fix the issue.

    Please let me know if I have to provide more details.

    With Thanks In Advance


    1. Hello Rama, as you have mentioned NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15, is it for the repo database? Or the registry entry for Oracle environment? Please check your email, I will be asking you few specific questions & screen shots to assess the issue you have mentioned.

Leave a Reply

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