JDBC Datasource creation on Precise Ubuntu box using Vagrant Oracle XE

Preparation 

• Download Ubuntu-Vagrant-Oracle-xe
• Modify the Vagrantfile

The major changes in the vagrangfile are Oracle XE on Vagrant Ubuntu box

• Memory size 1024MB 
• Select the hostonly network adapter with a private IP. 

 The vagrant file:

# -*- mode: ruby -*-
# vi: set ft=ruby :

Vagrant.configure("2") do |config|
  config.vm.box = "precise64"
  config.vm.box_url = "http://files.vagrantup.com/precise64.box"
  config.vm.hostname = "oracle.vybhava.com"
  config.vm.synced_folder ".", "/home/vagrant/vagrant-ubuntu-oracle-xe", :mount_options => ["dmode=777","fmode=666"]
  config.vm.network "private_network", ip: "192.168.33.105"
  config.vm.network :forwarded_port, guest: 1521, host: 1521

  config.vm.provider :virtualbox do |vb|
    vb.customize ["modifyvm", :id,
                  "--name", "oracle",
                  # Oracle claims to need 512MB of memory available minimum
                  "--memory", "1024",
                  # Enable DNS behind NAT
                  "--natdnshostresolver1", "on"]
  end

  config.vm.provision :shell, :inline => "echo \"America/New_York\" | sudo tee /etc/timezone && dpkg-reconfigure --frontend noninteractive tzdata"
  config.vbguest.auto_update = false
  ....
... # remain code as it is no changes
end

Configure DataSource on WebLogic administration console

Step-by-Step JDBC Datasource creation process is as follows

1. login to your WebLogic domain and navigate to the domain structure section select datasource

1. Select Datasource in the work area select New button

1.a Select Generic Data source

2. Enter JDBC Datasource properties : name, JNDI name, Database type

3. Select Database driver

4.XA driver selection nothing to select in the transaction

5. Connection pool parameters

6.a. Connection pool Test confirmation

6.c. Test Configuration Message - Succeeded

7. Target the data source to Cluster for HA

8. Completion of Datasource configuration

Sample Java program to validate the datasource given below:

package vybhava.technologies.jdbc;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Hashtable;
import javax.naming.Context;
import javax.naming.InitialContext;

/**
 * This example demonstrates obtaining a database connection using a
 * DataSource object.
 * Create a DataSource using any DB name it as myDs and its JNDI as jdbc/myDs
 * To compile:  javac -d . SimpleSql.java
 * Execute : java vybhava.technologies.jdbc.SimpleSql
 */
public class SimpleSql {

  public static void main(String argv[])
      throws Exception {

    java.sql.Connection conn = null;
    java.sql.Statement stmt = null;
    ResultSet rs = null;

    try {

      // ============== Get a database connection ==================

      Context ctx = null;

      // Put connection properties in to a hashtable.
      Hashtable ht = new Hashtable();
      ht.put(Context.INITIAL_CONTEXT_FACTORY,"weblogic.jndi.WLInitialContextFactory");
      ht.put(Context.PROVIDER_URL, "t3://192.168.33.104:7011,192.168.33.104:7012");

      // Get a context for the JNDI lookup
      ctx = new InitialContext(ht);
      // Look up the data source
      javax.sql.DataSource ds = (javax.sql.DataSource) ctx.lookup("jdbc/myDs1");
      //Get a database connection from the data source
      conn = ds.getConnection();
      conn.setAutoCommit(true);

      System.out.println("Making connection...\n");

      // ============== Execute SQL statements ======================
      stmt = conn.createStatement();

      try {
        stmt.execute("drop table empdemo");
        System.out.println("Table empdemo dropped.");
      } catch (SQLException e) {
        System.out.println("Table empdemo doesn't need to be dropped.");
      }

      stmt.execute("create table empdemo (empid int, name varchar(30), dept int)");
      System.out.println("Table empdemo created.");

      int numrows = stmt.executeUpdate("insert into empdemo values (0, 'John Smith', 12)");
   numrows = stmt.executeUpdate("insert into empdemo values (1, 'Pavan Devarakonda', 12)");
   numrows = stmt.executeUpdate("insert into empdemo values (2, 'Suresh', 13)");
      System.out.println("Number of rows inserted = " + numrows);

      stmt.execute("select * from empdemo");

      rs = stmt.getResultSet();
      System.out.println("Querying data...");
      while (rs.next()) {
        System.out.println("  ID: " + rs.getString("empid") +
            "\n  Name: " + rs.getString("name") +
            "\n  Dept: " + rs.getString("dept"));
      }

      numrows = stmt.executeUpdate("delete from empdemo where empid = 0");
      System.out.println("Number of rows deleted = " + numrows);
    } catch (Exception e) {
      System.out.println("Exception was thrown: " + e.getMessage());
    } finally {
   // ========== Close JDBC objects, including the connection ======= 
      try {
        if (stmt != null) {
          stmt.close();
          stmt = null;
        }
      } catch (SQLException e) {
        throw e;
      } finally {
        try {
          if (conn != null) {
            conn.close();
            conn = null;
          }
        } catch (SQLException e) {
          throw e;
        }
      }
    }
  }
}

 Finally you need to compile the above program and execute that. You can see the commands in the comments.

JDBC Datasource validating  with SimpleSql.java compile and execution

01.a. Installation of WebLogic Server 12c on Unix and Linux platforms

The beginning of the WebLogic Administration practical work with installation of WebLogic software. Before you began, you must aware per-requisites for installation and also how you can proceed for the installation.  This blog post is specially for newbies who just began learning WebLogic.

Determining supported configurations for WebLogic Server

Software requirements
There are many Java vendors according to your platform you need to select specific Java. every WebLogic release version is publishing a certificate matrix which will tell you what platform versions it support and which JDK version you need to use for WebLogic installation.

• Sun/Oracle HotSpot JDK
• Oracle JRockit
• IBM JVM
• HP JDK

Example Certificate Matrix Reference
WebLogic 12.1.3 certificate matrix

Hardware Requirements

• 512 MB RAM
• 20 GB HDD
• CPU 300 MHz
• i3 or above processors Amd

Installation modes

WebLogic server 12c can be installed in two ways

• Silent mode installation
• GUI mode installation

WebLogic 12.1.3 silent mode installation on Ubuntu

1. What is silent mode installation? And why?

This is the initial setup required to learn WebLogic Administrator. If you unable to do silently you are unfit for the production environment setup. Silent-mode installation allows us to define an installation configuration only once and then use the configuration to duplicate the installation on many machines. During installation in silent mode, the installation program reads the inputs for desired settings up configuration from an silent response file that you must prepare before beginning the installation. The installation program does not display any configuration options during the installation process. Silent-mode installation works on both Windows and Linux and UNIX systems also.

WebLogic 12c silent mode installation

Major Benefits

• Less time of execution of the installation process 
• Cloud-ready platforms use this method most often
• This process can be used in configuration tools such as chef, puppet etc 
•  Easy to install in multiple machines/Production environments
•  No need of X11 or Mouse clicks!!

Java Installation

Step 1: JDK installation

You can download JDK from Oracle Technical Network (OTN)  Link

 We have two choices to install JDK on a Linux platform:
1. Common for any Linux platform: tar.gz file

tar -zxvf /u01/app/software/jdk*.gz

 

2. To install WebLogic Server in silent mode installation first we have to install JDK in the Ubuntu.The alternative in the Ubuntu box as follows:

1. sudo add-apt-repository ppa:webupd8team/java
2. sudo apt-get update
3. sudo apt-get install oracle-java7-installer

Step 2: Setup the Environment variables in file called .bash_profile, assume that your login shell is bash. Modify the JAVA_HOME, MW_HOME according to your installations.

export JAVA_HOME=/usr/lib/jvm/java-7-oracle
export PATH=$PATH:$JAVA_HOME/bin
export MW_HOME=/u01/app/oracle/fmw/oraclehome
export WL_HOME=$MW_HOME/wlserver
export CLASSPATH=$WL_HOME/server/lib/weblogic.jar:.

alias wlst="$MW_HOME/oracle_common/common/bin/wlst.sh"

Step 3:Download WebLogic server 12.1.3 Generic file from download link.

Steps involved in silent mode installation

Step 4: Create a directory “silent” and copy the wls.jar file to this directory. mkdir silent

Step 5: Go to the silent directory by using cd silent/

Step 6: Create a file oraInst.loc file in silent directory as follows as: vi oraInst.loc And insert inventory location and installation group as follow as

Inventory_loc=/u01/app/oracle/silent/oraInventory/
Inst_group=oinstall

Step 7: Create a response file and insert below things in the response file

[ENGINE]
Response File Version=1.0.0.0.0
[GENERIC]
ORACLE_HOME=/u01/app/oracle/fmw
INSTALL_TYPE=WebLogic Server
DECLINE_SECURITY_UPDATES=true
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false

You could edit the ORACLE_HOME as you change versions and also

There could be multiple options for INSTALLATION_TYPE:

1. WebLogic Server
2. Coherence
3. Complete with Examples
4. Fusion Middleware Infrastructure [Infrastructure domains]
5. Fusion Middleware Infrastructure with Examples [for Restricted JRF, EM domains]

Step 7: Go to the wls.jar location ie in the silent directory and insert the following command

java -jar /u01/app/software/fmw_12*_wls.jar \
-silent -invPtrLoc /u01/app/oracle/silent/oraInst.loc \
-responseFile /u01/app/oracle/silent/responsefile.rsp

Step 8: Check WebLogic server is installed in mention location or not

Conclusion 

 Easy once you worked on this procedure you can work on SOA, OSB, ADF and any Oracle Fusion Middleware products.
The above work is for 12.1.3 version which is an older version of 12c!

WebLogic 12.2.1.x installation in silent mode

The latest version of 12c is 12.2.1.0.0 lets enjoy the new features of WebLogic on Vagrant box here I have executed the installer without matching the certificate matrix. So two of them are not satisfied

1. Ubuntu Linux
2. JDK 1.8.0_51 is expected provided 1.8.0_45 

WHAT IS NOT INCLUDED IN THE QUICK INSTALLER?

- Native JNI libraries for unsupported platforms.
- Samples, non-English console help (can be added by using the WLS supplemental Quick Install)
- Oracle Configuration Manager (OCM) is not included in the Quick installer
- SCA is not included in the Quick Installer

[Source extracted from README.txt file]

To install the Quick installer use the following command:

 java -jar fmw_12.2.1.3.0_wls_quick.jar ORACLE_HOME=/u01/app/oracle/fmw

The output of Quick install command:

To install the generic installer use the following command:

oracle@mydev:/u01/app/software$ java -jar fmw_12*_wls.jar -silent -invPtrLoc /home/oracle/silent/oraInst.loc -response /home/oracle/silent/responsefile.rsp
Launcher log file is /tmp/OraInstall2015-10-30_01-30-57AM/launcher2015-10-30_01-30-57AM.log.
Option "-response" is deprecated; use "-responseFile" instead.
Extracting files................................
Starting Oracle Universal Installer

Checking if CPU speed is above 300 MHz.   Actual 2592.418 MHz    Passed
Checking swap space: must be greater than 512 MB.   Actual 767 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 72517 MB    Passed


Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2015-10-30_01-30-57AM
Log: /tmp/OraInstall2015-10-30_01-30-57AM/install2015-10-30_01-30-57AM.log
Copyright (c) 1996, 2015, Oracle and/or its affiliates. All rights reserved.
Reading response file..
Skipping Software Updates
SEVERE:OUI-10054:Unable to modify the group ownership of the OUI inventory to the requested group name "vagrant". Either the specified group doesnt exist, or the current userid does not belong to that group. If the group exists, you may run the shell script {1} as root to change the group name after installation is complete.
Starting check : CertifiedVersions
sh: 1: /bin/rpm: not found
Check complete. The overall result of this check is: Not executed <<<<
Warning: Check:CertifiedVersions completed with warnings.


Starting check : CheckJDKVersion
Problem: This JDK version was not certified at the time it was made generally available. It may have been certified following general availability.

Recommendation: Check the Supported System Configurations Guide (http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html) for further details. Press "Next" if you wish to continue.

Expected result: 1.8.0_51
Actual result: 1.8.0_45
Warning: Check:CheckJDKVersion completed with warnings.


Validations are enabled for this session.
Verifying data
Copying Files

...............................................................  38% Done.
...............................................................  76% Done.
.....
Installation in progress (Friday, October 30, 2015 1:32:39 AM UTC)
                                                            79% Done.
Install successful

Linking in progress (Friday, October 30, 2015 1:33:07 AM UTC)
Link successful

Setup in progress (Friday, October 30, 2015 1:33:07 AM UTC)
Setup successful

Saving inventory (Friday, October 30, 2015 1:33:08 AM UTC)
Saving inventory complete

End of install phases.(Friday, October 30, 2015 1:33:08 AM UTC)
Percent Complete : 100

The installation of Oracle Fusion Middleware 12c WebLogic Server and Coherence 12.2.1.0.0 completed successfully.
Logs successfully copied to /home/oracle/oraInventory/logs.
oracle@mydev:/u01/app/software$

 Troubleshoot installation issues

Issue 1: Qucick installation time got the following error

oracle@localhost:~$ java -jar fmw_12.2.1.3.0_wls_quick.jar ORACLE_HOME=/u01/app/oracle/fmw
Error: Unable to access jarfile fmw_12.2.1.3.0_wls_quick.jar

Fix: Check the the path where the "fmw_12.2.1.3.0_wls_quick.jar" available, navigate to the path or provide absolute path.

 * Quiz time

When installing Oracle Weblogic Server 11g with the graphical installer, which three statements are true?
A. You must choose either a typical or a custom installation.
B. You install under Microsoft Windows because the graphical installer is available only for Window C. You may create a new middleware home directory or choose an existing one.
D. You must register for critical security updates.
E. You may install a JDK or choose one that was previously installed.