Wednesday, 6 January 2016

How to Find LOCKS / blocking sessions :



Show locked objects
set lines 100 pages 999
col username  format a20
col sess_id  format a10
col object format a25
col mode_held format a10
select oracle_username || ‘ (‘ || s.osuser || ‘)’ username
, s.sid || ‘,’ || s.serial# sess_id
, owner || ‘.’ || object_name object
, object_type
, decode( l.block
, 0, ‘Not Blocking’
, 1, ‘Blocking’
, 2, ‘Global’) status
, decode(v.locked_mode
, 0, ‘None’
, 1, ‘Null’
, 2, ‘Row-S (SS)’
, 3, ‘Row-X (SX)’
, 4, ‘Share’
, 5, ‘S/Row-X (SSX)’
, 6, ‘Exclusive’, TO_CHAR(lmode)) mode_held
from v$locked_object v
, dba_objects d
, v$lock l
, v$session s
where  v.object_id = d.object_id
and  v.object_id = l.id1
and  v.session_id = s.sid
order by oracle_username
, session_id;

Find Which ROW is locked :
select do.object_name
, row_wait_obj#
, row_wait_file#
, row_wait_block#
, row_wait_row#
, dbms_rowid.rowid_create (1, ROW_WAIT_OBJ#, ROW_WAIT_FILE#,
ROW_WAIT_BLOCK#, ROW_WAIT_ROW#)
from v$session s
, dba_objects do
where sid=&sid
and  s.ROW_WAIT_OBJ# = do.OBJECT_ID;

List of Locks:
column lock_type format a12
column mode_held format a10
column mode_requested format a10
column blocking_others format a20
column username format a10
SELECT session_id
, lock_type
, mode_held
, mode_requested
, blocking_others
, lock_id1
FROM dba_lock l
WHERE  lock_type NOT IN (‘Media Recovery’, ‘Redo Thread’)

SELECT DISTINCT a.sid “BLOCKED”, a.serial# “BLOCKEDSERIAL”, a.username “BLOCKEDUSER”, d.sid “BLOCKEDBYSID”,
d.serial# “BLOCKEDBYSERIAL#”, d.username “BLOCKINGUSERNAME”
from v$session a, dba_objects b, dba_data_files c, v$lock e,
(SELECT b.sid, b.serial#, b.username, a.id1
from v$lock a, v$session b where block=1
and a.sid=b.sid) d
where a.row_wait_obj#=b.object_id
and a.row_wait_file#=c.file_id
and a.lockwait is not null
and e.id1=d.id1
and e.block=0 and e.type=’TX’;
Script to Kill all the locks:
SELECT OS_USER_NAME, ORACLE_USERNAME AS orauser, s.sid, o.object_name,
o.object_type, s.serial#, a.sql_text
FROM v$locked_object l, dba_objects o, v$session s, v$sqlarea a
WHERE l.object_id = o.object_id
AND s.SQL_ADDRESS = a.address
AND l.SESSION_ID = s.sid;
SELECT ‘ALTER SYSTEM KILL SESSION ”’||TO_CHAR(s.sid)||’,’||TO_CHAR(s.serial#)||”’;’
AS “Statement to kill”
FROM v$locked_object l, dba_objects o, v$session s
WHERE l.object_id = o.object_id
AND l.SESSION_ID = s.sid;

Thanks
Srini

How to Troubleshoot Connectivity Issue with 11gR2 SCAN



Installed the Oracle 11g RAC successfully, But when tried connecting from remote client via SCAN, it used to raise ORA-12537. This is the most common issues that the happens with SCAN listener. And there are few common mistakes that generally cause this issue..
So, here is how we can troubleshoot the connectivity issues with SCAN, and cases out the possibilities.
1) Check if Local_listener and remote_listener parameter are set properly on all nodes.
2) The very common issue is with permissions. SCAN will always be created under grid user (Grid cluserware installation user). Oracle will also create one local listener “LISTENER” during grid infrastructure installation. But if that is not present then always make sure that you create a local listener with grid user. This is required to handover the connection between remote and local listener.
3) Also “oracle” executable should have given to oracle and grid user i.e. 6751. Under $ORACLE_HOME/bin. If permission are not proper the use root user to set the permissions. Else it will raise error (ORA-12537, )
-rwsr-s–x 1 oracle oinstall 106M Aug 25 2012 oracle
4) Your database instance is registered with Local Listener?
5) Check if scan config are proper and showing the details similar to :
[oracle@mynode] srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521
SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1521
SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1521
[oracle@mynode] srvctl config scan
SCAN name: sales1-scan, Network: 1/133.22.67.0/255.255.255.0/
SCAN VIP name: scan1, IP: /sales1-scan.example.com/133.22.67.192
SCAN VIP name: scan2, IP: /sales1-scan.example.com/133.22.67.193
SCAN VIP name: scan3, IP: /sales1-scan.example.com/133.22.67.194
6) Check if all above 3 SCAN IPs are responding the ping.
7) Your Oracle Client must be 11g R2 and above release in order to use SCAN functionality.
8) Following is the Oracle Document ID 975457.1. Which helped me for ORA-12537. Last case was valid for me.
9) If the following all settings are proper then try to enable SQL Net tracing on Client site and check if the packer size between client and server are compatible.
(This you can confirm by connecting the oracle with normal connection. i.e. try using SQL>conn user/password@server-ip/oracle_sid. if this is not working then you need to check packet size on TCP else you have oracle client 11gR2 then you may need to troubleshoot it with https://support.oracle.com only J)
How to Troubleshoot Connectivity Issue with 11gR2 SCAN Name [ID 975457.1]
Applies to:
Oracle Server – Enterprise Edition – Version: 11.2.0.1 and later [Release: 11.2 and later ]
Information in this document applies to any platform.
Goal
The goal of this document is to provide checklist when connection through 11gR2 Grid Infrastructure (CRS) SCAN name to database fails.
Solution
Troubleshooting Steps
When client program connects to RAC database through SCAN name, SCAN listener will accept t he request and redirect the connection to local listener. To identify connection issue, first try to connect to each local listener through node VIP, then try each SCAN listener through each SCAN VIP.
To test through node VIP:
sqlplus <username>/<password>@<nodename-vip.domain>:<local-listener-port>/<service-name>
Example:
sqlplus scott/tiger@racnode1-vip.us.eot.com:1521/testsvc
Repeat the same test for all local listener/node VIP in the cluster.
If GNS is used, node VIP name will be in the format of nodename-vip.gnssubdomain (example racnode1-vip.us.eot.com)
If connection through local listener fails, check whether service/instance is registered properly to that local listener with “lsnrctl service <local-listener-name>”.
To test through SCAN VIP address:
sqlplus <username>/<password>@<scan-ipn>:<scan-listener-port>/<service-name>
Example:
sqlplus scott/tiger@120.0.0.205:1521/testsvc
Note it’s IP address instead of SCAN name
Repeat the same command for all SCAN IP
If connection through SCAN listener fails, check whether service/instance is registered properly to that SCAN listener with “lsnrctl service <SCAN-listener-name>”.
Other client tool (JDBC or such) can also be used to test connection though sqlplus is preferred for the purpose of testing.
Example Output
Configuration
Below is an example output from a 2-node cluster with the following configuration:
SCAN name and VIP:
nslookup eotcs.us.oracle.com
..
Name: eotcs.us.oracle.com
Address: 120.0.0.207
Name: eotcs.us.oracle.com
Address: 120.0.0.205
Name: eotcs.us.oracle.com
Address: 120.0.0.206
Ping doesn’t have to go through if ICMP is disabled but should return correct IP for corresponding name.
ping -c 1 eotcs.us.oracle.com
PING eotcs.us.oracle.com (120.0.0.207) 56(84) bytes of data.
64 bytes from 120.0.0.207: icmp_seq=1 ttl=64 time=3.37 ms
..
ping -c 1 eotcs.us.oracle.com
PING eotcs.us.oracle.com (120.0.0.206) 56(84) bytes of data.
64 bytes from 120.0.0.206: icmp_seq=1 ttl=64 time=1.85 ms
..
ping -c 1 eotcs.us.oracle.com
PING eotcs.us.oracle.com (120.0.0.205) 56(84) bytes of data.
64 bytes from 120.0.0.205: icmp_seq=1 ttl=64 time=2.45 ms
..
ping -c 1 eotcs
PING eotcs.us.oracle.com (120.0.0.207) 56(84) bytes of data.
64 bytes from eotcs.us.oracle.com (120.0.0.207): icmp_seq=1 ttl=64 time=3.18 ms
Node Public Name/IP Address
Name: eyrac1f.us.oracle.com Address: 120.0.0.111
Name: eyrac2f.us.oracle.com Address: 120.0.0.112
ping -c 1 eyrac1f.us.oracle.com
PING eyrac1f.us.oracle.com (120.0.0.111) 56(84) bytes of data.
64 bytes from eyrac1f.us.oracle.com (120.0.0.111): icmp_seq=1 ttl=64 time=3.36 ms
..
ping -c 1 eyrac2f.us.oracle.com
PING eyrac2f.us.oracle.com (120.0.0.112) 56(84) bytes of data.
64 bytes from eyrac2f.us.oracle.com (120.0.0.112): icmp_seq=1 ttl=64 time=3.37 ms
..
Nodes VIP Name/IP Address
Name: eyrac1fv.us.oracle.com Address: 120.0.0.211
Name: eyrac2fv.us.oracle.com Address: 120.0.0.212
nslookup eyrac1fv.us.oracle.com
..
Name: eyrac1fv.us.oracle.com
Address: 120.0.0.211
nslookup eyrac2fv.us.oracle.com
..
Name: eyrac2fv.us.oracle.com
Address: 120.0.0.212
ping -c 1 eyrac1fv.us.oracle.com
PING eyrac1fv.us.oracle.com (120.0.0.211) 56(84) bytes of data.
64 bytes from eyrac1fv.us.oracle.com (120.0.0.211): icmp_seq=1 ttl=64 time=4.04 ms
..
ping -c 1 eyrac2fv.us.oracle.com
PING eyrac2fv.us.oracle.com (120.0.0.212) 56(84) bytes of data.
64 bytes from eyrac2fv.us.oracle.com (120.0.0.212): icmp_seq=1 ttl=64 time=1.98 ms
..
Database Name: b2no
Service Name: sno
TNS Connection String
sno =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = eotcs.us.oracle.com)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = sno)
)
)
1. Checklist on RAC Cluster Nodes
Prior to the following checking, please set environment variable GRID_HOME to home of 11.2 Grid Infrastructure installation, for example:
GRID_HOME=/ogrid/gbase
export GRID_HOME
Please note:
* Oracle Network related files (sqlnet.ora, tnsnames.ora, listener.ora etc) are in $TNS_ADMIN or $ORACLE_HOME/network/admin if TNS_ADMIN is not set.
* This note assumes SCAN VIP and node VIP are all up and running (can be verified through “srvctl status nodeapps” and “srvctl status scan” or “crsctl stat res”), troubleshooting of SCAN VIP or node VIP startup issue is out of scope of this note.
A. SCAN Listener Resource Status
A1. SCAN Configuration:
$GRID_HOME/bin/srvctl config scan
SCAN name: eotcs.us.oracle.com, Network: 1/120.0.0.0/255.255.255.0/eth3
SCAN VIP name: scan1, IP: /120.0.0.206/120.0.0.206
SCAN VIP name: scan2, IP: /120.0.0.207/120.0.0.207
SCAN VIP name: scan3, IP: /120.0.0.205/120.0.0.205
A2. SCAN Listener Configuration:
$GRID_HOME/bin/srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521
SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1521
SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1521
A3. SCAN Listener Resource Status:
$GRID_HOME/bin/crsctl stat res -w “TYPE = ora.scan_listener.type”
NAME=ora.LISTENER_SCAN1.lsnr
TYPE=ora.scan_listener.type
TARGET=ONLINE
STATE=ONLINE on eyrac1f
NAME=ora.LISTENER_SCAN2.lsnr
TYPE=ora.scan_listener.type
TARGET=ONLINE
STATE=ONLINE on eyrac2f
NAME=ora.LISTENER_SCAN3.lsnr
TYPE=ora.scan_listener.type
TARGET=ONLINE
STATE=ONLINE on eyrac2f
B. SCAN Listener Status and Service
Log on to corresponding RAC node to find out SCAN listener status and service once SCAN listener resource status is confirmed. All SCAN listener should have same service served. Please set ORACLE_HOME environment variable prior to run any lsnrctl command, for example:
ORACLE_HOME=$GRID_HOME
export ORACLE_HOME
B1. SCAN Listener Status:
$GRID_HOME/bin/lsnrctl status LISTENER_SCAN2
..
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))
STATUS of the LISTENER
————————
..
Listener Parameter File /ogrid/gbase/network/admin/listener.ora
Listener Log File /ogrid/gbase/log/diag/tnslsnr/eyrac2f/listener_scan2/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN2)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=120.0.0.207)(PORT=1521)))
..
B2. SCAN Listener Service:
$GRID_HOME/bin/lsnrctl service LISTENER_SCAN2
..
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))
Services Summary…
Service “b2no” has 2 instance(s).
Instance “b2no1”, status READY, has 1 handler(s) for this service…
Handler(s):
“DEDICATED” established:0 refused:0 state:ready
REMOTE SERVER
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=eyrac1fv)(PORT=1521)))
Instance “b2no2”, status READY, has 1 handler(s) for this service…
Handler(s):
“DEDICATED” established:0 refused:0 state:ready
REMOTE SERVER
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=eyrac2fv)(PORT=1521)))
Service “sno” has 2 instance(s).
Instance “b2no1”, status READY, has 1 handler(s) for this service…
Handler(s):
“DEDICATED” established:0 refused:0 state:ready
REMOTE SERVER
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=eyrac1fv)(PORT=1521)))
Instance “b2no2”, status READY, has 1 handler(s) for this service…
Handler(s):
“DEDICATED” established:0 refused:0 state:ready
REMOTE SERVER
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=eyrac2fv)(PORT=1521)))
C. Node Listener Status and Service
C1. Node Listener Status:
$GRID_HOME/bin/lsnrctl status LISTENER
..
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
————————
..
Listener Parameter File /ogrid/gbase/network/admin/listener.ora
Listener Log File /home/oracle/app/oracle/diag/tnslsnr/eyrac2f/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=120.0.0.112)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=120.0.0.212)(PORT=1521)))
Services Summary…
Service “b2no” has 1 instance(s).
Instance “b2no2”, status READY, has 1 handler(s) for this service…
Service “sno” has 1 instance(s).
Instance “b2no2”, status READY, has 1 handler(s) for this service…
C2. Node Listener Service:
$GRID_HOME/bin/lsnrctl service LISTENER
..
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
Services Summary…
Service “b2no” has 1 instance(s).
Instance “b2no2”, status READY, has 1 handler(s) for this service…
Handler(s):
“DEDICATED” established:0 refused:0 state:ready
LOCAL SERVER
Service “sno” has 1 instance(s).
Instance “b2no2”, status READY, has 1 handler(s) for this service…
Handler(s):
“DEDICATED” established:0 refused:0 state:ready
LOCAL SERVER
D. Database Service Status
D1. Service Resource Configuration
$GRID_HOME/bin/srvctl config service -d b2no -s sno -a
Service name: sno
Service is enabled
Server pool: b2no_sno
Cardinality: 2
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Failover type: SELECT
Failover method: BASIC
TAF failover retries: 2
TAF failover delay: 20
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: BASIC
Preferred instances: b2no1,b2no2
Available instances:
D2. Service Resource Status:
$GRID_HOME/bin/srvctl status service -d b2no -s sno -v
Service sno is running on instance(s) b2no1,b2no2
E. Instance Listener Parameter Setting:
E1. remote_listener setting:
For 11gR2 database
SQL> show parameter remote_listener
NAME TYPE VALUE
———————————— ———– ——————————
remote_listener string eotcs.us.oracle.com:1521
For pre-11gR2 database
SQL> show parameter remote_listener
NAME TYPE VALUE
———————————— ———– ——————————
remote_listener string (ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 120.0.0.206)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 120.0.0.207)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 120.0.0.205)(PORT = 1521)))
OR
remote_listener string LISTENERS_SCAN
Note tnsnames.ora must have the following entry for LISTENERS_SCAN
LISTENERS_SCAN =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 120.0.0.206)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 120.0.0.207)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 120.0.0.205)(PORT = 1521))
)
If sqlnet.ora does not contain EZCONNECT in NAMES.DIRECTORY_PATH list, remote_listener should set to LISTENERS_SCAN as in above example.
E2. local_listener setting:
For Instance1:
SQL> show parameter local_listener
NAME TYPE VALUE
———————————— ———– ——————————
local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD
DRESS=(PROTOCOL=TCP)(HOST=eyra
c1fv)(PORT=1521))))
For Instance2:
SQL> show parameter local_listener
NAME TYPE VALUE
———————————— ———– ——————————
local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD
DRESS=(PROTOCOL=TCP)(HOST=eyra
c2fv)(PORT=1521))))
2. Checklist on Client
A successful tnsping to TNS connection string for SCAN doesn’t necessarily mean the connection will be successful, client should be able to resolve to SCAN name, node VIP name
For supported client version, refer to section “VERSION AND BACKWARD COMPATIBILITY” of the following:
http://www.oracle.com/technetwork/database/clustering/overview/scan-129069.pdf
A. SCAN Name Resolution
nslookup and ping of SCAN name should return correct SCAN VIP(s), ORA-12545 could be reported if client can’t resolve SCAN name properly
B. Node VIP name:
By default, pfile/spfile parameter local_listener is set to short node VIP name instead of FQDN name, client need to be able to resolve to short VIP name as well as FQDN name; for example with following local_listener setting, client should be able to resolve short VIP name:
SQL> show parameter local_listener
NAME TYPE VALUE
———————————— ———– ——————————
local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD
DRESS=(PROTOCOL=TCP)(HOST=eyra
c1fv)(PORT=1521))))
ping -c 1 eyrac1fv
PING eyrac1fv.us.oracle.com (120.0.0.211) 56(84) bytes of data.
64 bytes from eyrac1fv.us.oracle.com (120.0.0.211): icmp_seq=1 ttl=64 time=4.04 ms
..
ping -c 1 eyrac2fv
PING eyrac2fv.us.oracle.com (120.0.0.212) 56(84) bytes of data.
64 bytes from eyrac2fv.us.oracle.com (120.0.0.212): icmp_seq=1 ttl=64 time=1.98 ms
..
If client can resolve FQDN node VIP name but not short node VIP name (client in different domain), ORA-12537 could be reported and pfile/spfile local_listener need to be adjusted with FQDN node VIP name:
SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=eyrac1fv.us.oracle.com)(PORT=1521))))’ sid=’b2no1′;
SQL> show parameter local_listener
NAME TYPE VALUE
———————————— ———– ——————————
local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD
DRESS=(PROTOCOL=TCP)(HOST=eyra
c1fv.us.oracle.com)(PORT=1521))))
Once instance updated local_listener setting to listeners, SCAN listener should have similar output like following:
$GRID_HOME/bin/lsnrctl service LISTENER_SCAN2
..
Services Summary…
Service “b2no” has 2 instance(s).
Instance “b2no1”, status READY, has 1 handler(s) for this service…
Handler(s):
“DEDICATED” established:4 refused:0 state:ready
REMOTE SERVER
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=eyrac1fv.us.oracle.com)(PORT=1521)))
Instance “b2no2”, status READY, has 1 handler(s) for this service…
Handler(s):
“DEDICATED” established:3 refused:0 state:ready
REMOTE SERVER
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=eyrac2fv)(PORT=1521)))
Service “sno” has 2 instance(s).
Instance “b2no1”, status READY, has 1 handler(s) for this service…
Handler(s):
“DEDICATED” established:4 refused:0 state:ready
REMOTE SERVER
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=eyrac1fv.us.oracle.com)(PORT=1521)))
Instance “b2no2”, status READY, has 1 handler(s) for this service…
Handler(s):
“DEDICATED” established:3 refused:0 state:ready
REMOTE SERVER
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=eyrac2fv)(PORT=1521)))
Note for node1 it’s FQDN name but for node2 it’s still short name as node2 is not updated yet
If for some reason, client can’t resolve FQDN node VIP name nor short node VIP name, pfile/spfile local_listener need to be adjusted with IP of VIP name:
SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=120.0.0.211)(PORT=1521))))’ sid=’b2no1′;
SQL> show parameter local_listener
NAME TYPE VALUE
———————————— ———– ——————————
local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD
DRESS=(PROTOCOL=TCP)(HOST=120.
0.0.211)(PORT=1521))))

Thanks
Srini

Weblogic Managed server status struck in STARTING


 

We faced the issue while starting the weblogic managed server, the status of the server struck in STARTING.
W could not able to find a valid error messages in the log files
Managed Server Log File:
<30-Oct-2014 11:13:29 o’clock GMT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to STARTING> 
No logs are getting printed after this.
Node Manager Log File:
<30-Oct-2014 11:09:44> <INFO> <SOACoreDomain> <MS1> <Server failed during startup so will not be restarted>
<30-Oct-2014 11:09:44> <WARNING> <Exception while starting server ‘MS1’>
java.io.IOException: Server failed to start up. See server output log for more details.
      at weblogic.nodemanager.server.AbstractServerManager.start(AbstractServerManager.java:200)
      at weblogic.nodemanager.server.ServerManager.start(ServerManager.java:23)
      at weblogic.nodemanager.server.Handler.handleStart(Handler.java:604)
      at weblogic.nodemanager.server.Handler.handleCommand(Handler.java:121)
      at weblogic.nodemanager.server.Handler.run(Handler.java:71)
      at java.lang.Thread.run(Thread.java:662)
The root cause of this issue is somehow the ldap directory of the server got corrupted.
To resolve this issue:
  •  Kill the managed server
  •  Remove the ldap folder from the following location  <<DOMAIN_HOME>>/servers/<<Managed Server>>, this file will be auto generated while restarting the server.
  • Restart the server
Thanks
Srini

How to find component version in Oracle E-Business Suite.


 

How to compile form:
frmcmp_batch module=$AU_TOP/forms/US/MSDDEMRH.fmb userid=apps/$APPSPW output_file=$MSD_TOP/forms/US/MSDDEMRH.fmx module_type=form batch=no compile_all=yes
Maintain Snapshot Information: 
This will sync up your application tier with database.
http://oracleappstechnology.blogspot.com/2008/05/appltop-snapshot-feature.html
Run the following command to locate the properties file that you want to customize to preserve your settings:
R11i10
sh $AD_TOP/bin/adtmplreport.sh contextfile=$CONTEXT_FILE target=$IAS_ORACLE_HOME/Apache/Jserv/etc/xmlsvcs.properties
R12
sh $AD_TOP/bin/adtmplreport.sh contextfile=$CONTEXT_FILE target=$INST_TOP/ora/10.1.3/j2ee/oafm/config/oc4j.properties
Navigate to the location of the template directory and create a custom subdirectory to store to store your customization:
cd $FND_TOP/admin/template
mkdir custom
Copy the template file to the custom directory. and edit to add custom entries and run autoconfig”
What is staging area ?
Staging Area is special directory structure where you can dump 11i installation software so that you don’t have to insert CD’s during install and these disks will automatically be picked by Installer.
Q. How you set up staging area ?
Use adautostg.pl to create staging area orcreate required directory manually for staging like (following directories under Stage11i – startCD, oraApps, oraDB, oraiAS, oraAppsDB, oraNLS and inside these directories Disk1, Disk2…).
AOLJTEST
http://hostname:portno/OA_HTML/jsp/fnd/aoljtest.jsp
Check Jserv with the following url http://:port/servlets/Hello
Increase number of JVM to 2: 
1. Comment out this line in the jserv.conf file:
ApJServGroup OACoreGroup 1 1 /d01/oracle/prodora/iAS/Apache/Jserv/etc/jserv.properties
2. Uncomment this line in the jserv.conf file:
#ApJServGroup OACoreGroup 2 1 /d01/oracle/prodora/iAS/Apache/Jserv/etc/jserv.properties
Bounce apache
To change paswords for all modules:
select ‘FNDCPASS apps/xxx 0 Y system/xxx ORACLE ‘||oracle_username||’ xxxxx’ from fnd_oracle_userid where oracle_username in (select username from dba_users) and oracle_username not in (‘APPS’,’APPLSYS’,’APPLSYSPUB’);
PASSWORD CREATION USING FNDCPASS
FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME
FNDCPASS apps/apps 0 Y system/manager ORACLE GL GL1
FNDCPASS apps/apps 0 Y system/manager USER VISION WELCOME
edit pwd is wdbsvr.app and cat $806ORACLE_HOME/reports60/server/CGIcmd.dat
alter user system identified by xxx;
alter user sys identified by xxx;
FNDCPASS apps/xxx 0 Y system/xxxxxx ALLORACLE xxxxx
WFLOAD syntax
WFLOAD 0 Y {UPLOAD | DOWNLOAD | UPGRADE | FORCE} [@:] []
EXECUTION OF LDT FILE
FNDLOAD &ui_apps 0 Y UPLOAD @FND:patch/115/import/affaudit.lct @GMA:patch/115/import/US/gmaausch.ldt
download from one instance and upload to another instance
FNDLOAD apps/password 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct
TPCOCUSTMAP.ldt PROGRAM
CONCURRENT_PROGRAM_NAME=”TPCOCUSTMAP”
APPLICATION_SHORT_NAME=”XBOL”
FNDLOAD APPS/password 0 Y UPLOAD @FND:patch/115/import/afcpprog.lct
TPCOCUSTMAP.ldt
backup menus, Responsibility, user using below FNDLOAD commands( ****IMPORTANT STEP****)
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct PATCH_SUB_MENU.ldt MENU MENU_NAME=””WH_ENQ””
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct PATCH_MENU.ldt MENU MENU_NAME=””WH_ENQ_MAIN””
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct PATCH_RESP.ldt FND_RESPONSIBILITY RESP_KEY=””MFG US ATP WH MGMT””
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct PATCH_USER.ldt FND_USER USER_NAME=””MOBILE_USER””
Upload Menus, Responsibility and User using below FNDLOAD commands
cd $backup_dir ** directory in which files were backed up thru step#4

FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct PATCH_SUB_MENU.ldt
FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct PATCH_MENU.ldt
FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct PATCH_RESP.ldt
FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct /tmp/PATCH_USER.ldt
PACKAGE CREATION USING PKH and PKB FILES
sqlplus apps/apps @******.pkh — this will create the package header or specification
sqlplus apps/apps @******.pkb — this will create the package body
ODF FILE EXECUTION
adodfcmp userid=cn/cn mode=TABLES odffile=cntrx02.odf touser=apps/apps priv_schema=apps/apps logfile=cn.log changedb=YES
adodfcmp userid=/ odffile=afsec.odf touser=apps_appfnd/xxx logfile=/tmp/a2.lst changedb=Yes priv_schema=apps_appfnd/xxx mode=tables
Execute the following command to determine the version of OA.jsp: 
ident $FND_TOP/html/OA.jsp and
ident $OA_HTML/OA.jsp
(ie: Header: OA.jsp 115.26 2002/01/18 14:49:41 pkm ship)
Attention: The version of OA.jsp in $FND_TOP/html should be the same as the one in $OA_HTML if the version of OA.jsp does not match do the following :
Run adadmin.
Choose the option called Maintain Application Files.
Choose the option called Copy files to destination.
Note: If the ident command returns a no such file error or does not return any version information for OA.jsp then you have not installed the Oracle Applications Self Service Framework. Please use this metalink document to install the Self Service Framework.
Note: ident is not available on SUN & AIX. In this instance please use:
adident Header $FND_TOP/html/OA.jsp and
adident Header $OA_HTML/OA.jsp
How to compile JSP in Oracle Apps ?
You can use ojspCompile.pl perl script shipped with Oracle apps to compile JSP files. This script is under $JTF_TOP/admin/scripts. Sample compilation method is
perl ojspCompile.pl –compile –quiet
compiling few jsp’s
Clear the following files from $OA_HTML/../_pages/_oa__html
rm _qot*.*
rm _xx*.*
ojspCompile.pl –compile -s ‘%qot%.jsp’ -log $HOME/err.log –flush
ojspCompile.pl –compile -s ‘%xxdhr%.jsp’ -log $HOME/err.log –flush
Confirm _qot*.* and _xx*.* files exist (after running the above Perl script)
in $OA_HTML/../_pages/_oa__html directory
Compile JSPs (~ 45 mts)
cd $FND_TOP/patch/115/bin
perl ojspCompile.pl –compile –flush -p 2
JSP compilation
$ cd $JTF_TOP/admin/scripts
$ ./ojspCompile.pl –compile
perl -x $JTF_TOP/admin/scripts/ojspCompile.pl –compile –quiet
perl -x $JTF_TOP/admin/scripts/ojspCompile.pl –compile –quiet -log /tmp/ojspc_error.log 341205.1
cd $FND_TOP/patch/115/bin
$ ls -rlt ojsp*
-rwxr-xr-x 1 appldev2 dba 85192 Apr 24 06:23 ojspCompile.pl
$ perl -x ojspCompile.pl –compile –quiet
logfile set: $INST_TOP/logs/appl/rgf/ojsp/ojspc_error.log
For r12
How to convert pll to pld file or pld file to pll ?
Pll->Pld f60gen module=MSCOSCW3.pll module_type=library userid=apps/ module_access=file output_file=MSCOSCW1.pld script=yes
Pld -> pll f60gen module=MSCOSCW3.pld userid=apps/ module_type=library module_access=file output_file=MSCOSCW1.pll parse=y batch=yes compile_all=special
How to convert pll to pld file or pld file to pll ?
Ans: Pll->Pld f60gen module=MSCOSCW3.pll module_type=library userid=apps/ module_access=file output_file=MSCOSCW1.pld script=yes
Pld -> pll f60gen module=MSCOSCW3.pld userid=apps/ module_type=library module_access=file output_file=MSCOSCW1.pll parse=y batch=yes compile_all=special
FORM file compilation
The following environment setting should be part of the Forms compilation to include the standard oracle library files.
export PATH=$PATH:$AU_TOP/forms/US:$AU_TOP/resource:$AU_TOP/resource/US
export FORMS60_PATH=$FORMS60_PATH:$AU_TOP/forms/US:$AU_TOP/resource:$AU_TOP/resource/US
f60gen module=$AU_TOP/forms/US/INVTOMAI.fmb userid=apps/xxx output_file=$INV_TOP/forms/US/INVTOMAI.fmx module_type=form batch=yes compile_all=special
Temporarily resetting FORMS_PATH to compile language forms
$AU_TOP/resource:$AU_TOP0/forms/F:$AU_TOP/resource/F
FORM file compilation
f60gen module=$AU_TOP/forms/F/ASXTRLKP.fmb userid=apps/apps output_file=$AS_TOP/forms/F/ASXTRLKP.fmx module_type=form batch=yes compile_all=special
To complie .fmb , .pll in R12
$ frmcmp_batch.sh module=$AU_TOP/resource/CUSTOM.pll userid=apps/xxxx output_file=$AU_TOP/resource/CUSTOM.plx module_type=library compile_all=special
frmcmp_batch.sh module=$AU_TOP/forms/US/CLX_CTG_FORM.fmb userid=apps/xxxx output_file=$AU_TOP/forms/US/CLX_CTG_FORM.fmx module_type=form compile_all=special
To compile pll file 
f60gen module=$AU_TOP/resource/CUSTOM.pll userid=apps/apps output_file=$AU_TOP/resource/CUSTOM.plx module_type=library batch=yes compile_all=special
Playing with CUSTOM.pll
To convert from CUSTOM.pll to CUSTOM.pld
f60gen module_type=LIBRARY module=CUSTOM script=YES userid=apps/apps
To convert back from CUSTOM.pld to CUSTOM.pll ( after having edited the text pld file )
f60gen module_type=LIBRARY module=CUSTOM parse=YES userid=apps/apps
To convert from CUSTOM.pll to CUSTOM.plx
f60gen module_type=LIBRARY module=CUSTOM userid=apps/apps
REPORT file comilation
rwcon60 userid=APPS/xxx source=$BIL_TOP/reports/US/BILPHP01.rdf dest=$APPL_TOP/admin/CNV1/out/tmp001.rdf stype=rdffile dtype=rdffile logfile=$APPL_TOP/admin/CNV1/out/adrep001.txt overwrite=yes batch=yes compile_all=yes
rwcon60 userid=APPS/xxx source=BILPHP01.rdf dest=BILPHP01.rex stype=rdffile dtype=rexfile logfile=BILPHP01.txt overwrite=yes batch=yes
rwcon60 userid=apps/apps source=JEFRDVER.rdf stype=rdffile dtype=rexfile dest=JEFRDVER.rex overwrite=yes batch=yes
Compiling all application flexfields.
$FND_TOP/bin/fdfcmp APPS/***** 0 Y
TO start dataInstaller
jre oracle.apps.per.DataInstall apps pwd thin dbt11.unix.flarock.com:1551:OABT
jre oracle.apps.per.DataInstall apps thin ::
hrglobal.drv
PER_TOP/patch/115/driver
To check to make sure the correct data was installed run the following script this script can also be used to check if datainstaller was run successfully:
select application_short_name, Legislation_code, status, action, last_update_date
from hr_legislation_installations
where application_short_name in (‘PER’,’PAY’);
To check the version of the iAS 1.0.2.2.2 
cd <ias_oracle_home>/Apache/Apache
httpd -version
To check the version of the forms
f60gen
To relink manually
adrelink.sh force=Y ranlib=Y “AD”
./adrelink.sh force=y ranlib=y “WPS WPCFSQ”
To complile forms and reports library
cd $ORACLE_HOME/forms/lib32
Note: if this directory does not exist: cd $ORACLE_HOME/forms/lib
$ make -f ins_forms.mk install
cd $ORACLE_HOME/reports/lib32
Note: if this directory does not exist: cd $ORACLE_HOME/reports/lib
$ make -f ins_reports.mk install
Relink Procedure Builder, Forms, Graphics and Reports: 
cd $ORACLE_HOME/procbuilder60/lib; make -f ins_procbuilder.mk install
cd $ORACLE_HOME/forms60/lib; make -f ins_forms60w.mk install
cd $ORACLE_HOME/graphics60/lib; make -f ins_graphics60w.mk install
Reports has both link-time and run-time dependency with libjava.so so you need to append $ORACLE_HOME/network/jre11/lib/linux/native_threads in
$LD_LIBRARY_PATH before linking Reports. The same $LD_LIBRARY_PATH should be used at run-time.
cd $ORACLE_HOME/reports60/lib; make -f ins_reports60w.mk install
Relink iAS and Oracle Home using 
$IAS_ORACLE_HOME/bin/adlnkiAS.sh and $ORACLE_HOME/bin/adlnk806.sh
To fin perl version
$ perl -version
To find java version
$ java -version
To find JDK version:
From appl_top, xml file
< jdk_top oa_var=”s_jdktop”>/amtoac/applmgr/common/util/java/1.4/j2sdk1.4.2_04
Discoverer launcher and viewer urls
http://hostname.oracle.com:10000/discwb4/html/discolaunch.htm)
http://hostname.oracle.com:10000/discoverer4i/viewer
Plus–http://hostname.domain:port/discwb4/html/english/welcome.htm
To find Version
$ string –a dis4pr | grep –i ‘discoverer version’
The location for looking for dis4pr is $ORACLE_HOME/diswb4/bin
To start discoverer
Script to start discoverer server is addisctl.sh under $OAD_TOP/admin/scripts/$CONTEXT_NAME
— This script in turn start discoverer processes which can be start by startall.sh under $ORACLE_HOME/discwb4/util (This script is different from adstrtal.sh)
— startall.sh calls scripts like startgatekeeper.sh, startlocator.sh , startoad.sh, startosagent.sh to start gatekeeper, locator, oad & osagent resp.
In Apps two major way to access EUL is via Discoverer view & Discoverer Plus edition (You can use Discoverer Administration Edition as well)
to generate xml file on apps and db tier
ad_top/bin
adbldxml.sh tier=apps appsuser= appspasswd=
Source the environment before runnibg
Go to /appsutil/bin
perl adbldxml.pl tier=db appsuser= appspasswd=
Make command
make -f $APPL_TOP/admin/train/out/link_inv_1040580.mk $INV_TOP/bin/INCOIN
restart apache without killing current web sessions 
usellx41.corp.invacare.us:support_conf> $SCRIPTS/adapcctl.sh graceful
adapcctl.sh version 115.48
Apache Web Server Listener :httpd ( pid 16249 ) is running.
Gracefully restarting the Apache Web Server Dedicated HTTP Listener..
Apache Web Server Listener (PLSQL) :httpd ( pid 16379 ) is running.
Gracefully restarting the Apache Web Server Dedicated PLSQL Listener..
adapcctl.sh: exiting with status 0
enabling Autoconfig on DB tier
As applmgr Copy AutoConfig templates to the RDBMS ORACLE_HOME
—————————————————————————
Create appsutil.zip file by: perl $AD_TOP/bin/admkappsutil.pl
sandbox806> perl $AD_TOP/bin/admkappsutil.pl
Starting the generation of appsutil.zip
Log file located at /ORACLE/apps/sandbox/admin/log/MakeAppsUtil_09061407.log
output located at /ORACLE/apps/sandbox/admin/out/appsutil.zip
MakeAppsUtil completed successfully.
sandbox806>
Copy appsutil.zip file to the $RDBMS_ORACLE_HOME
sandbox> id
uid=300(oracle) gid=200(dba) groups=1(staff),202(oaa),203(move),13(oinstall)
sandbox> cp /ORACLE/apps/sandbox/admin/out/appsutil.zip $ORACLE_HOME
sandbox> ls -l $ORACLE_HOME/appsutil.zip
-rw-r–r– 1 oracle dba 2814669 Sep 06 14:13 /ORACLE/sandbox/9.2.0/appsutil.zip
unzip -o appsutil.zip # say A if being prompted for file over-writing
# Generate the database context file:
————————————
sandbox> pwd
/ORACLE/sandbox/9.2.0/appsutil/bin
sandbox> id
uid=300(oracle) gid=200(dba) groups=1(staff),202(oaa),203(move),13(oinstall)
sandbox> perl adbldxml.pl tier=db appsuser=apps
Starting context file generation for db tier..
Using JVM from /ORACLE/sandbox/9.2.0/jdk/bin/java to execute java programs..
APPS Password: apps
The log file for this adbldxml session is located at:
/ORACLE/sandbox/9.2.0/appsutil/log/adbldxml_09061436.log
Enter the value for Display Variable: hostname:1
Context File /ORACLE/sandbox/9.2.0/appsutil/sandbox_hostname.xml
already exists.
Overwriting Context File may cause loss of existing settings, hence
backing it up as: /ORACLE/sandbox/9.2.0/appsutil/sandbox_hostname.xml.bak
The context file has been created at:
/ORACLE/sandbox/9.2.0/appsutil/sandbox_hostname.xml
# Take a backup of all the crucial configuration files and Generate and apply AutoConfig configuration file:
————————————————————————————————————
a) Backup $TNS_ADMIN/*.ora and $ORACLE_HOME/dbs/*.ora
b) run Autoconfig on source tier to generate the context specific files:
cd /appsutil/bin
adconfig.sh contextfile= appspass=
c) Restore the $TNS_ADMIN/*.ora and $ORACLE_HOME/dbs/*.ora Immediately
d) Do a reload of the listener.ora to make sure other instances using /var/opt/oracle/listener.ora do not get affected:
$ lsnrctl reload qa
$ lsnrctl reload sandbox
The command used to check for the Forms patchset level 
( you should be 17 or above)
`f60gen | grep ‘(Form Compiler)’ | grep -v Release | awk -F. ‘{print $5}’ `
How to find JDBC thin driver that your iAS 1.0.2.2.2 is using ?
A simple java program & procedure to compile it that will give your jdbc thin driver version.
Create a file with name JDBCVersion.java in your middle tier (Application Tier)
———
import java.sql.*;
import oracle.jdbc.driver.*;
class JDBCVersion
{
public static void main (String args[])
throws SQLException
{
// Load the Oracle JDBC driver
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
// Get a connection to a database
Connection conn = DriverManager.getConnection
(“jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=YES)(FAILOVER=YES) (ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST= ) (PORT= )))(CONNECT_DATA=(SID=)))” ,”apps”,””);
// Create Oracle DatabaseMetaData object
DatabaseMetaData meta = conn.getMetaData();
// gets driver info:
System.out.println(“JDBC driver version is ” + meta.getDriverVersion());
}
}
———–
Replace following parameters
1. with your database hostname or IP address
2. with your database port no.
3. with SID for your database
4. with your apps password
After changing save it with name JDBCVersion.java in your middle tier & execute command
javac JDBCVersion.java
This will create class file in your workign directory. Include your current directory into your classpath like
export CLASSPATH=$CLASSPATH:/
then execute
java JDBCVersion
you should see output like
JDBC driver version is 9.2.0.6.0
Which means you are using jdbc thin driver version 9.2.0.6.0.
How to check if Apps 11i System is Autoconfig enabled ?
Under $AD_TOP/bin check for file adcfginfo.sh & if this exists use
adcfginfo.sh contextfile= show=enabled
If this file is not there , look for any configuration file under APPL_TOP if system is Autoconfig enabled then you will see entry like
# AutoConfig automatically generates this file. It will be read and …….
Context Editor 
Application <common_top>/util/editcontext/
Database /appsutil/editcontext/
“To run the Context Editor:
On UNIX
editcontext
If the [COMMON_TOP]/util/editcontext (for Unix) or [COMMON_TOP]\util\editcontext (for Windows) directory does not
exist, please refer to MetaLink Note 165195.1 titled “”Using AutoConfig to Manage System Configurations with Oracle
Applications 11i””.
Copy the Context Editor meta data file adctxinf.tmp to the common top directory under util/editcontext/etc and rename
it as adctxinf.xml:
on UNIX:
cp $AD_TOP/admin/template/adctxinf.tmp [COMMON_TOP]/util/editcontext/etc/adctxinf.xml
EDITING CONTEXT FILE 
Editing Context file(xml file) in Oracle apps R12 using Context editor.
It is a mandatory thing that you should not edit the context file or xml file manually .
Context editor should be used for this(This can be used for updating ports or to change any configuration)
of application Tier or database tier.
follow these steps to install context editor in your existing oracle apps R12 system.
Apply patch 2873456 from metalink
after applying you will not be able to invoke the editcontext executable and you will get a error. this is because jre 1.1.8 which is
supplied along with this patch is no longer supported.
So download jre1.5.0_10 from sun.java.com and unpack it inside the path editcontext/jre/Linux/
and rename the old 1.1.8 jre inside that
then go to the bin directory inside the editcontext directory
open the file runWizard.sh
and accordingly replace the jre directory and also replace the jre executable with java in the same file ..
and invoke it from
$RDBMS_ORACLE_HOME/appsutil for editing database context(xml) file.
$COMMON_TOP/util for editing Application context(xml) file.
Syntax is
./editcontext
Before editing shutdown the application tier and after editing run autoconfig.sh to update the configuration files to reflect the new value.
The URL for ext web node is
JTF Login Page for customers using CRM (Check for each MT using real host names).
http://:port/OA_HTML/jtflogin.jsp
start Apache in SSL mode as root (on web025) using following cmd: 
. //APPSORA.env
$IAS_ORACLE_HOME/Apache/Apache/bin/httpdsctl startssl.
URL to access OAM
access http://.:/servlets/weboam/oam/oamlogin
How will you identify if you are using Forms in Socket or Servlet mode in Oracle Applications 11i or R12 ?
You can find out the form are in Socket or Servlet mode in form configuration file it is in $COMMON_TOP/html/bin and the file name is “appsweb_SID_hostname.cfg”.
s_forms_servlet_serverurl If value is blank that means this is not servlet else if value is “/forms/formservlet” this indicates forms servlet.
In the context file, unde OA variable, ‘frmConnectMode’
repackage the jinit using the following command : 
adjbuild.sh $COMMON_TOP/util/jinitiator $COMMON_TOP/util/jinitiator/j2se15012.exe 1.5.0.12
CPU patch log location on iAS HOME/d01/oratst/preprodora/iAS/cpu/CPUJul2005/install-Jun-09-2008-07-11-34.log
Apache config test
$ pwd
/d01/oratst/preprodora/iAS/Apache/Apache/bin
$ ./apachectl configtest
Syntax error on line 239 of /d01/oratst/preprodora/iAS/Apache/Apache/conf/httpd.conf:
Cannot load /d01/oratst/preprodora/iAS/Apache/Apache/libexec/mod_log_config.so into server: ld.so.1: httpd: fatal: relocation error: file /d01/oratst/preprodora/iAS/Apache/Apache/libexec/mod_log_config.so: symbol ap_escape_logitem: referenced symbol not found
To check X-display is working
Access page at http://hostname.domainnmae:8000/OA_HTML/testXServer.jsp. If the display setting is inappropriate you will see an exception page
Edit the AutoConfig context file.
If you are currently using E-Business Suite level 11.5.9 or above, or have applied FND.G patchset (or above), you will use Oracle Applications Manager to edit your context file. For all previous versions, you will use the AutoConfig Context Editor tool.
To edit the context file using Oracle Applications Manager, login to Oracle Applications Manager and navigate to Site Map > AutoConfig > Edit Parameters.
To edit the context file using the AutoConfig Context Editor tool, enter the following commands:
% cd [COMMON_TOP]/util/editcontext/
% ./editcontext”
To convert host specific url to user friendly url
Make host entries for ebus and make the following xml file changes and run autoconfig.
$ grep evis VIS_hostname.xml
ebus

< disco_machine oa_var=”s_disco_machine”>evis.corpdom.local
http://evis.corpdom.local:8000
evis
< apps_portal_url oa_var=”s_apps_portal_url”>http://evis.corpdom.local:8000/pls/VIS_portal30/portal30.home
< login_page oa_var=”s_login_page”>http://evis.corpdom.local:8000/OA_HTML/US/ICXINDEX_VIS_hostname.htm
< forms60_mapping oa_var=”s_f60map”>http://evis.corpdom.local:8000/OA_TEMP
$
MWA boucne procedure on 11 i
cd $MWA_TOP/bin
mwactl.sh start 10200
mwactl.sh start 10210
mwactl.sh start 10220
mwactl.sh start 10230
mwactl.sh start 10240
nohup mwactl.sh start_dispatcher & Port for Dispatcher is 10300
Procedure to Shutdown Dispatcher
mwactl.sh -login sysadmin/xxx stop_force 10200
mwactl.sh -login sysadmin/xxx stop_force 10210
mwactl.sh -login sysadmin/xxx stop_force 10220
mwactl.sh -login sysadmin/xxx stop_force 10230
mwactl.sh -login sysadmin/xxx stop_force 10240
nohup mwactl.sh stop_dispatcher &
1. Autoconfig. In autoconfig-enbled environment configuration file mwa.cfg is written by autoconfig. So it would be good to modify any configuration setting that you want to be permanent via AutoConfig editor in OAM. For all MWA server configuration variables OA_VAR begins from s_mwa. There is also a description for each parameter.
2. R12. While in 11i mwa.cfg is located in $MWA_TOP/secure, in R12 it’s in $INST_TOP/admin/install. Startup script mwactl.sh in R12 is located in $INST_TOP/admin/scripts
3. Dispatcher. If we are going to run multiple servers (specified by mwa.TelnetPortNumber / s_mwaTelnetPortNo) then we most likely will also use dispatcher to load balance client requests between MCSA telnet servers. We use mwa.Dispatcher=host:port to set MCSA dispatcher (in AutoConfig there is s_mwaDispatcherPort for the port setting). To start|stop dispatcher we can use:
mwactl.sh start_dispatcher | stop dispatcher.
Dispatcher is MWADIS binary within $MWA_TOP/bin directory. We can check whether it’s running using:
ps -ef | grep MWADIS
4. OAM. There are Generic Services (MWA MSCA Telnet Server & MWA MSCA Telnet Dispatchers) in OAM that corresponds to MSCA telnet server & dispatcher respectively and can be used to start/stop them automatically.
5. Server shutdown. When we use
mwactl.sh -login / stop [port]
– it’s so called graceful shutdown. MCSA Telnet Server won’t stop unless there are no clients currently using it. If you need to force shutdown, use stop_force instead of stop
6. Tracing. Setting mwa.LogLevel could be very useful for trobleshooting issues with MWA In 11.5.10/R12 this will usually produce serveral files within MWA log directory:
.system.log
.INV.log
.WMS.log (optionally)
But for performance tuning we can also use SQL tracing. It can be enabled by setting mwa.LogLevel (s_mwaLogLevel) to performance. SQL trace file will be put into usual user_dump_dest directory on database server.
The steps that needs to be done to disable MWA are as follows: 
1. Modify the $IAS_ORACLE_HOME/Apache/Jserv/etc/mobile.properties file by commenting out the following line:
servlets.startup=oracle.apps.mwa.wap.engine.WapServlet
2. Comment out the following lines in the $IAS_ORACLE_HOME/Apache/Jserv/etc/jserv.properties file:
zones=mobile
3. Comment out the following lines in the $IAS_ORACLE_HOME/Apache/Jserv/etc/jserv.conf file:
ApJServGroupMount /mobile balance://OACoreGroup/mobile
Check if tcfsocket server is running
ps -ef|grep jre|grep comn
appltst 6466 6226 0 14:04:07 ? 0:03 /d01/oratst/testcomn/util/jre/1.1.8/bin/../bin/sparc/native_threads/jre -Ddbcfi
appltst 7969 6226 0 14:12:59 ? 0:03 /d01/oratst/testcomn/util/jre/1.1.8/bin/../bin/sparc/native_threads/jre -Ddbcfi
appltst 6496 6226 0 14:04:13 ? 0:03 /d01/oratst/testcomn/util/jre/1.1.8
Generating jar files
Generating product JAR files in JAVA_TOP –
/d01/oratst/testcomn/java with command:
adjava -mx512m -nojit oracle.apps.ad.jri.adjmx @/d01/oratst/testappl/admin/TEST02/out/genjars.cmd
The AutoConfig check utility
The AutoConfig check utility is located at Target Database Tier /appsutil/bin
i) Check the AutoConfig configuration files by executing the following command
adchkcfg.sh contextfile=.xml  appspass= – This report provides information about All the profile options that get changed during the next normal execution of AutoConfig.
– For every profile option there is information about the current value in the database, the changed value and the AutoConfig script that changes the profile option.
– The script will also create a zip file report “ADXcfgcheck.zip” that contains all the files and reports mentioned above, so that you can copy the ADXcfgcheck.zip to a local desktop PC and view the html report from there without breaking the hyper-links in the report.
Check Java Cache in your Env :
login to URL http://: /OA_HTML/jtflogin.jsp
Login as sysadmin and navigate to Performance -> Components.
How to change all Applications user passwords 
In apps, there are times when we want to force all the application users to change their passwords. In apps 11i, we have a concurrent request under System Administrator->
CP SQL*Plus Expire FND_USER Passwords
This concurrent request basically sets the fnd_user.password_date to null for all apps users. The users are thus prompted to change their passwords on next login
Responsibility attached to a users 
SELECT UNIQUE u.user_id, SUBSTR (u.user_name, 1, 30) user_name,
SUBSTR (r.responsibility_name, 1, 60) responsiblity,
SUBSTR (a.application_name, 1, 50) application
FROM fnd_user u,
fnd_user_resp_groups g,
fnd_application_tl a,
fnd_responsibility_tl r
WHERE g.user_id(+) = u.user_id
AND g.responsibility_application_id = a.application_id
AND a.application_id = r.application_id
AND g.responsibility_id = r.responsibility_id
ORDER BY SUBSTR (user_name, 1, 30),
SUBSTR (a.application_name, 1, 50),
SUBSTR (r.responsibility_name, 1, 60);
Query useful when user wants to get application wise responsibility list 
SELECT (SELECT application_short_name
FROM fnd_application fa
WHERE fa.application_id = frt.application_id) application,
frt.responsibility_id, frt.responsibility_name
FROM apps.fnd_responsibility_tl frt;
####### Script to create LENOVO User ###################
####### Please copy this script in a file and execute as apps user #####
REM XX_CREATE_USER.SQL
REM Script to create a user and add
REM responsibility. This script will run as part of
REM post-clone processes in a non-PROD instance.
SET serveroutput ON
DECLARE
l_appl_short_name fnd_application.application_short_name%TYPE;
l_resp_key fnd_responsibility.responsibility_key%TYPE;
BEGIN
SAVEPOINT create_user;
DBMS_OUTPUT.put_line(‘Creating user …’||CHR(10));
FND_USER_PKG.CreateUser ( x_user_name => ‘LENOVO’
,x_owner => ‘SEED’
,x_unencrypted_password => ‘welcome1’
,x_description => ‘Consultant’
);
DBMS_OUTPUT.put_line(‘User created successfully.’||CHR(10));
SELECT application_short_name
,responsibility_key
INTO l_appl_short_name
,l_resp_key
FROM fnd_responsibility_vl resp
,fnd_application app
WHERE app.application_id = resp.application_id
AND responsibility_name = ‘System Administrator’;
DBMS_OUTPUT.put_line(‘Adding Responsibility…’||CHR(10));
FND_USER_PKG.addresp( username => ‘DELOITTE’
,resp_app => l_appl_short_name
,resp_key => l_resp_key
,security_group => ‘STANDARD’
,description => ”
,start_date => SYSDATE – 1
,end_date => SYSDATE + 364
);
DBMS_OUTPUT.put_line(‘Repsonsibility added sucessfully.’);
COMMIT;
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.put_line(SUBSTR(SQLERRM,1,200));
ROLLBACK TO create_user;
END;
/
####### Script to create LENOVO User ###################
Using following tables we can get the end-user access details:
APPLSYS.FND_LOGINS
APPLSYS.FND_LOGIN_RESPONSIBILITY
APPLSYS.FND_LOGIN_RESP_FORMS
APPLSYS.FND_UNSUCCESSFUL_LOGINS
FND_CONCURRENT_REQUESTS
ICX.ICX_FAILURES
Clients requires to restrict duplicate user sessions usually, so in previous project we setted ICX_SESSIONS of DISABLED_FALG=Y to restrict the duplicate session of E-buss suite user. { This can obtain by patch 21228669 }
Requirement:
Client want to secure login policy to more robust for users of 11i.
> The password contains at least one letter and at least one number
> The password does not contain the username
> If user tried more than 3 attempts , password should lock
> If user unable to login more than 2 attempted, need weekly report of those users.
After doing a bit R & D, recommended for the client the following:
1. Change the profile option ” Signon Password Failure limit” to 3, defalt is None.
2. Change the profile option ” Signon Password Hard to guess” to YES, defalt is NO.
3. We are sheduling a con.program weekly using the tables FND_UNSUCCESSFUL_LOGINS and ICX.ICX_FAILURES to reports on login attempts.
JDK version userd by AD Utilities
AD Utilities use jdk 1.3 or jdk 1.4. You can detect the version used by the AD Utilities with the command $ADJVAPRG -version.

Thanks
Srini