Online Apps DBA

This is my first attempt with WLST (WebLogic Scripting Tool) which is scripting tool to create , manage and monitor webLogic domains, more information here .

.

You can invoke WLST by running  “java weblogic.WLST”

I tried this on my WebLogic Server and straight hit error
_________

Exception in thread “main” java.lang.NoClassDefFoundError: weblogic/WLST
_________

I soon realised that jar file which contains class weblogic.WLST is missing from classpath and quick fix is to set environment variable using setWLSEnv.sh (under WL_HOME/server/bin) . For Fusion MiddleWare (FMW) 11g, it should be under $MW_HOME/ wlserver_10.3/ server/ bin

______
set environemnt variable for weblogic server
cd WL_HOME/server/bin
. ./setWLSEnv.sh
______

$ java weblogic.WLST

Initializing WebLogic Scripting Tool (WLST) …

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands

wls:/offline>
__________

.
More on WLST commands coming in next posts but here are some WLST basics

.

1. WebLogic Scripting Tool (WLST) – is command line scripting tool to create , manage and monitor webLogic domains and resources/applications deployed on WebLogic

2. WLST is based on Jython based scripting language, which in turn is Java implementation of Python.

3. WLST is used
- To automate common tasks
- If administration console is not available or as alternative to Administration Console

4. WLST can be run in offline and online mode
a) online mode> interact with running weblogic server
b) offline mode> servers in domain should be shutdown and WLST updates directly config.xml on file system

5. If you do not supply any script file then WLST runs in interactive mode.
6.You can generate WLST scripts via WebLogic Console as well -> click on Record button on console after clicking ‘Lock and Edit’ button on change center. To end recording click on ‘Activate Changes’

.

.

7. WLST communicates with Weblogic’s MBean to retrieve and update resources on a running server.

1. Exception in thread “main” java. lang. NoClassDefFoundError : weblogic/WLST

Share This

In my first post on WebLogic here here, I discussed about Weblogic installation using 32 bit of JDK so How to install 64 bit WebLogic on 64 bit Operating System (Linux/Unix) ?

 .

Install 64 bit WebLogic on 64 bit O.S (Unix/Linux)

1. Download jar file wlsXXX_generic.jar from here under column “Additional Platform”

2. Install 64 bit of JDK on your Unix/Linux machine (steps below)

3. Install WebLogic Server using 64 bit JDK with option -d64 and wlsXXX_generic.jar  like

$JDK1.6/bin/java -d64 -jar wlsXXX_generic.jar

 .

.
How to install 64 bit JDK on Solaris Sparc ?

Steps mentioned here are for 64 bit Solaris Sparc (If you are using Linux download 64 bit JDK for Linux)

1. Download JDK 1.6 from here  and copy it to /tmp

mkdir /usr/java/1.6
cd /usr/java/1.6

2. Install jdk-6u16-solaris-sparc.sh
/tmp/jdk-6u16-solaris-sparc.sh

3. Install jdk-6u16-solaris-sparcv9.sh
cd /usr/java/1.6
/tmp/jdk-6u16-solaris-sparcv9.sh

4. Check JDK version
bash-3.00# cd /usr/java/1.6/bin
bash-3.00# ./java -d64 -version

_______
java version “1.6.0_16″
Java(TM) SE Runtime Environment (build 1.6.0_16-b01)
Java HotSpot(TM) 64-Bit Server VM (build 14.2-b01, mixed mode)
_______ .

References

• Download WebLogic Software
• Install 32 Bit Java  
• Install 64 bit Java
• WebLogic Server Installation Guide 

1. Oracle WebLogic Installation Steps
2. Domain , Administration & Managed Server, Cluster in Oracle WebLogic
3. Create Domain in Oracle WebLogic
4. Oracle WebLogic Server - Startup/Shutdown
5. Oracle WebLogic Server 10g R3 10.3 is out now
6. Deploy Application on Oracle WebLogic Server
7. Cluster Architecture : Oracle WebLogic Server
8. Start WebLogic Server on Linux on port 80, 443 <= 1024
9. JDBC (Java DataBase Connectivity ) in Oracle WebLogic - Overview
10. WebLogic Server JDBC for Database connection : Step by Step
11. Security in Oracle WebLogic : Realm, Security Provider, Authentication, Authorization, Users
12. Deploy ADF application to Oracle WebLogic Server
13. Node Manager in Oracle WebLogic Server
14. Configure Oracle HTTP Server infront of Oracle WebLogic Server mod_wl_ohs
15. How to install weblogic server on 64 bit O.S. (Linux /Solaris) ?

Share This

Autoconfig is tool/utility to reconfigure your Oracle Application configuration files using context (XML file) and template files, more information here and here  

This post covers steps to run Autoconfig in Oracle Apps R12 (steps are similar to 11i, only change is location of autoconfig script and log files)

.

A) Running Autoconfig on R12 environment Application Tier

1. Login as user owning application tierfor R12 (usually applmgr)

2. Set environment variable by executing env file $INSTALL_BASE/ apps/ apps_st/ appl/ APPL[$SID]_[$hostname].env

3. cd $ADMIN_SCRIPTS_HOME  (or $INSTALL_BASE/apps/$CONTEXT_NAME/ admin/ scripts)

4. run adautocfg.sh (Autoconfig script)
./adautocfg.sh5. Supply apps password when prompted.
.
B) Running Autoconfig on R12 environment Database Tier

1.Login as user owning database tier for R12 (usually oracle)

2. Set environment variable by executing env file $INSTALL_BASE/ db/ tech_st/ [11.1.0 or 10.2.0]/ [$SID]_[$hostname].env

3. cd $ORACLE_HOME/ appsutil/ scripts/ $CONTEXT_NAME

4. run adautocfg.sh (Autoconfig script)
./adautocfg.sh

5. Supply apps password when prompted

.

.

Things good to know about Autoconfig in R12
1. Autoconfig logs for R12 application tier are at

$INSTALL_BASE/inst/apps/$CONTEXT_NAME/admin/log/$MMDDHHMM/adconfig.log ($INST_TOP/admin/log/[$MMDDhhmm])

2. Autoconfig logs for R12 Database tier are at

[$RDBMS_ORACLE_HOME]/appsutil/log/[$CONTEXT_NAME]/[$MMDDhhmm]/adconfig.log

3. R12 system is autoconfig enabled and uses context file stored in [INST_TOP]/appl/admin/[CONTEXT_NAME].xml (Application Tier)
and
[$DATABASR_ORACLE_HOME]/appsutil/[$CONTEXT_NAME].xml (Database Tier)

.

Related

• 387859.1  Using AutoConfig to Manage System Configurations in Oracle E-Business Suite Release 12

1. Preserving Customizations in Oracle Apps 11i or R12
2. Autoconfig Basics
3. Unwrapping XML , Context File or Autoconfig configuration file
4. Autoconfig in Apps template files Contd….
5. Autoconfig in Oracle Apps R12 adautocfg.sh

Share This

Last Year I discussed about Oracle Service Bus here, from Fusion Middleware SOA 11g, Oracle’s Enterprise Bus is renamed as Oracle Mediator and BEA’s AquaLogic Service Bus (ALSB) is now called as Oracle Service Bus.

This post covers high level Installation steps for Oracle Service Bus (OSB) 10.3.1 .  Oracle Service Bus 10.3.1 uses Oracle WebLogic Server so make sure you understand WebLogic concepts “Domain, Administration and Managed Server” more information here

.
Oracle Service Bus Installation Steps

A. Install OSB Software
B. Configure/create domain for OSB
C. Start WebLogic Server
D. Access OSB Console

A. Install OSB Software

1. Download Service Bus Software from here
2. Start Installation by running osb1031_wls103_[os].bin
3. Choose Installation Type
a) Typical- WebLogic Server, Workshop and Oracle Service Bus
b) Custom - individual components

.
4. Select Installation Directory for OSB

.

B. Create/Configure domain for OSB

1. Start domain creation by running $INSTALL_BASE/ wlserver_10.3/ common/ bin/config.sh
2. Select create a new WebLogic Domain

3. Select Generate a domain configured to automatically support Oracle Service Bus

4. Enter WebLogic Administrator Login details
5. You can choose customize installation (change listen port, server…) or select default installation

Default installation will create domain “base_domain” with Administration Server listening on port 7001

. 

C. Start WebLogic Server

$INSTALL_BASE/ user_projects/ domains/ [base_domain]/ startWebLogic.sh
 

D. Access Oracle Service Bus Console

Use URL  http://servername:7001/sbconsole

(weblogic/password) where weblogic/password are credential defined above (section B point 4)

.
.

Documentation

• Download Oracle Service Bus from here
• OSB Documentation Library here
• OSB installation Guide here

.

Oracle Service Bus High Availability Deployment (Active-Active) coming soon !!!

1. Oracle Service Bus << AquaLogic Service Bus (BEA) + Oracle Enterprise Service Bus (Oracle)
2. Oracle Service Bus 10.3.1 Installation

Share This

This post covers steps on how to troubleshoot “Unable to call fnd_ldap_wrapper . create_user / update_user” issues. This is similar to issue I discussed here in May 2009

.

Setup - E-Business Suite (11i/R12) integrated with OID/SSO
Issue- Error while creating/updating user in EBS 11i/R12 - Unable to call fnd_ldap_wrapper . create_user | update_user

.

This error could be because of many reasons , to name few
1) More Secure Password Policy in OID compared to E-Business Suite
2) User already exists in OID but missing in E-Business Suite
3)  apps user does not have privileges to access dbms_ldap package.
4) AppsDN password expired in OID (password expiry in OID)
5) OID or DIP server not running

To narrow down issue, enable debug in Apps and then search for issues around error message.

.

How to troubleshoot fnd_ldap_wrapper issues ?

Step 1 : Enable Profile Option Debug

System Administrator -> Profile -> System -> set profile option “FND: Debug Log Enabled” to Yes

.

Step 2 : Reproduce Issue

Step 3 : Check logs in FND_LOG_MESSAGES table

SQL> select module||’ ‘||message_text , timestamp from apps.fnd_log_messages where timestamp > (sysdate - 1) order by timestamp;

fnd.plsql.oid. fnd_ldap_user. create_user: ORA-31202:DBMS_LDAP: LDAP client/server error: UnKnown Error Encountered
. Server Plug-in OCI failure 12-Aug-09

Step 4 : Search for issue mentioned in message_text from apps.fnd_log_messages (In my case ORA-31202 - Server Plug-in OCI failure which was caused by custom plug-in OID for ldapadd event)

1. 25 Things Apps DBA should know for Apps 11i/R12 Integration with OID/SSO
2. Questions for Oracle Apps 11i & R12 Integration with 10g AS/SSO
3. Oracle Single Sign-On Server for Apps DBA
4. Clone Apps 11i/R12/12i integrated with SSO
5. Notes/Docs to integrate Apps 11i with 10g AS Portal/OID/SSO
6. Migrate Users to/from OID and Oracle Apps 11i/R12
7. User created in Apps 11i/R12/12i not sync to OID
8. Apps 11i/R12/12i Registration/Deregistration with OID/SSO : internals
9. Error while running SSO registration on 11i : txkrun.pl -script=SetSSOReg
10. How to Deregister SSO/OID from Oracle Apps 11i/R12/12i
11. Error adding new User (11i) - unable to call fnd_ldap _wrapper .create_user
12. Unable to call fnd_ldap_wrapper . create_user / update_user ORA-20001

Share This

Concurrent –> Request –> Submit Request –> Gather Schema statistics (Paramerters “ALL”)The above request gathers statistics for all schemas , however it skips custom schemas registered in Oracle Applications.Explaination : Whenever Custom schemas are registerd in Oracle Applications , the entries are done in 2 tables

Share This

RCU - Repository Creation Utility (more information here ) is certified only on Windows and Linux , then how to create schema on database running on Solaris, AIX or HP-Unix ?

Download RCU on Linux/Windows machine and connect to database server (running on Solaris/HP-Unix) and load schema remotely (no client software required on Windows/Linux machine).

• Download either windows or Linux version of RCU (from here - under “Required Additional Software“) on your windows or Linux machine .
• Ensure that Windows/Linux machine can connect to remote database server on database listener port. 
• Start rcu from windows/Linux machine and connect to your database on Solaris/AIX/HP-Ux machine remotely (database client software is NOT required on Windows/Linux machine)  steps here

.

1. Oracle Fusion Middleware 11g - Repository Creation Utility (RCU)
2. How to create FMW 11g schemas (SOA, WebCenter) on Solaris (non Windows/Linux) platform ?

Share This

Oracle Software (Database, OID, HTTP Server, Forms & Report, Discoverer …) installation issues are logged under oraInventory/logs/[filename].log (for more on oraInventory click here ) but how to identify oraInventory location on system ?

Oracle Inventory Pointer oraInst.loc (registry variable inst_loc for windows)  determines oraInventory location

• oraInventory location in windows : INST_LOC - “c:\program files\Oracle\Inventory“
• oraInventory default location in Linux, AIX : Directory mentioned in /etc/oraInst.loc
  
• oraInventory default location in Solaris: Directory mentioned in /var/opt/oracle / oraInst.loc
  
• oraInventory default location in HP OpenVMS: Directory under sys$login 

.

.

To find INST_LOC registry variable in windows : Start > Run > regedit > HKLM > Software > Oracle

.

1. oraInventory in Oracle
2. oraInventory Location & oraInst.loc on Windows , Linux , Unix

Share This

.

When I run a Concurrent request I get Phase - Pending and the Status - Standby. What does pending standby means and how to fix it ?

When I run a request in GL,the status appears Inactive and phase as No Manager. Please tell me what the problem could be ?

These are some of common questions I receive in my mail box so I decided to dedicate a post on concurrent request life-cycle.

.

Concurrent Request Lifecycle

Concurrent Request/Program can be under one of four Phases . Each phase has different Status .

Phase : Pending, Running , Completed, Inactive

.

Status :

Pending - Normal, Standby, Schedules, Waiting
Running - Normal, Paused, Resuming, Terminating
Completed - Normal, Error, Warning, Cancelled, Terminated, Disabled
Inactive - Disabled , On Hold, No Manager

.

.

A. Pending Standby  - Phase Pending and Status Standby means Program to run request is incompatible with other program(s) currently running.

How to check Incompatible Program/Request for any Program/Request ?

• Login with Application Developer responsibility
• Click on Concurrent > Program
• Query Program
• Click on Incompatibilities button

.

B. Inactive - No Manager

i) No manager is defined to run the request
or
ii) All managers are locked by run-alone requests
or
iii) Concurrent Manager Service is down
or
iv) No concurrent manager process because of workshift

To check Work Shift for any Concurrent Manager From System Administrator responsibility > Concurrent > Manager > Define > Work Shifts > Processes

For Description of other Concurrent Request Phase/Status click here
.

.

References

• Oracle Applications R12 System Administrator’s Maintenence Guide [Page 22-24]
• Orace Applications 11i System Administrator’s Maintenance Guide - [Page 20-21]
• Concurrent Request Phase and Status

1. Troubleshooting Concurrent Managers
2. Troubleshoot long running Concurrent Request in Apps 11i/R12
3. How to troubleshoot Concurrent Manager in 11i/R12 - Apps Listener
4. 11i/R12 Concurrent Program/Request : Pending Standby or Inactive No Manager

Share This

For daily checks ( Health Check on Admin/Concurrent Manager Node click on this link eBusiness 11i/R12 - Daily Checks (for Apps. DBA) - Admin Node

.

Related : For health check in 11i Click Here 

Share This

Here is short presentation on“introduction of Oracle Web Services Manager (OWSM) 11g R1″ from Vikas Jain

OWSM is tool to secure Web Services (+ more) and provides centralized management of policies (using OWSM Policy Manager).
OWSM agents are already embedded in WebLogic Server (for more information on WebLogic click here)

.
.
OWSM is completely re-architected in 11g Fusion Middleware , for changes in OWSM from 10g to 11g click here
.

1. Oracle Web Services Manager Architecture (OWSM)
2. short presentation on Oracle Web Services Manager - OWSM in 11g R1

Share This

This post covers overview of Oracle Directory Service Manager (ODSM) , new tool to manager Oracle Internet Directory (OID) and Oracle Virtual Directory (OVD)

JNDI - Java Naming and Directory Interface
LDAP - Lightweight Directory Access Protocol
ODM  - Oracle Directory Manager (10g OID)
ODSM- Oracle Directory Services Manager (11g OID)
OID  - Oracle Internet Directory
OVD  - Oracle Virtual Directory
WLST- WebLogic Scripting Tool

.
Oracle Directroy Service Manager  (ODSM) - is Java application (introduced in 11g OID/OVD) to manage OID and OVD. 
a)  ODSM is java application which runs on WebLogic Server (Managed Server - wls_ods1) 
b) Oracle Directory Manager (tool to manage OID in 10g) is now deprecated in 11g OID.
c) ODSM uses JNDI to connect to OID & OVD
d) You can install and configure ODSM with OID/OVD during installation or later

.
How to find ODSM URL ?

Option 1 - $Fusion_Middleware_Home/ Oracle_Identity_Management_domain/ servers/ wls_ods/ data/ nodemanager/ wls_ods1.url

Option 2 - Identify Managed Server (wls_ods1) port and use URL http://host:port/odsm
. 

How to access ODSM ?1. Start Managed Server wls_ods1 
startManagedWebLogic.sh wls_ods1

2. Access ODSM from URL - http://host:port/odsm  where default managed server (wls_ods1) port is 7005 (cn=orcladmin)

.

.
References

• ODSM Concept
• Use ODSM to Manage OID
• Troubleshooting Directory Services Manager 
• Installing and Configuring Oracle Directory Services Manager

1. Oracle Internet Directory OID
2. Oracle Internet Directory - Basics II
3. Integrate OID with AD Part I
4. OID to OID/Active Directory/iPlanet other LDAP Server Integration
5. Multi Master OID Replication
6. OID Architecture
7. Oracle Internet Directory , OID Troubleshooting
8. Server Chaining in OID
9. OID Quesries/ Scripts FAQ
10. OIDADMIN Client
11. Oracle Identity Management (OID) 11g installation Issues on Linux
12. OID 11g - Oracle Directory Services Manager (ODSM)

Share This

Today’s post is from one of our Apps DBA training exercise (more information on our online Apps DBA training [699 USD] here   ) related to Concurrent Manager.

.

How to check if Concurrent Manager is Up and running ?

Login as user with System Administrator responsibility. Under Concurrent : Manager click on Administer (Actual should be equal to Target)

.

.

.

How to troubleshoot Concurrent Manager issue ?  

Check Concurrent Manager log $SID_[MMDD] where MMDD is Concurrent Manager start Month & Date

 1. $APPLCSF/$APPLLOG/$SID_[MMDD].mgr

Could NOT contact Service Manager FNDSM_INNOWAVE03_visr12. 
 
The TNS alias could NOT be located, the listener process onINNOWAVE03 could NOT be contacted, 
 
OR the listener failed TO spawn the Service Manager process. 
 
     Process monitor session started : 24-SEP-2009 20:31:07Could NOT contact Service Manager FNDSM_INNOWAVE03_visr12. 
 
The TNS alias could NOT be located, the listener process onINNOWAVE03 could NOT be contacted, 
 
OR the listener failed TO spawn the Service Manager process.

2. Error message is pointing towards “FNDSM_INNOWAVE03_visr12″ so run tnsping to check status of TNS alias like

[avisr12@innowave03 ~]$ tnsping FNDSM_INNOWAVE03_visr12

Output like

TNS Ping Utility for Linux: Version 10.1.0.5.0 - 
 
Production on 24-SEP-2009 20:36:12Copyright (c) 1997, 2003, Oracle.  
 
All rights reserved.Used parameter files:Used TNSNAMES adapter to resolve the alias 
 
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=innowave03.com)(PORT=1638)) (CONNECT_DATA=(SID=FNDSM))) 
 
TNS-12541: TNS:no listener

3. Check Apps Listener status like

[avisr12@innowave03 ~]$ lsnrctl status APPS_visr12

LSNRCTL for Linux: Version 10.1.0.5.0 - 
 
Production on 24-SEP-2009 20:37:36Copyright (c) 1991, 2004, Oracle.  
 
All rights reserved.Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=innowave03.com)(Port=1638)) 
 
TNS-12541: TNS:no listener  
 
TNS-12560: TNS:protocol adapter error  
 
TNS-00511: No listener   
 
Linux Error: 111: Connection refused

4. Start Apps Listener

[avisr12@innowave03 scripts]$ ./adalnctl.sh start

output like

adalnctl.sh version 120.3 
 
Checking for FNDFS executable. 
 
Starting listener process APPS_visr12. 
 
adalnctl.sh: exiting with status 0adalnctl.sh: check the logfile /oracle/ apps/ r12/ visr12/ inst/ apps/ visr12_innowave03/ logs/ appl/ admin/ log/ adalnctl.txt formore information ... 

5. Try again tnsping again

[avisr12@innowave03 scripts]$ tnsping FNDSM_INNOWAVE03_visr12

output like

TNS Ping Utility for Linux: Version 10.1.0.5.0 - 
 
Production on 24-SEP-2009 20:39:09Copyright (c) 1997, 2003, Oracle.  
 
All rights reserved.Used parameter files:Used TNSNAMES adapter to resolve the aliasAttempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=innowave03.com)(PORT=1638)) (CONNECT_DATA=(SID=FNDSM))) 
 
OK (0 msec)

6. Restart CM again

For further information on Concurrent Manager click on System Administrator Maintenance Guide here  [page 21-77]

1. Troubleshooting Concurrent Managers
2. Troubleshoot long running Concurrent Request in Apps 11i/R12
3. How to troubleshoot Concurrent Manager in 11i/R12 - Apps Listener
4. 11i/R12 Concurrent Program/Request : Pending Standby or Inactive No Manager

Share This

mod_wl_ohs: is a module in Oracle HTTP Server 11g R1 which allows requests to be proxied from Oracle HTTP Server (OHS) to Oracle WebLogic Server.

mod_weblogic: This module is part of Apache HTTP Server and allows requests to be proxied from Apache HTTP Server to Oracle WebLogic Server.

For difference between mod_wl_ohs and mod_weblogic click here

Things good to know about configuring OHS infront of weblogic

1. You can use Fusion Middleware control /em (register OHS with weblogic Server to access it from control) , steps here  or directly update httpd.conf  (steps given below) to configure mod_wl_ohs

2. If weblogic server is clustered then mod_wl_ohs uses simple round-robin to forwards requests from HTTP Server to all available weblogic servers.
  mod_wl_ohs directs HTTP requests containing a cookie, URL-encoded session, or a session stored in the POST data to the server in the cluster that originally created the cookie.

3. mod_wl_ohs (as of 11gR1) only support container level failover and NOT application level failover. mod_wl_ohs continues to route requests to a down application as long as the managed server is up and running.

4. Configuration file of mod_wl_ohs is $INSTANCE_HOME/ config/ OHS/ <component_name>/ mod_wl_ohs.conf and included in $INSTANCE_HOME/ config/ OHS/ <component_name>/ httpd.conf (entry like
include “${ORACLE_INSTANCE}/ config/ ${COMPONENT_TYPE}/${COMPONENT_NAME}/ mod_wl_ohs.conf”)

5. mod_wl_ohs module file is available at $ORACLE_HOME/ ohs/ modules/ mod_wl_ohs.so

6. You can either use URL like /console using location directive (<Location /console>) or MatchExpression directive in mod_wl_ohs.conf to forward requests from HTTP Server to WebLogic Server.

7. While starting OHS on Windows, if you see error like
—
C:/atul/ fmw/ instances1/ config/ OHS/ ohs1/ mod_wl_ohs.conf:
Cannot load C:/ atul/ fmw/ ohs/ modules/ mod_wl_ohs.so into server: The specified module could not be found
—

Check mod_wl_ohs.so exists in specified location, if yes then
Copy “$ORACLE_HOME\ oui\ lib\ win32\ msvcp71.dll” to “c:\ windows\ system32″ and try again

.
Configure HTTP Serer infront of WebLogic Server

1. Install WebLogic Server and define server listening on port XXXX (7001 in this example)

2. Install Oracle HTTP Sever 11g steps here

3. Modify mod_wl_ohs.conf
$ORACLE_INSTANCE/ config/ <COMPONENT_TYPE>/ <COMPONENT_NAME>/ mod_wl_ohs.conf

a) For weblogic single instance

<Location /console>
    SetHandler weblogic-handler
    WebLogicHost server1
    WeblogicPort 7001
</Location>

* This will forward /console from HTTP server to /console on WebLogic Server server1:7001

b) For Weblogic instances in cluster

<Location /myServerURL>
    SetHandler weblogic-handler
    WebLogicCluster server1:7010,server2:7010
</Location>

* This will forward /myServerURL from HTTP server to /myServerURL on WebLogic Cluster server1:7010 and server2:7010
 

4. Restart HTTP Server
$INSTANCE_HOME/ bin/ opmnctl restartproc ias-component=ohs1

5. Test that you can access application deployed on Weblogic using Oracle HTTP Server like

http://servername:ohs_http_port/console

. 

References

• Web Server Plug-Ins with WebLogic Server 
• mod_wl_ohs in Oracel HTTP Server
• Configuring mod_wl_ohs in Oracle HTTP Server
• Configure HTTP Server for Administration Server
• Oracle Web Tier 11g R1 presentation from Oracle 
• Install HTTP Server
• Configure HTTP Server for Administration Server
• 865237.1  Using OHS for Fusion Middleware 11g Weblogic Domains for ADF 11g

1. Oracle WebLogic Installation Steps
2. Domain , Administration & Managed Server, Cluster in Oracle WebLogic
3. Create Domain in Oracle WebLogic
4. Oracle WebLogic Server - Startup/Shutdown
5. Oracle WebLogic Server 10g R3 10.3 is out now
6. Deploy Application on Oracle WebLogic Server
7. Cluster Architecture : Oracle WebLogic Server
8. Start WebLogic Server on Linux on port 80, 443 <= 1024
9. JDBC (Java DataBase Connectivity ) in Oracle WebLogic - Overview
10. WebLogic Server JDBC for Database connection : Step by Step
11. Security in Oracle WebLogic : Realm, Security Provider, Authentication, Authorization, Users
12. Deploy ADF application to Oracle WebLogic Server
13. Node Manager in Oracle WebLogic Server
14. Configure Oracle HTTP Server infront of Oracle WebLogic Server mod_wl_ohs

Share This

Last month I discussed 11g Identity Management (OID, DIP, OVD and OIF) installation here , today’s post covers issues encountered during 11g OID/OVD installation on Linux.

1.  Set hard file and soft file limit to at-least 4096 for user installing 11g Identity Management (OID)

. 

/etc/security/limits.conf

<os_user> hard nofile 4096
<os_user> soft nofile 4096

If O.S. user installing 11g Identity Management is “oracle” then add entry like below in /etc / security/ limits.conf

oracle hard nofile 4096
oracle soft nofile 4096

2. Database (Repository for IdM) should be minimum 10.2.0.4 (for 10g) or 11.1.0.6 (for 11g)

For complete database list  click here

3. Database processes should be at-least 500 , if not change it like

SQL> alter system set processes=500 scope=both;

scope=both -> If you are using spfile .
modify init<sid>.ora -> if you are using pfile .

4.  Unset LD_ASSUME_KERNEL else Installation will fail at instance creation (during start of OPMN)

.

How to check if LD_ASSUME_KERNEL is set ?
echo $LD_ASSUME_KERNEL

How to unset LD_ASSUME_KERNEL ?
unset LD_ASSUME_KERNEL

________________ 

Installation logs are under global oraInventory/logs/oraInstallYYYY-MM-DD_HH-MM-SSPM.out
opmnctl start: failed.
oracle.as.provisioning.util.ConfigException:
Error creating ASInstance asinst_1.
Cause:An internal operation has failed: Error in starting opmn server
Operation aborted because of a system call failure or internal error
________________

.
Log file location

1. Installation logs: Global oraInventory/ logs/ oraInstallYYYY-MM-DD_HH-MM-SSPM.out

2. OID/IdM configuration logs: $ORACLE_HOME/ cfgtoollogs/ cfgfw/ CfmLogger_YYYY-MM-DD_HH-MM-SSPM.log where
ORACLE_HOME is $MW_HOME/Oracle_IDM1   (Oracle_IDM1 is default name , you can change this during installation)

3. Oracle Internet Directory logs  $ORACLE_INSTANCE/ diagnostics/ logs/ OID/ <component_name>/ oid*.log

4. OID Monitor Logs$ORACLE_INSTANCE/ diagnostics/ logs/ OID/ <component_Name>/ oidmon-XXXX.log

5. OPMN logs $ORACLE_INSTANCE/ diagnostic/ logs/ OPMN/ opmn/

1. Oracle Internet Directory OID
2. Oracle Internet Directory - Basics II
3. Integrate OID with AD Part I
4. OID to OID/Active Directory/iPlanet other LDAP Server Integration
5. Multi Master OID Replication
6. OID Architecture
7. Oracle Internet Directory , OID Troubleshooting
8. Server Chaining in OID
9. OID Quesries/ Scripts FAQ
10. OIDADMIN Client
11. Oracle Identity Management (OID) 11g installation Issues on Linux
12. OID 11g - Oracle Directory Services Manager (ODSM)

Share This

AD4J - Application Diagnostics for Java
JADE - Java Application Diagnostics Expert

Application Diagnostics for Java (AD4J aka JADE - Java Application Diagnostics Expert) is lightweight application to diagnose performance issues in Java Applications (including Database Tier)

.

AD4J Architecture

1. AD4J Console : is web based console to setup/monitor performance of Java Virtual Machine (JVM) including Database.

AD4J Console listen on two ports
a) 3500 (80 for Windows) for requests from end user/Administrator
b) 3600 for requests from Agents (JVM Agent & DB Agent)

.

2. AD4J Repository : is database (Oracle or Postgres) to store JVM state.  Postgres is default database for Console on windows

3. Agents : two type of Agents AD4J JVM Agent and AD4J DB Agent which collects JVM or Database state and pass on to Console to store it in Repository.
You need to install/configure 1 JVM agent per JVM and 1 DB Agent per Database.

.

Things good to know about AD4J

1. Default HTTP port for client requests is 3500 (Unix) or 80 (windows)
2. Default console login credentials is admin/welcome
3. Default repository database with windows is Postgres
4. AD4j Console is available on both Windows and Unix platform
5. For Solaris use bash or ksh shell while running configure.sh

.

Install Application Diagnostics for Java (AD4J)

1. Download and unzip software (jamserv-<os>.zip) from here

2. Configure AD4J  by running configure.sh (Unix) or by double click on jamserv-win.exe (windows)

configure.sh $JDK_LOCATION 

3. Start console by running jamserv/bin/apachectl start  (jamserv is directory created after unzipping jamserv-<os>.zip) - This step is NOT required on windows.

If you can’t access console page as given in point 4 below then start Jserv using jamserv/bin/jservctl start

For steps on installing AD4J Console on Unix click here 
For steps on installing AD4J Console on Windows click here 

4. Access console and configure repository for AD4J console - This step is NOT required on windows

Access console using URL http://[servername]:3500 (Unix)  orhttp://[servername] (Windows)

Setup -> click on link adminDB.properties

I created repository database user jamuser in database FUSION

SQL> create user jamuser identified by jamuser;
SQL> grant connect, resource to jamuser;

.

5. Download Agents for JVM & Database

a)Download JVM agents (available as war, ear or zip) for JVM’s you are planning to monitor  Setup -> Download Agent

b) Download Database agents (specific to O.S. of your database) for Database you are planning to monitor  Setup -> Download Agent

.

 6. Install JVM Agents -
Use Application Server specific steps to deploy Agent on JVM you wish to monitor check here

7. Install Database Agents using Setup -> Database -> Register New DB ;  more information  here

Now you are ready to monitor your Database and Application Server (JVM - Java Virtual Machine)

Next step - Run load tests using software like LoadRunner against your Key transactions and analyze

a) JVM Activity - CPU, OSR, Locks, Threads, DB wait time , Heap Usage, Garbage Collection….
b) Database Activity - Locks, top SQL, I/O wait …..

.

Refarences

• AD4J Installation Guide 

1. Which Diagnostic Tool should I use for Fusion Middleware Performance Tuning ?
2. JADE / AD4J - Application Diagnostics for Java : Architecture / Installation and Configuration

Share This

 Today’s post is little different from my other posts as I need your help to identify right diagnostic tool for performance issues in Oracle Fusion Middleware (10g & 11g).

Issue : My client is using Oracle Fusion Middleware; 10g R2 (Portal/SSO/OID), 10g R3 (custom J2EE application) and 11g R1 (SOA on WebLogic). Application response time is acceptable for approx. 200 concurrent users but as user load increases (500+ concurrent users) performance degrades exponentially (only 30% of memory & cpu in use).

How would you troubleshoot performance issues in such scenario ?

Which tool would you suggest to identify performance bottlenecks in Fusion Middleware and Database stack ?

Performance Diagnostic Tool, I am planning to use is Application Diagnostics for Java (AD4J)

.
Why I decided AD4J ?

1. Most of my applications are J2EE and AD4J provides immediate visibility in Java Stack (Thread States and Java methods/line number)

2. Oracle AD4J facilitates tracing of Java requests to the associated database sessions and vice-versa thus highlight any problems that span different tiers (Middle Tier and Database Tier)

3. AD4J provides JVM tracing for fine-grained details of JVM activity, helpful in monitoring short transactions. Helpful to identify interdependency of threads, resource bottlenecks (DB, I/O, network ..)

.

Which tool you use to identify performance issues with J2EE application and Fusion Middleware (SOA, OAS, SSO, WebCenter and WebLogic ) ?

1. Which Diagnostic Tool should I use for Fusion Middleware Performance Tuning ?
2. JADE / AD4J - Application Diagnostics for Java : Architecture / Installation and Configuration

Share This

Oracle Instance - Oracle Instance contains one or more system components *( HTTP Server, WebCache, Oracle Internet Directory). Oracle Instance Directory contains updatable files like configuration files, log files. Oracle Instance directory is different from Oracle Home Directory and can reside inside or outside Middleware Home.

WebLogic Server- is J2EE application Server in Fusion Middleware 11g.

OPMN- Oracle Process Manager and Notification Server is management & notification server for system components like HTTP Server, OID, WebCache.

opmnctl - is utility to start/stop and manage system components in Fusion Middleware 11g. From Fusion Middleware 11g, opmnctl command exists in two places ; $ORACLE_HOME/opmn/bin and $ORACLE_INSTANCE/bin

Why to integrate Oracle Instance with WebLogic Server Domain ? - If you wish to manage system components (like HTTP Server, OID, Webcache) using Fusion Middleware Control Console (/em) then register ORACLE_INSTANCE with Weblogic Server Domain.

How to register Oracle Instance with WebLogic Server Domain  ? - use opmnctl from INSTANCE_HOME to register Oracle Instance with WebLogic Server. Ex

$INSTANCE_HOME/bin/opmnctl registerinstance -adminHost myhostname -adminPort 7001

*Fusion Middleware provides two type of system component Java Component & System component

References/Related

• Oracle Instance   -
• OPMNCTL Commands 
• Register Oracle OID Instance with WebLogic  -
• Register Oracle HTTP Server with WebLogic   -

1. Oracle Fusion Middleware Part II
2. Oracle Fusion Middleware Overview
3. Oracle Fusion Middleware : BEA WebLogic or Oracle Application Server
4. Oracle Fusion Middleware 11g is coming … 1 July 2009
5. Oracle Fusion Middleware 11g launched today
6. Oracle Fusion Middleware 11g concepts for Apps DBA’s
7. Fusion Middleware 11g - How to register Oracle Instance with Webogic Server (opmnctl) ?

Share This

Oracle Webcenter Suite  is enterprise Portal solution from Oracle. This post covers installation overview of Oracle WebCenter Suite 11g R1 (step by step installation document on Linux coming in next post)
.

Components of Oracle WebCenter

A. Oracle WebCenter Framework
B. Oracle WebCenter Spaces
C. Oracle Composer
D. WebCenter Services - Discussions, Blog, Wiki

For more information on these components click here

.
Software required to install Oracle WebCenter

WebCenter is deployed as J2EE application on Oracle Weblogic Server and uses Oracle Database as repository so in total you need to download following software to install Oracle WebCenter Suite 11g

1. Oracle Database- Repository for WebCenter Suite
Download 11g R1 (11.1.0.7 or higher) or 10g R2 (10.2.0.4 or higher) from here

2. Repository Creation Utility (RCU)- To load WebCenter Repository in Oracle Database
Download it  from here  (under Required Optional Software)

3. Oracle WebLogic Server 11gR1(10.3.1) - Application Server required to host WebCenter Suite from here

4. Oracle WebCenter Suite 11g R1  under Runtime Software from here

.

WebCenter 11g Installation Order

1. Install Oracle Database 10gR2 (10.2.0.4 or higher)  or 11g R1 (11.1.0.7 or higher)

2. Load/Create schema (webcenter, portlet, ocserver, discussions, wiki) in database using RCU (Repository Creation Utility) more information here

3. Install Oracle WebLogic Server (This step will create Fusion Middleware Home and install WebLogic Server in that home) - to know more about homes in Fusion Middleware click here

4. Install WebCenter Suite 11g (This step will install webcenter suite ORACLE_HOME under Fusion Middleware Home)

5. Configure WebCenter Suite (This step will create 1 Administration Server and three Managed Server (WLS_Portlet, WLS_Services and WLS_Spaces in Weblogic Server) - To know more about Administration Server and Managed Server in WebLogic click here

6. Start Administration and Managed Server (WLS_Portlet, WLS_Services and WLS_Spaces)

7. Access WebCenter Applications  (webcenter, portalTools, owc_discussions, owc_wiki) using URLs mentioned below

.
Things good to know about WebCenter Suite 11g Installation

1. For WebCenter Suite installation you need JRE/JDK 1.6 ; You can use JDK 1.6 installed as part of Weblogic Server

2. You can install WebCenter 11g with or without UCM (Universal Content Management)

3. If you are planning to select UCM with WebCenter Suite then HTTP Server is required (install HTTP server before WebCenter or you can use an existing HTTP Server)

4. While creating repository (using RCU) connect as sysdba privileges (sys or system) else schema load will fail

5. When you configure Webcenter (step 5 above) using config.sh from WebCenter ORACLE_HOME/common/bin ; it creates a WebLogic Domain with one Administration Server and three Managed Server
a) WLS_Spaces for WebCenter Spaces listening on port 8888
b) WLS_Portlet for Portlets listening on port 8889
c) WLS_Services for Discussions, Wiki, Blog on port 8890

6. Various default URL’s for Webcenter Suite

• http://<servername>:7001/console  - Administration Server Console for WebLogic
• http://<servername>:8888/webcenter - Webcenter Spaces
• http://<servername>:8889/portalTools - Portlet
• http://<servername>:8890/owc_discussions - Discussions
• http://<servername>:8890/owc_wiki - Wiki/Blog
  .

Webcenter Suite Installation Documentation from Oracle

• Webcenter Suite Installation Guide
• Webcenter Suite Quick Installation Guide

Step by Step Installation of Oracle WebCenter Suite 11g coming soon !!

1. Oracle WebCenter Suite Installation Overview
2. Oracle WebCenter Interaction / BEA AquaLogic User Interaction (ALUI)
3. Oracle Webcenter Suite 11g (FMW) Installation Overview

Share This

Q. What happens when you run ALTER DATABASE OPEN RESETLOGS ?
The current online redo logs are archived, the log sequence number is reset to 1, new database incarnation is created, and the online redo logs are given a new time stamp and SCN.
.

Q. In what scenarios open resetlogs required ?

An ALTER DATABASE OPEN RESETLOGS statement is required after incomplete recovery (Point in Time Recovery) or recovery with a backup control file.
.

Q. What is SCN (System Change Number) ?

The system change number (SCN) is an ever-increasing value that uniquely identifies a committed version of the database at a point in time. Every time a user commits a transaction Oracle records a new SCN in redo logs.

Oracle uses SCNs in control files datafile headers and redo records. Every redo log file has both a log sequence number and low and high SCN. The low SCN records the lowest SCN recorded in the log file while the high SCN records the highest SCN in the log file.
.

Q. What is Database Incarnation ?

Database incarnation is effectively a new “version” of the database that happens when you reset the online redo logs using “alter database open resetlogs;”.

Database incarnation falls into following category Current, Parent, Ancestor and Sibling

i) Current Incarnation : The database incarnation in which the database is currently generating redo.

ii) Parent Incarnation : The database incarnation from which the current incarnation branched following an OPEN RESETLOGS operation.

iii) Ancestor Incarnation : The parent of the parent incarnation is an ancestor incarnation. Any parent of an ancestor incarnation is also an ancestor incarnation.

iv) Sibling Incarnation : Two incarnations that share a common ancestor are sibling incarnations if neither one is an ancestor of the other.
.

Q. How to view incarnation history of Database ?

Using SQL> select * from v$database_incarnation;
Using RMAN>LIST INCARNATION;

However, you can use the RESET DATABASE TO INCARNATION command to specify that SCNs are to be interpreted in the frame of reference of another incarnation.

•For example my current database INCARNATION is 3 and now I have used
FLASHBACK DATABASE TO SCN 3000;then SCN 3000 will be search in current incarnation which is 3. However if I want to get back to SCN 3000 of INCARNATION 2 then I have to use,

RMAN> RESET DATABASE TO INCARNATION 2;
RMAN> RECOVER DATABASE TO SCN 3000;
.

References/Related

• Database Point In Time (PIT) Recovery

1. Blocks , Extents, Segments in Oracle Database : Back to Basics
2. Tablespace and Datafiles in Oracle Database : Back to Basics
3. Oracle Database Incarnation : Open Resetlogs , SCN
4. ORA-1652: unable to extend temp segment by 128 in tablespace TEMP

Share This