No post should look good, started with a statement asking the visitor to move on because “There is nothing much to see here”. Trust me, if you already referred my previous post(s) for Oracle Forms & Reports 12.2.1.4, then there is nothing new I have for you in this post. As I don’t have much to offer other than what I have already did through my previous post, let us see how we can insure your fresh attempt to get this whole complex stack installed & configured successfully on your computer.
Are you excited? Don’t be. Oracle has released the much waited Windows version for their Oracle Forms & Reports couple of days back and I must say, I was super excited based on the promises given about the IDE improvements. For improvements what I could see what line numbers inside PL/SQL editor.
Software Requirements
Side note before anything else. Please note, you must install software from the same architecture. Said, if you install JDK 32-Bit and expect your 64-Bit Weblogic to work properly, that is not going to happen. Hence insure all the software you download and install belong to the same architecture.
Microsoft Visual C++ Redistributable packages (Specific to Weblogic 12.2)
and for Oracle Forms 12.2.1.19, you have to install Visual Studio 2017 VC++ compoments.
Before you start the installation, let’s do a checklist
Is your Windows machine updated with latest patches for OS and .Net?
Do you have a static IP address for your computer/laptop?
What is the name of your computer? does it looks like some random letters?
Have your read the installation document? :) nobody does it right?
Legal, cracked, pirated… OS comes in different flavors & nothing can stop it. However, keeping your box up to date is your responsibility. Oracle is a very complex technology, that depends upon many OS elements. A broken box will not get you anywhere.
Static IP address is 2nd most important element when you are installing a server software, that is WebLogic in our case. As this server has to be identified and reached by clients, a fixed IP address is a must, however not always possible when a user has limited infrastructure. Microsoft has provided “Microsoft Loopback” interface for such requirements. Please Google and find more about setting it up, if you are one of those users. Microsoft Loopback helps you to setup a static IP address, please note other computers in your network cannot reach your computer using this IP address or setup!
Name of your computer or HOST name. Much of the Computer/Laptop that you buy with Windows preinstalled come with some whacky names. You should change such names to something more meaningful like “JOHN-PC”,”XYZ” etecetra.
I didn’t either read installation manuals until recent times. I realized that, I could avoid hours or sometimes days long Googling merely by reading the instruction manuals.
Once you are done with Microsoft Visual Studio C++ redistributable package(s) installations, we can proceed. Please follow the below post that should take you through installation and setting up a classic weblogic domain, report server instance etc. I hope you will have least issues installating and configuring Oracle Forms & Reports following my post 🙏(Don’t get discouraged by the title of the referred post, as I stated in the beginning, there is nothing new HERE!). The one thing I want to warn you about the time that your computer might take to bring up the UI for the Oracle Forms & Reports installer. This could be nothing less that 7-8 minutes, much more depending upon your hardware resources.
Two days back I’ve seen a tweet from Michael Ferrante asking the “Forms Enthusiasts” to hold their breathe, as Oracle is going to announce something “Exciting” for Oracle forms. Are you EXCITED as much I am? Well, I am pretty sure, it is going to be a push for AuraPlayer, as he has mentioned them in the tweet.
Regardless, I’ve a local instance of Weblogic Server 12.2.1.3, installed and a classic domain created. I stopped using it as my firm decided to drop the idea to migrate our 20+ years old Developer 6i developed ERP to Weblogic due to the complexity of Oracle licensing, followed by the uncertainty of Oracle support for Oracle forms beyond 2025 (Which is just 6 years away).
Hell with it, I wanted to see how far I have configured the domain and ended up setting up the forms server, publishing the half baked legacy application. As I have made more than dozen Weblogic installations in last 2-3 years time, I had almost everything backed up from different installations like configuration files, environment and registry files. All I needed was to copy and replace them at most of the places to bring the legacy application online within couple of hours time.
However, I have noticed that while starting the Weblogic Admin Server (from the command prompt, using supplied .cmd files), I was getting a number of java errors & all of them were related to FADS (Forms Application Development Services) & some text were like below (Sorry for the wrapping issues)
weblogic.application.library.LibraryDeploymentException: [J2EE:160141] Could not initialize the library Extension-Name: fads-dbtools-library. Ensure that the deployment unit is a valid library type (WAR, EJB, EAR, plain JAR). D:\Weblogic\Middleware\Oracle_Home\forms..\sqldeveloper\sqldeveloper\lib\oracle.dbtools-common.jar (The system cannot find the file specified) with : D:\Weblogic\Middleware\Oracle_Home\forms..\sqldeveloper\sqldeveloper\lib\oracle.dbtools-common.jar at weblogic.application.internal.library.LibraryDeploymentFactory.getLibData(LibraryDeploymentFactory.java:98) at weblogic.application.internal.library.LibraryDeploymentFactory.createDeployment(LibraryDeploymentFactory.java:50) at weblogic.application.internal.DeploymentManagerImpl.createDeployment(DeploymentManagerImpl.java:195) at weblogic.application.internal.DeploymentManagerImpl.access$800(DeploymentManagerImpl.java:61) at weblogic.application.internal.DeploymentManagerImpl$DeploymentCreatorImpl.createDeployment(DeploymentManagerImpl.java:628) Truncated. see log file for complete stacktrace
weblogic.application.internal.DeploymentStateChecker$DeploymentAssertionError: Unexpected transition: current state for application fads#1.0 : STATE_NEW attempt to transition to STATE_ADMIN Dumping 2 callbacks ———————- BEGIN CALLBACK DUMP ——- java.lang.Exception: prepare at weblogic.application.internal.DeploymentStateChecker.save(DeploymentStateChecker.java:152) at weblogic.application.internal.DeploymentStateChecker.prepare(DeploymentStateChecker.java:157) at weblogic.deploy.internal.targetserver.AppContainerInvoker.prepare(AppContainerInvoker.java:65) at weblogic.deploy.internal.targetserver.AppDeployment.prepare(AppDeployment.java:166) at weblogic.management.deploy.internal.DeploymentAdapter$1.doPrepare(DeploymentAdapter.java:41) at weblogic.management.deploy.internal.DeploymentAdapter.prepare(DeploymentAdapter.java:193) at weblogic.management.deploy.internal.AppTransition$1.transitionApp(AppTransition.java:31) at weblogic.management.deploy.internal.ConfiguredDeployments$2.doItem(ConfiguredDeployments.java:741) at weblogic.management.deploy.internal.parallel.BucketInvoker$2.run(BucketInvoker.java:95) at weblogic.work.ContextWrap.run(ContextWrap.java:46) at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:670) at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352) at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337) at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57) at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41) at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:644) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:415) at weblogic.work.ExecuteThread.run(ExecuteThread.java:355) java.lang.Exception: activate at weblogic.application.internal.DeploymentStateChecker.save(DeploymentStateChecker.java:152) at weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:164) at weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:90) at weblogic.deploy.internal.targetserver.BasicDeployment.activate(BasicDeployment.java:274) at weblogic.deploy.internal.targetserver.BasicDeployment.activateFromServerLifecycle(BasicDeployment.java:507) at weblogic.management.deploy.internal.DeploymentAdapter$1.doActivate(DeploymentAdapter.java:53) at weblogic.management.deploy.internal.DeploymentAdapter.activate(DeploymentAdapter.java:202) at weblogic.management.deploy.internal.AppTransition$2.transitionApp(AppTransition.java:52) at weblogic.management.deploy.internal.ConfiguredDeployments$2.doItem(ConfiguredDeployments.java:741) at weblogic.management.deploy.internal.parallel.BucketInvoker$2.run(BucketInvoker.java:95) at weblogic.work.ContextWrap.run(ContextWrap.java:46) at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:670) at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352) at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337) at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57) at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41) at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:644) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:415) at weblogic.work.ExecuteThread.run(ExecuteThread.java:355) ———————- END CALLBACK DUMP ——- at weblogic.application.internal.DeploymentStateChecker.throwAssertion(DeploymentStateChecker.java:88) at weblogic.application.internal.DeploymentStateChecker.illegal(DeploymentStateChecker.java:107) at weblogic.application.internal.DeploymentStateChecker.up(DeploymentStateChecker.java:122) at weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:166) at weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:90) Truncated. see log file for complete stacktrace
Basically, these errors NEVER truly interrupt anything with deploying a forms based application, unless you want to do more with FADS. FADS deployment looks for some specific libraries and missing them were generating the above errors. As I mentioned, for a classic domain, addressing this error may not be truly necessary (for testing). I just love NO errors under usual scenarios, hence decided to fix it.
I referred the below documents to find a proper solution
The 1st document insists that we must delete/rename the pre-installed SQLDEVELOPER (3.x) under ORACLE_HOME (eg: D:\Weblogic\Middleware\Oracle_Home) & install a version that is minimum 4.2, however doesn’t mention anything about the highest version supported.
After checking the fads configuration py file, I realized that the files FADS deployment trying to locate during the startup were NOT available with SQLDEVELOPER 18.x:
The 2nd document I referred explained about configuring FADS & the blogger used SQLDEVELOPER 17.2 for his exercise. Hence I downloaded the specific version 17.2, extracted and copied the folder “sqldeveloper” to ORACLE_HOME & followed the instructions as provided within the Oracle document.
Error while using SQLDEVELOPER 18.x
D:\Weblogic\Middleware\Oracle_Home\oracle_common\common\bin>wlst.cmd D:\Weblogic\Middleware\Oracle_Home\forms\fads\fads_config.py Picked up JAVA_TOOL_OPTIONS: -Djava.vendor=”Sun Microsystems Inc.” Initializing WebLogic Scripting Tool (WLST) … Welcome to WebLogic Server Administration Scripting Shell Type help() for help on available commands
fads configuration script Admin Server will be shutdown by running this script. Do you want to continue? [Y/n] :Y You need to install Oracle SQL Developer 4.2 or higher under ORACLE_HOME. Did you install SQL Developer 4.2? [Y/n] :Y error: SQL Developer 4.2 is not installed under D:\Weblogic\Middleware\Oracle_Home Install it and run this script again. Download Oracle Sql Developer from http://www.oracle.com. exiting… Problem invoking WLST – Traceback (innermost last): File “D:\Weblogic\Middleware\Oracle_Home\forms\fads\fads_config.py”, line 341, in ? File “D:\Weblogic\Middleware\Oracle_Home\forms\fads\fads_config.py”, line 207, in fullConfig NameError: system
Successful configuration using SQLDEVELOPER 17.x
D:\Weblogic\Middleware\Oracle_Home\oracle_common\common\bin>wlst.cmd D:\Weblogic\Middleware\Oracle_Home\forms\fads\fads_config.py Picked up JAVA_TOOL_OPTIONS: -Djava.vendor=”Sun Microsystems Inc.” Initializing WebLogic Scripting Tool (WLST) … Welcome to WebLogic Server Administration Scripting Shell Type help() for help on available commands
fads configuration script Admin Server will be shutdown by running this script. Do you want to continue? [Y/n] :Y You need to install Oracle SQL Developer 4.2 or higher under ORACLE_HOME. Did you install SQL Developer 4.2? [Y/n] :Y SQL Developer 4.2 is installed under D:\Weblogic\Middleware\Oracle_Home connecting to WebLogic: Please enter your username :weblogic Please enter your password : Please enter your server URL [t3://localhost:7001] : Connecting to t3://localhost:7001 with userid weblogic … Successfully connected to Admin Server “AdminServer” that belongs to domain “base_domain”. Warning: An insecure protocol was used to connect to the server. To ensure on-the-wire security, the SSL port or Admin port should be used instead. obtaining Admin Server host/port information Location changed to domainRuntime tree. This is a read-only tree with DomainMBean as the root MBean. For more help, use help(‘domainRuntime’) fadsui.ear:-> D:\Weblogic\Middleware\Oracle_Home\user_projects\applications\base_domain\forms\fads\fads-ui.ear webservices – http://localhost:7001/fads/apis (updated to http://192.168.125.1:7001/fads/apis) Saving… Totals {connections=1, rest=1, updated=1} updating FADS OWSM policy creating fads keystore Already in Domain Runtime Tree Keystore created Already in Domain Runtime Tree Key pair generated Context is missing, therefore using current context “/WLS/base_domain”. Successfully configured property “keystore.type”. Successfully configured property “location”. Successfully configured property “keystore.sig.csf.key”. Successfully configured property “keystore.enc.csf.key”. creating fads WSM policy set Session started for modification. Description defaulted to “Global policy attachments for RESTful Resource resources.” The policy set was created successfully in the session. Policy reference “oracle/multi_token_rest_service_policy” added. The configuration override property “propagate.identity.context” having value “true” has been added to the reference to policy with URI “oracle/multi_token_rest_service_policy”. The policy set restPolicySet is valid. Creating policy set restPolicySet in repository. Session committed successfully. importing fads authorization policy import fadsWSpolicy passed D:\Weblogic\Middleware\Oracle_Home\forms\fads\policy\fadsWSMPolicy.zip Importing “META-INF/policies/oracle/binding_authorization_template_fads” Successfully imported “1” documents Location changed to edit custom tree. This is a writable tree with No root. For more help, use help(‘editCustom’) Starting an edit session … Started edit session, be sure to save and activate your changes once you are done. Saving all your changes … Saved all your changes successfully. Activating all your changes, this may take a while … The edit lock associated with this edit session is released once the activation is completed. Activation completed shutting down the Admin Server Shutting down the server AdminServer with force=false while connected to AdminServer … Disconnected from weblogic server: AdminServer shutting down the Admin Server …….done with fads post configuration………… please start the Admin Server
Exiting WebLogic Scripting Tool.
Once the configurations are successfully completed, the configuration process shuts down the Admin Server. Start the Admin Server & there should not be errors towards missing FADS libraries.
I’ve been installing and configuring Weblogic 10.3.6 & 12c (recently) and came across a peculiar issue, where the reports server failing to map the keys I’ve specified with cgicmd.dat file.
The best I could recollect from my memories was, I only added the keys to a single instance of cgicmd.dat file, as there are many instances of the same file once after classic domains are created.
Under linux installations you will find the file in 3 different locations once after the domain created and WLS_REPORTS server started.
With my latest installations of 12c & 11g, I had issue getting the keys mapped properly & after loads and loads of googling I decided to add the same key to all available instances of cgicmd.dat one after another.
So I started with the first instance of cgicmd.dat file, that was found under
which is WLS_REPORTS temporary folder. I added the key, restarted the WLS_REPORTS server & the key was mapped as required!
This could be a nasty bug because I don’t remember adding the keys to multiple files while I tried out forms and reports 11g Release 2 almost 2 years back!
The most interesting part of the entire exercise is, once the key mapping happens successfully, you can remove the keys from cgicmd.dat file that in the temporary location and everything works! Could be the magic of cache
So if you come across key mapping issues, you know where to look at for a quick fix.
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)
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.
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
OS: Windows 10 64bit Professional
Memory: 16gb
Processor: i7
Storage: Around 4.6 TB (4 Disks)
Software downloads required for the setup
Oracle database 12c
JDK
Middleware aka Weblogic Server 12c
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
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.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)
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
WLS_FORM
WLS_REPORTS
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)
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
Was one of our maximum sought posts & recently I decided to go for a fresh installation of Weblogic 10.3.6 64Bit installation + Forms & reports 11g R2 64Bit. We repeat one of the best articles explain how to is available here and what we are going to provide you additional is few of the things those are different from a typical 32Bit installation.
JDK 8 is not supported (Or my two attempts didn’t bring any fruits)
Node Manager Windows service installation is not offered during the normal/custom installations. That means you MUST install the node manager service by running the .cmd file provided. Default location for the .cmd file is …\wlserver_10.3\server\bin and the file name is “installNodeMgrSvc.cmd”. You should execute this .cmd file from an elevated command prompt!
If you prefer to install a service for Admin server, we have altered the script a little bit and please find it below.
[code language=”text” gutter=”false”]
echo off
SETLOCAL
set DOMAIN_NAME=ClassicDomain
set USERDOMAIN_HOME=D:\WebLogic\user_projects\domains\ClassicDomain
set SERVER_NAME=AdminServer
set WL_HOME=D:\WebLogic\wlserver_10.3
set WLS_USER=weblogic
set WLS_PW=pass123
set PRODUCTION_MODE=true
set MEM_ARGS=-Xms512m -Xmx512m
call "%USERDOMAIN_HOME%\bin\setDomainEnv.cmd"
call "%WL_HOME%\server\bin\installSvc.cmd"
ENDLOCAL
[/code]
I really hope the above tips will make your Weblogic installation more enjoyable.
if [ -z "$1" ]; then
echo "You must supply either start or stop command while calling this script! correct usage: weblogic_start_stop.sh start|stop"
exit
fi
bold=`tput bold`
normal=`tput sgr0`
case "$1" in
‘start’)
echo "Starting Management Node & Weblogic Server 10.3.6"
We have recently noticed something very interesting about Oracle’s services were absconding (means not to be seen) from Services listing, however the Oracle products are intact in all other means.
Earlier we shared a post explaining recreating the missing database services. Today we will try to explain how you can recreate missing Weblogic services. You MUST have Administrative access to the box, and en elevated command prompt (right click, start as administrator)
Assuming you have installed the Weblogic 10.3.6 server in the folder “D:\WebLogic\Middleware>” let us start
Start an elevated command prompt. Switch to “D:\WebLogic\Middleware>”
Let us do an old DOS trick to print all the .cmd files available with the repository
If you really know where exactly the .cmd files are, you may go ahead with the rest of the exercises. So the Node manager installer script is residing under D:\WebLogic\Middleware\wlserver_10.3\server\bin folder. Switch to the folder and execute the .cmd file
Executing the .cmd file should create a new service and available to start within services console.
So once we created the Node Manager Service, we can start re-creating the optional service(s). We will limit ourselves to Weblogic Admin Console service, which is the maximum for our exercises. You may refer to our other post about installing & Configuring Weblogic 10.3.6 for details about creating individual services for Forms and Reports services.
Based on the application domain(the directory export will clearly give you an idea of the folders where components are installed) you have chosen during the installation, switch to the domain folder now
Weblogic Server 10.3.6: Basic & Advanced (Collaborative)
Oracle E-Business Suite: Concepts, basics, technical advanced level involving first level DBA activities like cloning and simple patching
Linux: Basics which can help you to manage Oracle products on Linux (Red Hat Linux, Oracle Unbreakable Linux, CentOS)
& more
Feel free to drop me a e-mai address (please avoid absolute account names like abc@xyz.com, instead use abc at xyz dot com format to avoid spams reaching your inbox)l, contact numbers (post them like 9 9 9 9 1 2 4 5) with the comment session and I’ll contact you. As the topic header says, I’ll provide you free sessions based on my available timings
Language(s) I can handle
Malayalam
Tamil
Hindi
English
And you as a “student” must have a laptop/notebook with minimum 4GB memory and 500GB HDD (internal or external) to carry out the exercises. I won’t go to your place, you will to my place :)
Okay, we are moving from Client/Server architecture to Weblogic+Developer 11g. One of the major requirements was to design and deploy a menu, which resembles Oracle application navigator.
We managed to design a menu, using LIST item (tlist) manipulation and the complete solution you can download from following link
Hello guys, we just posted how to upgrade your existing Forms & Reporots 32Bit 11.1.2.1.0 to 11.1.2.2.0. Why don’t check it out here?
We are running a blog explaining many workaround solutions for installing and configuring discontinued, uncertified Oracle software on Windows 7 & Windows 8 from last year onward.
Let us accept it, Developer 6i applications face multiple issues while used on both Windows 7&8 like:
Intermittent crashes
Rendering menu modules
Stability
Running products like Reports and Graphs
Usually a legacy application compiled using patch sets below 18 are less prone to above mentioned issues, however an application completely developed using patch 18 regularly get into issues on Windows 7 & 8 where hacks are used.
Recently we were forced to look towards a better environment for a new application, which by certain reasons cannot be accommodated and hosted within Oracle Application entity, and we started dwelling the possibilities of setting up a Weblogic server (old application server) for our forms and reports modules.
in short, we did it! and we are sharing the experience with you.
you need the following to carryout the installation and configuration
(Hurry, you may not find the above software bundles with OTN after few weeks or months time)
Part 1 – Weblogic Server 10.3.6 Installation
Installation of Weblogic is pretty straight forward on Windows 8. Only once the compatibility issue is raised, which you can safely ignore by the click of a button.
The Weblogic 10.3.6 (wls1036_win32.exe) installation comes as a single .exe file, which you can start like any other installer.
Please have a look at the images
Choose a directory name without spaces, this is going to be your middleware home.
Uncheck the email notification, you don’t need it as far you don’t have a support from oracle
Select “Custom” installation type, as you can select which JDK to be selected and other components at later stages. We installed both JDK for our installation.
Click next to continue
Leave the selection as it is
Select Yes for “Node Manager Service”, it will make few things simpler at later stages, especially while you are using Admin Server for managing both forms and reports servers.
Select “All Users”
Clicking “Next” will start installing the Weblogic server 10.3.6 for you. Relax and wait until the installation completes.
Once installation has been done, you will be given an option to setup the Weblogic server with an instance, which we will do as a part of Forms & Reports 11g installation and configuration.
Part 2 – Installation ofOracle Forms and Reports 11g Release 2
Once you download the Oracle Forms and Reports 11g Release 2, the zip archive must be unzipped to a folder, which will create Disk1, Disk2, Disk3 folders. You should start the “Setup.exe” from Disk1 folder. Once again the installation is straight forward, without requiring to make any specific hack to the installation media.
You must skip the “Software Update” option, unless you have the paid support from Oracle for the product you are installing.
Most important: You should select “Install Software – Do not configure” at this level, as the configuration will be done once after the installation completed.
On Windows 8 you will be notified about two vital check failures, however allowing you to continue the installation at own risk by clicking the “Continue” button.
Next page will clearly notify you that you must have an application server already installed. Application server akka Weblogic server. Without Weblogic server you cannot use Oracle Forms and Reports 11g Release 2 even for development purpose.
You can safely ignore being updated about the software updates once again
Once you say yes to software update related prompt, the installation will start
Now you have finished installing Oracle Forms and Reports 11g Release 2 on Windows 8/Windows 2008 R2
Part 3 – Configuring the Weblogic server with forms and reports 11g
As we have installed “Node Manager Service” prior configuring the forms and reports, we need to stop the Node Manager Service from Windows services console
Invoke “services.msc” and stop the following service “Oracle Weblogic NodeManager(D_Weblogic_Middleware_wlserver_10.3)
If you don’t stop this service, you are going to come across issues as discussed here
To configure the Weblogic server for forms and reports, you need to invoke the “Configure Classic Instance” cmd file from Windows menu folder “Oracle Classic 11g – Home1”
It may take couple of minutes until you are provided the installation application GUI as shown below. Click next
Select the option “Configure for Deployment”
Unless you are entitled for Oracle support ignore the email part
Now, choose a meaningful name for your Oracle instance.
Important: You must note down the following details for future references. We opted to use the username suggested by Oracle during the configuration which is “weblogic” and provide a password consist of alphabets and minimum one digit (number)
Domain is the node which will be setup with Weblogic for Administration server as well for both Forms and Reports Servers.
By default, Developer tools are not selected, you MUST select this node, incase if you are going to use the same machine for development (which is our objective with this exercise). You may uncheck the “Clustered” option, unless used in a production environment.
Select “Auto Port Configuration”
Try to avoid using Proxy. Microsoft ISA server can make the whole experience a parody, if used.
Use Identity management, only if already implemented and business mandatory. Else leave it unchecked
Click on “Configure” button and sit back, until the process is over!
You may save the installation responses for a future installation by clicking the Save button. Click “Finish” button to exit the configuration wizard
You may run into issues accessing the Enterprise Manager, incase if you have automated the weblogic admin server startup part using services & we have another post explaining how to tackle it here
If the node manager service is installed you can start and stop various components for the domain through this console.
Part 4 – Starting and Stopping domain components AdminServer, WLS_FORMS(Forms Server), WLS_REPORTS(Reports server)
Oracle provides batch files to start and stop all the above mentioned components. You may start just WLS_FORMS and WLS_REPORTS services, unless planning to manage them through the Admin Server console.
Starting Weblogi Admin Server
Starting Forms Server
Starting Reports Server
Part 5 – Automating Weblogic Admin Server, WLS_FORMS(Forms Server), WLS_REPORTS(Reports server) startup with Windows Services
Let us agree, the cmd windows look ugly, dangerous and a user can close them down, thus bringing the entire servers down unintentionally. A windows service looks much favorable under such scenarios and wise people from Oracle do provide solutions to create windows services for
Weblogic Admin Server
WLS_FORMS (Forms Server)
WLS_REPORTS (Reports Server)
Creating Windows services for Admin Server and Forms server are pretty simple and straight forward business, while CMD command line length limitations will make Reports Server service creation a little difficult, don’t worry we have solution for it also.
Part 6 – Creating Windows Service for Weblogic Admin Server
Pre-requisite(s)
Notepad++ (or any decent text editor other than Windows notepad)
Create a .cmd file named “Install_AdminServer.cmd” with the following lines
[sourcecode language=”text” padlinenumbers=”true”]
echo off
SETLOCAL
set DOMAIN_NAME=appsdomain
set USERDOMAIN_HOME=D:\WebLogic\Middleware\user_projects\domains\appsdomain
set SERVER_NAME=AdminServer
set WL_HOME=D:\WebLogic\Middleware\wlserver_10.3
set WLS_USER=weblogic
set WLS_PW=pass123
set PRODUCTION_MODE=true
set MEM_ARGS=-Xms512m -Xmx512m
call "%WL_HOME%\server\bin\installSvc.cmd"
ENDLOCAL
[/sourcecode]
Please note, you must provide the absolute domain name and physical directory names based on your installation preferences!
Save the script to “USERDOMAIN_HOME” folder, ie, “D:\WebLogic\Middleware\user_projects\domains\appsdomain” in our case
From elevated command line, execute the batch file, and the Windows service for Admin Server must be created, unless there were mismatches with the information supplied
Part 7 – Creating Windows Service for WLS_FORMS(Forms Server)
Create a .cmd file “InstallWLS_FORMS.cmd” using Notepad++ with following lines
[sourcecode language=”text”]
echo off
SETLOCAL
set DOMAIN_NAME=appsdomain
set USERDOMAIN_HOME=D:\WebLogic\Middleware\user_projects\domains\appsdomain
set SERVER_NAME=WLS_FORMS
set WL_HOME=D:\WebLogic\Middleware\wlserver_10.3
set WLS_USER=weblogic
set WLS_PW=pass123
set PRODUCTION_MODE=true
set ADMIN_URL=http://localhost:7001
cd %USERDOMAIN_HOME%
call %USERDOMAIN_HOME%\bin\setDomainEnv.cmd
rem *** call "D:\Oracle\Middleware\wlserver_10.3\server\bin\installSvc.cmd"
call "%WL_HOME%\server\bin\installSvc.cmd"
ENDLOCAL
[/sourcecode]
Save the script to “USERDOMAIN_HOME” folder, ie, “D:\WebLogic\Middleware\user_projects\domains\appsdomain” in our case
From elevated command line, execute the batch file, and the Windows service for WLS_FORMS must be created, unless there were mismatches with the information supplied
Part 8 – Creating Windows Service for WLS_REPORTS(Reports Server)
Create a .cmd file “InstallWLS_REPORTS.cmd” using Notepad++ with following lines
[sourcecode language=”text”]
SETLOCAL
set DOMAIN_NAME=appsdomain
set USERDOMAIN_HOME=D:\WebLogic\Middleware\user_projects\domains\appsdomain
set SERVER_NAME=WLS_REPORTS
set WL_HOME=D:\WebLogic\Middleware\wlserver_10.3
set WLS_USER=weblogic
set WLS_PW=pass123
set PRODUCTION_MODE=true
set ADMIN_URL=http://localhost:7001
cd %USERDOMAIN_HOME%
call %USERDOMAIN_HOME%\bin\setDomainEnv.cmd
rem *** call "D:\Oracle\Middleware\wlserver_10.3\server\bin\installSvc.cmd"
call "%WL_HOME%\server\bin\installSvc.cmd"
ENDLOCAL
[/sourcecode]
Unfortunately, you cannot just run the .cmd file and create a service for WLS_REPORTS like other services, as the java CLASSPATH for reports server has more than 3000 character length, which is beyond 32Bit command line architecture.
Hence you have to do a minor hack, as provided as a solution by Oracle.
Go to “D:\WebLogic\Middleware\wlserver_10.3\server\bin” folder (equivalent on your machine) and make a backup for the file “InstallSvc.cmd”
If the report server is running, terminate it by using Ctrl+C within the open cmd window
Wait until the server shutdown. Check the status through Admin Console.
Now restart the Report Server, using the menu interface
Mark and copy the CLASSPATH= output and paste it to a new text document. You have to spend few minutes to wrap up the text and make sure the entire text is wrapped into a single line (This is why we love Notepad++)
Add “set” in front of CLASSPATH= and your txt file content should look something like below and save the text file as “myClasspath.txt”
[sourcecode language=”text”]
set CLASSPATH=D:\WebLogic\Middleware\Oracle_FRHome1\jdbc\lib\ojdbc6.jar;;;D:\WebLogic\MIDDLE~1\ORACLE~1\modules\oracle.jdbc_11.1.1\ojdbc6dms.jar;D:\WebLogic\MIDDLE~1\patch_wls1036\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\WebLogic\MIDDLE~1\JROCKI~1.0-1\lib\tools.jar;D:\WebLogic\MIDDLE~1\WLSERV~1.3\server\lib\weblogic_sp.jar;D:\WebLogic\MIDDLE~1\WLSERV~1.3\server\lib\weblogic.jar;D:\WebLogic\MIDDLE~1\modules\features\weblogic.server.modules_10.3.6.0.jar;D:\WebLogic\MIDDLE~1\WLSERV~1.3\server\lib\webservices.jar;D:\WebLogic\MIDDLE~1\modules\ORGAPA~1.1/lib/ant-all.jar;D:\WebLogic\MIDDLE~1\modules\NETSFA~1.0_1/lib/ant-contrib.jar;D:\WebLogic\Middleware\wlserver_10.3\server\lib\weblogic.jar;D:\WebLogic\Middleware\oracle_common\modules\oracle.dms_11.1.1\dms.jar;D:\WebLogic\Middleware\oracle_common\modules\oracle.jmx_11.1.1\jmxframework.jar;D:\WebLogic\Middleware\oracle_common\modules\oracle.jmx_11.1.1\jmxspi.jar;D:\WebLogic\Middleware\oracle_common\modules\oracle.odl_11.1.1\ojdl.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\lib\adf-share-mbeans-wlst.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\lib\mdswlst.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\auditwlst.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\jps-wlst.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\jrf-wlst.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\oamap_help.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\oamAuthnProvider.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\ossoiap_help.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\ossoiap.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\sslconfigwlst.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\wsm-wlst.jar;D:\WebLogic\Middleware\wlserver_10.3\server\lib\weblogic.jar;D:\WebLogic\Middleware\Oracle_FRHome1\opmn\lib\nonj2eembeans.jar;D:\WebLogic\Middleware\Oracle_FRHome1\jdbc\lib\ojdbc6.jar;D:\WebLogic\Middleware\Oracle_FRHome1\opmn\lib\optic.jar;D:\WebLogic\Middleware\Oracle_FRHome1\opmn\lib\iasprovision.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\lib\adf-share-mbeans-wlst.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\lib\mdswlst.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\auditwlst.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\jps-wlst.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\jrf-wlst.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\oamap_help.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\oamAuthnProvider.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\ossoiap_help.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\ossoiap.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\sslconfigwlst.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\wsm-wlst.jar;D:\WebLogic\Middleware\oracle_common\modules\oracle.adf.share_11.1.1\commons-el.jar;D:\WebLogic\Middleware\Oracle_FRHome1\jlib\dfc.jar;D:\WebLogic\Middleware\Oracle_FRHome1\dvt\lib\dvt-jclient.jar;D:\WebLogic\Middleware\Oracle_FRHome1\dvt\lib\dvt-utils.jar;D:\WebLogic\Middleware\oracle_common\jlib\ewt3.jar;D:\WebLogic\Middleware\oracle_common\modules\oracle.iau_11.1.1\fmw_audit.jar;D:\WebLogic\Middleware\Oracle_FRHome1\oui\jlib\http_client.jar;D:\WebLogic\Middleware\oracle_common\modules\oracle.idm_11.1.1\identitystore.jar;D:\WebLogic\Middleware\oracle_common\modules\oracle.idm_11.1.1\identityutils.jar;D:\WebLogic\Middleware\oracle_common\modules\oracle.jps_11.1.1\jaccprovider.jar;D:\WebLogic\Middleware\oracle_common\modules\oracle.jps_11.1.1\jacc-spi.jar;D:\WebLogic\Middleware\Oracle_FRHome1\ord\jlib\jai_codec.jar;D:\WebLogic\Middleware\Oracle_FRHome1\ord\jlib\jai_core.jar;D:\WebLogic\Middleware\oracle_common\modules\oracle.oc4j-obsolete_11.1.1\jazn.jar;D:\WebLogic\Middleware\oracle_common\modules\oracle.oc4j-obsolete_11.1.1\jazncore.jar;D:\WebLogic\Middleware\oracle_common\jlib\jewt4.jar;D:\WebLogic\Middleware\Oracle_FRHome1\jlib\jta.jar;D:\WebLogic\Middleware\oracle_common\modules\oracle.ldap_11.1.1\ldapjclnt11.jar;D:\WebLogic\Middleware\Oracle_FRHome1\lib\mail.jar;D:\WebLogic\Middleware\Oracle_FRHome1\jlib\netcfg.jar;D:\WebLogic\Middleware\Oracle_FRHome1\jlib\oracle_ice.jar;D:\WebLogic\Middleware\oracle_common\jlib\share.jar;D:\WebLogic\Middleware\Oracle_FRHome1\jlib\zrclient.jar;D:\WebLogic\Middleware\Oracle_FRHome1\reports\jlib\aolj.jar;D:\WebLogic\Middleware\Oracle_FRHome1\reports\jlib\confmbean.jar;D:\WebLogic\Middleware\Oracle_FRHome1\reports\jlib\runtimembean.jar;D:\WebLogic\Middleware\Oracle_FRHome1\reports\jlib\rwadmin.jar;D:\WebLogic\Middleware\Oracle_FRHome1\reports\jlib\rwenv.jar;D:\WebLogic\Middleware\Oracle_FRHome1\reports\jlib\rwrun.jar;D:\WebLogic\Middleware\Oracle_FRHome1\reports\jlib\rwxdo.jar;D:\WebLogic\Middleware\Oracle_FRHome1\jlib\rts2.jar;;D:\WebLogic\MIDDLE~1\ORACLE~1\soa\modules\commons-cli-1.1.jar;D:\WebLogic\MIDDLE~1\ORACLE~1\soa\modules\oracle.soa.mgmt_11.1.1\soa-infra-mgmt.jar;D:\WebLogic\MIDDLE~1\ORACLE~1\modules\oracle.jrf_11.1.1\jrf.jar;D:\WebLogic\MIDDLE~1\WLSERV~1.3\common\derby\lib\derbyclient.jar;D:\WebLogic\MIDDLE~1\WLSERV~1.3\server\lib\xqrl.jar
[/sourcecode]
Now open the “InstallSvc.cmd” using Notepad++ and locate the line “set CLASSPATH=%WEBLOGIC_CLASSPATH%;%CLASSPATH%” and comment the same like
rem *** set CLASSPATH=%WEBLOGIC_CLASSPATH%;%CLASSPATH%
Now locate the line “set CMDLINE” within the “InstallSvc.cmd” and change the line like following
There are two instances of set CMDLINE, you must change both lines, only replacing the “-classpath \”%CLASSPATH%\” part with -classpath @d:\myClasspath.txt
After the above, from elevated command line, execute the batch file, and the Windows service for WLS_REPORTS must be created, unless there were mismatches with the information supplied
Change “Automatic” to “Manual” for better ease, at various situations. You may create a .cmd file for starting the services and another one for stopping them.
From our prospects, these services are just a facelift for the batch files, avoiding the immediate problems with accidental closure of cmd windows and thus causing serious issues to the instance. We came to this conclusion because, the service status are not updated incase if one of the services stopped by the Admin Server console at later stages, neither the service status update waits until the actual server starts to update state of the service.
You can delete whole these service from command prompt, after stopping like following
>SC DELETE “service name”
We hope you will enjoy setting up Weblogic 10.3.6 and Oracle Forms and Reports 11g Release 2 on Windows 8/ Windows 2008 R2 following the instruction set provided above.