tag:blogger.com,1999:blog-43446849789578858062024-03-14T11:53:15.550+01:00Dirk Nachbar: This Blog is discontinued, its only read-onlyThis Blog is discontinued, its only read-onlyDirk Nachbarhttp://www.blogger.com/profile/07873896834616675757noreply@blogger.comBlogger258125tag:blogger.com,1999:blog-4344684978957885806.post-28461499835555330562020-11-02T13:45:00.000+01:002020-11-02T13:45:29.742+01:00CVE-2020-14750 - Oracle WebLogic Server<p> Today on 2nd November 2020 Oracle released overlay patches for the CVE-2020-14750 (<a href="https://www.oracle.com/security-alerts/alert-cve-2020-14750.html" target="_blank">https://www.oracle.com/security-alerts/alert-cve-2020-14750.html</a>).</p><p>This CVE-2020-14750 got a score of 9.8 out of 10. According to SANS ISC InfoSec the exploitation of this vulnerability is really trivial, see <a href="https://isc.sans.edu/forums/diary/PATCH+NOW+CVE202014882+Weblogic+Actively+Exploited+Against+Honeypots/26734/" target="_blank">https://isc.sans.edu/forums/diary/PATCH+NOW+CVE202014882+Weblogic+Actively+Exploited+Against+Honeypots/26734/</a></p><p>Oracle released already overlay patches, which needs to be applied over an already patched Oracle WebLogic Server with the CPU October 2020.</p><p>Following Oracle WebLogic released are affected (<a href="https://support.oracle.com/epmos/faces/DocContentDisplay?id=2724951.1" target="_blank">https://support.oracle.com/epmos/faces/DocContentDisplay?id=2724951.1</a>):</p><p>Oracle WebLogic Server 10.3.6</p><p></p><ul style="text-align: left;"><li>WLS PATCH SET UPDATE 10.3.6.0.201020, Patch 31641257 (<a href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?patchId=31641257" target="_blank">https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?patchId=31641257</a>)</li><li>Overlay Patch 32097188 for CVE-2020-14750 <a href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?patchId=32097188" target="_blank">https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?patchId=32097188</a></li></ul><p></p><p>Oracle WebLogic Server 12.1.3</p><p></p><ul style="text-align: left;"><li>WLS PATCH SET UPDATE 12.1.3.0.201020, Patch 31656851 <a href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?patchId=31656851" target="_blank">https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?patchId=31656851</a></li><li>Overlay Patch 32097177 for CVE-2020-14750 <a href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?patchId=32097177" target="_blank">https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?patchId=32097177</a></li></ul><p></p><p>Oracle WebLogic Server 12.2.1.3</p><p></p><ul style="text-align: left;"><li>WLS PATCH SET UPDATE 12.2.1.3.201001, Patch 31961038 <a href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?patchId=31961038" target="_blank">https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?patchId=31961038</a></li><li>Overlay Patch 32097173 for CVE-2020-14750 <a href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?patchId=32097173" target="_blank">https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?patchId=32097173</a></li></ul><p></p><p>Oracle WebLogic Server 12.2.1.4</p><p></p><ul style="text-align: left;"><li>WLS PATCH SET UPDATE 12.2.1.4.201001, Patch 31960985 <a href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?patchId=31960985" target="_blank">https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?patchId=31960985</a></li><li>Overlay Patch 32097167 for CVE-2020-14750 <a href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?patchId=32097167" target="_blank">https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?patchId=32097167</a></li></ul><p></p><p>Oracle WebLogic Server 14.1.1</p><p></p><ul style="text-align: left;"><li>WLS PATCH SET UPDATE 14.1.1.0.200930, Patch 31957062 <a href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?patchId=31957062" target="_blank">https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?patchId=31957062</a></li><li>Overlay Patch 32097180 for CVE-2020-14750 <a href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?patchId=32097180" target="_blank">https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?patchId=32097180</a></li></ul><p></p><p>It's strongly recommended to apply this overlay patch to your Oracle WebLogic Server environments.</p><div><br /></div>Dirk Nachbarhttp://www.blogger.com/profile/07873896834616675757noreply@blogger.comtag:blogger.com,1999:blog-4344684978957885806.post-10446597842909451802020-10-26T13:30:00.001+01:002020-10-26T13:30:34.338+01:00Oracle Forms & Reports 12.2.1.4.0 certified with ATP<p>Since a few days, the current release of Oracle Forms & Reports 12.2.1.4.0 is officially certified with the use of Oracle Autonomous Transaction Processing (ATP) Database.</p><p>You can use the ATP Database for the Metadata Repository for Oracle Forms & Reports 12.2.1.4.0 and/or as application Database.</p><p>The certification you can see in the What's new Guide <a href="https://docs.oracle.com/en/middleware/developer-tools/forms/12.2.1.4/releasenotes-fnr/whats-new-this-release.html#GUID-5D5D50BB-9358-4009-A324-024EF97CA3D8" target="_blank">https://docs.oracle.com/en/middleware/developer-tools/forms/12.2.1.4/releasenotes-fnr/whats-new-this-release.html#GUID-5D5D50BB-9358-4009-A324-024EF97CA3D8</a></p><p>In the Oracle Fusion Middleware 12c Certification Excel Sheet for 12.2.1.4.0, <a href="https://www.oracle.com/technetwork/middleware/fmw-122140-certmatrix-5763476.xlsx" target="_blank">https://www.oracle.com/technetwork/middleware/fmw-122140-certmatrix-5763476.xlsx</a> you can see the certification for the usage of ATP databases as well:</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjioRVu3X0MjDmxsvAuJWocb3246bQdal7eaFFm5WqIEQEzRmbUShOXXQGCNi4UdzCLaN4j9i0dYox9zrS5YRAWkYJjjarO0c3KYxO82umqxfCys-eG-WlOKFpPIWMRzrqpEkQnGhGIed0/s2542/Forms_ATP_Certified.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1237" data-original-width="2542" height="312" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjioRVu3X0MjDmxsvAuJWocb3246bQdal7eaFFm5WqIEQEzRmbUShOXXQGCNi4UdzCLaN4j9i0dYox9zrS5YRAWkYJjjarO0c3KYxO82umqxfCys-eG-WlOKFpPIWMRzrqpEkQnGhGIed0/w640-h312/Forms_ATP_Certified.png" width="640" /></a></div><br /><p><br /></p>Dirk Nachbarhttp://www.blogger.com/profile/07873896834616675757noreply@blogger.comtag:blogger.com,1999:blog-4344684978957885806.post-12398361623838372020-09-04T10:34:00.000+02:002020-09-04T10:34:14.902+02:00In-Process Reports Server<p>From time to time I am receiving questions concerning the Oracle In-Process Reports Server which come by default with the configuration of Oracle Forms & Reports.</p><p>Mainly the questions are, how can start or stop the In-Process Reports Server or how to disable the default In-Process Reports Server completely?</p><p><br /></p><h4 style="text-align: left;">Start and Stop of the In-Process Reports Server</h4><p>To start, simple open a Browser and point to http://<your_server_name>:<Port_of_ManagedServerReports>/reports/rwservlet/startserver</p><p>To stop just use http://<your_server_name>:<Port_of_ManagedServerReports>/reports/rwservlet/stopserver</p><p style="text-align: left;"><br /></p><h4 style="text-align: left;">Disable the In-Process Reports Server</h4><p>In order to completely disable the default In-Process Reports Server, you have to edit the rwservlet.properties file, which is located under $DOMAIN_HOME/config/fmwconfig/servers/<Name_ManagedServerReports>/applications/reports_12.2.1/configuration</p><p></p>
<pre class="brush:bash">#
# Align the line from
<inprocess>yes</inprocess>
# to
<inprocess>no</inprocess>
</pre>
<p>After that restart the ManagedServer for Reports and you are done.</p><p>In Oracle Reports 11.x Releases, you can disable the default In-Process Reports Server via the Enterprise Manager Fusion Middleware Control under the Reports Menu. </p><p>But in Oracle Reports 12.x the management of Reports is no longer available within the Enterprise Manager Fusion Middleware Control, so you will have to do it manually directly in the rwservlet.properties file.</p><p><br /></p>Dirk Nachbarhttp://www.blogger.com/profile/07873896834616675757noreply@blogger.comtag:blogger.com,1999:blog-4344684978957885806.post-79461726865148429592020-08-24T11:10:00.000+02:002020-08-24T11:10:02.827+02:00Oracle Forms & Reports 12.2.1.4.0 on Oracle Linux 8 / Redhat 8Oracle Forms & Reports 12.2.1.4.0 is officially supported and certified with Oracle Linux 8 and Redhat 8.
But in case you want to install the Oracle Forms & Reports 12.2.1.4.0 you will see that you are running into an error while performing the prerequirement check.
<div><br /></div><div><br /></div>
<pre class="brush:bash">#
Starting check : CertifiedVersions
Expected result: One of oracle-7, redhat-7, redhat-6, oracle-6, SuSE-11, SuSE-12, SuSE-15
Actual Result: redhat-8.2
Check complete. The overall result of this check is: Passed
CertifiedVersions Check: Success.
Starting check : Packages
Checking for binutils-2.23.52.0.1; found binutils-2.30-73.el8-x86_64. Passed
Checking for compat-libcap1-1.10; Not found. Failed
Checking for compat-libstdc++-33-3.2.3-x86_64; Not found. Failed
Checking for libgcc-4.8.2-x86_64; found libgcc-8.3.1-5.el8-x86_64. Passed
Checking for libstdc++-4.8.2-x86_64; found libstdc++-8.3.1-5.el8-x86_64. Passed
Checking for libstdc++-devel-4.8.2-x86_64; found libstdc++-devel-8.3.1-5.el8-x86_64. Passed
Checking for sysstat-10.1.5; found sysstat-11.7.3-2.el8-x86_64. Passed
Checking for gcc-4.8.2; found gcc-8.3.1-5.el8-x86_64. Passed
Checking for gcc-c++-4.8.2; found gcc-c++-8.3.1-5.el8-x86_64. Passed
Checking for ksh-...; found ksh-20120801-254.el8-x86_64. Passed
Checking for make-3.82; found make-1:4.2.1-10.el8-x86_64. Passed
Checking for glibc-2.17-x86_64; found glibc-2.28-101.el8-x86_64. Passed
Checking for glibc-devel-2.17-x86_64; found glibc-devel-2.28-101.el8-x86_64. Passed
Checking for libaio-0.3.109-x86_64; found libaio-0.3.112-1.el8-x86_64. Passed
Checking for libaio-devel-0.3.109-x86_64; found libaio-devel-0.3.112-1.el8-x86_64. Passed
Checking for motif-2.3.4; found motif-2.3.4-16.el8-x86_64. Passed
Check complete. The overall result of this check is: Failed
</pre>
<div>As you can see from above, the Oracle Installer is failing because of the missing packages compat-libcap1-1.10 and compat-libstdc++-33-3.2.3-x86_64.<br /><div>These 2 packages can not be found in the Oracle Linux 8 and Redhat 8 distrubition, they have been removed since Release 8.</div><div><br /></div><div>To resolve this problem, you will need to download the Patch 31190532 from My Oracle Support, transfer the patch to your target server, extract the patch somewhere and modify your Oracle Installer startup command as follows:</div><div><br />
<pre class="brush:bash">#
./fmw_12.2.1.4.0_fr_linux64.bin -prereqConfigLoc <Path_to_the_patch>/31190532/prereq_metadata/oracle.as.install.fr.prerequisite/prereq
</pre>
<div><br />
and now the Oracle Installer will successfully pass the prerequirement checks:
<div><br />
<pre class="brush:bash">#
Starting check : CertifiedVersions
Expected result: One of oracle-8, oracle-7, redhat-8, redhat-7, redhat-6, oracle-6, SuSE-11, SuSE-12, SuSE-15
Actual Result: redhat-8.2
Check complete. The overall result of this check is: Passed
CertifiedVersions Check: Success.
Starting check : Packages
Checking for binutils-2.23.52.0.1; found binutils-2.30-73.el8-x86_64. Passed
Checking for libcap-2.25-9; found libcap-2.26-3.el8-x86_64. Passed
Checking for libstdc++-8.2.1-3.5.0.1.el8-x86_64; found libstdc++-8.3.1-5.el8-x86_64. Passed
Checking for libgcc-4.8.2-x86_64; found libgcc-8.3.1-5.el8-x86_64. Passed
Checking for libstdc++-devel-4.8.2-x86_64; found libstdc++-devel-8.3.1-5.el8-x86_64. Passed
Checking for sysstat-10.1.5; found sysstat-11.7.3-2.el8-x86_64. Passed
Checking for gcc-4.8.2; found gcc-8.3.1-5.el8-x86_64. Passed
Checking for gcc-c++-4.8.2; found gcc-c++-8.3.1-5.el8-x86_64. Passed
Checking for ksh-...; found ksh-20120801-254.el8-x86_64. Passed
Checking for make-3.82; found make-1:4.2.1-10.el8-x86_64. Passed
Checking for glibc-2.17-x86_64; found glibc-2.28-101.el8-x86_64. Passed
Checking for glibc-devel-2.17-x86_64; found glibc-devel-2.28-101.el8-x86_64. Passed
Checking for libaio-0.3.109-x86_64; found libaio-0.3.112-1.el8-x86_64. Passed
Checking for libaio-devel-0.3.109-x86_64; found libaio-devel-0.3.112-1.el8-x86_64. Passed
Checking for motif-2.3.4; found motif-2.3.4-16.el8-x86_64. Passed
Check complete. The overall result of this check is: Passed
Packages Check: Success.
</pre>
<div><br /></div></div></div></div></div>Dirk Nachbarhttp://www.blogger.com/profile/07873896834616675757noreply@blogger.comtag:blogger.com,1999:blog-4344684978957885806.post-60606675234911701062020-05-18T16:12:00.002+02:002020-05-18T16:12:47.951+02:00Oracle WebLogic 14.1.1 under Podman<div>
Since a few weeks the latest release of the Oracle WebLogic Server 14.1.1.0.0 is available and I was testing it already on native Linux Servers and within Docker.</div>
<div>
Now it's time to check Oracle WebLogic Server 14.1.1.0.0 under Podman <a href="https://podman.io/" target="_blank">https://podman.io</a> </div>
<div>
<br /></div>
<div>
At first you will need an Oracle Linux 8.2 Server with podman. A really good instruction you can find at oracle-base.com <a href="https://oracle-base.com/articles/linux/podman-install-on-oracle-linux-ol8" target="_blank">https://oracle-base.com/articles/linux/podman-install-on-oracle-linux-ol8</a></div>
<div>
<br /></div>
<div>
As a starting point, just clone my GitHub Repository <a href="https://github.com/DirkNachbar/Docker" target="_blank">https://github.com/DirkNachbar/Docker</a> there you will find some Dockerfiles for Oracle WebLogic Server 14.1.1.0.0</div>
<div>
<br /></div>
<div>
The first task is to create a JDK 11 Podman Image.</div>
<div>
<br /></div>
<div>
Under my GitHub Repository in the subdirectory OracleWebLogic/dockerfiles/14.1.1.0.0/serverjre/java-11 you will find a Dockerfile for a JDK 11 Image.</div>
<div>
Simply download from Oracle Technology Network <a href="https://www.oracle.com/java/technologies/javase-jdk11-downloads.html" target="_blank">https://www.oracle.com/java/technologies/javase-jdk11-downloads.html</a> the Linux Compressed Archive of the JDK 11 and place it in the directory OracleWebLogic/dockerfiles/14.1.1.0.0/serverjre/java-11</div>
<div>
Then just run the podman build command as follows:<br />
<br />
<pre class="brush:bash">[root@podman java-11]#
[root@podman java-11]# cat Dockerfile
#
# Dockerfile for creating Oracle JDK 11 Images based on OL latest
#
FROM oraclelinux:7-slim
MAINTAINER Dirk Nachbar <https://dirknachbar.blogspot.com>
ENV JAVA_PKG=jdk-11*linux-x64_bin.tar.gz \
JAVA_HOME=/usr/java/default
ADD $JAVA_PKG /usr/java/
RUN export JAVA_DIR=$(ls -1 -d /usr/java/*) && \
ln -s $JAVA_DIR /usr/java/latest && \
ln -s $JAVA_DIR /usr/java/default && \
alternatives --install /usr/bin/java java $JAVA_DIR/bin/java 20000 && \
alternatives --install /usr/bin/javac javac $JAVA_DIR/bin/javac 20000 && \
alternatives --install /usr/bin/jar jar $JAVA_DIR/bin/jar 20000
# Execute the podman build command
[root@podman java-11] podman build -t oracle/jdk:11 .
STEP 1: FROM oraclelinux:7-slim
STEP 2: MAINTAINER Dirk Nachbar <https://dirknachbar.blogspot.com>
0a8a2a2490e09457a55c815b8c0e7b84712162282b7dca2290972ae74ab03dcf
STEP 3: ENV JAVA_PKG=jdk-11*linux-x64_bin.tar.gz JAVA_HOME=/usr/java/default
e308caf489693447f398651473cdbb1b54f77ace324a06831ed518bb0341be3e
STEP 4: ADD $JAVA_PKG /usr/java/
0a2f357d4e064545764064f1ee9e84d6b95dff8e1077d0326a9361bafe58ab41
STEP 5: RUN export JAVA_DIR=$(ls -1 -d /usr/java/*) && ln -s $JAVA_DIR /usr/java/latest && ln -s $JAVA_DIR /usr/java/default && alternatives --install /usr/bin/java java $JAVA_DIR/bin/java 20000 && alternatives --install /usr/bin/javac javac $JAVA_DIR/bin/javac 20000 && alternatives --install /usr/bin/jar jar $JAVA_DIR/bin/jar 20000
STEP 6: COMMIT oracle/jdk:11
14e68c77ac48b34e8d6ffda5614c03a787c949a920576e1432d8d7fa9697726f
# Check the JDK 11 Image
[root@podman jdk11]# podman images
REPOSITORY TAG IMAGE ID CREATED SIZE
localhost/oracle/jdk 11 14e68c77ac48 25 seconds ago 986 MB
docker.io/library/oraclelinux 7-slim 3f15c01b91bb 13 days ago 126 MB
</pre>
<br />
Now as next we can build the Oracle WebLogic Image. For this download the Oracle WebLogic 14c Generic Installer from <a href="https://www.oracle.com/middleware/technologies/fusionmiddleware-downloads.html" target="_blank">https://www.oracle.com/middleware/technologies/fusionmiddleware-downloads.html</a> and place the installer (dont unzip it) into the subirectory OracleWebLogic/dockerfiles/14.1.1.0.0<br />
After you have placed the Generic Installer, you can execute the podman build to build the Oracle WebLogic Image as follows</div>
<div>
<br /></div>
<pre class="brush:bash">[root@podman 14.1.1.0.0]#
[root@podman 14.1.1.0.0] podman build -t oracle/weblogic:14.1.1.0.0-optimized -f Dockerfile.optimized
STEP 1: FROM oracle/jdk:11 AS base
STEP 2: MAINTAINER Dirk Nachbar <https://dirknachbar.blogspot.com>
a24b9133c927b4ccff67f37c775bf53680e861da472fefd909bc22b775603ca8
STEP 3: ENV ORACLE_HOME=/u01/oracle USER_MEM_ARGS="-Djava.security.egd=file:/dev/./urandom" SCRIPT_FILE=/u01/oracle/createAndStartEmptyDomain.sh PATH=$PATH:${JAVA_HOME}/bin:/u01/oracle/oracle_common/common/bin:/u01/oracle/wlserver/common/bin
239b6e6b88f8f4926dde93e5b10517a695f240c481c5034556066d93d13a59c1
STEP 4: RUN mkdir -p /u01 && chmod a+xr /u01 && useradd -b /u01 -d /u01/oracle -m -s /bin/bash oracle
49b27820a188efa1c3fb125ba35737819f6c9a5810599ca0f83cf5a39980b13e
STEP 5: COPY container-scripts/createAndStartEmptyDomain.sh container-scripts/create-wls-domain.py /u01/oracle/
9daad5ed3cfd18e0a9e9450374cb6530e18186141da4b7c63d96465981e9c886
STEP 6: ENV DOMAIN_NAME="${DOMAIN_NAME:-base_domain}" ADMIN_LISTEN_PORT="${ADMIN_LISTEN_PORT:-7001}" ADMIN_NAME="${ADMIN_NAME:-AdminServer}" ADMINISTRATION_PORT_ENABLED="${ADMINISTRATION_PORT_ENABLED:-true}" ADMINISTRATION_PORT="${ADMINISTRATION_PORT:-9002}"
4a0f6a9cda24712750ab4897e3c3c423b3c90880053668d6fb097c5373ad54fa
STEP 7: ENV FMW_PKG=fmw_14.1.1.0.0_wls_Disk1_1of1.zip FMW_JAR=fmw_14.1.1.0.0_wls.jar
1cf02aa4288004bf699f95255d76c9dbefe2c197c449ef530374afdde4883b9b
STEP 8: FROM 1cf02aa4288004bf699f95255d76c9dbefe2c197c449ef530374afdde4883b9b AS builder
STEP 9: COPY $FMW_PKG install.file oraInst.loc /u01/
4cb0de51b444f880fe3ec0605147bda1ec5a86b46d3ca0bae8e4a4a9e5358b67
STEP 10: RUN chown oracle:oracle -R /u01 && chmod +xr $SCRIPT_FILE
7556f584bf843d9b6741a247d6dc66113ecec2ee6207f8e21a93dc25ca7f952e
STEP 11: USER oracle
cc27e8664abbc4c7ee210588ccac3b2e1b8c8b41129bf88de67914cae68b7ea3
STEP 12: RUN cd /u01 && ${JAVA_HOME}/bin/jar xf /u01/$FMW_PKG && cd - && ls /u01 && ${JAVA_HOME}/bin/java -jar /u01/$FMW_JAR -silent -responseFile /u01/install.file -invPtrLoc /u01/oraInst.loc -jreLoc $JAVA_HOME -ignoreSysPrereqs -force -novalidation ORACLE_HOME=$ORACLE_HOME INSTALL_TYPE="WebLogic Server" && rm /u01/$FMW_JAR /u01/$FMW_PKG /u01/oraInst.loc /u01/install.file
/
fmw_14.1.1.0.0_wls.jar install.file oracle
fmw_14.1.1.0.0_wls_Disk1_1of1.zip oraInst.loc
Launcher log file is /tmp/OraInstall2020-05-18_09-19-42AM/launcher2020-05-18_09-19-42AM.log.
Extracting the installer . . . . . . . Done
Checking if CPU speed is above 300 MHz. Actual 2194.918 MHz Passed
Checking swap space: must be greater than 512 MB. Actual 4067 MB Passed
Checking temp space: must be greater than 300 MB. Actual 23718 MB Passed
Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2020-05-18_09-19-42AM
Log: /tmp/OraInstall2020-05-18_09-19-42AM/install2020-05-18_09-19-42AM.log
Setting ORACLE_HOME...
Setting INSTALL_TYPE...
Copyright (c) 1996, 2020, Oracle and/or its affiliates. All rights reserved.
Reading response file..
Skipping Software Updates
Validations are disabled for this session.
Verifying data
Copying Files
Percent Complete : 10
Percent Complete : 20
Percent Complete : 30
Percent Complete : 40
Percent Complete : 50
Percent Complete : 60
Percent Complete : 70
Percent Complete : 80
Percent Complete : 90
Percent Complete : 100
The installation of Oracle Fusion Middleware 14.1.1 WebLogic Server and Coherence 14.1.1.0.0 completed successfully.
Logs successfully copied to /u01/oracle/.inventory/logs.
5975a5d295923d0d13875bbb180de5acde5e7cb93cf51f8ebe03fea72fe362c8
STEP 13: FROM 1cf02aa4288004bf699f95255d76c9dbefe2c197c449ef530374afdde4883b9b
STEP 14: COPY --chown=oracle:oracle --from=builder $ORACLE_HOME $ORACLE_HOME
bc0e5e9a75ae49cf0800317c5e2da309ae76b036a76ba9528a783f4c06ad5ba6
STEP 15: COPY --chown=oracle:oracle --from=builder $JAVA_HOME $JAVA_HOME
133eb7a4a072b4e2d3d4a50f606f7908fb4adcdd6a7b9479748a9afdc7f8518f
STEP 16: WORKDIR ${ORACLE_HOME}
bfba2b46902c13dd3b4d6fa5e0cdb3a157202140e20c67c931694eced8c82525
STEP 17: CMD ["/u01/oracle/createAndStartEmptyDomain.sh"]
STEP 18: COMMIT oracle/weblogic:14.1.1.0.0-optimized
fba87010a1c6b16a7760af38681f37496163885badb4bd0f0e2515f6fd27edf8
# Now let's verify the podman Image for the WebLogic 14.1.1.0.0
[root@podman 14.1.1.0.0] podman images
REPOSITORY TAG IMAGE ID CREATED SIZE
localhost/oracle/weblogic 14.1.1.0.0-optimized fba87010a1c6 2 hours ago 3.11 GB
localhost/oracle/jdk 11 14e68c77ac48 3 hours ago 986 MB
docker.io/library/oraclelinux 7-slim 3f15c01b91bb 13 days ago 126 MB
</pre>
<div>
<br /></div>
<div>
The final step is to create a pod and a running container with Oracle WebLogic Server 14.1.1.0.0.<br />
The pod creation and the container creation can be done within one single command:<br />
<br />
<pre class="brush:bash">[root@podman 14.1.1.0.0]#
[root@podman 14.1.1.0.0] podman run -d --name [Name of your Container] --pod=new:[Pod Name] \
-p 7001:7001 -p 9002:9002 \
-v [Directory to your domain.properties file]:/u01/oracle/properties \
-e ADMINISTRATION_PORT_ENABLED=true -e DOMAIN_NAME=[WebLogic Domain Name] \
oracle/weblogic:14.1.1.0.0-optimized
# E.g.:
[root@podman 14.1.1.0.0] podman run -d --name wls1411optimized --pod=new:pod_wls1411 \
-p 7001:7001 -p 9002:9002 \
-v /work/Docker/OracleWebLogic/dockerfiles/14.1.1.0.0/properties:/u01/oracle/properties \
-e ADMINISTRATION_PORT_ENABLED=true -e DOMAIN_NAME=OptimizedDomain \
oracle/weblogic:14.1.1.0.0-optimized
# Let's check the pod creation:
[root@podman 14.1.1.0.0] podman pod ls
POD ID NAME STATUS CREATED # OF CONTAINERS INFRA ID
4e0b599d0083 pod_wls1411 Running 12 seconds ago 2 68ccf98d911a
# Let's check the WebLogic Container:
[root@podman 14.1.1.0.0] podman ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
5a1e9a6fcd3a localhost/oracle/weblogic:14.1.1.0.0-optimized /u01/oracle/creat... 42 seconds ago Up 41 seconds ago 0.0.0.0:7001->7001/tcp wls1411optimized
</pre>
As you can see, it's really easy to get Oracle WebLogic Server 14c up and running under Podman.</div>
<div>
<br /></div>
<div>
<br /></div>
Dirk Nachbarhttp://www.blogger.com/profile/07873896834616675757noreply@blogger.comtag:blogger.com,1999:blog-4344684978957885806.post-51079573070078343592020-04-24T09:58:00.000+02:002020-04-24T09:58:26.776+02:00Oracle Enterprise Manager 13.4 - New Add-On Plug-ins availableOracle released some new Add-On Plug-ins for the Oracle Enterprise Manager 13.4.x<br />
<br />
Following new Add-On Plug-Ins are available:<br />
<br />
<ul>
<li>Enterprise Manager for Oracle Database Appliance</li>
<li>Enterprise Manager for TimesTen</li>
<li>Enterprise Manager for Oracle GoldenGate</li>
<li>Enterprise Manager for Oracle Unified Directory</li>
<li>Enterprise Manager for Utilities (TUGBU)</li>
<li>Enterprise Manager for Peoplesoft</li>
</ul>
<div>
</div>
<br />
<div>
The installation files for the above mentioned Add-On Plug-Ins can be found under: <a href="https://www.oracle.com/enterprise-manager/downloads/oem-v134-update-plugins-downloads.html" target="_blank">https://www.oracle.com/enterprise-manager/downloads/oem-v134-update-plugins-downloads.html</a></div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjqzKnqpT7uCSyz1XI1s1Fx8IAOsK05UFrrxRM5WIXzmhCPrNx1HtvLZU0cH3graDM-jsjla9Ge7UIvA8pv-Wanvz2-Efp7cw-ZE8lzCrylmTQ_uqiotOH8XUyf3w_9qJbufcIOPEjejUs/s1600/download_AddOn_PlugIns.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="635" data-original-width="1600" height="250" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjqzKnqpT7uCSyz1XI1s1Fx8IAOsK05UFrrxRM5WIXzmhCPrNx1HtvLZU0cH3graDM-jsjla9Ge7UIvA8pv-Wanvz2-Efp7cw-ZE8lzCrylmTQ_uqiotOH8XUyf3w_9qJbufcIOPEjejUs/s640/download_AddOn_PlugIns.png" width="640" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
Dirk Nachbarhttp://www.blogger.com/profile/07873896834616675757noreply@blogger.comtag:blogger.com,1999:blog-4344684978957885806.post-38574644628518028922020-04-02T13:13:00.000+02:002020-04-02T13:13:59.658+02:00Oracle WebLogic Server 14.1.1.0.0 and Oracle WebLogic Monitoring ExporterAs the latest release of Oracle WebLogic Server 14.1.1.0.0 is available (see my blogposts <a href="https://dirknachbar.blogspot.com/2020/03/oracle-weblogic-141100-available.html" target="_blank">https://dirknachbar.blogspot.com/2020/03/oracle-weblogic-141100-available.html</a> and <a href="https://dirknachbar.blogspot.com/2020/03/oracle-weblogic-141100-first-look.html" target="_blank">https://dirknachbar.blogspot.com/2020/03/oracle-weblogic-141100-first-look.html</a>), it's time to test Oracle WebLogic Server 14.1.1.0.0 and the Oracle WebLogic Monitoring Exporter <a href="https://github.com/oracle/weblogic-monitoring-exporter" target="_blank">https://github.com/oracle/weblogic-monitoring-exporter</a><br />
<br />
In a previous blogpost (<a href="https://dirknachbar.blogspot.com/2020/02/weblogic-monitoring-with-prometheus-and.html" target="_blank">https://dirknachbar.blogspot.com/2020/02/weblogic-monitoring-with-prometheus-and.html</a>) I was already talking about the Oracle WebLogic Monitoring Exporter, which is generating Prometheus conform metrics out of the Oracle WebLogic Server 12.2.x.<br />
<br />
In the WebLogic Monitoring Exporter release 1.1.1 was a small issue with the option "domainQualifier: true". This option was causing, that a non Prometheus conform metric was generated and therefor your Prometheus Server couldn't capture the metrics.<br />
With the actual release 1.1.2 of the WebLogic Monitoring Exporter this issue is fixed, many thanks to the Development Team behind the WebLogic Monitoring Exporter.<br />
<br />
So, what you will need, is a running WebLogic Server 14.1.1.0.0 domain, download the get1.1.2.sh file from <a href="https://github.com/oracle/weblogic-monitoring-exporter/releases" target="_blank">https://github.com/oracle/weblogic-monitoring-exporter/releases</a> and create a YAML file for the to be generated metrics:<br />
<div>
<br /></div>
<div>
<pre class="brush:bash">#
$ cat exporter-config.yml
metricsNameSnakeCase: true
domainQualifier: true
queries:
- key: name
keyName: location
prefix: wls_server_
applicationRuntimes:
key: name
keyName: app
componentRuntimes:
prefix: wls_webapp_config_
type: WebAppComponentRuntime
key: name
values: [deploymentState, contextRoot, sourceInfo, sessionsOpenedTotalCount, openSessionsCurrentCount, openSessionsHighCount]
servlets:
prefix: wls_servlet_
key: servletName
- JVMRuntime:
prefix: wls_jvm_
key: name
- executeQueueRuntimes:
prefix: wls_socketmuxer_
key: name
values: [pendingRequestCurrentCount]
- workManagerRuntimes:
prefix: wls_workmanager_
key: name
values: [stuckThreadCount, pendingRequests, completedRequests]
- threadPoolRuntime:
prefix: wls_threadpool_
key: name
values: [executeThreadTotalCount, queueLength, stuckThreadCount, hoggingThreadCount]
- JMSRuntime:
key: name
keyName: jmsruntime
prefix: wls_jmsruntime_
JMSServers:
prefix: wls_jms_
key: name
keyName: jmsserver
destinations:
prefix: wls_jms_dest_
key: name
keyName: destination
- persistentStoreRuntimes:
prefix: wls_persistentstore_
key: name
- JDBCServiceRuntime:
JDBCDataSourceRuntimeMBeans:
prefix: wls_datasource_
key: name
- JTARuntime:
prefix: wls_jta_
key: name
</pre>
<div>
Place the get1.1.2.sh and the YAML file in one directory and execute from your Shell following command, which will add your YAML file into the wls-exporter.war file.</div>
<div>
<br /></div>
<div>
<pre class="brush:bash">#
$ ls -la
-rw-r--r-- 1 oracle oinstall 1401 Apr 2 11:46 exporter-config.yml
-rwxr-xr-x@ 1 oracle oinstall 373 Apr 2 11:43 get1.1.2.sh
$ ./get1.1.2.sh exporter-config.yml
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 607 100 607 0 0 1568 0 --:--:-- --:--:-- --:--:-- 1564
100 2018k 100 2018k 0 0 937k 0 0:00:02 0:00:02 --:--:-- 2009k
created /var/folders/b_/ldw8b91n7h7dp58hd3xf2qmc0000gn/T/ci-XXXXXXXXXX.EUmQ8eka
/var/folders/b_/ldw8b91n7h7dp58hd3xf2qmc0000gn/T/ci-XXXXXXXXXX.EUmQ8eka ~/Downloads/test
in temp dir
updating: config.yml
zip warning: Local Entry CRC does not match CD: config.yml
(deflated 64%)
~/Downloads/test
$ ls -la wls-exporter.war
-rw-r--r-- 1 oracle oinstall 2066869 Apr 2 11:47 wls-exporter.war
</pre>
Now, just deploy the newly generated war file wls-exporter.war on your WebLogic 14.1.1.0.0 domain, start the webapp and you can access the metrics over the URL http://<Your Servername>:<Port of Managed Server or AdminServer>/wls-exporter/metrics</div>
<div>
<br /></div>
<div>
Snippet from an AdminServer</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7AHVupAu0u6Ghyl_94I5dwgar33MbSp16twjCHwZmTjw2BrnznLBF_gOA65hufc4VsKtfuLhWhGeEL0k9ht_QGZaCfGKcXhn1AX6ge7A477dUunmX2enwnFmYTmq7LBCLnyHOeh3azcU/s1600/prometheus_adminserver.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="332" data-original-width="1443" height="146" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7AHVupAu0u6Ghyl_94I5dwgar33MbSp16twjCHwZmTjw2BrnznLBF_gOA65hufc4VsKtfuLhWhGeEL0k9ht_QGZaCfGKcXhn1AX6ge7A477dUunmX2enwnFmYTmq7LBCLnyHOeh3azcU/s640/prometheus_adminserver.png" width="640" /></a></div>
<div>
Snippet from a Managed Server</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCOqKjfLeTtbur7-DvmhIuXA14hrf_gVUAFUJRTyn9_TeiVB4JzSx9PslQ-ga9L4YFuWTqoqUlL5xWJMKABUkHktMuzM5cBI_NCslbn4AtYwZrCNuo3Wpam0FVukpBr_wEEfFMk7OHA6U/s1600/prometheus_managedserver.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="251" data-original-width="1404" height="110" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCOqKjfLeTtbur7-DvmhIuXA14hrf_gVUAFUJRTyn9_TeiVB4JzSx9PslQ-ga9L4YFuWTqoqUlL5xWJMKABUkHktMuzM5cBI_NCslbn4AtYwZrCNuo3Wpam0FVukpBr_wEEfFMk7OHA6U/s640/prometheus_managedserver.png" width="640" /></a></div>
<div>
<br /></div>
<div>
How to integrate the metrics from your WebLogic Server 14.1.1.0.0 into your Prometheus, just have a look on my previous blogpost "Weblogic Monitoring with Prometheus and Grafana" <a href="https://dirknachbar.blogspot.com/2020/02/weblogic-monitoring-with-prometheus-and.html" target="_blank">https://dirknachbar.blogspot.com/2020/02/weblogic-monitoring-with-prometheus-and.html</a>. The method remains the same as for Oracle WebLogic Server 12.2.x</div>
<div>
<br /></div>
<div>
<br /></div>
</div>
Dirk Nachbarhttp://www.blogger.com/profile/07873896834616675757noreply@blogger.comtag:blogger.com,1999:blog-4344684978957885806.post-91637503260221780312020-04-01T16:21:00.000+02:002020-04-01T16:21:09.182+02:00Oracle WebLogic Server 14.1.1.0.0 Docker ImageAs since around 2 days the latest Oracle WebLogic Server 14.1.1.0.0 was released, I had some time to create Docker Images for the Oracle WebLogic Server 14.1.1.0.0<br />
<br />
I have created two versions based on WebLogic Server 14.1.1.0.0 Generic with JDK 11:<br />
<ul>
<li>General Docker Image (not optimized with space usage)</li>
<li>Optimized Docker Image (nearly 50% space savings)</li>
</ul>
The corresponding Dockerfiles and so on you can find in my GitHub Repository <a href="https://github.com/DirkNachbar/Docker/tree/master/OracleWebLogic" target="_blank">https://github.com/DirkNachbar/Docker/tree/master/OracleWebLogic</a><br />
The Readme for the usage is under <a href="https://github.com/DirkNachbar/Docker/blob/master/OracleWebLogic/README1411.md" target="_blank">https://github.com/DirkNachbar/Docker/blob/master/OracleWebLogic/README1411.md</a><br />
<br />
So just clone the above mentioned GitHub Repository, get the 2 required installation files:<br />
<ul>
<li>WebLogic Server 14.1.1.0.0 Generic <a href="https://www.oracle.com/middleware/technologies/fusionmiddleware-downloads.html" target="_blank">https://www.oracle.com/middleware/technologies/fusionmiddleware-downloads.html</a></li>
<li>Oracle JDK 11.0.6 tar.gz file <a href="https://www.oracle.com/java/technologies/javase-jdk11-downloads.html" target="_blank">https://www.oracle.com/java/technologies/javase-jdk11-downloads.html</a></li>
</ul>
Drop the WebLogic 14.1.1.0.0 Generic installer into the directory Docker/OracleWebLogic/dockerfiles/14.1.1.0.0<br />
Drop the JDK 11.0.6 installer into the directory Docker/OracleWebLogic/dockerfiles/14.1.1.0.0/serverjre/java-11<br />
<br />
At first you need to run the script Docker/OracleWebLogic/dockerfiles/14.1.1.0.0/serverjre/java-11/buildDockerImage.sh<br />
After that you should have a Docker Image for your JDK 11.<br />
<br />
<pre class="brush:bash">#
docker images | grep jdk
REPOSITORY TAG IMAGE ID CREATED SIZE
oracle/jdk 11 19088de5fc56 23 minutes ago 422MB
</pre>
<br />
As next you have to run the script Docker/OracleWebLogic/dockerfiles/buildDockerImage.sh<br />
<br />
<pre class="brush:bash">#
$ ./buildDockerImage.sh -v 14.1.1.0.0 -o
Checking if required packages are present and valid...
fmw_14.1.1.0.0_wls_Disk1_1of1.zip: OK
=====================
Building image 'oracle/weblogic:14.1.1.0.0-optimized' ...
Sending build context to Docker daemon 1.111GB
Step 1/17 : FROM oracle/jdk:11 as base
. . .
. . .
Successfully built ebe06a93a85b
Successfully tagged oracle/weblogic:14.1.1.0.0-optimized
WebLogic Docker Image for 'optimized' version 14.1.1.0.0 is ready to be extended:
--> oracle/weblogic:14.1.1.0.0-optimized
Build completed in 76 seconds.
$ docker images | grep weblogic
REPOSITORY TAG IMAGE ID CREATED SIZE
oracle/weblogic 14.1.1.0.0-optimized ebe06a93a85b 5 minutes ago 1.62GB
</pre>
<br />
In order to get a running WebLogic 14.1.1.0.0 Container you just need to align at first the domain.properties under Docker/OracleWebLogic/dockerfiles/14.1.1.0.0/properties with your preferred WebLogic username and password and execute your docker run command<br />
<br />
<pre class="brush:bash">#
# Define the Docker Image based on your above Docker Image build
# Either its "oracle/weblogic:14.1.1.0.0-optimized" or "oracle/weblogic:14.1.1.0.0-generic"
$ docker run -d --name <ContainerName> \
-p 7001:7001 -p 9002:9002 \
-v <Host Path to subdirectory properties>:/u01/oracle/properties \
-e ADMINISTRATION_PORT_ENABLED=true -e DOMAIN_NAME=<DomainName> \
oracle/weblogic:14.1.1.0.0-optimized
$ docker logs -f <ContainerName>
# For Example:
$ docker run -d --name wls1411optimized \
-p 7001:7001 -p 9002:9002 \
-v /projects/Docker/OracleWebLogic/dockerfiles/14.1.1.0.0/properties:/u01/oracle/properties \
-e ADMINISTRATION_PORT_ENABLED=true -e DOMAIN_NAME=OptimizedDomain \
oracle/weblogic:14.1.1.0.0-optimized
$ docker logs -f wls1411optimized
. . .
. . .
<Apr 1, 2020, 12:40:28,980 PM Greenwich Mean Time> <Notice> <WebLogicServer> <BEA-000329> <Started the WebLogic Server Administration Server "AdminServer" for domain "OptimizedDomain" running in production mode.>
<Apr 1, 2020, 12:40:28,980 PM Greenwich Mean Time> <Notice> <Server> <BEA-002613> <Channel "DefaultSecure" is now listening on 172.17.0.2:7002 for protocols iiops, t3s, ldaps, https.>
<Apr 1, 2020, 12:40:28,981 PM Greenwich Mean Time> <Notice> <Server> <BEA-002613> <Channel "Default" is now listening on 172.17.0.2:7001 for protocols iiop, t3, ldap, snmp, http.>
<Apr 1, 2020, 12:40:28,981 PM Greenwich Mean Time> <Notice> <Server> <BEA-002613> <Channel "Default[1]" is now listening on 127.0.0.1:7001 for protocols iiop, t3, ldap, snmp, http.>
<Apr 1, 2020, 12:40:28,982 PM Greenwich Mean Time> <Notice> <Server> <BEA-002613> <Channel "DefaultSecure[1]" is now listening on 127.0.0.1:7002 for protocols iiops, t3s, ldaps, https.>
<Apr 1, 2020, 12:40:28,983 PM Greenwich Mean Time> <Notice> <Server> <BEA-002613> <Channel "DefaultSecure" is now listening on 172.17.0.2:7002 for protocols iiops, t3s, ldaps, https.>
<Apr 1, 2020, 12:40:28,983 PM Greenwich Mean Time> <Notice> <Server> <BEA-002613> <Channel "Default" is now listening on 172.17.0.2:7001 for protocols iiop, t3, ldap, snmp, http.>
<Apr 1, 2020, 12:40:28,984 PM Greenwich Mean Time> <Notice> <Server> <BEA-002613> <Channel "Default[1]" is now listening on 127.0.0.1:7001 for protocols iiop, t3, ldap, snmp, http.>
<Apr 1, 2020, 12:40:29,010 PM Greenwich Mean Time> <Notice> <WebLogicServer> <BEA-000360> <The server started in RUNNING mode.>
<Apr 1, 2020, 12:40:29,021 PM Greenwich Mean Time> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to RUNNING.>
</pre>
<br />
<br />Dirk Nachbarhttp://www.blogger.com/profile/07873896834616675757noreply@blogger.comtag:blogger.com,1999:blog-4344684978957885806.post-61428236844529907262020-03-31T13:29:00.000+02:002020-03-31T13:29:31.749+02:00Oracle WebLogic 14.1.1.0.0 - First LookSince last night the Oracle WebLogic Server 14.1.1.0.0 is available for download (see my previous blog post <a href="https://dirknachbar.blogspot.com/2020/03/oracle-weblogic-141100-available.html" target="_blank">https://dirknachbar.blogspot.com/2020/03/oracle-weblogic-141100-available.html</a>).<br />
<br />
Now let's have a look on the new Oracle WebLogic Server 14.1.1.0.0<br />
<br />
At first we can use now a JDK 11 with the WebLogic Server 14.1.1.0.0, for the following showcase I am using a JDK 11.0.6.<br />
<br />
At first download the required software installation files:<br />
<br />
<ul>
<li>WebLogic Server 14.1.1.0.0 Generic <a href="https://www.oracle.com/middleware/technologies/fusionmiddleware-downloads.html" target="_blank">https://www.oracle.com/middleware/technologies/fusionmiddleware-downloads.html</a></li>
<li>JDK 11.0.6 <a href="https://www.oracle.com/java/technologies/javase-jdk11-downloads.html" target="_blank">https://www.oracle.com/java/technologies/javase-jdk11-downloads.html</a></li>
</ul>
<br />
Then transfer the above files to your target server. For the JDK installation, my personal preferences are, that I install the JDK under the oracle software user, so that I am independent from the Java delivered and maintained by the Linux distribution. For example:<br />
<br />
<pre class="brush:bash"># Align the target directory
# for the JDK 11 to your settings
mv /tmp/jdk-11.0.6_linux-x64_bin.tar.gz /u00/app/oracle/product
gunzip jdk-11.0.6_linux-x64_bin.tar.gz
tar -xvf jdk-11.0.6_linux-x64_bin.tar
export JAVA_HOME=/u00/app/oracle/product/jdk-11.0.6
export PATH=$JAVA_HOME/bin:$PATH
</pre>
<br />
As next unzip the WebLogic Server 14.1.1.0.0 Generic Installer zip file.<br />
<br />
<pre class="brush:bash">cd /tmp
unzip fmw_14.1.1.0.0_wls_Disk1_1of1.zip
java -jar fmw_14.1.1.0.0_wls.jar
Launcher log file is /tmp/OraInstall2020-03-31_11-35-42AM/launcher2020-03-31_11-35-42AM.log.
Extracting the installer . . . . . . Done
Checking if CPU speed is above 300 MHz. Actual 2194.918 MHz Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Checking swap space: must be greater than 512 MB. Actual 3071 MB Passed
Checking temp space: must be greater than 300 MB. Actual 10290 MB Passed
Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2020-03-31_11-35-42AM
</pre>
<br />
At first set your Oracle Inventory and align the operating system group<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMf2EpSA0P5Jhf0pkKWkbkRThHIMYJvsU6vw1KeRGw_RARR5vIWvOTU20YjF2IlvFCelD-Cbyc9-lz6CTPw3Vx3smmqVhoKC9vpeTaO5D7vTBUDFqM5jnoH1u0-aSmPQk6PR3Ywvzpz78/s1600/01_wls_install.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="864" data-original-width="1244" height="444" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMf2EpSA0P5Jhf0pkKWkbkRThHIMYJvsU6vw1KeRGw_RARR5vIWvOTU20YjF2IlvFCelD-Cbyc9-lz6CTPw3Vx3smmqVhoKC9vpeTaO5D7vTBUDFqM5jnoH1u0-aSmPQk6PR3Ywvzpz78/s640/01_wls_install.png" width="640" /></a></div>
<br />
Then confirm the Welcome screen with the button Next<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOUrlgg3LqEzSDIKWQ2r2q4_YYVa1-yjMV7tFK10_3es2ytYTUpTJQM2Js6wa9h0f5_CQoZ9C314G_0HIbWJnT3vPdAf1N0gW8bZngjEVw4C6K4k_j9ebGJw5U51n8LSd4JaHKBQvv4R4/s1600/02_wls_install.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1298" data-original-width="1600" height="514" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOUrlgg3LqEzSDIKWQ2r2q4_YYVa1-yjMV7tFK10_3es2ytYTUpTJQM2Js6wa9h0f5_CQoZ9C314G_0HIbWJnT3vPdAf1N0gW8bZngjEVw4C6K4k_j9ebGJw5U51n8LSd4JaHKBQvv4R4/s640/02_wls_install.png" width="640" /></a></div>
<br />
Select Skip Auto Updates and proceed with the Next button<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXb2oEdHC7C73KKMl-ZSlIxz-ctKGh6R7FuzvBOEmRpuk-VOVeBMgAkzGFYenPurpd_Lq7Xz9wlUjXB7JCsAYAp_KibrJ88F1k0cJoehzrOPl948oWs3z2-bsNu_R5tRWMDnoUpnK53wA/s1600/03_wls_install.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1298" data-original-width="1600" height="514" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXb2oEdHC7C73KKMl-ZSlIxz-ctKGh6R7FuzvBOEmRpuk-VOVeBMgAkzGFYenPurpd_Lq7Xz9wlUjXB7JCsAYAp_KibrJ88F1k0cJoehzrOPl948oWs3z2-bsNu_R5tRWMDnoUpnK53wA/s640/03_wls_install.png" width="640" /></a></div>
<br />
Set the target ORACLE_HOME to your environment<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTDGhcnssNUVMWaKtHQjjGyPQ_7c9c4hKyETCYNEfqWU4Zi54w2XBIJPa14U4I0kiLkfg45FB-OLQRtAXnhT1qcL7YVKxJYLLzG7PVzEIYFgo5jD6kpUyjBXzKPSW-iMzAK10y6HeJdjg/s1600/04_wls_install.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1298" data-original-width="1600" height="514" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTDGhcnssNUVMWaKtHQjjGyPQ_7c9c4hKyETCYNEfqWU4Zi54w2XBIJPa14U4I0kiLkfg45FB-OLQRtAXnhT1qcL7YVKxJYLLzG7PVzEIYFgo5jD6kpUyjBXzKPSW-iMzAK10y6HeJdjg/s640/04_wls_install.png" width="640" /></a></div>
<br />
Choose the Installation Type, either WebLogic or Coherence or Complete with Examples<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiY_xgUrRaVVAzOAqPhNjznHYdrMdIE7PvJDQZ8Hh-YGoRVnC57VFg4OgLMIpKigkENlV_ptevtY4qQRQIc-h27_nCnlbZS4r-iEAO63NU4bcxIcq05cwk_iKNriqnOMlDexjMVuTV2SPY/s1600/05_wls_install.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1298" data-original-width="1600" height="514" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiY_xgUrRaVVAzOAqPhNjznHYdrMdIE7PvJDQZ8Hh-YGoRVnC57VFg4OgLMIpKigkENlV_ptevtY4qQRQIc-h27_nCnlbZS4r-iEAO63NU4bcxIcq05cwk_iKNriqnOMlDexjMVuTV2SPY/s640/05_wls_install.png" width="640" /></a></div>
<br />
The Prerequisite Checks are executed, be sure that they successfully completed<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhan_rH-g9oUP518HGnOhvgnr1_aUBiJVHMv6zzZYVq8KccChkReEB7T8b78Ed40_NUR00xbZwBhtniOF8KsKNVlLrkPwMyEr105LBa8cd-Q-5HZDHeXZtkILJ_18Df0K7_GuVVFKuXzDU/s1600/06_wls_install.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1298" data-original-width="1600" height="514" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhan_rH-g9oUP518HGnOhvgnr1_aUBiJVHMv6zzZYVq8KccChkReEB7T8b78Ed40_NUR00xbZwBhtniOF8KsKNVlLrkPwMyEr105LBa8cd-Q-5HZDHeXZtkILJ_18Df0K7_GuVVFKuXzDU/s640/06_wls_install.png" width="640" /></a></div>
<br />
Confirm the Installation Summary with the Next button<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQKk-tA8XrJM4BgvsuvsZEiOny8WOBxjXdmSaMweSLC8hWM_YBUSbbFbrqXJIa9F3pFLdFzatkGp7h8WgjGYn01otpHWvJRpydivPd3O5H7xQftLbERLe2gE9MEShbRd_dD75Kv-i_nIg/s1600/07_wls_install.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1298" data-original-width="1600" height="514" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQKk-tA8XrJM4BgvsuvsZEiOny8WOBxjXdmSaMweSLC8hWM_YBUSbbFbrqXJIa9F3pFLdFzatkGp7h8WgjGYn01otpHWvJRpydivPd3O5H7xQftLbERLe2gE9MEShbRd_dD75Kv-i_nIg/s640/07_wls_install.png" width="640" /></a></div>
<br />
The installation is starting now<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbhJsOYgORax4i6Pocpn1cXBLtzsKts2lkfTWZKosx2y25nbpI2tMQ4US5y9yLe911qx0ky4mW1kC7LGTvWKYIndJ8-HKTVAvAXgl_zDT4ijS_Q9Qq1Tz30O1HEyF3dJduCWClpW3GuKY/s1600/08_wls_install.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1298" data-original-width="1600" height="514" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbhJsOYgORax4i6Pocpn1cXBLtzsKts2lkfTWZKosx2y25nbpI2tMQ4US5y9yLe911qx0ky4mW1kC7LGTvWKYIndJ8-HKTVAvAXgl_zDT4ijS_Q9Qq1Tz30O1HEyF3dJduCWClpW3GuKY/s640/08_wls_install.png" width="640" /></a></div>
<br />
When the Installation Progress is reaching 100% you can proceed with the Next button.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhM53HiwMfNMTLOIHMb4XM8BGG7W6oUgnjdY_ZLbBass5Md575zKMe_ZSmN1aDL6zPUrXuYqXfq6sRmFe_5VJ-wqKdDkMzI6Cpw7-zRh42apOujLE0Z_fCQ0pmEulehc-XGB3U4MUuq6zk/s1600/09_wls_install.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1298" data-original-width="1600" height="514" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhM53HiwMfNMTLOIHMb4XM8BGG7W6oUgnjdY_ZLbBass5Md575zKMe_ZSmN1aDL6zPUrXuYqXfq6sRmFe_5VJ-wqKdDkMzI6Cpw7-zRh42apOujLE0Z_fCQ0pmEulehc-XGB3U4MUuq6zk/s640/09_wls_install.png" width="640" /></a></div>
<br />
Under the Installation Complete screen you can find a summing up of the installation.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMLkynWhRveSCH0cqiY_4OS1_ZH5ISdXXyGx1oHGdMRT51u5YCiDBq8IeFXM7WAeApNo6QNV_6e2Vs4XMusuC6zUZwTJ7uivxn2Aq6sW6nrj8q6-QML6vfV6DCtI6TclJrkg3LJJ_SZTQ/s1600/10_wls_install.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1298" data-original-width="1600" height="514" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMLkynWhRveSCH0cqiY_4OS1_ZH5ISdXXyGx1oHGdMRT51u5YCiDBq8IeFXM7WAeApNo6QNV_6e2Vs4XMusuC6zUZwTJ7uivxn2Aq6sW6nrj8q6-QML6vfV6DCtI6TclJrkg3LJJ_SZTQ/s640/10_wls_install.png" width="640" /></a></div>
<br />
As next go to the $MW_HOME/oracle_common/common/bin directory and start the Configuration Wizard to create a WebLogic 14.1.1.0.0 Domain.<br />
<br />
<pre class="brush:bash">#
cd $MW_HOME/oracle_common/common/bin
./config.sh
</pre>
<br />
The Configuration Wizard is the same as in the previous releases of Oracle WebLogic Server, so just get through the various settings and configure and create your WebLogic Domain, then startup your NodeManager ($DOMAIN_HOME/bin/startNodeManager.sh) and the WebLogic Server AdminServer ($DOMAIN_HOME/startWebLogic.sh).<br />
<br />
Now you can connect to the WebLogic Console http://<Your ServerName>:<AdminServerPort>/console and login with your weblogic user and password<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtvUW6saeFeGTeH3HDR-DjvXyl10eYB2bzjYRLP-ynzcwB7i5zBQG66olNegSyKgysryOQfTXS9dQkSunsJvLgpJrr_tT49ITtYf4bkDIfr4zXeptykYUE-aP1vi2G1M8ltS-FYB_10bE/s1600/01_wls_console.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="829" data-original-width="1600" height="330" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtvUW6saeFeGTeH3HDR-DjvXyl10eYB2bzjYRLP-ynzcwB7i5zBQG66olNegSyKgysryOQfTXS9dQkSunsJvLgpJrr_tT49ITtYf4bkDIfr4zXeptykYUE-aP1vi2G1M8ltS-FYB_10bE/s640/01_wls_console.png" width="640" /></a></div>
<br />
As you can see under the Domain Structure Navigation, that under the entry Environment the element Partition is gone. From WebLogic 14.1.1.0.0 the Multitenant (Partitions) option is removed<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjwETorsntGKM5IYVGkb-MlLf7EsS6PTo8au4NAx0PnlffxZsYj5yFOFqX1CdVvVXj61RiYXtR0BRSqImKKmpfd_NRSrRStCkf2yttCeg0bywqE-qKJdivxiuxdB-4PqX8R519ibs41YY/s1600/02_wls_console.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1340" data-original-width="1148" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjwETorsntGKM5IYVGkb-MlLf7EsS6PTo8au4NAx0PnlffxZsYj5yFOFqX1CdVvVXj61RiYXtR0BRSqImKKmpfd_NRSrRStCkf2yttCeg0bywqE-qKJdivxiuxdB-4PqX8R519ibs41YY/s640/02_wls_console.png" width="546" /></a></div>
<br />
<br />
<br />Dirk Nachbarhttp://www.blogger.com/profile/07873896834616675757noreply@blogger.comtag:blogger.com,1999:blog-4344684978957885806.post-82670713889363150912020-03-31T09:47:00.001+02:002020-03-31T09:47:37.144+02:00Oracle WebLogic 14.1.1.0.0 availableSince last night the latest release of the Oracle WebLogic Server 14.1.1.0.0 is available for download.<br />
<br />
There are 3 different installation types available for download:<br />
<br />
<ul>
<li>Generic Installer (888 MB)</li>
<li>Quick Installer (514 MB)</li>
<li>Slim Installer (474 MB)</li>
</ul>
<br />
The software download files can be found under: <a href="https://www.oracle.com/middleware/technologies/fusionmiddleware-downloads.html" target="_blank">https://www.oracle.com/middleware/technologies/fusionmiddleware-downloads.html</a><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiiUQixi53hj0GwDi-5TyJUcT1Gjhtv513v5geVzmP6T97Z2AH8WysnCy741GN-WAerlzebZ38sCuyFESALy6RIAU0ivmbCKcvqOe_KHE1G2fwlql2vPvl7dLqxh-YYq0igO9mFmBAaSbM/s1600/WLS1411_download.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="872" data-original-width="1600" height="348" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiiUQixi53hj0GwDi-5TyJUcT1Gjhtv513v5geVzmP6T97Z2AH8WysnCy741GN-WAerlzebZ38sCuyFESALy6RIAU0ivmbCKcvqOe_KHE1G2fwlql2vPvl7dLqxh-YYq0igO9mFmBAaSbM/s640/WLS1411_download.png" width="640" /></a></div>
<br />
<br />
The overall Oracle WebLogic Server 14.1.1.0.0 documentation can be found under <a href="https://docs.oracle.com/en/middleware/standalone/weblogic-server/14.1.1.0/index.html" target="_blank">https://docs.oracle.com/en/middleware/standalone/weblogic-server/14.1.1.0/index.html</a><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFspCjJiF8VUgQgmlCIDLmvD5DiHPy3YFz6VGnZsi5PscCGYm9SzG5tWaXvXoyr89kOr0JUo9Wh97fPlgU5siN2lRh3io2S6aKzN77uo-WgP4gvhf3jatCtu4_oKdNgTN81IqsbppxfNw/s1600/WLS1411_docu.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="728" data-original-width="1600" height="290" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFspCjJiF8VUgQgmlCIDLmvD5DiHPy3YFz6VGnZsi5PscCGYm9SzG5tWaXvXoyr89kOr0JUo9Wh97fPlgU5siN2lRh3io2S6aKzN77uo-WgP4gvhf3jatCtu4_oKdNgTN81IqsbppxfNw/s640/WLS1411_docu.png" width="640" /></a></div>
<br />
<br />
The "What's new in WebLogic Server" guide can be found under: <a href="https://www.oracle.com/pls/topic/lookup?ctx=en/middleware/standalone/weblogic-server/14.1.1.0&id=NOTES107" target="_blank">https://www.oracle.com/pls/topic/lookup?ctx=en/middleware/standalone/weblogic-server/14.1.1.0&id=NOTES107</a><br />
<br />
Now with the latest Oracle WebLogic 14.1.1.0.0 you will have the official certification for Java 11. A complete overview of the Oracle WebLogic 14.1.1.0.0 Certification you can find in the Excel Sheet <a href="https://www.oracle.com/technetwork/middleware/fmw-141100-certmatrix-6400512.xlsx" target="_blank">https://www.oracle.com/technetwork/middleware/fmw-141100-certmatrix-6400512.xlsx</a><br />
<br />
<br />Dirk Nachbarhttp://www.blogger.com/profile/07873896834616675757noreply@blogger.comtag:blogger.com,1999:blog-4344684978957885806.post-13345519625221165002020-03-30T13:23:00.001+02:002020-03-30T13:23:50.944+02:00Oracle Fusion Middleware 12.2.1.4.0 certified with Linux 8Currently Oracle certified the Oracle Fusion Middleware 12.2.1.4.0 Components for the use of Linux 8, which includes the Oracle Linux 8 and the Red Hat Enterprise Linux 8.<br />
<br />
You can find the newly added certifications in My Oracle Support (<a href="https://support.oracle.com/" target="_blank">https://support.oracle.com</a>) under the tab Certifications:<br />
<br />
Oracle WebLogic 12.2.1.4.0 Certification:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibAK2MG7s5fm07GdWRbAN6zRO11uo7CHlt6HhjOzQHPc_k85MPkyc_AMLHnHQeZUZS4AvY8ppJ_86Ex2smdmzdBLKjm-wAAwghu9YFjK22nWkbtbLa4JXOKGzSMo2IB472buQqPB4F2ew/s1600/wls122140_linux8.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="515" data-original-width="1600" height="206" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibAK2MG7s5fm07GdWRbAN6zRO11uo7CHlt6HhjOzQHPc_k85MPkyc_AMLHnHQeZUZS4AvY8ppJ_86Ex2smdmzdBLKjm-wAAwghu9YFjK22nWkbtbLa4JXOKGzSMo2IB472buQqPB4F2ew/s640/wls122140_linux8.png" width="640" /></a></div>
<br />
<br />
Oracle Forms & Reports 12.2.1.4.0 Certification:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhxahKKyNyBSr_aXjNGYj4niSZhJFYsAlnOeAoW2QSUyeyGp0PMh72DN_Y_cqe7Grm-1Ghd7-2HEscj-FIxkewiA14P1Rn8qJJphFEnuT5qxxi-QVu-kmkpOyxqqbFjpCLuXOhfZW2au5w/s1600/forms122140_linux8.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="515" data-original-width="1600" height="206" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhxahKKyNyBSr_aXjNGYj4niSZhJFYsAlnOeAoW2QSUyeyGp0PMh72DN_Y_cqe7Grm-1Ghd7-2HEscj-FIxkewiA14P1Rn8qJJphFEnuT5qxxi-QVu-kmkpOyxqqbFjpCLuXOhfZW2au5w/s640/forms122140_linux8.png" width="640" /></a></div>
<br />
<br />
Oracle SOA Suite 12.2.1.4.0 Certification:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIPL9KGBSSIw5ubDb_cr6YkoFi0uR0bP0IVneSSFxVPsdB7PpoUuDVmO6CSqkTbrEls-ZmSMdgY2ytyPvbPlL3gXPqeUvfx7FbWUW3KNe9tsy8FtrV9hNlV8kiObbLZqy1kbUglP-iaW8/s1600/soa122140_linux8.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="515" data-original-width="1600" height="206" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIPL9KGBSSIw5ubDb_cr6YkoFi0uR0bP0IVneSSFxVPsdB7PpoUuDVmO6CSqkTbrEls-ZmSMdgY2ytyPvbPlL3gXPqeUvfx7FbWUW3KNe9tsy8FtrV9hNlV8kiObbLZqy1kbUglP-iaW8/s640/soa122140_linux8.png" width="640" /></a></div>
<br />
<br />
Moreover you can find the corresponding Oracle Fusion Middleware 12c Certifications under <a href="https://www.oracle.com/middleware/technologies/fusion-certification.html" target="_blank">https://www.oracle.com/middleware/technologies/fusion-certification.html</a> and there the Excel Sheet <a href="https://www.oracle.com/technetwork/middleware/fmw-122140-certmatrix-5763476.xlsx" target="_blank">https://www.oracle.com/technetwork/middleware/fmw-122140-certmatrix-5763476.xlsx</a> which contains the newly added certification for Linux 8 (Oracle Linux 8 and Red Hat Enterprise Linux 8).<br />
<br />
Under the "Oracle Fusion Middleware System Requirements and Specifications" documentation for 12.2.1.4.0 in the section "Linux Operating System Requirements" (<a href="https://docs.oracle.com/en/middleware/fusion-middleware/12.2.1.4/sysrs/system-requirements-and-specifications.html#GUID-37C51062-3732-4A4B-8E0E-003D9DFC8C26" target="_blank">https://docs.oracle.com/en/middleware/fusion-middleware/12.2.1.4/sysrs/system-requirements-and-specifications.html#GUID-37C51062-3732-4A4B-8E0E-003D9DFC8C26</a>) you can find all required packages to be installed.<br />
Take note that 2 of them are EL7 packages (compat-libcap1-1.10-7.el7.x86_64 and compat-libstdc++-33-3.2.3-72.el7.x86_64), which are not longer present in the Linux 8 distributions, so when you install your Fusion Middleware 12.2.1.4.0 components just ignore the warnings/failure for the 2 EL7 packages by using the Skip button in the graphical installer.<br />
<br />
<br />Dirk Nachbarhttp://www.blogger.com/profile/07873896834616675757noreply@blogger.comtag:blogger.com,1999:blog-4344684978957885806.post-28042557818706007332020-03-02T11:24:00.000+01:002020-03-02T11:24:27.162+01:00Generating Prometheus Metrics directly from your Oracle DatabasePrometheus (<a href="https://prometheus.io/" target="_blank">https://prometheus.io/</a>) is getting more and more common as a Monitoring Solution, many products are offering out-of-box Prometheus formatted metrics (e.g WildFly, Spring Boot and so on). Even Oracle is providing for the Oracle WebLogic Server a weblogic-monitoring-exporter, which is generating Prometheus formatted metrics (see <a href="https://github.com/oracle/weblogic-monitoring-exporter" target="_blank">https://github.com/oracle/weblogic-monitoring-exporter</a> and checkout my previous blog post "WebLogic Monitoring with Prometheus and Grafana" <a href="https://dirknachbar.blogspot.com/2020/02/weblogic-monitoring-with-prometheus-and.html" target="_blank">https://dirknachbar.blogspot.com/2020/02/weblogic-monitoring-with-prometheus-and.html</a>).<br />
<br />
Many people are using Oracle Enterprise Manager for Oracle Database Monitoring, which makes sense if you have a certain environment size, but for some small environments, e.g. you have a couple of database, Oracle Enterprise Manager might be an overkill. On top, if you are running your Oracle Database in Docker, you might want to have an agent-less and lightweight monitoring alternative.<br />
<br />
So why not to use Prometheus? The problem is, Oracle is not providing Prometheus formatted metrics for the Oracle Database :-( but with a little bit of PL/SQL and Oracle REST Data Services (ORDS) you can get Prometheus formatted metrics out of your Oracle Database and you can define which metrics you want to get.<br />
<br />
The first step is to create a procedure which will collect your Prometheus formatted metrics, for this I am simply using the good old PL/SQL Webtool Kit. In my case I will create the procedure under the Oracle Database User dbsnmp, as this user got already the required permissions on the various v$ and dba_% views.<br />
<br />
The basic concept is really simply, at first define all the cursors you will need for collecting your required metrics, e.g. "c_process is SELECT COUNT(*) as count FROM v$process;" and later you will loop over the cursor and generate a output with htp.print. That's all ...<br />
<br />
Below is an example, which you can use as starting point to collect your metrics and you can easily add your own required metrics or remove them.<br />
<br />
<pre class="brush:bash">create or replace NONEDITIONABLE procedure prometheus_metrics IS
-- =======================================================================
-- Procedure prometheus_metrics
-- Purpose: Generating Prometheus formatted metrics from the Oracle DB
--
-- Author: Dirk Nachbar, https://dirknachbar.blogspot.com
--
-- =======================================================================
--
cursor c_processes is
SELECT COUNT(*) as count FROM v$process;
--
cursor c_sessions is
SELECT status, type, COUNT(*) as value FROM v$session GROUP BY status, type;
--
cursor c_activities is
SELECT name, value FROM v$sysstat WHERE name IN ('parse count (total)', 'execute count', 'user commits', 'user rollbacks');
--
cursor c_version is
select 'Oracle' as oracle, substr(version_full, 1,2)||'.'|| substr(version_full, 4,1) as value from v$instance;
--
cursor c_tablespaces is
SELECT
Z.name as tablespace,
dt.contents as type,
Z.bytes as bytes,
Z.max_bytes as max_bytes,
Z.free_bytes as free
FROM
(
SELECT
X.name as name,
SUM(nvl(X.free_bytes,0)) as free_bytes,
SUM(X.bytes) as bytes,
SUM(X.max_bytes) as max_bytes
FROM
(
SELECT
ddf.tablespace_name as name,
ddf.status as status,
ddf.bytes as bytes,
sum(coalesce(dfs.bytes, 0)) as free_bytes,
CASE
WHEN ddf.maxbytes = 0 THEN ddf.bytes
ELSE ddf.maxbytes
END as max_bytes
FROM
sys.dba_data_files ddf,
sys.dba_tablespaces dt,
sys.dba_free_space dfs
WHERE ddf.tablespace_name = dt.tablespace_name
AND ddf.file_id = dfs.file_id(+)
GROUP BY
ddf.tablespace_name,
ddf.file_name,
ddf.status,
ddf.bytes,
ddf.maxbytes
) X
GROUP BY X.name
UNION ALL
SELECT
Y.name as name,
MAX(nvl(Y.free_bytes,0)) as free_bytes,
SUM(Y.bytes) as bytes,
SUM(Y.max_bytes) as max_bytes
FROM
(
SELECT
dtf.tablespace_name as name,
dtf.status as status,
dtf.bytes as bytes,
(
SELECT
((f.total_blocks - s.tot_used_blocks)*vp.value)
FROM
(SELECT tablespace_name, sum(used_blocks) tot_used_blocks FROM gv$sort_segment WHERE tablespace_name!='DUMMY' GROUP BY tablespace_name) s,
(SELECT tablespace_name, sum(blocks) total_blocks FROM dba_temp_files where tablespace_name !='DUMMY' GROUP BY tablespace_name) f,
(SELECT value FROM v$parameter WHERE name = 'db_block_size') vp
WHERE f.tablespace_name=s.tablespace_name AND f.tablespace_name = dtf.tablespace_name
) as free_bytes,
CASE
WHEN dtf.maxbytes = 0 THEN dtf.bytes
ELSE dtf.maxbytes
END as max_bytes
FROM
sys.dba_temp_files dtf
) Y
GROUP BY Y.name
) Z, sys.dba_tablespaces dt
WHERE
Z.name = dt.tablespace_name;
--
cursor c_locked_accounts is
select username, case when account_status like '%LOCKED%' then '1' else '0' END value from dba_users where username in ('SYSTEM', 'SYS', 'DEMO');
--
cursor c_top_sessions is
SELECT a.username as username, a.sid, a.machine as machine, a.program as program, Trunc(b.value/1024) as memorykb
FROM v$session a,
v$sesstat b,
v$statname c
WHERE a.sid = b.sid
AND a.username is not null
AND b.statistic# = c.statistic#
AND c.name = 'session pga memory'
AND a.program IS NOT NULL
AND rownum <= 10
ORDER BY b.value DESC;
--
cursor c_fileio is
SELECT ddf.tablespace_name as tablespace_name, d.name as filename, f.phyblkrd as blocksread, f.phyblkwrt as blockswriten, f.phyblkrd + f.phyblkwrt as totalio FROM v$filestat f, v$datafile d, dba_data_files ddf WHERE d.file# = f.file# and ddf.file_id = d.file# ORDER BY f.phyblkrd + f.phyblkwrt DESC;
--
cursor c_sga_info is
SELECT decode(name, 'Fixed SGA Size','FixedSGASize','Redo Buffers','RedoBuffers','Buffer Cache Size','BufferCacheSize','In-Memory Area Size','InMemoryAreaSize','Shared Pool Size','SharedPoolSize','Large Pool Size','LargePoolSize','Java Pool Size','JavaPoolSize','Streams Pool Size','StreamsPoolSize','Shared IO Pool Size','SharedIOPoolSize','Data Transfer Cache Size','DataTransferCacheSize','Granule Size','GranuleSize','Maximum SGA Size','MaximumSGASize','Startup overhead in Shared Pool','StartupOverheadInSharedPool','Free SGA Memory Available','FreeSGAMemoryAvailable') name,
bytes as value
FROM v$sgainfo;
--
cursor c_db_status is
SELECT instance_name as name, decode(status, 'STARTED', 0, 'MOUNTED', 1, 'OPEN', 2, 'OPEMN MIGRATE', 3) as value
FROM v$instance;
--
cursor c_archiver_status is
SELECT instance_name as name, decode(archiver, 'STOPPED', 0, 'STARTED', 1, 'FAILED', 2) as value
FROM v$instance;
--
begin
owa.num_cgi_vars := 0;
htp.init();
--
-- Oracle Version
--
htp.print('# HELP oracle_version Oracle DB Version Number');
htp.print('# TYPE oracle_version counter');
for rec_version in c_version loop
htp.print('oracle_version ' || rec_version.value);
end loop;
--
-- Oracle Processes
--
htp.print('# HELP oracle_processes Current Number of processes');
htp.print('# TYPE oracle_processes counter');
for rec_processes in c_processes loop
htp.print('oracle_processes ' || rec_processes.count);
end loop;
--
-- Oracle Sessions
--
htp.print('# HELP oracle_sessions Current Number of sessions');
htp.print('# TYPE oracle_sessions counter');
for rec_sessions in c_sessions loop
htp.print('oracle_sessions{status="'||rec_sessions.status||'",type="'||rec_sessions.type||'"} ' || rec_sessions.value);
end loop;
--
-- Oracle Activities
--
htp.print('# HELP oracle_activity Metrics from v$sysstat');
htp.print('# TYPE oracle_activity counter');
for rec_activities in c_activities loop
htp.print('oracle_activities{name="'||rec_activities.name||'"} ' || rec_activities.value);
end loop;
--
-- Oracle Tablespaces
--
-- bytes
htp.print('# HELP oracle_tablespace_bytes Generic counter metric of tablespace bytes in Oracle DB');
htp.print('# TYPE oracle_tablespace_bytes gauge');
for rec_tablespaces in c_tablespaces loop
htp.print('oracle_tablespace_bytes{tablespace="'||rec_tablespaces.tablespace||'",type="'||rec_tablespaces.type||'"} ' || rec_tablespaces.bytes);
end loop;
-- free bytes
htp.print('# HELP oracle_tablespace_free Generic counter metric of tablespace free bytes in Oracle DB');
htp.print('# TYPE oracle_tablespace_free gauge');
for rec_tablespaces in c_tablespaces loop
htp.print('oracle_tablespace_bytes_free{tablespace="'||rec_tablespaces.tablespace||'",type="'||rec_tablespaces.type||'"} ' || rec_tablespaces.free);
end loop;
-- max bytes
htp.print('# HELP oracle_tablespace_max_bytes Generic counter metric of tablespace max bytes in Oracle DB');
htp.print('# TYPE oracle_tablespace_max_bytes gauge');
for rec_tablespaces in c_tablespaces loop
htp.print('oracle_tablespace_max_bytes{tablespace="'||rec_tablespaces.tablespace||'",type="'||rec_tablespaces.type||'"} ' || rec_tablespaces.max_bytes);
end loop;
--
-- Locked Accounts
--
htp.print('# HELP oracle_locked_accounts Metrics from dba_users');
htp.print('# TYPE oracle_locked_accounts counter');
for rec_locked_accounts in c_locked_accounts loop
htp.print('oracle_locked_accounts{username="'||rec_locked_accounts.username||'"} ' || rec_locked_accounts.value);
end loop;
--
-- File IO
--
htp.print('# HELP oracle_fileio Metrics from v$filestat, v$datafile');
htp.print('# TYPE oracle_fileio counter');
for rec_fileio in c_fileio loop
htp.print('oracle_fileio{tablespace_name="'||rec_fileio.tablespace_name||'",filename="'||rec_fileio.filename||'",type="blocksread"} ' || rec_fileio.blocksread);
htp.print('oracle_fileio{tablespace_name="'||rec_fileio.tablespace_name||'",filename="'||rec_fileio.filename||'",type="blockswriten"} ' || rec_fileio.blockswriten);
htp.print('oracle_fileio{tablespace_name="'||rec_fileio.tablespace_name||'",filename="'||rec_fileio.filename||'",type="totalio"} ' || rec_fileio.totalio);
end loop;
--
-- Top Sessions
--
htp.print('# HELP oracle_top_sessions Metrics from v$session, v$sesstat, v$statname');
htp.print('# TYPE oracle_top_sessions counter');
for rec_top_sessions in c_top_sessions loop
htp.print('oracle_top_sessions{username="'||rec_top_sessions.username||'",sid="'||rec_top_sessions.sid||'",program="'||rec_top_sessions.program||'"} ' || rec_top_sessions.memorykb);
end loop;
--
-- SGA Info
--
htp.print('# HELP oracle_sga_info Metrics from v$sgainfo');
htp.print('# TYPE oracle_sga_info counter');
for rec_sga_info in c_sga_info loop
htp.print('oracle_sga_info{name="'||rec_sga_info.name||'"} ' || rec_sga_info.value);
end loop;
--
-- DB Status
--
htp.print('# HELP oracle_db_status from v$instance');
htp.print('# TYPE oracle_db_status counter');
for rec_db_status in c_db_status loop
htp.print('oracle_db_status{name="'||rec_db_status.name||'"} ' || rec_db_status.value);
end loop;
--
-- Archiver Status
--
htp.print('# HELP oracle_archiver_status from v$instance');
htp.print('# TYPE oracle_archiver_status counter');
for rec_archiver_status in c_archiver_status loop
htp.print('oracle_archiver_status{name="'||rec_archiver_status.name||'"} ' || rec_archiver_status.value);
end loop;
end;
/
show err
</pre>
<br />
To test, if the metrics are generated correctly enable the OWA Output in your SQL Developer and execute the above created procedures.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhgDfFH6IQnf-8ISMFLJn9DxFQRxOv5ivQQBDO6PGBPMhwWReqZGxGqvGIR1uTjUnH1AGc6sr7bz9C3ITY-L9aBZrR9iezcBEfduhFU9BlFh1mJq1dqh79KPTY92SjZ0iTuaI7HBowSy0/s1600/sqldeveloper_test_prometheus_metrics.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1104" data-original-width="1600" height="440" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhgDfFH6IQnf-8ISMFLJn9DxFQRxOv5ivQQBDO6PGBPMhwWReqZGxGqvGIR1uTjUnH1AGc6sr7bz9C3ITY-L9aBZrR9iezcBEfduhFU9BlFh1mJq1dqh79KPTY92SjZ0iTuaI7HBowSy0/s640/sqldeveloper_test_prometheus_metrics.png" width="640" /></a></div>
<br />
<br />
As next we have to setup the Oracle REST Data Services (ORDS). I am using as a showcase the ORDS 19.4 release and will do a setup in Standalone Mode, so with the integrated Jetty Server, you can also deploy your ords.war into a Tomcat or an Oracle WebLogic Server.<br />
<br />
Download the ORDS 19.4 from Technical Resources from Oracle (former OTN) https://www.oracle.com/database/technologies/appdev/rest-data-services-downloads.html, transfer the zip file to your server and unzip it somewhere on your server, I am using /u00/app/oracle/product/ords-19.4 (so I am a bit OFA aligned).<br />
Then you have to run the install process:<br />
<br />
<pre class="brush:bash"> #
[oracle@prometheus ords-19.4]$ cd /u00/app/oracle/product/ords-19.4
[oracle@prometheus ords-19.4]$ java -jar ords.war install advanced
This Oracle REST Data Services instance has not yet been configured.
Please complete the following prompts
Enter the location to store configuration data: .
Specify the database connection type to use.
# Choose Option 1 for a Basic Connection String
Enter number for [1] Basic [2] TNS [3] Custom URL [1]:1
# Provide the Servername of your Database Server Host
Enter the name of the database server [localhost]:prometheus
# Provide the Listener Port or confirm the default value with 1521
Enter the database listen port [1521]:
# If you are using Database Service Names, choose Option 1
Enter 1 to specify the database service name, or 2 to specify the database SID [1]:
# Provide the Database Service Name
Enter the database service name:DB193
# Choose Option 2
Enter 1 if you want to verify/install Oracle REST Data Services schema or 2 to skip this step [1]:2
# Confirm the default Option 1
Enter 1 if you want to use PL/SQL Gateway or 2 to skip this step.
If using Oracle Application Express or migrating from mod_plsql then you must enter 1 [1]:
# Provide the Database User, in my case dbsnmp
Enter the PL/SQL Gateway database user name [APEX_PUBLIC_USER]:dbsnmp
# Provide 2 times the password of the above provided Database User
Enter the database password for dbsnmp:
Confirm password:
# Choose Option 3
Enter a number to select a feature to enable [1] SQL Developer Web [2] REST Enabled SQL [3] None [1]:3
2020-03-02T08:33:12.149Z INFO reloaded pools: []
# For showcases I am using the Standalone Mode, so choose Option 1
Enter 1 if you wish to start in standalone mode or 2 to exit [1]:
# Choose if you are using http or https, I choose 1 = http
Enter 1 if using HTTP or 2 if using HTTPS [1]:1
# Provide the http Port, in my case 7778
Enter the HTTP port [8080]:7778
2020-03-02 09:33:34.927:INFO::main: Logging initialized @84052ms to org.eclipse.jetty.util.log.StdErrLog
2020-03-02 09:33:34.967:INFO:oeju.TypeUtil:main: JVM Runtime does not support Modules
2020-03-02T08:33:35.017Z INFO HTTP and HTTP/2 cleartext listening on host: localhost port: 7778
2020-03-02T08:33:35.039Z INFO Disabling document root because the specified folder does not exist: /u00/app/oracle/product/ords-19.4/ords/standalone/doc_root
2020-03-02 09:33:35.342:INFO:oejs.Server:main: jetty-9.4.24.v20191120; built: 2019-11-22T11:09:44.612Z; git: 8b8c80157294e38f81ef8ea2358a0c49bf5db918; jvm 1.8.0_232-b09
2020-03-02 09:33:35.380:INFO:oejs.session:main: DefaultSessionIdManager workerName=node0
2020-03-02 09:33:35.380:INFO:oejs.session:main: No SessionScavenger set, using defaults
2020-03-02 09:33:35.381:INFO:oejs.session:main: node0 Scavenging every 660000ms
2020-03-02T08:33:36.218Z INFO Configuration properties for: |apex||
db.connectionType=basic
db.hostname=prometheus
db.port=1521
db.servicename=DB193
db.password=******
db.username=dbsnmp
resource.templates.enabled=true
2020-03-02T08:33:36.222Z WARNING *** jdbc.MaxLimit in configuration |apex|| is using a value of 10, this setting may not be sized adequately for a production environment ***
2020-03-02T08:33:36.222Z WARNING *** jdbc.InitialLimit in configuration |apex|| is using a value of 3, this setting may not be sized adequately for a production environment ***
2020-03-02T08:33:37.045Z INFO Oracle REST Data Services initialized
Oracle REST Data Services version : 19.4.0.r3521226
Oracle REST Data Services server info: jetty/9.4.24.v20191120
2020-03-02 09:33:37.524:INFO:oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@4470f8a6{/ords,null,AVAILABLE}
2020-03-02 09:33:37.535:INFO:oejs.AbstractConnector:main: Started ServerConnector@74eb909f{HTTP/1.1,[http/1.1, h2c]}{0.0.0.0:7778}
2020-03-02 09:33:37.535:INFO:oejs.Server:main: Started @86661ms
# Now hit Control-C to stop the Jetty Server
^C2020-03-02 09:36:07.794:INFO:oejs.AbstractConnector:Thread-1: Stopped ServerConnector@74eb909f{HTTP/1.1,[http/1.1, h2c]}{0.0.0.0:7778}
2020-03-02 09:36:07.795:INFO:oejs.session:Thread-1: node0 Stopped scavenging
2020-03-02 09:36:07.811:INFO:oejsh.ContextHandler:Thread-1: Stopped o.e.j.s.ServletContextHandler@4470f8a6{/ords,null,UNAVAILABLE}
</pre>
<br />
After the Jetty Server is stopped, we can setup the Database Definition for our Prometheus Metrics.<br />
<br />
<pre class="brush:bash"> #
[oracle@prometheus ords-19.4]$ java -jar ords.war setup --database prometheus_metrics
Specify the database connection type to use.
# Choose Option 1 for a Basic Connection String
Enter number for [1] Basic [2] TNS [3] Custom URL [1]:1
# Provide the Servername of your Database Server Host
Enter the name of the database server [localhost]:prometheus
# Provide the Listener Port or confirm the default value with 1521
Enter the database listen port [1521]:
# If you are using Database Service Names, choose Option 1
Enter 1 to specify the database service name, or 2 to specify the database SID [1]:
# Provide the Database Service Name
Enter the database service name:DB193
# Choose Option 2
Enter 1 if you want to verify/install Oracle REST Data Services schema or 2 to skip this step [1]:2
# Confirm the default Option 1
Enter 1 if you want to use PL/SQL Gateway or 2 to skip this step.
If using Oracle Application Express or migrating from mod_plsql then you must enter 1 [1]:
# Provide the Database User, in my case dbsnmp
Enter the PL/SQL Gateway database user name [APEX_PUBLIC_USER]:dbsnmp
# Provide 2 times the password of the above provided Database User
Enter the database password for dbsnmp:
Confirm password:
# Choose Option 3
Enter a number to select a feature to enable [1] SQL Developer Web [2] REST Enabled SQL [3] None [1]:3
2020-03-02T08:37:46.632Z INFO reloaded pools: [|apex||, |prometheus_metrics||]
</pre>
<br />
As next we need to define the mapped URL for the above created Database Definition<br />
<div>
<br /></div>
<div>
<pre class="brush:bash"> #
[oracle@prometheus ords-19.4]$ java -jar ords.war map-url --type base-path /prometheus_metrics prometheus_metrics
2020-03-02T08:38:32.462Z INFO Creating new mapping from: [base-path,/prometheus_metrics] to map to: [prometheus_metrics, null, null]
</pre>
<br />
Finally we can startup the ords.war in standalone mode<br />
<br />
<pre class="brush:bash"> #
[oracle@prometheus ords-19.4]$ java -jar ords.war standalone
2020-03-02 09:38:43.552:INFO::main: Logging initialized @1525ms to org.eclipse.jetty.util.log.StdErrLog
2020-03-02 09:38:43.595:INFO:oeju.TypeUtil:main: JVM Runtime does not support Modules
2020-03-02T08:38:43.652Z INFO HTTP and HTTP/2 cleartext listening on host: localhost port: 7778
2020-03-02T08:38:43.682Z INFO Disabling document root because the specified folder does not exist: /u00/app/oracle/product/ords-19.4/ords/standalone/doc_root
2020-03-02 09:38:44.283:INFO:oejs.Server:main: jetty-9.4.24.v20191120; built: 2019-11-22T11:09:44.612Z; git: 8b8c80157294e38f81ef8ea2358a0c49bf5db918; jvm 1.8.0_232-b09
2020-03-02 09:38:44.330:INFO:oejs.session:main: DefaultSessionIdManager workerName=node0
2020-03-02 09:38:44.330:INFO:oejs.session:main: No SessionScavenger set, using defaults
2020-03-02 09:38:44.331:INFO:oejs.session:main: node0 Scavenging every 600000ms
2020-03-02T08:38:45.500Z INFO Configuration properties for: |apex||
db.connectionType=basic
db.hostname=prometheus
db.port=1521
db.servicename=DB193
db.password=******
db.username=dbsnmp
resource.templates.enabled=true
2020-03-02T08:38:45.507Z WARNING *** jdbc.MaxLimit in configuration |apex|| is using a value of 10, this setting may not be sized adequately for a production environment ***
2020-03-02T08:38:45.507Z WARNING *** jdbc.InitialLimit in configuration |apex|| is using a value of 3, this setting may not be sized adequately for a production environment ***
2020-03-02T08:38:46.221Z INFO Configuration properties for: |prometheus_metrics||
db.connectionType=basic
db.hostname=prometheus
db.port=1521
db.servicename=DB193
db.password=******
db.username=dbsnmp
resource.templates.enabled=true
2020-03-02T08:38:46.221Z WARNING *** jdbc.MaxLimit in configuration |prometheus_metrics|| is using a value of 10, this setting may not be sized adequately for a production environment ***
2020-03-02T08:38:46.221Z WARNING *** jdbc.InitialLimit in configuration |prometheus_metrics|| is using a value of 3, this setting may not be sized adequately for a production environment ***
2020-03-02T08:38:46.594Z INFO Oracle REST Data Services initialized
Oracle REST Data Services version : 19.4.0.r3521226
Oracle REST Data Services server info: jetty/9.4.24.v20191120
2020-03-02 09:38:47.093:INFO:oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@47db50c5{/ords,null,AVAILABLE}
2020-03-02 09:38:47.103:INFO:oejs.AbstractConnector:main: Started ServerConnector@2438dcd{HTTP/1.1,[http/1.1, h2c]}{0.0.0.0:7778}
2020-03-02 09:38:47.103:INFO:oejs.Server:main: Started @5078ms
</pre>
<br />
Just to test, open a browser and point to http://<servername>:<Jetty Port>/ords/prometheus_metrics/PROMETHEUS_METRICS and you show see as follows:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigykCXfc4TSiEhwCtwHKFDoKUsF74QJOmD9NrMP2kfv_I_kjL_PiZ-zl7ywu-4Jrq43Dx4Jkr5OskAoIqLhQTUW2wVYgA6qTKcp2n6tC0EWl6Y89NAHF3VQ89KuQmG-Jc2aUi_eiX3jVY/s1600/browser_test_prometheus_metrics.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="722" data-original-width="1270" height="362" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigykCXfc4TSiEhwCtwHKFDoKUsF74QJOmD9NrMP2kfv_I_kjL_PiZ-zl7ywu-4Jrq43Dx4Jkr5OskAoIqLhQTUW2wVYgA6qTKcp2n6tC0EWl6Y89NAHF3VQ89KuQmG-Jc2aUi_eiX3jVY/s640/browser_test_prometheus_metrics.png" width="640" /></a></div>
<br />
The final step is to add in your Prometheus Configuration File prometheus.yml under the scrape_configs section a job_name for the Prometheus formatted metrics out of your Oracle Database<br />
<br />
<pre class="brush:bash">
. . .
scrape_configs:
. . .
# Align the IP address and Ports for the targets with your settings
- job_name: 'oracle_db'
scrape_interval: 10s
scrape_timeout: 5s
metrics_path: /ords/prometheus_metrics/PROMETHEUS_METRICS
static_configs:
- targets: ['172.17.0.1:7778']
. . .
</pre>
<br />
Restart your Prometheus Server and check the status of the new target in the Prometheus Console<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizrFVSU5NXBkH0K_i6ax_zYh7lZeTXOB61sa4NLW2iu1AoT_RdI06_EiVNSYIFBV9gh47pe9E4tbRCZb5r3_rbhrspHFVfV-Bfyk2_7BBd3wwhbka5uc-Fqqnf3JNk5Xn5-B-tXDyI4Gk/s1600/prometheus_console_targets.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="577" data-original-width="1600" height="230" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizrFVSU5NXBkH0K_i6ax_zYh7lZeTXOB61sa4NLW2iu1AoT_RdI06_EiVNSYIFBV9gh47pe9E4tbRCZb5r3_rbhrspHFVfV-Bfyk2_7BBd3wwhbka5uc-Fqqnf3JNk5Xn5-B-tXDyI4Gk/s640/prometheus_console_targets.png" width="640" /></a></div>
<br />
Under the Graph section in the Prometheus Console you can find your defined metrics from the Oracle Database<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjRG41dYfVYIDZmqdTw0Z4mZ4X8yP_rU7hyphenhyphenBq0tB4Ine1QEQ-xB6G_t5__iWwE7vrJ3cWUG1ZfqOcVRdkFHGQnJsqYGYdtevpXO9NNKxoA6qokKz6uFGBgVWLyhjpCUk0GK49KKdFi2kw/s1600/prometheus_console_graph.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="547" data-original-width="1600" height="214" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjRG41dYfVYIDZmqdTw0Z4mZ4X8yP_rU7hyphenhyphenBq0tB4Ine1QEQ-xB6G_t5__iWwE7vrJ3cWUG1ZfqOcVRdkFHGQnJsqYGYdtevpXO9NNKxoA6qokKz6uFGBgVWLyhjpCUk0GK49KKdFi2kw/s640/prometheus_console_graph.png" width="640" /></a></div>
<br />
Finally you can create in your Grafana a Dashboard to reflect your Oracle Metrics:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2Jw5OLudt1UJn0xLM_7ZNNXpOrc547qYuwox4P7xYVsRoZRQv5_uM-GqEIJvrCM-p9hA_MjSJlGe2_wCrzjehcW3cwsYWtPJn_ZdFj7xLJURzfrzL_WLILiguXowLGoCDg7eO31F4HCc/s1600/grafana_dashboard.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1165" data-original-width="1600" height="466" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2Jw5OLudt1UJn0xLM_7ZNNXpOrc547qYuwox4P7xYVsRoZRQv5_uM-GqEIJvrCM-p9hA_MjSJlGe2_wCrzjehcW3cwsYWtPJn_ZdFj7xLJURzfrzL_WLILiguXowLGoCDg7eO31F4HCc/s640/grafana_dashboard.png" width="640" /></a></div>
<br />
As you can see, with a little bit of work, you can collect from your Oracle Database with really easy methods Prometheus formatted metrics, push them into your Prometheus system and build a nice dashboard with Grafana. You can even setup thresholds for your Oracle Database metrics and generate alerts either using the Prometheus Alertmanager or trigger the alerts via Grafana.<br />
<br />
<br /></div>
Dirk Nachbarhttp://www.blogger.com/profile/07873896834616675757noreply@blogger.comtag:blogger.com,1999:blog-4344684978957885806.post-36100267137246543082020-02-28T13:32:00.000+01:002020-04-02T11:27:39.383+02:00Weblogic Monitoring with Prometheus and GrafanaSince quite some time Oracle is providing in their GitHub Repository the weblogic-monitoring-exporter <a href="https://github.com/oracle/weblogic-monitoring-exporter" target="_blank">https://github.com/oracle/weblogic-monitoring-exporter</a>.<br />
<br />
This weblogic-monitoring-exporter is basically a war file, which uses the WebLogic Server RESTful Management API to collect defined metrics of your WebLogic Server and exports them in a Prometheus compatible format.<br />
<br />
At first you will need to download the get[Version-Number].sh from the GitHub Repository <a href="https://github.com/oracle/weblogic-monitoring-exporter/releases" target="_blank">https://github.com/oracle/weblogic-monitoring-exporter/releases</a>. Next step is to create a YAML file in which you define which metrics you want to collect from your WebLogic Server.<br />
Place both files in one directory and execute the get[Version-Number].sh with your YAML file as input parameter. The get[Version-Number].sh will simple download from GitHub the required war file, so make sure that your system on which you execute the script got internet connection, and merge your YAML file into the war file.<br />
<br />
Example YAML file named exporter-config.yml<br />
<br />
<pre class="brush:bash">metricsNameSnakeCase: true
queries:
- key: name
keyName: location
prefix: wls_server_
applicationRuntimes:
key: name
keyName: app
componentRuntimes:
prefix: wls_webapp_config_
type: WebAppComponentRuntime
key: name
values: [deploymentState, contextRoot, sourceInfo, sessionsOpenedTotalCount, openSessionsCurrentCount, openSessionsHighCount]
servlets:
prefix: wls_servlet_
key: servletName
- JVMRuntime:
prefix: wls_jvm_
key: name
- executeQueueRuntimes:
prefix: wls_socketmuxer_
key: name
values: [pendingRequestCurrentCount]
- workManagerRuntimes:
prefix: wls_workmanager_
key: name
values: [stuckThreadCount, pendingRequests, completedRequests]
- threadPoolRuntime:
prefix: wls_threadpool_
key: name
values: [executeThreadTotalCount, queueLength, stuckThreadCount, hoggingThreadCount]
- JMSRuntime:
key: name
keyName: jmsruntime
prefix: wls_jmsruntime_
JMSServers:
prefix: wls_jms_
key: name
keyName: jmsserver
destinations:
prefix: wls_jms_dest_
key: name
keyName: destination
- persistentStoreRuntimes:
prefix: wls_persistentstore_
key: name
- JDBCServiceRuntime:
JDBCDataSourceRuntimeMBeans:
prefix: wls_datasource_
key: name
- JTARuntime:
prefix: wls_jta_
key: name
</pre>
<br />
Now let's merge the exporter-config.yml into the wls-exporter.war<br />
<br />
<pre class="brush:bash"> #
./get1.1.1.sh exporter-config.yml
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 607 100 607 0 0 2872 0 --:--:-- --:--:-- --:--:-- 2876
100 2018k 100 2018k 0 0 1165k 0 0:00:01 0:00:01 --:--:-- 2247k
created /tmp/ci-21tVFvZiR4
/tmp/ci-21tVFvZiR4 /u00/app/oracle/install
in temp dir
adding: config.yml (deflated 64%)
/u00/app/oracle/install
</pre>
<br />
As next we can deploy the generated wls-exporter.war on your WebLogic Server, just connect with a browser to your WebLogic Console (http://<servername>:<AdminServerPort>/console)<br />
<br />
Navigate under the Domain Structure to the Option Deployments, click the "Lock & Edit" button in the Change Center, if you are running your WebLogic Domain in Production Mode and click the "Install" button under the Configuration tab in the Deployments.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibGo_yF9tjR_ElT46gmUEqIxXjzaaRCgZ8Oj9m6NpjwoX8agHYsCJmIIWqdAXBWEGE61hccfFGhVyx3vLN4LGrGV42PuwQNp1PDXfGwj1AGqg6qOVmZ_cTF7f2wP9iO-t_it2Wr4WuBC8/s1600/01_wls-deployment.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="836" data-original-width="1398" height="382" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibGo_yF9tjR_ElT46gmUEqIxXjzaaRCgZ8Oj9m6NpjwoX8agHYsCJmIIWqdAXBWEGE61hccfFGhVyx3vLN4LGrGV42PuwQNp1PDXfGwj1AGqg6qOVmZ_cTF7f2wP9iO-t_it2Wr4WuBC8/s640/01_wls-deployment.png" width="640" /></a></div>
<br />
Now navigate to the location of the wls-exporter.war file and select it and hit the button "Next"<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEinikopBTOB_q2tL_JP-eZO5MhMzWaGPGkFk2x2e-FrIoiY-nRBflZ0mYFjs_U_nBqVdNg1SYsSUxuPmd04m0cLNHKHrHTUEupfrX4QcWGIC27sl2Ak-EVEQptO-UOZ6XZD6SKEW2fctp8/s1600/02_wls-deployment.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="836" data-original-width="1398" height="382" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEinikopBTOB_q2tL_JP-eZO5MhMzWaGPGkFk2x2e-FrIoiY-nRBflZ0mYFjs_U_nBqVdNg1SYsSUxuPmd04m0cLNHKHrHTUEupfrX4QcWGIC27sl2Ak-EVEQptO-UOZ6XZD6SKEW2fctp8/s640/02_wls-deployment.png" width="640" /></a></div>
<br />
Make sure that the option "Install this deployment as an application" is marked and hit the button "Next"<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9VpElO6jyttX_mU1rM5G6cUJuXywVsbqbs6tEN9i-A3YbGfc_SmANfsE_fMnH3Lhsk__rCYbRqxSD2c2VsIpLOujWQ6YBfbbx9MCIyvewMKlinfgP2x7Vetz1y5gqZJeEF2Qi_Fc-oNU/s1600/03_wls-deployment.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="836" data-original-width="1398" height="382" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9VpElO6jyttX_mU1rM5G6cUJuXywVsbqbs6tEN9i-A3YbGfc_SmANfsE_fMnH3Lhsk__rCYbRqxSD2c2VsIpLOujWQ6YBfbbx9MCIyvewMKlinfgP2x7Vetz1y5gqZJeEF2Qi_Fc-oNU/s640/03_wls-deployment.png" width="640" /></a></div>
<br />
Target the deployment of the wls-exporter.war to your Servers and hit the button "Next"<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJrgPbXITvUNYm7eKaJp5akgVpevJqeSYd6zWmkvhVAjgPCyw7k2pqcVC8QqHp2RvyoM-0jvQzge7iDoUGQ9PNG8ah3gq_-zNSPp-5qftvoIknkcrOLIpGkfH59t3mX9gmNjOQ1wkdrjg/s1600/04_wls-deployment.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="836" data-original-width="1398" height="382" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJrgPbXITvUNYm7eKaJp5akgVpevJqeSYd6zWmkvhVAjgPCyw7k2pqcVC8QqHp2RvyoM-0jvQzge7iDoUGQ9PNG8ah3gq_-zNSPp-5qftvoIknkcrOLIpGkfH59t3mX9gmNjOQ1wkdrjg/s640/04_wls-deployment.png" width="640" /></a></div>
<br />
Leave the default and hit the button "Next"<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhEee6qtuaNS5ODO9wHz239yKIqzUt2FERKcJ93xqkxHBjmNCbl-B0euInrEj5pyvtQEsLS4ItV5Et85yA5roOG8hnfI7Sg37EEwXO6W7XzT1m1VuKQv0Hq4RBmhZUsrji_QJ_2_55XBZ0/s1600/05_wls-deployment.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1062" data-original-width="1398" height="486" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhEee6qtuaNS5ODO9wHz239yKIqzUt2FERKcJ93xqkxHBjmNCbl-B0euInrEj5pyvtQEsLS4ItV5Et85yA5roOG8hnfI7Sg37EEwXO6W7XzT1m1VuKQv0Hq4RBmhZUsrji_QJ_2_55XBZ0/s640/05_wls-deployment.png" width="640" /></a></div>
<br />
Leave the default and hit the button "Next"<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_0osLdhPe0y729YTEFD0i3KbVWhG3gbJTgR9US4GM2Dt345BkkCyt3KkLKm6IXf9G3C9S6Oy4wjwPJkDjaoplRs41UqKSsf6Lxgn49iCorF4I7n3oNqFMRRz4-giJZBkGbbJbVhrtYqM/s1600/06_wls-deployment.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="804" data-original-width="1398" height="368" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_0osLdhPe0y729YTEFD0i3KbVWhG3gbJTgR9US4GM2Dt345BkkCyt3KkLKm6IXf9G3C9S6Oy4wjwPJkDjaoplRs41UqKSsf6Lxgn49iCorF4I7n3oNqFMRRz4-giJZBkGbbJbVhrtYqM/s640/06_wls-deployment.png" width="640" /></a></div>
<br />
Click the button "Save" and finally click the button "Activate Changes" in the Change Center<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEictVKtSyOwHt0M1xyFCQAK_kEfr7Clng8dWdOCPIJbEdt6gVmKryYu_fz2EG8UF15guz7DQN06kyZ5JBZNO0kjOtTEo2cmBwW7RRr52rOptDWM1njR3ZrVtTXqfVvNtxORmSSuO4VJvIE/s1600/07_wls-deployment.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="979" data-original-width="1398" height="448" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEictVKtSyOwHt0M1xyFCQAK_kEfr7Clng8dWdOCPIJbEdt6gVmKryYu_fz2EG8UF15guz7DQN06kyZ5JBZNO0kjOtTEo2cmBwW7RRr52rOptDWM1njR3ZrVtTXqfVvNtxORmSSuO4VJvIE/s640/07_wls-deployment.png" width="640" /></a></div>
<br />
After the successful activation you should see as follows<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuk8c8t4p75C_StP_p4vWn2LvZUTthSbVe0Iky0zyMkMz4Z5hNc39M2pQfLm9zjWBBgG8SniFFTCFCt2zowR0Z0t701x5UfGm5Fyakqg4b8uWDwEidhg-UtJJ4Cvho9SebBXtAdAXSVg8/s1600/08_wls-deployment.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="246" data-original-width="1398" height="110" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuk8c8t4p75C_StP_p4vWn2LvZUTthSbVe0Iky0zyMkMz4Z5hNc39M2pQfLm9zjWBBgG8SniFFTCFCt2zowR0Z0t701x5UfGm5Fyakqg4b8uWDwEidhg-UtJJ4Cvho9SebBXtAdAXSVg8/s640/08_wls-deployment.png" width="640" /></a></div>
<br />
Now we are done with the deployment of the wls-exporter.war and we can start the application, just go to the tab "Control" and click under "Start" the option "Servicing all requests"<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpvPhdfkMsaYA8CyNgRVjcFeT7fWXdbWMkMZmEK6UREpgkaNNSu_JgipsjTLQ6MkQJdvVT8ZQv1zuA4_rpYNWmAgjBMYeswlayr_mYx0XCfiyy51gMiKxODHen-3qi-7rlhnlwmfDmhyg/s1600/09_wls-deployment.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="502" data-original-width="1398" height="228" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpvPhdfkMsaYA8CyNgRVjcFeT7fWXdbWMkMZmEK6UREpgkaNNSu_JgipsjTLQ6MkQJdvVT8ZQv1zuA4_rpYNWmAgjBMYeswlayr_mYx0XCfiyy51gMiKxODHen-3qi-7rlhnlwmfDmhyg/s640/09_wls-deployment.png" width="640" /></a></div>
<br />
Confirm the startup of the application with "Yes"<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_vgSWwD2T2JIt96KhofsffuzKErLRxWf1jeQbdIUvlC-IgU7ksbmoygHCn8Tf_GMzYdVLzt44M-xG5wGhhKu6aYZYxdy9A9ns6KRihcJ-nB1J4j_4GVolf0HmNfXnOEVmr8JZm9pQQqI/s1600/10_wls-deployment.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="303" data-original-width="1398" height="134" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_vgSWwD2T2JIt96KhofsffuzKErLRxWf1jeQbdIUvlC-IgU7ksbmoygHCn8Tf_GMzYdVLzt44M-xG5wGhhKu6aYZYxdy9A9ns6KRihcJ-nB1J4j_4GVolf0HmNfXnOEVmr8JZm9pQQqI/s640/10_wls-deployment.png" width="640" /></a></div>
<br />
After that you should see under the Control tab that the wls-exporter application is now in state Active<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyAC70fBP20QHGByHopZPk2M6LkG0kv8SYmwkDutof8ha_swIRZKz9fUGaWB9qnR_8v5SatXbuACVOSvyGRSlWHt1b90khzdhqauNQCrINXwR0UOuVbvQTmJEnp0AGLVSaMeKDCpwvNlk/s1600/11_wls-deployment.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="532" data-original-width="1398" height="242" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyAC70fBP20QHGByHopZPk2M6LkG0kv8SYmwkDutof8ha_swIRZKz9fUGaWB9qnR_8v5SatXbuACVOSvyGRSlWHt1b90khzdhqauNQCrINXwR0UOuVbvQTmJEnp0AGLVSaMeKDCpwvNlk/s640/11_wls-deployment.png" width="640" /></a></div>
<br />
The next step is to configure your Prometheus environment to collect the metrics from the wls-exporter application. Just add under the scrape_configs section in your prometheus.yml configuration file the necessary entries for the WebLogic Servers.<br />
Simply add under the scrape_config section in the prometheus.yml a job_name for each WebLogic Managed Server (including your AdminServer). If you are adding multiple WebLogic Servers, its advisable to use the metric_relabel_configs option, to prefix each metric collected by Prometheus with for example the name of the WebLogic Server:<br />
<br />
<pre class="brush:bash">
# Align the job_name with your settings
# Align the IP address and Ports for the targets with your settings
# Align the metric_relabel_configs with your settings
global:
scrape_interval: 15s
evaluation_interval: 15s
scrape_timeout: 10s
. . .
. . .
scrape_configs:
. . .
. . .
- job_name: 'WebLogicAdminServer'
scrape_interval: 10s
metrics_path: /wls-exporter/metrics
static_configs:
- targets: ['172.17.0.1:7001']
basic_auth:
username: weblogic
password: Oracle12c
metric_relabel_configs:
- source_labels: [__name__]
target_label: __name__
replacement: "DemoAdminServer_${1}"
- job_name: 'WebLogicDEMOMS1'
scrape_interval: 10s
metrics_path: /wls-exporter/metrics
static_configs:
- targets: ['172.17.0.1:7003']
basic_auth:
username: weblogic
password: Oracle12c
metric_relabel_configs:
- source_labels: [__name__]
target_label: __name__
replacement: "DEMOMS1_${1}"
- job_name: 'WebLogicDEMOMS2'
scrape_interval: 10s
metrics_path: /wls-exporter/metrics
static_configs:
- targets: ['172.17.0.1:7004']
basic_auth:
username: weblogic
password: Oracle12c
metric_relabel_configs:
- source_labels: [__name__]
target_label: __name__
replacement: "DEMOMS2_${1}"
. . .
. . .
</pre>
<br />
fter this changes, just restart your Prometheus and check under the Prometheus Console - Targets the status of your job_name.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhSZnHtux3H3FoP1o4wCBH6q69ty05fOncRSZxraxx9cweYDDCL47ornoqEITnjfc32RI17LkmNsdE_6yjrMtOZz3UA-XM1ljLt1YI5YhfIjqva8Avy0aIzhM8PfNtWQUzypo-ESTROmk/s1600/01_prometheus.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="680" data-original-width="1398" height="310" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhSZnHtux3H3FoP1o4wCBH6q69ty05fOncRSZxraxx9cweYDDCL47ornoqEITnjfc32RI17LkmNsdE_6yjrMtOZz3UA-XM1ljLt1YI5YhfIjqva8Avy0aIzhM8PfNtWQUzypo-ESTROmk/s640/01_prometheus.png" width="640" /></a></div>
<br />
You can see that we have now 3 Endpoints, one for each WebLogic Server (one AdminServer and two Managed Servers).<br />
<br />
Under the Prometheus Console - Graph you can see all your defined metrics for your WebLogic Servers.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSmHeFll4TAAs4vINFg8gyhYR6onyb5CFRrQ5D10KzviN8ElymTpi894VG3r3IM8Ea3sq2alOw6W7Pw2djQOYIMIQsvGhPyiYNRChXW_DcpkTcCnH9Ari8aaS5Qs3OD2DB1oAXYqVzQw0/s1600/02_prometheus.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1230" data-original-width="1398" height="562" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSmHeFll4TAAs4vINFg8gyhYR6onyb5CFRrQ5D10KzviN8ElymTpi894VG3r3IM8Ea3sq2alOw6W7Pw2djQOYIMIQsvGhPyiYNRChXW_DcpkTcCnH9Ari8aaS5Qs3OD2DB1oAXYqVzQw0/s640/02_prometheus.png" width="640" /></a></div>
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6eiFr8cnQCrM7E-GblIe77P_PLKI9HKgka3efyJ9rxMLJjNUqsYkm3d-7DJCl2ZIPbntn6ABWwQZLX91mWZB1d7daNQVxbLW174idGAVd-SuYOnwWupm7qwsJgs0afNDdDyjil0QxRAI/s1600/03_prometheus.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="466" data-original-width="1398" height="210" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6eiFr8cnQCrM7E-GblIe77P_PLKI9HKgka3efyJ9rxMLJjNUqsYkm3d-7DJCl2ZIPbntn6ABWwQZLX91mWZB1d7daNQVxbLW174idGAVd-SuYOnwWupm7qwsJgs0afNDdDyjil0QxRAI/s640/03_prometheus.png" width="640" /></a></div>
<br />
As next you can create a Dashboard in your Grafana environment.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisOEqr5v1eSFtU285Hp2NH7W4j-15JfY5735QGq6vRr1uual92exMlzcI8Vr0G3NSQfxXZ6r0NfE08oCK387feVN8Ap1_T3-3UJGBvXEmoXymWxMmt5wAfB6b-8yV_4xP1OztamWoHYX8/s1600/01_grafana.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1109" data-original-width="1600" height="442" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisOEqr5v1eSFtU285Hp2NH7W4j-15JfY5735QGq6vRr1uual92exMlzcI8Vr0G3NSQfxXZ6r0NfE08oCK387feVN8Ap1_T3-3UJGBvXEmoXymWxMmt5wAfB6b-8yV_4xP1OztamWoHYX8/s640/01_grafana.png" width="640" /></a></div>
<br />
<br />
So with a little bit of work you can easily monitor your WebLogic Environment with Prometheus and Grafana. In addition you can configure thresholds for your metrics and trigger alerts either via the alertmanager from Prometheus or via Grafana.<br />
<br />
One point you should take care of with the weblogic-monitoring-exporter is the usage of the configuration option "domainQualifier: true". As documented this configuration is the metrics with the domain name, but currently the option "domainQualifier: true" will cause a non-Prometheus-conform formatted metric.<br />
<br />
<pre class="brush:bash">name{domain="demo_domain"} demo_domain
DemoAdminServer_wls_server_activation_time{domain="demo_domain",location="DemoAdminServer"} 1581419617765
DemoAdminServer_wls_server_admin_server_listen_port{domain="demo_domain",location="DemoAdminServer"} 7001
DemoAdminServer_wls_server_open_sockets_current_count{domain="demo_domain",location="DemoAdminServer"} 4
DemoAdminServer_wls_server_state_val{domain="demo_domain",location="DemoAdminServer"} 2
</pre>
<br />
As you can see from above listing, the wls-exporter is generating the first line wrong, as the metric value is a string and therefor it can not be parsed by Prometheus.<br />
<br />
I have currently opened an issue in the GitHub Repository for the weblogic-monitoring-exporter and I hope to get soon a feedback and/or solution <a href="https://github.com/oracle/weblogic-monitoring-exporter/issues/82" target="_blank">https://github.com/oracle/weblogic-monitoring-exporter/issues/82</a><br />
<br />
But nevertheless, the weblogic-monitoring-exporter is a great add-on for the Oracle WebLogic Server in order to monitor your environment with Prometheus and visualise your metrics with Grafana.<br />
<br />
<b><span style="color: red;">UPDATE 2nd April 2020:</span></b> the above mentioned problem with the non-conform Prometheus formatted metric is resolved by the Oracle Development Team for the WebLogic-Monitoring-Exporter, just get the release 1.1.2 (<a href="https://github.com/oracle/weblogic-monitoring-exporter/releases" target="_blank">https://github.com/oracle/weblogic-monitoring-exporter/releases</a>)<br />
<div>
<br /></div>
<div>
<br /></div>
Dirk Nachbarhttp://www.blogger.com/profile/07873896834616675757noreply@blogger.comtag:blogger.com,1999:blog-4344684978957885806.post-42647386736631893912020-02-20T13:57:00.000+01:002020-02-20T13:57:46.630+01:00Cleanup Oracle Fusion Middleware 12c Repository manuallyCurrently I was cleaning up some of my Oracle Fusion Middleware Forms & Reports test and demo environments manually and wanted to setup them freshly.<br />
<br />
As I was lazy, I didn't used the RCU (Repository Creation Utility) for the cleanup, I just did a manual drop user and drop tablespace and cleaned up my $DOMAIN_HOME.<br />
<br />
In my case it was a Forms & Reports environment with the Prefix FR12213, so I manually dropped all the Repository Users starting with FR12213 and the corresponding tablespaces.<br />
<br />
<pre class="brush:bash">#
sqlplus / as sysdba
SQL> drop user FR12213_OPSS cascade;
SQL> drop user FR12213_STB cascade;
SQL> drop user FR12213_MDS cascade;
SQL> drop user FR12213_IAU_APPEND cascade;
SQL> drop user FR12213_IAU_VIEWER cascade;
SQL> drop user FR12213_IAU cascade;
SQL> drop user FR12213_WLS_RUNTIME cascade;
SQL> drop user FR12213_WLS cascade;
SQL> drop user FR12213_UMS cascade;
SQL> drop tablespace FR12213_IAS_OPSS including content and datafiles;
SQL> drop tablespace FR12213_IAS_TEMP including content and datafiles;
SQL> drop tablespace FR12213_IAS_UMS including content and datafiles;
SQL> drop tablespace FR12213_IAU including content and datafiles;
SQL> drop tablespace FR12213_MDS including content and datafiles;
SQL> drop tablespace FR12213_STB including content and datafiles;
SQL> drop tablespace FR12213_WLS including content and datafiles;
</pre>
<br />
After that I simply cleaned up the $DOMAIN_HOME and wanted to create the complete WebLogic Domain again including the run of the RCU, everything in silent mode.<br />
<br />
While running the RCU following error came up:<br />
<br />
<pre class="brush:bash">#
Processing command line ....
Repository Creation Utility - Checking Prerequisites
Checking Global Prerequisites
ERROR - RCU-6016 Invalid prefix specified.
CAUSE - RCU-6016 The specified prefix already exists.
ACTION - RCU-6016 Specify another prefix.
ERROR - RCU-6091 Component validation failed.
CAUSE - RCU-6091 One or more component specific validation failed.
ACTION - RCU-6091 Check log for more details and fix the validation error.
</pre>
<br />
After a bit of searching around and think, I came to the table SYSTEM.SCHEMA_VERSION_REGISTRY$<br />
<br />
<pre class="brush:bash">#
sqlplus / as sysdba
SQL> select distinct(MRC_NAME) from SYSTEM.SCHEMA_VERSION_REGISTRY$;
MRC_NAME
------------------------------
FR12213
SQL> delete from SYSTEM.SCHEMA_VERSION_REGISTRY$ where MRC_NAME = 'FR12213';
SQL> commit;
</pre>
<br />
After deleting the corresponding rows in the SYSTEM.SCHEMA_VERSION_REGISTRY$ table, the silent execution of the RCU was running without any errors.<br />
So don't forget to cleanup the SYSTEM.SCHEMA_VERSION_REGISTRY$ if you are performing a manual cleanup :-)<br />
<br />
The above concept applies to any Oracle Fusion Middleware Component which is using Repository Users created by the RCU (SOA Suite, Forms & Reports and so on)<br />
<br />
<br />Dirk Nachbarhttp://www.blogger.com/profile/07873896834616675757noreply@blogger.comtag:blogger.com,1999:blog-4344684978957885806.post-47951008030399905342020-02-14T11:05:00.003+01:002020-02-14T11:05:56.370+01:00Oracle 20c Documentation availableSince a few hours the Oracle Database 20c documentation is online.<br />
<br />
<a href="https://docs.oracle.com/en/database/oracle/oracle-database/20/books.html" target="_blank">https://docs.oracle.com/en/database/oracle/oracle-database/20/books.html</a><br />
<br />
There are quite some interesting new features/changes in the new upcoming Oracle 20c release.<br />
<br />
The complete list of new features you can find under: <a href="https://docs.oracle.com/en/database/oracle/oracle-database/20/newft/new-features.html" target="_blank">https://docs.oracle.com/en/database/oracle/oracle-database/20/newft/new-features.html</a><br />
<br />
One of the most interesting new feature/change is, that from Oracle 20c going, the only supported architecture is only Multitenant.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOABaGlwoxA-9lNlM1h3v6Zcbm-qL6-1bDSjjhCvfQMUSQHBDVF4XXH4e1XGqZCw4x5qcHcJIe6wB5ok_kM7gbVb1pLOTmhWtDt9lh5tKokPGZ0AKkkK8iHw2lWclocC34Ivz69dCJNeo/s1600/only_multitenant.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="521" data-original-width="1600" height="208" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOABaGlwoxA-9lNlM1h3v6Zcbm-qL6-1bDSjjhCvfQMUSQHBDVF4XXH4e1XGqZCw4x5qcHcJIe6wB5ok_kM7gbVb1pLOTmhWtDt9lh5tKokPGZ0AKkkK8iHw2lWclocC34Ivz69dCJNeo/s640/only_multitenant.png" width="640" /></a></div>
<br />
Enjoy reading the new features :-)<br />
<br />
<br />Dirk Nachbarhttp://www.blogger.com/profile/07873896834616675757noreply@blogger.comtag:blogger.com,1999:blog-4344684978957885806.post-24581839537035770962020-02-06T13:52:00.000+01:002020-02-06T13:52:03.999+01:00Huge Number of component_event.xlf* and pki_data*.tmp files in /tmp in Oracle Forms & Reports 12cIf you are running an Oracle Forms and Reports 12c (12.2.1.+) environment over quite some time, you might discover that under the /tmp directory are a quite huge number of files named component_event.xlf* and pki_data*.tmp are generated and filling up your /tmp space.<br />
<div>
<br /></div>
<div>
The pki_data*.tmp files are usually 0 Bytes, but the component_event.xlf* files are between some Bytes up to some 100 Bytes. Over some time, these files are really fill up your /tmp.</div>
<div>
<br /></div>
<div>
These files are generated by the Oracle Platform Security for Java component and they are holding temporarily cache data.</div>
<div>
<br /></div>
<div>
In order to get rid of the component_event.xlf* files, you will just to have modify two configuration files of your WebLogic Domain.</div>
<div>
<br /></div>
<div>
In the configuration file $DOMAIN_HOME/config/fmwconfig/jps-config.xml find the following line and comment this line out.</div>
<div>
<br /></div>
<div>
<pre class="brush:bash">#
# Original line
<serviceInstanceRef ref="audit.db"/>
# Modified line
<!-- serviceInstanceRef ref="audit.db"/ -->
</pre>
<div>
<br /></div>
<div>
The second configuration file is the $DOMAIN_HOME/config/fmwconfig/jps-config-jse.xml. Find the following line and comment this line out.</div>
<div>
<br /></div>
<div>
<pre class="brush:bash">#
# Original line
<serviceInstanceRef ref="audit.db"/>
# Modified line
<!-- serviceInstanceRef ref="audit.db"/ -->
</pre>
<div>
<br /></div>
<div>
After the above modifications are done, you will have to restart your WebLogic Domain and you can see that no more component_event.xlf* are generated.<br />
There are just the pki_data*.tmp files, but these files are usually 0 Bytes. For this files you can use a normal housekeeping job to clean them up regulary.</div>
<div>
<br /></div>
<div>
<br /></div>
</div>
</div>
Dirk Nachbarhttp://www.blogger.com/profile/07873896834616675757noreply@blogger.comtag:blogger.com,1999:blog-4344684978957885806.post-32906092541780624182020-02-03T14:25:00.000+01:002020-02-03T14:25:44.531+01:00Patching Oracle WebLogic Server 12.2.1.4.0 Slim EditionIn my last blog I was showing how to install the new Oracle WebLogic Server 12.2.1.4.0 Slim Installer (<a href="https://dirknachbar.blogspot.com/2020/02/oracle-weblogic-server-122140-slim.html" target="_blank">https://dirknachbar.blogspot.com/2020/02/oracle-weblogic-server-122140-slim.html</a>), now let's see how the minimised Oracle WebLogic Server 12.2.1.4.0 Slim Edition will handle a patching.<br />
<br />
For this I will use the Oracle WLS PATCH SET UPDATE 12.2.1.4.191220 (Patch No. 30689820).<br />
<br />
Login as oracle User to your server hosting the Oracle WebLogic Server 12.2.1.4.0 Slim Installation. Transfer the above mentioned Patch to your server and extract the zip file:<br />
<br />
<pre class="brush:bash">#
# set the necessary environment variables
[oracle@wlstest] export ORACLE_HOME=/u00/app/oracle/product/fmw-wls-slim-12.2.1.4.0
# switch to the extracted patch directory
[oracle@wlstest] cd /u00/app/oracle/patches/30689820
# Lets check the current patch status
[oracle@wlstest] $ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 13.9.4.2.1
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : /u00/app/oracle/product/fmw-wls-slim-12.2.1.4.0
Central Inventory : /u00/app/oracle/oraInventory
from : /u00/app/oracle/product/fmw-wls-slim-12.2.1.4.0/oraInst.loc
OPatch version : 13.9.4.2.1
OUI version : 13.9.4.0.0
Log file location : /u00/app/oracle/product/fmw-wls-slim-12.2.1.4.0/cfgtoollogs/opatch/opatch2020-02-03_14-02-27PM_1.log
OPatch detects the Middleware Home as "/u00/app/oracle/product/fmw-wls-slim-12.2.1.4.0"
Lsinventory Output file location : /u00/app/oracle/product/fmw-wls-slim-12.2.1.4.0/cfgtoollogs/opatch/lsinv/lsinventory2020-02-03_14-02-27PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: wlstest.oracle-stuff.com
ARU platform id: 226
ARU platform description:: Linux x86-64
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
</pre>
<br />
As you can see, no patches so far installed on my fresh WebLogic Server 12.2.1.4.0 Slim Edition, now let's install the WLS PATCH SET UPDATE<br />
<br />
<pre class="brush:bash">#
# set the necessary environment variables
[oracle@wlstest] export ORACLE_HOME=/u00/app/oracle/product/fmw-wls-slim-12.2.1.4.0
# switch to the extracted patch directory
[oracle@wlstest] cd /u00/app/oracle/patches/30689820
[oracle@wlstest] $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 13.9.4.2.1
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : /u00/app/oracle/product/fmw-wls-slim-12.2.1.4.0
Central Inventory : /u00/app/oracle/oraInventory
from : /u00/app/oracle/product/fmw-wls-slim-12.2.1.4.0/oraInst.loc
OPatch version : 13.9.4.2.1
OUI version : 13.9.4.0.0
Log file location : /u00/app/oracle/product/fmw-wls-slim-12.2.1.4.0/cfgtoollogs/opatch/opatch2020-02-03_14-02-41PM_1.log
OPatch detects the Middleware Home as "/u00/app/oracle/product/fmw-wls-slim-12.2.1.4.0"
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 30689820
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u00/app/oracle/product/fmw-wls-slim-12.2.1.4.0')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '30689820' to OH '/u00/app/oracle/product/fmw-wls-slim-12.2.1.4.0'
ApplySession: Optional component(s) [ oracle.wls.admin.console.en, 12.2.1.4.0 ] , [ oracle.wls.admin.console.en, 12.2.1.4.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.wls.libraries, 12.2.1.4.0...
Patching component oracle.wls.core.app.server, 12.2.1.4.0...
Patch 30689820 successfully applied.
Log file location: /u00/app/oracle/product/fmw-wls-slim-12.2.1.4.0/cfgtoollogs/opatch/opatch2020-02-03_14-02-41PM_1.log
OPatch succeeded.
# Let's verify the patch apply
[oracle@wlstest] $ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 13.9.4.2.1
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : /u00/app/oracle/product/fmw-wls-slim-12.2.1.4.0
Central Inventory : /u00/app/oracle/oraInventory
from : /u00/app/oracle/product/fmw-wls-slim-12.2.1.4.0/oraInst.loc
OPatch version : 13.9.4.2.1
OUI version : 13.9.4.0.0
Log file location : /u00/app/oracle/product/fmw-wls-slim-12.2.1.4.0/cfgtoollogs/opatch/opatch2020-02-03_14-03-05PM_1.log
OPatch detects the Middleware Home as "/u00/app/oracle/product/fmw-wls-slim-12.2.1.4.0"
Lsinventory Output file location : /u00/app/oracle/product/fmw-wls-slim-12.2.1.4.0/cfgtoollogs/opatch/lsinv/lsinventory2020-02-03_14-03-05PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: wlstest.oracle-stuff.com
ARU platform id: 226
ARU platform description:: Linux x86-64
Interim patches (1) :
Patch 30689820 : applied on Mon Feb 03 14:02:57 CET 2020
Unique Patch ID: 23281789
Patch description: "WLS PATCH SET UPDATE 12.2.1.4.191220"
Created on 20 Dec 2019, 17:56:29 hrs PST8PDT
Bugs fixed:
26444945, 29671344, 29769772, 30067299, 30153412, 30230430, 30341541
30342923, 30362026, 30362086, 30589563
--------------------------------------------------------------------------------
OPatch succeeded.
</pre>
<br />
You can see, that the Patch apply went through without any problems, only the Patch apply prints you out some informations, that the to be patched component "oracle.wls.admin.console.en" is not present in the target ORACLE_HOME:<br />
<br />
Optional component(s) [ oracle.wls.admin.console.en, 12.2.1.4.0 ] , [ oracle.wls.admin.console.en, 12.2.1.4.0 ] not present in the Oracle Home or a higher version is found.<br />
<br />
Thats just an information, as in the WebLogic Server 12.2.1.4.0 Slim Edition is no WebLogic Server Console present.<br />
<br />Dirk Nachbarhttp://www.blogger.com/profile/07873896834616675757noreply@blogger.comtag:blogger.com,1999:blog-4344684978957885806.post-3432405250374758302020-02-03T13:47:00.000+01:002020-02-03T13:47:14.204+01:00Oracle WebLogic Server 12.2.1.4.0 Slim InstallerSince WebLogic Server 12.2.1.4.0 you have a new edition of the Oracle WebLogic Server, it's the Slim Installer. The corresponding software you can download under:<br />
<br />
<a href="https://www.oracle.com/middleware/technologies/weblogic-server-installers-downloads.html" target="_blank">https://www.oracle.com/middleware/technologies/weblogic-server-installers-downloads.html</a><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjI-ubE0GXQBsH_UcIcas29sBUW3VfWV5k1MVrEWVxFf7WbPMj-jPTJnreKQXu-PZ6HxfcNN7kMoE18sfXR49kjxn9_CM1urSh1ePxtpC5v382N2NrREfqSLac-2Lfxr_Rffem-__CVZM0/s1600/WLS122140_Slim_download.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1212" data-original-width="1436" height="540" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjI-ubE0GXQBsH_UcIcas29sBUW3VfWV5k1MVrEWVxFf7WbPMj-jPTJnreKQXu-PZ6HxfcNN7kMoE18sfXR49kjxn9_CM1urSh1ePxtpC5v382N2NrREfqSLac-2Lfxr_Rffem-__CVZM0/s640/WLS122140_Slim_download.png" width="640" /></a></div>
<br />
<br />
The Slim Installer is much smaller than the Generic or the Fusion Middleware Infrastructure Installers.<br />
<ul>
<li>WebLogic Generic Installer: 826 MB</li>
<li>Fusion Middleware Infrastructure Installer: 1.5 GB</li>
<li>WebLogic Slim Installer: 182 MB</li>
</ul>
Basically the Slim Installer is a full WebLogic Server, but without any examples, no WebLogic Console, no WebLogic Clients, no Maven Plugin and no Java DB.<br />
<br />
The installation comes without any graphical installer, its pure command line. So be aware of the command line option for the invoking of the Slim Installer.<br />
In case you will start the Slim Installer, as you are used to the Generic Installer, just with "java -jar fmw_12.2.1.4.0_wls_quick_slim.jar", the installer will install the WebLogic Slim Edition in your present work directory/wls12214 and the corresponding Oracle Inventory will be created under $HOME/oraInventory.<br />
<br />
<pre class="brush:bash">#
# Set the necessary environment variables
# align them to your environment settings
[oracle@wlstest] export JAVA_HOME=/u00/app/oracle/product/jdk1.8.0_221
[oracle@wlstest] export PATH=$JAVA_HOME/bin:$PATH
[oracle@wlstest] pwd
/u00/app/oracle/install
[oracle@wlstest] java -jar fmw_12.2.1.4.0_wls_quick_slim.jar
Launcher log file is /tmp/OraInstall2020-02-03_10-20-45AM/launcher2020-02-03_10-20-45AM.log.
Extracting the installer . . . . Done
Checking if CPU speed is above 300 MHz. Actual 2194.918 MHz Passed
Checking swap space: must be greater than 512 MB. Actual 3071 MB Passed
Checking if this platform requires a 64-bit JVM. Actual 64 Passed (64-bit not required)
Checking temp space: must be greater than 300 MB. Actual 11025 MB Passed
Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2020-02-03_10-20-45AM
Log: /tmp/OraInstall2020-02-03_10-20-45AM/install2020-02-03_10-20-45AM.log
*****************************************************
Distribution Name : Oracle Fusion Middleware 12c WebLogic and Coherence Developer Slim
Distribution Version : 12.2.1.4.0
Oracle Inventory : /home/oracle/oraInventory
Oracle Home : /u00/app/oracle/install/wls12214
Java Home : /u00/app/oracle/product/jdk1.8.0_221
Note: Oracle Home not supplied (defaulted to <present dir="" working="">/wls12214)
*****************************************************
Copyright (c) 1996, 2019, Oracle and/or its affiliates. All rights reserved.
Skipping Software Updates
Starting check : CertifiedVersions
Expected result: One of oracle-6, oracle-7, redhat-7, redhat-6, SuSE-11, SuSE-12, SuSE-15
Actual Result: oracle-7.4
Check complete. The overall result of this check is: Passed
CertifiedVersions Check: Success.
Starting check : CheckJDKVersion
Expected result: 1.8.0_191
Actual Result: 1.8.0_221
Check complete. The overall result of this check is: Passed
CheckJDKVersion Check: Success.
Validations are enabled for this session.
Verifying data
Copying Files
Percent Complete : 10
Percent Complete : 20
Percent Complete : 30
Percent Complete : 40
Percent Complete : 50
Percent Complete : 60
Percent Complete : 70
Percent Complete : 80
Percent Complete : 90
Percent Complete : 100
The installation of Oracle Fusion Middleware 12c WebLogic and Coherence Developer Slim 12.2.1.4.0 completed successfully.
Logs successfully copied to /u00/app/oracle/install/wls12214/cfgtoollogs/oui.
</pre>
<br />
As you can see from above listing, the ORACLE_HOME location for the new installation is chosen automatically with my present work directory/wls122140 and the Oracle Inventory goes into $HOME/oraInventory.<br />
<br />
Second trial, this time with the command line option "java -jar fmw_12.2.1.4.0_wls_quick_slim.jar ORACLE_HOME=$ORACLE_HOME"<br />
<br />
<pre class="brush:bash">#
# Set the necessary environment variables
# align them to your environment settings
[oracle@wlstest] export ORACLE_HOME=/u00/app/oracle/product/fmw-wls-slim-12.2.1.4.0
[oracle@wlstest] export JAVA_HOME=/u00/app/oracle/product/jdk1.8.0_221
[oracle@wlstest] export PATH=$JAVA_HOME/bin:$PATH
[oracle@wlstest] java -jar fmw_12.2.1.4.0_wls_quick_slim.jar ORACLE_HOME=$ORACLE_HOME
Launcher log file is /tmp/OraInstall2020-02-03_10-27-21AM/launcher2020-02-03_10-27-21AM.log.
Extracting the installer . . . . Done
Checking if CPU speed is above 300 MHz. Actual 2194.918 MHz Passed
Checking swap space: must be greater than 512 MB. Actual 3071 MB Passed
Checking if this platform requires a 64-bit JVM. Actual 64 Passed (64-bit not required)
Checking temp space: must be greater than 300 MB. Actual 10469 MB Passed
Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2020-02-03_10-27-21AM
Log: /tmp/OraInstall2020-02-03_10-27-21AM/install2020-02-03_10-27-21AM.log
Setting ORACLE_HOME...
*****************************************************
Distribution Name : Oracle Fusion Middleware 12c WebLogic and Coherence Developer Slim
Distribution Version : 12.2.1.4.0
Oracle Inventory : /home/oracle/oraInventory
Oracle Home : /u00/app/oracle/product/fmw-wls-slim-12.2.1.4.0
Java Home : /u00/app/oracle/product/jdk1.8.0_221
*****************************************************
Copyright (c) 1996, 2019, Oracle and/or its affiliates. All rights reserved.
Skipping Software Updates
Starting check : CertifiedVersions
Expected result: One of oracle-6, oracle-7, redhat-7, redhat-6, SuSE-11, SuSE-12, SuSE-15
Actual Result: oracle-7.4
Check complete. The overall result of this check is: Passed
CertifiedVersions Check: Success.
Starting check : CheckJDKVersion
Expected result: 1.8.0_191
Actual Result: 1.8.0_221
Check complete. The overall result of this check is: Passed
CheckJDKVersion Check: Success.
Validations are enabled for this session.
Verifying data
Copying Files
Percent Complete : 10
Percent Complete : 20
Percent Complete : 30
Percent Complete : 40
Percent Complete : 50
Percent Complete : 60
Percent Complete : 70
Percent Complete : 80
Percent Complete : 90
Percent Complete : 100
The installation of Oracle Fusion Middleware 12c WebLogic and Coherence Developer Slim 12.2.1.4.0 completed successfully.
Logs successfully copied to /u00/app/oracle/product/fmw-wls-slim-12.2.1.4.0/cfgtoollogs/oui.
</pre>
<br />
This looks a bit better now, our target installation directory is now under our desired £ORACLE_HOME, but the Oracle Inventory is still under $HOME/oraInventory.<br />
<br />
3rd attempt, now with the command line option "java -jar fmw_12.2.1.4.0_wls_quick_slim.jar ORACLE_HOME=$ORACLE_HOME -invPtrLoc /u00/app/oracle/install/oraInst.loc" and a prepare oraInst.loc file in which we define the Oracle Inventory location and the group ownership for the Oracle Inventory.<br />
<br />
<pre class="brush:bash">#
[oracle@wlstest] cat /u00/app/oracle/oraInst.loc
inventory_loc=/u00/app/oracle/oraInventory
inst_group=oinstall
# Set the necessary environment variables
# align them to your environment settings
[oracle@wlstest] export ORACLE_HOME=/u00/app/oracle/product/fmw-wls-slim-12.2.1.4.0
[oracle@wlstest] export JAVA_HOME=/u00/app/oracle/product/jdk1.8.0_221
[oracle@wlstest] export PATH=$JAVA_HOME/bin:$PATH
[oracle@wlstest] java -jar fmw_12.2.1.4.0_wls_quick_slim.jar ORACLE_HOME=$ORACLE_HOME -invPtrLoc /u00/app/oracle/install/oraInst.loc
Launcher log file is /tmp/OraInstall2020-02-03_12-32-47PM/launcher2020-02-03_12-32-47PM.log.
Extracting the installer . . . . Done
Checking if CPU speed is above 300 MHz. Actual 2194.918 MHz Passed
Checking swap space: must be greater than 512 MB. Actual 3071 MB Passed
Checking if this platform requires a 64-bit JVM. Actual 64 Passed (64-bit not required)
Checking temp space: must be greater than 300 MB. Actual 10468 MB Passed
Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2020-02-03_12-32-47PM
Log: /tmp/OraInstall2020-02-03_12-32-47PM/install2020-02-03_12-32-47PM.log
Setting ORACLE_HOME...
*****************************************************
Distribution Name : Oracle Fusion Middleware 12c WebLogic and Coherence Developer Slim
Distribution Version : 12.2.1.4.0
Oracle Inventory : /u00/app/oracle/oraInventory
Oracle Home : /u00/app/oracle/product/fmw-wls-slim-12.2.1.4.0
Java Home : /u00/app/oracle/product/jdk1.8.0_221
*****************************************************
Copyright (c) 1996, 2019, Oracle and/or its affiliates. All rights reserved.
Skipping Software Updates
Starting check : CertifiedVersions
Expected result: One of oracle-6, oracle-7, redhat-7, redhat-6, SuSE-11, SuSE-12, SuSE-15
Actual Result: oracle-7.4
Check complete. The overall result of this check is: Passed
CertifiedVersions Check: Success.
Starting check : CheckJDKVersion
Expected result: 1.8.0_191
Actual Result: 1.8.0_221
Check complete. The overall result of this check is: Passed
CheckJDKVersion Check: Success.
Validations are enabled for this session.
Verifying data
Copying Files
Percent Complete : 10
Percent Complete : 20
Percent Complete : 30
Percent Complete : 40
Percent Complete : 50
Percent Complete : 60
Percent Complete : 70
Percent Complete : 80
Percent Complete : 90
Percent Complete : 100
The installation of Oracle Fusion Middleware 12c WebLogic and Coherence Developer Slim 12.2.1.4.0 completed successfully.
Logs successfully copied to /u00/app/oracle/product/fmw-wls-slim-12.2.1.4.0/cfgtoollogs/oui.
</pre>
<br />
This time everything is located and installed as we want :-)<br />
<br />
Now lets compare the space usage between the Oracle WebLogic Generic, Fusion Middleware Infrastructure and the WebLogic Slim:<br />
<br />
<pre class="brush:bash">#
[oracle@wlstest] cd /u00/app/oracle/product
[oracle@wlstest] du -sh fmw*
2.1G fmw-infra-12.2.1.4.0
1.1G fmw-wls-12.2.1.4.0
452M fmw-wls-slim-12.2.1.4.0
</pre>
<br />
As you can see, the WebLogic Generic (fmw-wls-12.2.1.4.0) needs 1.1 GB disk space, the Fusion Middleware Infrastructure (fmw-infra-12.2.1.4.0) needs 2.1 GB and the WebLogic Slim (fmw-wls-slim-12.2.1.4.0) just needs 452 MB (more than half lesser than the Generic Installer and more than 4 times lesser than the Fusion Middleware Infrastructure Installer).<br />
<br />
Specially when you will use the WebLogic Slim Installer in a Docker Image, you will gain a lot of disk savings.<br />
<br />
After you have installed the WebLogic Slim Installer you can as normal startup the $ORACLE_HOME/oracle_common/common/bin/config.sh to configure and create your WebLogic Domain with the graphical wizard, but be aware, you dont have any WebLogic Console (http://<servername>:<AdminServerPort>/console) afterwards. Everything you need to configure, you will have to do it through wlst or via RESTful Management API.<br />
<br />
<br />Dirk Nachbarhttp://www.blogger.com/profile/07873896834616675757noreply@blogger.comtag:blogger.com,1999:blog-4344684978957885806.post-59829686945817686902020-01-31T05:35:00.001+01:002020-01-31T09:14:14.622+01:00Enterprise Manager 13.4 is availableThe latest release of the Oracle Enterprise Manager 13.4.0.0.0 is now available for download in Oracle Technology Network:<br />
<br />
<a href="https://www.oracle.com/enterprise-manager/downloads/cloud-control-downloads.html">https://www.oracle.com/enterprise-manager/downloads/cloud-control-downloads.html</a><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJoCRxh__jI0diIgQ20Xn6332qJACRmbDzdV8JIewK6SpqbJpu53_bxT90whEf6sPR9o1QbYlGk80G0GR6OW273D9ZwZIRo_2GhVEKqpC5G9anve8PdyM3RN34j5CRcKQf34UfjzeTaYY/s1600/Screenshot+2020-01-31+at+05.30.11.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="982" data-original-width="1558" height="402" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJoCRxh__jI0diIgQ20Xn6332qJACRmbDzdV8JIewK6SpqbJpu53_bxT90whEf6sPR9o1QbYlGk80G0GR6OW273D9ZwZIRo_2GhVEKqpC5G9anve8PdyM3RN34j5CRcKQf34UfjzeTaYY/s640/Screenshot+2020-01-31+at+05.30.11.png" width="640" /></a></div>
<br />
The documentation is currently not available, but I hope it will be published soon.<br />
<br />
One of the positive aspects of the new Oracle Enterprise Manager 13c Release 4 (13.4.0.0.0) is, that the underlying Oracle WebLogic Server is now a 12.2.1.3.0 release, not longer a 12.1.3 release :-)<br />
<br />
So, happy download and enjoy the upgrade ...<br />
<br />Dirk Nachbarhttp://www.blogger.com/profile/07873896834616675757noreply@blogger.comtag:blogger.com,1999:blog-4344684978957885806.post-18933395249807309262020-01-27T15:09:00.000+01:002020-01-27T15:09:13.971+01:00WebLogic Server Future Releases - An educated guessToday I was checking as usual the available patches for Oracle WebLogic Server and I discovered some new WebLogic Server Releases within the drop list of the available releases.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWaAgxCS3XdDILI3jECJFrKuYSrVil220T8g84NkxOPApftoRMMfs2NrOnI5x7z13YpH4tLad_ErNETNM0GkL8sFBkUqKse6ymSY5ZCs3VdI4DvooWHMBWLiZIFihXLn3VYTiU7Re3sAg/s1600/MOS_WLS_Releases.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="334" data-original-width="1264" height="168" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWaAgxCS3XdDILI3jECJFrKuYSrVil220T8g84NkxOPApftoRMMfs2NrOnI5x7z13YpH4tLad_ErNETNM0GkL8sFBkUqKse6ymSY5ZCs3VdI4DvooWHMBWLiZIFihXLn3VYTiU7Re3sAg/s640/MOS_WLS_Releases.PNG" width="640" /></a></div>
<br />
<br />
It seems that for the current supported WebLogic Server 12.2.1.x will be a future PatchSet 5 (12.2.1.5.0).<br />
<br />
The given Release with 12.2.3.0.0, I personally doubt that this will come.<br />
<br />
For the future WebLogic Server, which is currently in Beta Testing, it seems that Oracle will really name it 14.1.1.0.0. I have no clue why Oracle is choosing this naming convention for the new Oracle WebLogic Server Release, seems they want to be back to the good old days with various naming conventions between Oracle DB, Oracle Enterprise Manager and Oracle Fusion Middleware products.<br />
<br />Dirk Nachbarhttp://www.blogger.com/profile/07873896834616675757noreply@blogger.comtag:blogger.com,1999:blog-4344684978957885806.post-61443477084088500082019-11-18T13:24:00.000+01:002019-11-18T13:24:08.004+01:00Deprecated Functionality for WebLogic Server 12.2.1.4.0Since around 6 weeks the last Oracle WebLogic Server 12.2.1.4.0 Release is available and I got some spare time to read the necessary documentations.<br />
<br />
In the "What's new Guide" <a href="https://docs.oracle.com/en/middleware/fusion-middleware/weblogic-server/12.2.1.4/notes/whatsnew.html" target="_blank">https://docs.oracle.com/en/middleware/fusion-middleware/weblogic-server/12.2.1.4/notes/whatsnew.html</a> I found 2 interesting deprecated features, which weren't announced somewhere else.<br />
<br />
Meaning of deprecated features (source MOS Note <a href="https://support.oracle.com/epmos/faces/DocContentDisplay?id=888028.1" target="_blank">888028.1</a>)<br />
<br />
<blockquote class="tr_bq">
Oracle Fusion Middleware deprecation process is to announce a feature deprecated in a given release where it will continue to be fully supported for bug fixes until the next major release. In the next major release, the feature will then be removed. In some cases it may remain, but only to extend the transition period where error correction support is no longer expected.
</blockquote>
<br />
Oracle Traffic Director is in deprecated status for Oracle WebLogic Server 12.2.1.4.0 <a href="https://docs.oracle.com/en/middleware/fusion-middleware/weblogic-server/12.2.1.4/notes/whatsnew.html#GUID-362AA8C0-082A-4744-B7F2-2BD4E0194F30" target="_blank">https://docs.oracle.com/en/middleware/fusion-middleware/weblogic-server/12.2.1.4/notes/whatsnew.html#GUID-362AA8C0-082A-4744-B7F2-2BD4E0194F30</a>. Oracle recommends as alternatives the usage of the Oracle HTTP Server, Microsoft IIS, Apache HTTPD Server with the corresponding Server Plugins and so on.<br />
<br />
The second interesting feature which is in deprecated status for Oracle WebLogic Server 12.2.1.4.0 is the WebLogic Multitenant feature and the Resource Consumption Management <a href="https://docs.oracle.com/en/middleware/fusion-middleware/weblogic-server/12.2.1.4/notes/whatsnew.html#GUID-B95FF848-893D-44A7-925E-1F87279F6CAE" target="_blank">https://docs.oracle.com/en/middleware/fusion-middleware/weblogic-server/12.2.1.4/notes/whatsnew.html#GUID-B95FF848-893D-44A7-925E-1F87279F6CAE</a>. As an alternative Oracle mentions the usage of Container-Based Solutions.<br />
<br />
<br />Dirk Nachbarhttp://www.blogger.com/profile/07873896834616675757noreply@blogger.comtag:blogger.com,1999:blog-4344684978957885806.post-50120484087832024002019-10-10T11:30:00.000+02:002019-10-10T11:30:38.928+02:00OGB Appreciation Day: What I appreciate and what I would like to appreciateIt's time again for the OGB Appreciation Day #ThanksOGB (formerly known as #ThanksOTN and #ThanksODC) initiated by Tim Hall <a href="https://twitter.com/OracleBase" target="_blank">https://twitter.com/OracleBase</a><br />
<div>
<br /></div>
<div>
<div>
At first, what I appreciate from Oracle:</div>
<div>
<br /></div>
<div>
WOW, We have a new Fusion Middleware Release 12.2.1.4.0 :-) after nearly waiting for 2 years ! </div>
<div>
As my main focus is on WebLogic and Oracle Forms & Reports, I already had a closer look on this stuff and I must say, that specially for Oracle Forms & Reports, Oracle integrated some cool features/enhancements.</div>
<div>
<br /></div>
<div>
The browser-less solution for running Oracle Forms & Reports with the Forms Standalone Launcher is getting more and more mature, specially now with the ability to use SSO from Forms Standalone Launcher.</div>
<div>
<br /></div>
<div>
I really must admit that the Forms Standalone Launcher is the best improvement for Oracle Forms & Reports so far, as we can get rid of the Java Plugin dependencies within the Browsers.</div>
<div>
<br /></div>
<div>
On top with the latest Release 12.2.1.4.0 for Oracle Forms & Reports it's for me a clear commitment from Oracle for the future of Forms & Reports (here my special thanks goes to Michael Ferrante - Product Manager Forms & Reports <a href="https://twitter.com/OracleFormsPM" target="_blank">https://twitter.com/OracleFormsPM</a> )</div>
<div>
<br /></div>
<div>
The next thing, what I personally appreciate is the Always Free Cloud offering from Oracle.</div>
<div>
It's really a great offering to give everybody for free and always 2 Oracle Databases (even when they are limited in terms of Memory and Space) and on top a Linux Server with 100 GB Storage with root privileges.</div>
<div>
Now everybody can test and play from everywhere and every time (only an Internet Connection is required) with an Oracle environment. The cool thing is even, that you have a web-based SQL Developer and APEX.</div>
</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<div>
As second, what I would like to appreciate from Oracle:</div>
<div>
<br /></div>
<div>
This is a long on going topic in the Oracle Community, the quality of the Oracle Support.</div>
<div>
Over the past years the quality of the Oracle Support were decreasing from year to year up to an unbearable level. </div>
<div>
You have to fight with Support-Bots (while I am writing this blog post, I have opened in parallel a SR with Oracle Support and ooooooh miracle I'm discussing my support case with a Support-Bot ... ) , your open Bugs are not being processed and partially you get complete wrong answers on your questions or even you ask something and there is no reply for 2 weeks.</div>
<div>
<br /></div>
<div>
Dear Oracle Support, I can understand, that you don't want to fix a bug (which is not mission critical) for a Database Release which will be out of support within the next 9 months, but then PLEASE tell us, that you don't want to fix it and it will be fixed within the next upcoming release. In this case, I would know what to expect and not to let stay open my bugs and post only the famous mystery lines:</div>
</div>
<div>
<blockquote class="tr_bq">
*** 11/19/18 10:03 am ***<br />*** 11/20/18 12:16 am ***<br />*** 11/29/18 12:00 am ***<br />*** 12/28/18 04:14 am ***<br />*** 12/28/18 04:14 am ***<br />*** 12/28/18 04:14 am ***<br />*** 01/31/19 12:34 am ***<br />*** 04/04/19 04:16 am ***<br />*** 07/29/19 08:12 am ***<br />*** 10/08/19 09:08 am ***</blockquote>
</div>
<div>
<br /></div>
<div>
<div>
The next thing what I would like appreciate from Oracle is the version numbering concept for my beloved Oracle Fusion Middleware.</div>
<div>
Currently we have for example Oracle WebLogic Server 12c (12.2.1.x) Releases, so far so good. The Oracle Database Releases are now following the version numbering concept with the years, for example Oracle Database 18c (2018), Oracle Database 19c (2019). So far so good, but who came to the brilliant idea to plan an Oracle WebLogic Release 14?</div>
<div>
Long time ago we had the same confusion with the different version numbering concept between Oracle Database and Oracle Middleware Products (like iAS, OAS and so on, the older folks will still remember this products), with Oracle Middleware 12c we were aligned, but now with a future Release 14 we are back to the old confusion.</div>
<div>
Dear Oracle, please align the version numbering concept ...</div>
</div>
<div>
<br /></div>
<div>
<br /></div>
Dirk Nachbarhttp://www.blogger.com/profile/07873896834616675757noreply@blogger.comtag:blogger.com,1999:blog-4344684978957885806.post-73876704322600695822019-10-01T14:23:00.000+02:002019-10-01T14:23:26.168+02:00Oracle Forms 12.2.1.4.0 - New Security Handling for useridIn the latest Oracle Forms 12.2.1.4.0 Release, Oracle has implemented a new cool feature for security handling of the userid parameter.<br />
<br />
Classically within the formsweb.cfg you are defining your section for your Forms Application, e.g.<br />
<div>
<br /></div>
<pre class="brush:bash">#
# The values for userid are provided in cleartext
[demo]
WebUtilArchive=frmwebutil.jar,jacob.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
baseHTML=webutilbase.htm
baseHTMLjpi=webutiljpi.htm
archive=frmall.jar
lookAndFeel=oracle
form=test.fmx
userid=scott/tiger@prod
</pre>
<div>
<br /></div>
<div>
<div>
Now, with Oracle Forms 12.2.1.4.0, after you started the AdminServer of your Oracle Forms & Reports 12.2.1.4.0 environment, the value for the parameter userid will be automatically encrypted.</div>
<div>
This is managed via the new parameter forms.userid.encryption.enabled=true for $EXTRA_JAVA_PROPERTIES inside the $DOMAIN_HOME/bin/setDomainEnv.sh script.</div>
<div>
<br /></div>
<div>
After you have started up your AdminServer the value for the parameter userid inside the formsweb.cfg will be encrypted:</div>
</div>
<div>
<br /></div>
<pre class="brush:bash">#
# After the startup of the AdminServer the value
# for the parameter userid is encrypted
[demo]
WebUtilArchive=frmwebutil.jar,jacob.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
baseHTML=webutilbase.htm
baseHTMLjpi=webutiljpi.htm
archive=frmall.jar
lookAndFeel=oracle
form=test.fmx
userid={AES}E/vW+IIt0wtgdExtevDqrg==
</pre>
<div>
<br /></div>
<div>
<br /></div>
Dirk Nachbarhttp://www.blogger.com/profile/07873896834616675757noreply@blogger.comtag:blogger.com,1999:blog-4344684978957885806.post-24685065330042688152019-09-30T14:13:00.001+02:002019-09-30T14:13:12.587+02:00Oracle Reports 12.2.1.4.0 - Create a Standalone Reports ServerOn Friday, 27th September 2019, Oracle released the latest Version of Oracle Forms & Reports 12.2.1.4.0 (see my blog post <a href="http://dirknachbar.blogspot.com/2019/09/oracle-forms-reports-122140-available.html" target="_blank">http://dirknachbar.blogspot.com/2019/09/oracle-forms-reports-122140-available.html</a>).<br />
<br />
As I already created an Oracle Forms & Reports 12.2.1.4.0 environment, it's now time to have a look on the Oracle Reports 12.2.1.4.0 environment.<br />
<br />
As usual, after you have successfully installed and configured your Oracle Forms & Reports 12.2.1.4.0 environment, the Oracle Reports Component is NOT configured completely.<br />
<br />
Following steps you will have to perform:<br />
<ul>
<li>Create the required Reports Tools Instance</li>
<li>Create the required Reports Server Instances</li>
<li>Optionally, if you don't any kind of security for accessing the Reports, disable the security settings and activate the Webcommands for the rwservlet</li>
</ul>
<div>
What you don't need anymore in Oracle Reports 12.2.1.4.0 are following steps:</div>
<div>
<ul>
<li>No more symbolic link from /usr/lib/libXm.so.4 to libXm.so.3</li>
<li>No more modification on the Java Cryptography Extension (JCE) Unlimited Strength Jurisdiction Policy Files on your JDK and the JDK under your $MW_HOME/oracle/common/jdk</li>
</ul>
</div>
<br />
Just perform following steps:<br />
<br />
<pre class="brush:bash">#
# At first we are creating the required Oracle Reports Tools Instance
cd $MW_HOME/oracle_common/common/bin
./wlst.sh
# replace the password with your password and verify if port 7001 is your Admin Server Port
wls:/offline> connect('weblogic','password','localhost:7001')
wls:/fr_domain/serverConfig/> createReportsToolsInstance(instanceName='reptools1',machine='AdminServerMachine')
wls:/fr_domain/serverConfig/> exit()
# Next we are creating our required Oracle Standalone Reports Server
cd $MW_HOME/oracle_common/common/bin
./wlst.sh
wls:/offline> connect('weblogic','password','localhost:7001')
wls:/fr_domain/serverConfig/> createReportsServerInstance(instanceName='rep_server1',machine='AdminServerMachine')
wls:/fr_domain/serverConfig/> exit()
</pre>
<br />
Now we have to align the rwserver.conf configuration file for the above created Oracle Standalone Reports Server, called in my example rep_server1.<br />
<br />
<pre class="brush:bash">#
# Open the rwserver.conf with an editor
# located under $DOMAIN_HOME/config/fmwconfig/components/ReportsServerComponent/<Reports Server Name>/rwserver.conf
# Align the following section from :
<cache class="oracle.reports.cache.RWCache">
<property name="cacheSize" value="50"/>
<!--property name="cacheDir" value="your cache directory"/-->
<!--property name="maxCacheFileNumber" value="max number of cache files"/-->
</cache>
<!--Please do not change the id for reports engine.-->
<!--The class specifies below is subclass of _EngineClassImplBase and implements EngineInterface.-->
<engine id="rwEng" class="oracle.reports.engine.EngineImpl" maxEngine="1" minEngine="1" engLife="50" >
<!--property name="sourceDir" value="your reports source directory"/-->
<!--property name="tempDir" value="your reports temp directory"/-->
<!--property name="keepConnection" value="yes"/-->
</engine>
# To (align the provided directories for cacheDir, sourceDir and tempDir to your settings)
<cache class="oracle.reports.cache.RWCache">
<property name="cacheSize" value="50"/>
<property name="cacheDir" value="/u00/app/oracle/demo_app/cache"/>
<property name="maxCacheFileNumber" value="50"/>
</cache>
<!--Please do not change the id for reports engine.-->
<!--The class specifies below is subclass of _EngineClassImplBase and implements EngineInterface.-->
<engine id="rwEng" class="oracle.reports.engine.EngineImpl" maxEngine="1" minEngine="1" engLife="50" >
<property name="sourceDir" value="/u00/app/oracle/demo_app/rdf"/>
<property name="tempDir" value="/u00/app/oracle/demo_app/temp"/>
<property name="keepConnection" value="yes"/>
</engine>
# In case you don't need any kind of security for your Oracle Reports align the following section as follows:
<job jobType="report" engineId="rwEng" securityId="rwJaznSec"/>
# To, remove the part securityId="rwJaznSec":
<job jobType="report" engineId="rwEng"/>
</pre>
<br />
To enable the Webcommands in the rwservlet just modify the rwservlet.properties file under $DOMAIN_HOME/config/fmwconfig/servers/<Name of Managed Server for Reports>/applications/reports_12.2.1/configuration<br />
<br />
<pre class="brush:bash">#
# Add the line <webcommandacess>L2</webaccesscommand>
<?xml version="1.0" encoding="UTF-8"?>
<rwservlet xmlns="http://xmlns.oracle.com/reports/rwservlet" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<server>rep_wls_reports_greenfield</server>
<singlesignon>no</singlesignon>
<inprocess>yes</inprocess>
<webcommandaccess>L2</webcommandaccess>
</rwservlet>
</pre>
Now start your Managed Server for Oracle Reports, normally WLS_REPORTS and after that start your newly created Oracle Standalone Reports Server<br />
<br />
<pre class="brush:bash">#
cd $DOMAIN_HOME/bin
# if you don't want to be prompted in future for the Nodemanager Password
# use the option storeUserConfig, it will store the password
./startComponent rep_server1 storeUserConfig
Starting system Component rep_server1 ...
Initializing WebLogic Scripting Tool (WLST) ...
Welcome to WebLogic Server Administration Scripting Shell
Type help() for help on available commands
Reading domain from /u00/app/oracle/user_projects/domains/demo_domain
Please enter Node Manager password:
Creating the key file can reduce the security of your system if it is not kept in a secured location after it is created. Creating new key...
The username and password that were used for this WebLogic NodeManager connection are stored in /home/oracle/.wlst/nm-cfg-demo_domain.props and /home/oracle/.wlst/nm-key-demo_domain.props.
Connecting to Node Manager ...
<Sep 30, 2019 1:28:41 PM CEST> <Info> <Security> <BEA-090905> <Disabling the CryptoJ JCE Provider self-integrity check for better startup performance. To enable this check, specify -Dweblogic.security.allowCryptoJDefaultJCEVerification=true.>
<Sep 30, 2019 1:28:41 PM CEST> <Info> <Security> <BEA-090906> <Changing the default Random Number Generator in RSA CryptoJ from ECDRBG128 to HMACDRBG. To disable this change, specify -Dweblogic.security.allowCryptoJDefaultPRNG=true.>
<Sep 30, 2019 1:28:41 PM CEST> <Info> <Security> <BEA-090909> <Using the configured custom SSL Hostname Verifier implementation: weblogic.security.utils.SSLWLSHostnameVerifier$NullHostnameVerifier.>
Successfully Connected to Node Manager.
Starting server rep_server1 ...
Successfully started server rep_server1 ...
Successfully disconnected from Node Manager.
Exiting WebLogic Scripting Tool.
Done
</pre>
Now you can access the Reports rwservlet commands under http://<Your ServerName>:9002/reports/rwservlet<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi2rtXAvdwS2gdTGex2DMl3WolyoYo8AdPyyRmDifQvPqIQum1EB5Cex4jYNqN8YVk0cM-W4pcj3aZw3QTZvJ1w3wn1n7MpmZpjjqjKN6vEr-9FP9UDFYow-wTtGMrgkkYh5t2xWqxR6Q4/s1600/reports_rwservlet.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="633" data-original-width="1125" height="360" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi2rtXAvdwS2gdTGex2DMl3WolyoYo8AdPyyRmDifQvPqIQum1EB5Cex4jYNqN8YVk0cM-W4pcj3aZw3QTZvJ1w3wn1n7MpmZpjjqjKN6vEr-9FP9UDFYow-wTtGMrgkkYh5t2xWqxR6Q4/s640/reports_rwservlet.png" width="640" /></a></div>
<br />
In order to see the environment/configuration for our newly created Oracle Standalone Reports Server rep_server1 just use following URL: http://<Your ServerName>:9002/reports/rwservlet/showenv?server=rep_server1<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgidSNkHTJTsKQnR3YfyUmXylNqHI6fDuuDhpbZCvbZ6LA5JEUUrO234rBViViZgHmnThxfooqMTIUYo_HgdwqQ8ZmU3-5OEXNdaNSvdcS2ByKduKzjr0RG52rzgXAr5MvD8LrvBvdlmNs/s1600/showenv.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1124" data-original-width="1600" height="448" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgidSNkHTJTsKQnR3YfyUmXylNqHI6fDuuDhpbZCvbZ6LA5JEUUrO234rBViViZgHmnThxfooqMTIUYo_HgdwqQ8ZmU3-5OEXNdaNSvdcS2ByKduKzjr0RG52rzgXAr5MvD8LrvBvdlmNs/s640/showenv.png" width="640" /></a></div>
<br />
Summing up, Oracle Reports 12.2.1.4.0 is still the same as the previous release, but 2 positive topics are that you don't need anymore to create the symbolic link for the libXm.so.3 and you don't need any more the modification on the Java Cryptography Extension (JCE) Unlimited Strength Jurisdiction Policy Files.<br />
<br />
<br />Dirk Nachbarhttp://www.blogger.com/profile/07873896834616675757noreply@blogger.comtag:blogger.com,1999:blog-4344684978957885806.post-58363759816322267002019-09-28T15:27:00.000+02:002019-09-28T15:27:52.619+02:00Oracle Forms & Reports 12.2.1.4.0 - First LookYesterday I was blogging about the new Oracle Forms & Reports 12.2.1.4.0 Release.<br />
<br />
Today I got some spare time to install and configure the latest Oracle Forms & Reports 12.2.1.4.0 Release on one of my test VM's.<br />
<br />
My configuration is as follows:<br />
<ul>
<li>Oracle Enterprise Linux 7.4</li>
<li>Oracle Database Enterprise Edition 19.3</li>
<li>Oracle Server JRE 8u221</li>
<ul>
<li>Download URL: <a href="https://www.oracle.com/technetwork/java/javase/downloads/server-jre8-downloads-2133154.html" target="_blank">https://www.oracle.com/technetwork/java/javase/downloads/server-jre8-downloads-2133154.html</a></li>
</ul>
<li>Oracle WebLogic Infrastructure 12.2.1.4.0</li>
<ul>
<li>Download URL: <a href="https://www.oracle.com/middleware/technologies/fusionmiddleware-downloads.html" target="_blank">https://www.oracle.com/middleware/technologies/fusionmiddleware-downloads.html</a> (download the Fusion Middleware Infrastructure Installer 1.5GB)</li>
</ul>
<li>Oracle Forms & Reports 12.2.1.4.0</li>
<ul>
<li>Download URL: <a href="https://www.oracle.com/middleware/technologies/forms/downloads.html" target="_blank">https://www.oracle.com/middleware/technologies/forms/downloads.html</a> (download the Forms & Reports 12.2.1.4.0 Release)</li>
</ul>
</ul>
<div>
The installation and configuration is the same as under the previous Oracle Forms & Reports 12.2.1.3.0 Release.</div>
<div>
At first install and configure your Oracle Database, I have created an Oracle 19c Instance with one PDB, which will be my target Database for the required Metadata Repository for Oracle Forms & Reports 12.2.1.4.0.</div>
<div>
Next step is to install the JDK (or better to say unzip your Oracle Server JRE 8u221, you can even use a full JDK).</div>
<div>
After that, install your Oracle WebLogic Server Infrastructure 12.2.1.4.0 and when this is done, install into the same MW_HOME your Oracle Forms & Reports 12.2.1.4.0 software.</div>
<div>
<br /></div>
<div>
Now, we can start to configure the required stuff. At first you need to run the Repository Creation Utility ($MW_HOME/oracle_common/bin/rcu), when this is done, we can configure the Oracle WebLogic Domain for Forms & Reports with the config.sh script located under $MW_HOME/oracle_common/common/bin).</div>
<div>
<br /></div>
<div>
When the configuration part is done, just startup your Node Manager with $DOMAIN_HOME/bin/startNodeManager.sh and after that your AdminServer with $DOMAIN_HOME/startWebLogic.sh</div>
<div>
<br /></div>
<div>
Now you can either start the Managed Servers (WLS_FORMS and WLS_REPORTS) from the WebLogic Console http://<your_servername>:7001/console or with the script $DOMAIN_HOME/bin/startManagedWebLogic.sh</your_servername></div>
<div>
<br /></div>
<div>
Just to test, if your Forms Environment is working, get the frmsal.jar (located under $MW_HOME/forms/java) to your Desktop and execute following command:</div>
<div>
<br /></div>
<pre class="brush:bash">#
# java -jar frmsal.jar -url "Full Qualified Server including the Configuration" [-t <timeout in milliseconds>] [-showConfig false|true]
java -jar frmsal.jar -url "http://<Your_ServerName>:9001/forms/frmservlet?config=standalone" -showConfig true
Config parameters from server are:
CODEBASE=/forms/java
ARCHIVE=frmall.jar
WIDTH=750
HEIGHT=600
NAME=
serverURL=/forms/lservlet?ifcfs=/forms/frmservlet?config=standaloneapp&standaloneapp=1&ifsessid=WLS_FORMS.formsapp.2&acceptLanguage=en-us
networkRetries=0
splashScreen=
background=
lookAndFeel=Oracle
colorScheme=swan
customColorScheme=
serverApp=
logo=
imageBase=codebase
formsMessageListener=
recordFileName=
EndUserMonitoringEnabled=false
EndUserMonitoringURL=
heartBeat=
MaxEventWait=
disableValidateClipboard=false
allowAlertClipboard=true
digitSubstitution=context
highContrast=false
disableMDIScrollbars=
clientDPI=
applet_stop_timeout=800
guiMode=0
idleTimeout=
isResizable=
centerOnStartup=
alwaysOnTop=
mediaBase=codebase
webFormsTitle=Oracle Fusion Middleware Forms Services
Inspecting archive files in cache directory /var/folders/b_/ldw8b91n7h7dp58hd3xf2qmc0000gn/T/frmsal/greenfield/12.2.1.4
Downloading archive file frmall.jar to cache subdirectory ermz9mn700rz58gniz4ftx8un
Forms Session ID is WLS_FORMS.formsapp.2
The proxy host is null, and the proxy port is 0.
Native HTTP implementation is being used for the connection.
The connection mode is HTTP.
Forms Applet version is 12.2.1.4
</pre>
<div>
With the optional option "-showConfig true" your java call on the frmsal.jar will display you the Forms Configuration in your shell or Command Prompt.<br />
<br />
Now you should see following:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgJSSGvQZusSSxX-6MMx0735U9iiDdir6u_szCBn5HHC8hwg18aH6xpv_PlIAFUn0ZEAadU2SKZQJ5exKd_k8micr97dmXv0lJjkcktweAJeAprfx3tDWoJuBx4HfXn1_oZGPjqYcE2E4/s1600/FormsStandaloneLauncher.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1500" height="510" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgJSSGvQZusSSxX-6MMx0735U9iiDdir6u_szCBn5HHC8hwg18aH6xpv_PlIAFUn0ZEAadU2SKZQJ5exKd_k8micr97dmXv0lJjkcktweAJeAprfx3tDWoJuBx4HfXn1_oZGPjqYcE2E4/s640/FormsStandaloneLauncher.png" width="640" /></a></div>
<br />
Enjoy the new Oracle Forms & Reports 12.2.1.4.0 Release, I will post in the next days more blog posts about the latest Oracle Forms & Reports 12.2.1.4.0 Release ...<br />
<br /></div>
<div>
<br /></div>
Dirk Nachbarhttp://www.blogger.com/profile/07873896834616675757noreply@blogger.com