eMarcel.com

Oracle Database, Fusion Middleware, Linux

Oracle Database 12c In-Memory How To Get Started

Oracle Database In-Memory feature has been released by Oracle in recent patch set 12.1.0.2. Here is how to upgrade Oracle database to version 12.1.0.2: Upgrade Oracle Database 12c with ASM 12.1.0.1 to 12.1.0.2

With the introduction of Oracle Database In-Memory, a single database can now efficiently support mixed workloads, delivering optimal performance for transactions while simultaneously supporting real-time analytics and reporting. This is possible due to a unique “dual-format” architecture that enables data to be maintained in both the existing Oracle row format, for OLTP operations, and a new purely in-memory column format, optimized for analytical processing. It is not a free feature though, see at the bottom for prices.

2015-05-25_000455

Continue reading…

, , ,

Upgrade Oracle Database 12c with ASM 12.1.0.1 to 12.1.0.2

db12c_logoIn previous tutorial of this topic, we covered installation of Oracle Database 12c R1 on Linux 6 with ASM version 12.1.0.1.0. Now it’s the time to upgrade our database to version  12.1.0.2.0 which introduces long awaited “In-Memory Aggregation” and “In-Memory Column store” features. There is obviously much more – full description of Oracle Database 12c R1 (12.1.0.2) New Features can be found here. Readme Information for Oracle Database 12c Release 1 (12.1.0.2) available here.

Upgrade plan:

  1. Download software packages from Oracle eDelivery.
  2. Upgrade Oracle Grid Infrastructure 12c R1 to version 12.1.0.2.0
  3. Install software and upgrade Oracle Database 12c R1 to version 12.1.0.2.0
  4. Configure database listener – netca
  5. Post-Upgrade steps

Continue reading…

, , , ,

Installing Oracle SOA Suite 12c (12.1.3.0)

Installing Oracle SOA Suite and BAM 12c with Oracle Database 12c and Oracle Linux 6.

Oracle SOA Suite 12c

In this article we will go through Oracle SOA Suite 12c and Oracle BAM 12c installation  on Oracle Linux. We assume that Oracle Database 12c and Oracle Linux has been already installed.

Infra design:

Prerequisites:

  1. Running Oracle Database 12c with opened pluggable database PDB01
  2. Running Oracle Linux 6  host prepared for Oracle products installations
  3. Configured network and hostname in Oracle Linux 6

Continue reading…

, , , , ,

How to easy check Oracle WebLogic Server version

There are several ways to determine Oracle WebLogic Server version. Here’s how we can check most of the general information in WebLogic Server Admin Console.

Login to WebLogic Administration Console and navigate to Servers –> AdminServer –> Monitoring tab. We see the following information:

  • State

    Click to enlarge

  • Activation Time
  • WebLogic Version
  • WebLogic Home
  • Middleware Home
  • Java Vendor
  • Java Version
  • OS Name
  • OS Version
  • JACC Enabled
  • Services available on this server instance

 

, ,

Recover Decrypt WebLogic Server Admin Password

One of the most important WebLogic Server files in terms of security is SerializedSystemIni.dat which contains encrypted security data and is located in $DOMAIN_HOME/security directory. Other file is boot.properties file located in $DOMAIN_HOME/servers/AdminServer/security directory which contains an encrypted version of weblogic admin username and password.

 Below tutorial shows how to decrypt, recover username or password, having access to SerializedSystemIni.dat and boot.properties files. But not only, we can also use this method to:

  • recover database username and password of JDBC Connection pool – encrypted password resides in $DOMAIN_HOME/config/jdbc directory, in xml files
  • recover password of a keystore where we store SSL certificates
  • any encrypted password from config.xml  located in $DOMAIN_HOME/config dir

Continue reading…

, , ,

Resolve Middleware problems faster with Remote Diagnostic Agent

Resolve Middleware Problems Faster! Use Remote Diagnostic Agent (RDA)

Source: support.oracle.com (Doc ID 1498376.1)

Comprehensive Data Collection

Remote Diagnostic Agent is a command-line tool which collects configuration and diagnostic data related to:

  • Operating System and Environment
    • Memory, CPU and Disk data
    • OS Patches and Packages
    • Environment Settings
    • Network configuration and statistics
  • Targeted Oracle Product(s)
    • Install Version and Patch information
    • All configuration and log files
    • Metrics (e.g Status Info, DMS Dump, MBean values)

Product Specific Health Checks

RDA also offers pre and post install health checks. Use a pre install check to discover if your host environment complies with Fusion Middleware system requirements. Run a post install check to bring to light configuration settings which may cause issues if not changed. Don’t wait for a problem to arise. Get proactive, take advantage of the health checks today!

Reduce Problem Resolution Time

Oracle Support may request RDA output because it reduces problem resolution time by minimizing the number of requests for more information. RDA is unobtrusive. It does not modify systems and a security filter is provided if required.

WebLogic Server Profile : Default Values and Suppression of Questions

Tip: Expedite result set configuration by setting ORACLE_HOME and DOMAIN_HOME environment variables beforehand.

Example – Target the following for data collection

  • Oracle WebLogic Server installed on a Unix machine
  • Domain – ‘my_domain’
ORACLE_HOME=/u01/app/product/fmw/software/wlserver_10.3; export ORACLE_HOME 
DOMAIN_HOME=/u01/app/product/fmw/config/domains/my_domain; export DOMAIN_HOME 

rda.sh -S -p WebLogicServer

 If RDA finds the environment variables above set, questions are suppressed and/or default answers are provided which can be accepted by hitting return.

Source: support.oracle.com (Doc ID 1498376.1)

Get Proactive with Fusion Middleware – Diagnostic Tools (Doc ID 1389188.1)

Remote Diagnostic Agent (RDA) and Oracle Configuration Manager (OCM)

  • Resolve Fusion Middleware Service Requests Faster! Use Remote Diagnostic Agent — ACT
  • How to Run Remote Diagnostic Agent ( RDA ) Against Oracle WebLogic Server ( WLS ) — ACT
  • Fusion Middleware RDA and OCM Documentation and Configuration Instructions — ACT
  • Using OCM with core Oracle Fusion Middleware Components — ACT
  • Configuring OCM in Oracle Application Server 11g? View this quick and easy Guide. — ACT

Other Fusion Middleware Diagnostic Tools

  • Capture Diagnostics At Time of Failure Using Diagnostic Framework (DFW) — ACT
  • Take Advantage of Dynamic Monitoring Service (DMS) — ACT
  • Take Advantage of Oracle Diagnostic Logging (ODL) — ACT
  • Troubleshoot WebLogic Managed Server Issues Using Thread Dumps — ACT

Inventory Reports

  • The Inventory Report displays data that is uploaded by the configuration manager collector. — ACT

Patch Recommendations

  • Patch recommendations identify configurations that are uploaded through the configuration manager release 10.3.2 or higher that are missing recommended patches issued by Oracle. — ACT

Source: support.oracle.com (Doc ID 1389188.1)

, ,

Installing Oracle Application Express in Oracle Database 12c

apex_logoOracle Application Express (Oracle APEX) is Oracle’s primary tool for developing Web applications with SQL and PL/SQL. Using only a web browser, you can develop and deploy professional Web-based applications for desktops and mobile devices. It is a fully supported, no cost option of the Oracle Database, and is installed by default in all editions of the Oracle Database.

2014-04-13_000116

This article is for learning purposes only!

Prerequisites:

, , , , ,

Installing Oracle WebLogic Server 12c and Oracle HTTP Server Part I

WebLogic12cOracle WebLogic Server 12c is one of the industry’s best application server for building and deploying enterprise Java EE applications. It’s a core component of Oracle Fusion Middleware portfolio and an engine powering Oracle products. Oracle WebLogic Server 12c Release 2 (12.1.2) has been released in July, 2013.

 In This demo/tutorial we will cover installation of Oracle Weblogic Server 12c and Oracle HTTP Server 12c (OHS) on Oracle Linux Server 6. This is one node cluster simulation.

This tutorial is for educational purposes only.

Deployment plan:

  1. Configuring Linux servers for  WLS and OHS
  2. Installing the JDK and setting JAVA_HOME environment variable.
  3. Installing WebLogic Server 12c software
  4. Patching WebLogic with OPatch
  5. Creating a WebLogic domain
  6. Starting WebLogic domain
  7. Installing and configuring Oracle HTTP Server (OHS) in Part II

Prerequisites:

  1. Two virtual Oracle Linux 6 servers have been cloned from a seed “OL6U4_SEED”. New virtual machine names: WLS12c-node1, OHS12c-node1:
  2. Download Oracle software from Oracle technology Network:

1. Configuring Linux servers for WebTier and MidTier – Part I, MidTier

WLS12c_OHS_infra

Continue reading…

, , , ,

Installing Oracle WebLogic Server 12c and Oracle HTTP Server Part II

In previous part we’ve covered installation of Oracle Weblogic Server 12c Installing Oracle WebLogic Server 12c and Oracle HTTP Server Part I. In this, second part we will continue with installation of an Oracle HTTP Server 12c.

Oracle HTTP Server is the web server component for Oracle Fusion Middleware. It provides a listener for Oracle WebLogic Server and the framework for hosting static pages, dynamic pages, and applications over the Web.

In this demo we will install an Oracle HTTP Server in a Standalone Domain.

WLS12c_OHS_infra_part2

Continue reading…

, , , , , ,

SSL Error: Connecting WebLogic Server to Tibco EMS over SSL

The following exception might occur when connecting WebLogic Server JMS Bridge to Tibco EMS Gateway. Bridge’s status: “WARN: failed to connect to the source / target”.

Exception:

javax.naming.ServiceUnavailableException: Failed to query JNDI: 
Failed to connect to the server at tcp://ems-hostname:7243 
[Root exception is javax.jms.JMSException: 
Failed to connect to the server at tcp://ems-hostname:7243]
Caused By: javax.jms.JMSException: Failed to connect to the server 
at tcp://ems-hostname:7243
at com.tibco.tibjms.TibjmsxLinkTcp._doHandshake(TibjmsxLinkTcp.java:893)

Solution:

1. Make sure you have the following files in WebLogic domain lib directory:

#Example:
DIR: /ora/product/oracle/admin/domains/wls_soadom1/lib/Tibco
#Required jars
tibjms.jar
tibcrypt.jar

#Other Tibco jars
slf4j-api-1.4.2.jar
slf4j-simple-1.4.2.jar
tibemsd_sec.jar
tibjmsadmin.jar
tibjmsapps.jar
tibjmsufo.jar
tibrvjms.jar

#Important!
jndi.properties

2. Most important part: create jndi.properties file in above directory with the following arguments:

# /ora/product/oracle/admin/domains/wls_soadom1/lib/Tibco
# jndi.properties

com.tibco.tibjms.naming.security_protocol=ssl
com.tibco.tibjms.naming.ssl_enable_verify_host=false
com.tibco.tibjms.ssl.vendor=j2se
com.tibco.tibjms.security_protocol=ssl
com.tibco.tibjms.ssl_enable_verify_host=false
com.tibco.tibjms.ssl.enable_verify_hostname=false

#DEBUG JVM arguments - not mandatory, only for debugging
com.tibco.tibjms.debug=true
com.tibco.tibjms.ssl.debug.trace=true
com.tibco.tibjms.ssl.trace=true

3. Optional Mandatory: Add lib location to the CLASSPATH in settings for JMS bridge destination for a JMS message provider. WebLogic Server is picking up automatically and recursively all libs from DOMAIN_HOME/lib directory, but not jndi.properties though.

#Example:
/ora/product/oracle/admin/domains/wls_soadom1/lib/Tibco

2014-03-23_000113

 

 Conclusion:

  • Make sure that Tibco root certificate has been added to WLS keystore (NOT DEMO store in PROD)
  • WLS managed server doesn’t have to listen on SSL port – in case of one way connection WLS (client) –> Tibco (Server) over SSL
  • Providing path in CLASSPATH is mandatory in each bridge destination configuration, this is also included in Tibco documentation.
  • Tibco should document its product in much better way.  Requirement for presence of jndi.properties file in lib directory seems to be not documented at all.

Cheers!

, , , , , , ,

Previous Posts Next posts

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close