• Home
  • RMAN
  • Database
    • Data Guard
    • Data Pump
    • Performance Tuning
    • Security
    • General
  • Enterprise Manager
    • Grid Control 11g
    • Cloud Control 12c
  • Middleware
    • APEX
    • Application Server
    • Forms & Reports
    • WebLogic Server
  • OS
    • Linux & UNIX
    • Windows
    • VirtualBox
  • SQL Server
  • MongoDB
  • About Me
Home » Archive for category "Middleware"

Category Archives: Middleware

OTN Appreciation Day : Oracle Reports Server Job Queue Monitoring

Posted on October 11, 2016 by Garth

Before I start, what’s this all about you might be thinking?  Well, Tim Hall recently floated the idea of an unofficial “OTN Appreciation Day” so everyone could create a short post about their favourite Oracle features.  So I figured I’d join in…and he thought it would help me “get back on the horse” with my

Read More…

Posted in Forms & Reports | Tags: otn, reports, rw_queue | 1 Comment |

Configuring Oracle Reports Server Job Queue Monitoring

Posted on October 10, 2016 by Garth

The Oracle Reports Services handle incoming client requests to run reports using a job queue mechanism, which are then submitted to the report engines.  This Report Server job queue information is stored on disk, in binary format, in the Report Server instance’s persistence file .i.e. $ORACLE_INSTANCE/reports/server/<reports server name>.dat Now querying this information can easily be

Read More…

Posted in Forms & Reports | Tags: job, queue, reports, rw_server | Leave a comment |

Additional plugins are required issue in Firefox with Forms 11g

Posted on May 19, 2013 by Garth

At the time of writing this post, Oracle Forms 11g installations are configured by default to work with a specific JPI (Java Plug-In) version: 1.6.0_12. You can verify this by checking your formsweb.cfg file: grep jpi-version formsweb.cfg #jpi_mimetype=application/x-java-applet;jpi-version=1.6.0_12 Unfortunately, it seems Firefox is very particular when it comes to JPI versions, and it will only run with the

Read More…

Posted in Forms & Reports | Tags: 11g, firefox, forms, java, jpi, missing, needed, plugin | 4 Comments |

Removing a Domain in WebLogic

Posted on May 16, 2013 by Garth

First of all, shutdown your domain (in this example, my domain is called ‘oldDomain’ and has one Managed Server): export MW_HOME=/u01/app/oracle/middleware export WLS_HOME=$MW_HOME/wls_10.3.6 export DOMAIN_NAME=oldDomain export DOMAIN_HOME=$MW_HOME/user_projects/domains/$DOMAIN_NAME $DOMAIN_HOME/bin/stopWebLogic.sh $DOMAIN_HOME/bin/stopManagedWebLogic.sh ManagedServer_1 Remove the domain entry from the Node Manager file: vi $WLS_HOME/common/nodemanager/nodemanager.domains …remove this line: oldDomain=/u01/app/oracle/middleware/user_projects/domains/oldDomain Remove the domain registry entry relevant to your domain: vi $MW_HOME/domain-registry.xml

Read More…

Posted in WebLogic Server | Tags: delete, domain, remove, weblogic, wls | Leave a comment |

Installing and configuring the APEX Listener 2.0.1 on WebLogic 12c

Posted on May 1, 2013 by Garth

The Oracle APEX Listener is a Java based alternative to using Oracle HTTP Server (OHS) with mod_plsql.  In the past I’ve installed early versions of APEX 3 using this configuration, then later on started using EPG (Embedded PL/SQL Gateway) which worked fairly well. Recently however, I decided to try using the latest APEX Listener 2.0.1 on WebLogic 12c

Read More…

Posted in APEX, WebLogic Server | Tags: 12c, 2.0, apex, listener, weblogic | 14 Comments |

Installing APEX 4.2 and configuring Embedded PL/SQL Gateway (EPG)

Posted on April 30, 2013 by Garth

A standard Oracle 11.2.0.3 database installation comes bundled with Application Express (APEX) 3.2.1 by default.  I’m going to upgrade to the latest version of APEX (currently 4.2.2) and then configure the Embedded PL/SQL Gateway (EPG), which uses the Oracle XML DB HTTP components within the database itself, so I don’t need to run a separate HTTP server. First

Read More…

Posted in APEX | Tags: acl, apex, epg, install, pl/sql gateway, upgrade, xml | 27 Comments |

Forms 11g – Java client hangs at security warning with “The application’s digital signature cannot be verified”

Posted on April 30, 2013 by Garth

Having modified our formsweb.cfg file recently to configure WebUtil in our Forms 11g installation, we started hitting issues when trying to access various form-based application URLs. When the security warning window appears (below), usually you would tick the check-box and run the application: In this instance however, the window turned completely unresponsive and just hung, resulting in the Java

Read More…

Posted in Forms & Reports | Tags: forms, formsweb.cfg, java, webutil, webutilarchive | 1 Comment |

Applying PSU 12.1.1.0.4 to WebLogic 12c…and patch conflicts!

Posted on April 18, 2013 by Garth

Following on from my recent WebLogic 12.1.1.0 installation on Linux, the first thing I then did was look for the latest PSU (Patch Set Update) to cover off the latest bug fixes and security vulnerabilities, that PSU being… PSU No: 12.1.1.0.4 (April 2013) Patch ID: YJCB Patch No: 16083652 To find the relevant patch number, I did

Read More…

Posted in WebLogic Server | Tags: 12.1.1.0.4, 12c, conflict, psu, weblogic | 1 Comment |

WebLogic Server 12c (12.1.1) installation

Posted on April 18, 2013 by Garth

This is pretty much identical to a WebLogic 11g installation, but I decided to post separately as this includes details of the PSU appropriate to this WebLogic 12.1.1 installation, a potential gotcha with the H675 patch, and I’m using Oracle JDK 7. I’m assuming here that the “oracle” user, groups etc. have already been created here.  If

Read More…

Posted in WebLogic Server | Tags: 12.1.1, installation, java 7, weblogic, wls | Leave a comment |

Error [J2EE:160149] deploying an ADF based application in WebLogic

Posted on April 4, 2013 by Garth

This morning I had a number of ADF based applications to deploy against a new WebLogic 11g domain.  When I tried to activate the changes, I hit the following error (the log file revealed nothing further): An error occurred during activation of changes, please see the log for details. [J2EE:160149]Error while processing library references. Unresolved

Read More…

Posted in WebLogic Server | Tags: adf, adf.oracle.domain, deployment, J2EE:160149, weblogic | 7 Comments |

Archived

Popular Posts

  • Restoring a MongoDB document from the oplog
  • PLS-00801: internal error [hshuid:LU invalid] when compiling a package body
  • OTN Appreciation Day : Oracle Reports Server Job Queue Monitoring
  • Configuring Oracle Reports Server Job Queue Monitoring
  • Data Guard "CORRUPTION DETECTED: In redo blocks starting at block..." issues

External Links

  • SQL Formatter
  • Oracle Live SQL
  • SQL Fiddle
  • ASH Viewer
  • MOS
  • Oracle Forum
  • Oracle Base
  • Oracle FAQ
  • Oracle Articles
  • Rob Zoeteweij’s EM Blog
  • 1
  • 2
  • Next
Copyright © 2020 SnapDBA.com