How to Create / Configure / Maintain JMS Server & Module in Weblogic 11g / 12c

In this post here i have tried to put across step by step process to create JMS Server , JMS Module etc to complete required full configuration for Weblogic JMS server for 12c. Steps will remain same for weblogic 11g as well.

• Login to Weblogic console and go to Domain Structure -> Services -> Messaging
• Select JMS Server
• Create a new JMS Server page will open, enter below details
• Name : Name of JMS Server 
• Persistent Store : Provide the name of Persistent Store. This is covered in other post previously. Click here to go to the How to create Persistent store 
• Click Next
• On the next screen select Target. It should be the server where you want to create this JMS Server.
• Click Finish 
• Now we have JMS Server and we need to add JMS Module 
• Go to Domain Structure -> Services -> Messaging -> Select JMS Module
• Click on New button to create new JMS Module
• Enter required information in create new JMS page
• Name : UserJMSModule
• Descriptor : UserJMSModule
• Location in Domain : leave it blank to create it at default location and click Next
•  On the next page select appropriate target server where you want to deploy this JMS Module and select Next
• In the next window leave the check box "Would you like to add resources to this JMS system module?" unchecked and click finish

• Message should be displayed as "The JMS module was created successfully". 
• Under settings for UserJMSModule go to subdeployment tab and click New
• Provide the name of subdeployment as "UserSubDeployment" and click next
• Select the previously created "UserJMSServer" and click on finish and message should be displayed as "Subdeployment created successfully"
• Click on Activate the changes to make the changes available for use in the domain.

• 
  
• 
  

Disable Case Sensitive Group Names in Human Task

Group Names in Human Task are case sensitive by default. However usernames are not. So While working with Human task you can use an case while specifying username but it may result into invalid group name / group not found issue if Group Name used is not using exact case.

You can disable case sensitivity of Group Name for Human Task by setting up caseSensitiveGroups Property in MBean Browser. Here are the steps.

1. Right-click soa-infra, and select Administration > System Mbean Browser.
   The System MBean Browser is displayed on the right side of the page.
   
2. Expand Application Defined MBeans > oracle.as.soainfra.config > Server: server_name > WorkflowIdentityConfig > human-workflow > WorkflowIdentityConfig.PropertyType > caseSensitiveGroups.
   
3. Click the Operations tab.
   
4. Click setValue.
   
5. In the Value field, enter false.
   
6. Click Invoke.
    
   

Decrease / Increase / Resize tablespace in Oracle Database

Below is the list of commands you can use to increase / decrease / Resize your tablespace in Oracle Database. I run this commands in Oracle 11g database however these should also run fine in other versions of Oracle as well.

Adding more tablespace
Alter tablespace  add datafile 'datafile_location_where_file_will_be_added_without_file_name' size 1G;

Checking size of datafiles
Select name, bytes from v$datafile;


Decreasing Tablespace
Say your datafile is of size of 10 gb and you want to decrease it by 6 GB you can use below command.
Alter database datafile 'complete_path_to_datafile_goes_here' resize 4G;

Above command may not work it space is already utilized and data is alredy there in the file. Oracle may throw appropriate error message like below.

ORA-03297: file contains used data beyond requested RESIZE value

ORA-12516, TNS:listener could not find available handler with matching protocol stack

In one of my SOA project, we are running SOA Suite 11g - 11.1.1.4  on Weblogic 11g Cluster in Bladframe machine. Backend used here for SOA Schema database is Oracle 11g RAC database.

After couple of weeks of successfully execution in developement environment we hit this issue of  ORA-12516, TNS:listener. This error generally means there is no connection available to the database.We need to configure the database to allow more connection.

As suggested by Oracle, we should have number of processes setting to 200 for SOA Suite 11g. This setting is already in place and still we hit the ORA-12516, TNS:listener-issue. This happens mostly because of wrong Data sources connection settings, which allows to exapand its connection pool to hundreds of connections.

Even while restarting the weblogic server you will not be able to get the weblogic server in running mode , because all data sources will fail while trying to connect to database and you server state will go to Admin mode because of this.

Solution to ORA-12516, TNS:listener Error

1. Loging to one of the database node using sqlplus as sys or system (basically sysdba role required)
2. Increase the number processes and sessions by executing below commands
• ALTER SYSTEM SET PROCESSES=400 SCOPE=SPFILE;
• ALTER SYSTEM SET SESSIONS=400 SCOPE=SPFILE;
3. Bounce the database again to take these changes
• SHUTDOWN IMMEDIATE;
• STARTUP;
4. To Verify the settings are updated properly; execute below sql commands
1. SHOW PARAMETERS PROCESSES;
2. SHOW PARAMETERS SESSIONS;

If you are using Oracle RAC database you may want to perform these steps again on another node.

Installing Oracle XE 11g Database on Redhat 5.6 / Linux 64 bit

Recently Oracle has announced the Beta release of Oracle Express Edition (XE) 11g. Below is the step by step process for the installation of Oracle XE 11g database on Linux x86-64 machine.

Installation of Oracle XE 11g is pretty straight forward process and all step by step installation steps are included here in this tutorial. All XE version of oracle are very easy to install and configure while you are in development mode.

Oracle XE 11g Installation steps :

1. You can download the most recent version of Oracle XE 11g database by refering the details on http://www.oracle.com/technetwork/database/express-edition/overview/index.html.
2. This installation will require minimum of 1.5 GB of RAM, so please make sure you have required space available on your machine.
3. Swap space required is 2 GB or twice the size of RAM. Whichever is less.
1. To check current you can run command swapon -s on shell.
4. And to start the installation it requires root permission on linux box.
5. execute the below command to install the Oracle XE 11g 
6. Oracle does not provide a way to install Oracle XE 11g on particular directory. It will install it directly on root /u01 but if you want to install this on directory of your choice use my post Hacker's choice.
7. rpm -ivh oracle-xe-11.2.0-0.5.x86_64.rpm below is the command with output
8.  rpm -ivh oracle-xe-11.2.0-0.5.x86_64.rpm
   Preparing...                ########################################### [100%]
      1:oracle-xe              ########################################### [100%]
   Executing post-install steps...
   
   You must run '/etc/init.d/oracle-xe configure' as the root user to configure the database.
   
9. Execute below command to configure Oracle XE 11g database.
   

   $ /etc/init.d/oracle-xe configure

10. It will ask for HTTP Port , database listener port, and password for the database which will be used for SYS and SYSTEM. Below is the complete installation output.
11. --> /etc/init.d/oracle-xe configure
    
    Oracle Database 11g Express Edition Configuration
    -------------------------------------------------
    This will configure on-boot properties of Oracle Database 11g Express
    Edition.  The following questions will determine whether the database should
    be starting upon system boot, the ports it will use, and the passwords that
    will be used for database accounts.  Press to accept the defaults.
    Ctrl-C will abort.
    
    Specify the HTTP port that will be used for Oracle Application Express [8080]:
    
    Specify a port that will be used for the database listener [1521]:
    
    Specify a password to be used for database accounts.  Note that the same
    password will be used for SYS and SYSTEM.  Oracle recommends the use of
    different passwords for each database account.  This can be done after
    initial configuration:
    Confirm the password:
    
    Do you want Oracle Database 11g Express Edition to be started on boot (y/n) [y]:
    
    Starting Oracle Net Listener...Done
    Configuring database...Done
    Starting Oracle Database 11g Express Edition instance...Done
    Installation completed successfully.
    
     
12. Now start the Oracle XE 11g database by using below command
13. --> /etc/init.d/oracle-xe start
14. If you want to stop command is --> /etc/init.d/oracle-xe stop

    Uninstalling the Oracle XE 11g #

    --> rpm -qa | grep oracle 

    --> rpm -e oracle-xe

Hacker's Choice - How to Install Oracle 11g XE on Specified Targeted Directory

If you are installing Oracle 11g XE on Linux machine, it is getting installed by default on root (/). And it does not provide a way to change.

Oracle is not providing a way to specify the destination directory / user defined directory for Oracle XE 11g Database. So here is the hack for how to install Oracle XE database on directory of your choice.

create a symbolic link with the name /u01 in root directory which point to /app/oracle.
For Oracle XE 11g  use below commands
--> cd /
--> ln -s / u01

Same trick works for Oracle XE 10g as well.

And .... yeah enough you are done. Go ahead with your normal installation and it will be installed to /app/oracle.

Tutorial 2 : How to Install Oracle SOA Suite 11g (11.1.1.3) Part II - Installing Oracle XE Database

In this tutorial, I am going to cover installation for the Oracle database  required for SOA Suite 11g. For developement purpose we are going to use Oracle Express edition of Database i.e. Oracle XE database. This tutorial and screen shots taken all are for Windows operation system but process is more or less similar in other operation systems as well.

This tutorial has to be followed properly and Oracle XE database has to be installed and configured perfectly. For successfull installation of SOA Suite 11g, this Oracle XE database has to be up and running before proceeding further for other tutorials.

If you have not download yet, Get the latest copy from Oracle website at http://www.oracle.com/technetwork/database/express-edition/downloads/index.html and save it to c:\SOAInstallables (This is the same director which we have created in first tutorial of How to Install Oracle SOA Suite 11g.

When you download the Oracle XE database make sure you download the Universal Installer


Note : When you are running Repository creation utility for creating schema in database before installing SOA Suite 11g, you will see warning that the database you are using is too old. you can safely ignore this warning as it applies for production environment.

As you are installing the Oracle XE as database server for SOA Suite 11g installation, It is important to know that what is the version when we say we are using Oracle XE Database. Database version for Oracle XE is 10.2.0.1 and SOA Suite 11g Installation requires actually 10.2.0.4 or higher or 11.1.0.7 or higher. And that is the reason we are getting the warning while running the Repository Creation Utility before installing SOA Suite 11g. Oracle XE is very good choice for small footprint database in SOA Suite 11g development environment.


Ok, Now you are ready to start with the installation of Oracle XE database for seting up SOA Suite 11g development environment.

Step 1 : Go to c:\SOAInstallables directory and click on OracleXEUniv.exe and It will start the Installation wizard as below. Click Next to proceed

Step 2: As shown in below screen shot select "I accept" and click Next

Step 3 : Specify the location where you want to install Oracle 10g Express Edition server and click next.

Step 4 : specify the password for the SYS and SYSTEM
user account for this database

Step 5 : Reviw the setting and click on Install

Step 6 :  Wizard will start installing and copying files

Step 7 : Click on Finish

Step 8 : Go to this URL http://127.0.0.1:8080/apex/ and login using SYS and password you have specified for the SYS and SYSTEM user accounts while creating database.  You will be able to see four icons

• Administration
• Object browser
• SQL
• Utilities

You won't need Oracle client here, all can be done from this User Interface.

• Oracle Essentials: Oracle Database 11g
• Oracle 11g For Dummies
• Expert Oracle Practices: Oracle Database Administration from the Oak Table 
• Oracle Database 11g DBA Handbook (Osborne ORACLE Press Series) 
• Oracle Database 11g The Complete Reference (Osborne ORACLE Press Series) 
• Beginning Oracle Database 11g Administration: From Novice to Professional 
• Oracle Database 10g Performance Tuning Tips & Techniques (Osborne ORACLE Press Series) 
• Expert Oracle Database Architecture: Oracle Database Programming 9i, 10g, and 11g Techniques and Solutions, Second Edition 
• Oracle Database 10g: A Beginner's Guide (Osborne ORACLE Press Series) 
• Oracle Database 11g PL/SQL Programming (Osborne ORACLE Press Series) 
• Expert Oracle Database 11g Administration (Expert's Voice in Oracle)