Configure Oracle Reports 12c (12.2.x) for destype=file

I currently had in a project a request, that Oracle Reports should be generated with the option destype=file to a specific location on the server which is hosting the Oracle Forms & Reports 12c environment. Since Oracle Forms & Reports 12c, the so called "File System Access Control" is enabled by default, so any request like http://<server>:<Port_of_ManagedServer_Reports>/reports/rwservlet?report=test.rdf&userid=test/test@db1&destype=file&desformat=pdf&desname=/u00/app/oracle/demo_app/rep_output/test.pdf&server=rep_server1...

Read More

Decrypt any encrypted password in your WebLogic Server Domain

It happens regularly, that you configure a WebLogic Domain and you forgot after some time the given password for the WebLogic Administration User or you have configured a JDBC Data Source and you forgot the password of the used Oracle Database User. All you need is following small Python Script called decrypt.py: #/bin/python #===================================================================== # # $Id: decrypt.py $ # # PURPOSE: Script to decrypt any Password or Username # within a WebLogic Server Domain # # PARAMETERS: none # #...

Read More

Oracle Installer fails with [EXCEPTION]:java.lang.reflect.InvocationTargetException under RedHat 7.4

I recently had a customer with a fresh installed RedHat 7.4 system on which we wanted to install different Oracle Software in graphical mode, like Oracle Database 12.1.0.2.0, Oracle WebLogic Server 12.2.1.3.0 and Oracle Data Integrator 12.2.1.3.0. Following error occured when we were starting the Oracle Installers, either runInstaller or java -jar fmw_12.2.1.3.0_odi.jar: export JAVA_HOME=/u00/app/oracle/product/jdk1.8.0_131 export PATH=$JAVA_HOME/bin:$PATH cd /u00/app/oracle/install java -jar fmw_12.2.1.3.0_odi.jar Launcher log file is /tmp/OraInstall2017-09-19_09-12-33AM/launcher2017-09-19_09-12-33AM.log. Extracting...

Read More

How to install and configure Oracle Traffic Director 12c - fully unattended

As I am not a fan of clicking through several Configuration Wizards, I am trying to script as much as possible. Here is a fully unattended way of how to install and configure Oracle Traffic Director 12.2.1.3.0. Following pre requirements are necessary: you need a certified Linux Server, e.g. with Oracle Enterprise Linux 7.3 an oracle user on the Linux Server all required packages as per documentation and the necessary kernel settings and so on create...

Read More

Oracle Forms 12.2.1.3.0 and the impact of new Required Support Files 12.1.0.2.0

With the latest Release of Oracle Forms & Reports 12.2.1.3.0 the Database Required Support Files got a facelift. Oracle moved the Database Required Support Files up from Release 11.2.0.3.0 to 12.1.0.2.0. On the first look this seems not to be too dramatically, but when you check out the Release Note for Oracle Forms & Reports 12.2.1.3.0 Section Lifecycle Management Informations, you will find this statement http://docs.oracle.com/middleware/12213/formsandreports/releasenotes-fnr/lifecycle-management-information.htm#FRREL-GUID-241658D3-387D-4154-9484-1BF55D4EFFB7 Which...

Read More

WebLogic Server 12.2.1.3.0 - Get Patch List with RESTful Management Services

Yesterday, I discovered a new field within the RESTful Management Services under serverRuntime - patchList. This new field contains the list of applied patches to your Oracle WebLogic Server 12.2.1.3.0 installation, so I thought, I will not longer need to access opatch lsinventory to retrieve the list of applied patches on my WebLogic Server installation ... You can check the list of applied Patches with following URL call within a browser or just...

Read More

Starting and Stopping Oracle Reports Servers with WLST

Normally people are using to start and stop their Oracle Reports Servers the by Oracle provided scripts startComponent.sh and stopComponent.sh in the $DOMAIN_HOME/bin. The problem with this set of scripts is, that they really take long time to complete and you need to execute it for each Reports Server: cd $DOMAIN_HOME/bin # Lets measure the time time ./startComponent.sh rep_server1 Starting system Component rep_server1 ... Initializing WebLogic Scripting Tool (WLST) ... Welcome to WebLogic Server Administration Scripting Shell Type help()...

Read More

Oracle Forms Application Deployment Services (FADS)

Within the latest release of Oracle Forms & Reports 12.2.1.3.0 is a really cool new feature - Oracle Forms Application Deployment Services (FADS). FADS allows you to package, deploy, configure and store complete Forms Applications. A normal Forms Application contains executables like fmx, mmx and plx, but also jar's, html's. With FADS you can package them all together, version them. The installation is quite simple, but ONLY if you follow...

Read More

Oracle Forms & Reports 12.2.1.3.0 - First Look

Today I had some time to play around with the latest Release of the Oracle Forms & Reports Services 12.2.1.3.0. Here are my first impressions (at first the positive findings ...): The installation procedure is the same as the previous release, so just install your JDK 1.8 (minimum version must be JDK 1.8_131), after that install your Oracle WebLogic Server Infrastructure 12.2.1.3.0 (not the generic WebLogic Server) and finally install over...

Read More