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

Hi guys

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)

93a

Important:

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.

w10

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 11.2.0.4, which will require an existing 11g R2 (11.2.0.2) 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

dv12c1

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”

dv12c2

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

dv12c3

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

clip_image001

clip_image003

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

clip_image005

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

clip_image007clip_image009

Add the languages you want to use with the database

clip_image011clip_image013

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:

clip_image015

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

clip_image017clip_image019clip_image021

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…

clip_image023clip_image025clip_image027clip_image029clip_image031clip_image033clip_image035clip_image037

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

clip_image039clip_image041clip_image043

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.

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

j

j1

j2

j3

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.2.1.0.0_infrastructure.jar” 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)

w1

w2

As usual you will skip the updates

w3

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

w4

Now select the first option, Fusion Middleware Infrastructure

w5

w6

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

w7

w8

w9

w10

w11

w12

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.

1

2

3

4

As usual We will skip auto updates

5

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

6

Select Forms and reports deployment

7

8

9

10

11

12

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 :)

13

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”

1

The creation of repo is pretty straight forward

2

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)

3

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

4

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)

5

6

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

7

8

9

10

11

12

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

path

path1

You can start the “config.bat” 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)

1

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.

2

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

3

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

4

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

5

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

6

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”

7

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

8

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.

9

10

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

11

Accept the defaults for Administration Server

12

Next screen you should be shown two components

  1. WLS_FORM
  2. WLS_REPORTS

13

Accept the defaults

14

15

16

17

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

18

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”

19

20

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

21

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

22

23

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

24

25

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

26

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

27

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

28

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.

29

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

30

Please see the below image(s) for details

31

32

33

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

34

35

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

36

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.

37

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.

38

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.

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

for Windows7bugs

rajesh

18 Responses to Install Oracle 12c forms & reports, database, weblogic server

  1. Puranjit Lodh says:

    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?

    • windows7bugs says:

      Yes, You can setup the db in a machine and rest in another. Just add the TNS entries into your weblogic domains.

      regards,

    • windows7bugs says:

      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

      regards,

      rajesh

  2. […] A week back I posted the procedures tested at my end (I’m excusing myself with this statement because 12c total setup could be a painful experience and may NOT be successful for many, even after following line by line instructions) here […]

  3. 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

    sanjay

    • windows7bugs says:

      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.

      HTH

      Rajesh

  4. Marcelo says:

    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.

    • windows7bugs says:

      Hello Marcelo
      Greetings! From your comment, I guess that you have some issues starting the OHS1 instance. Can you please provide me a screenshot or log file?

      Thanks

    • windows7bugs says:

      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

      rajesh

  5. windows7bugs says:

    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.

    regards,
    rajesh

  6. Marcelo says:

    apology for having sent repeated several times mistake, now uploaded it to a file on a server.

    I get this error when I run the startcomponent.cmd

    http://www.filedropper.com/ohsnm

    Thanks

    • windows7bugs says:

      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

      regards,

  7. piks says:

    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

    • windows7bugs says:

      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.

      regards,

  8. piks says:

    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.

  9. piks says:

    oracle forms runtime preferences: tools->preferences->application server URL

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: