AbdulWasiq: May 2013

Thursday 23 May 2013

Program was terminated by signal 25

User pinged me and reported that there concurrent programs are erroring out with signal 25.Below are the details.

Error Message in request Log file:
===================================
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 7275485 Review your concurrent request log and/or report output file for more detailed information.”
Program was terminated by signal 25.

Metalink id:
========
Error: Signal 25 Concurrent Program Completes with Error [ID 842850.1]

Symptoms

Problem Statement:
When attempting to run a concurrent program which is accessing file "reports.log" in directory $APPLCSF/$APPLLOG then following error occurs:

Error:
emsg:was terminated by signal 25

Cause:
File size of "reports.log" has reached its maximum limit at operating system which is 2GB. If $APPLCSF/$APPLLOG/reports.log will be huge -- 2GB in size, then reports can not append anything else to it and hence concurrent program accessing reports.log for its execution will error out.

Solution
========
1. Stop the concurrent manager.

2. Check the size of reports.log file and if file size is more than 2 GB then rename/truncate existing "reports.log" in directory $APPLCSF/$APPLLOG and create a empty "reports.log". One can do a find command as well.

$ find $INST_TOP -name reports.log
cd $APPLCSF/$APPLLOG

bash-3.2$ls -lrth reports.log
-rw-r–r– 1 applmgr dbamgr 2.1GB Mar 05 23:00 reports.log
bash-3.2$ cp -r reports.log reports.log_BKP
bash-3.2$ > reports.log

3. Start the concurrent manager.
4. Retest the issue.

The best way is learn to teach !!!!!!!!!!!!!!!

java.lang.NoClassDefFoundError: Could not initialize class oracle.apps.fnd.profiles.Profiles+in oracle application 11i

Users are reported that when they logged in to oracle application we are getting below error.

Error found in the front end .

Request URI:/OA_HTML/AppsLocalLogin.jsp

Exception:
java.lang.NoClassDefFoundError: Could not initialize class oracle.apps.fnd.profiles.Profiles

Solution:
we can resolve this issue in two ways.
1)bouncing the database 100% will work.
2)By doing below steps.

i)Take the backup of Jserv.properties file.
ii)change the value of the DLONG parameter from "true" to "false" in Jserv.properties file.

grep -i wrapper.bin.parameters=-DLONG_RUNNING_JVM Jserv.properties
wrapper.bin.parameters=-DLONG_RUNNING_JVM=false

iii)Stop adapactl.sh stop
clear cache. cd $COMMON_TO
mv _pages _pages_23may2013
mkdir _pages
cd $COMMON_TOP/admin/scripts/$CONTEXT_NAME
adapactl.sh start.

Performing the above steps will fix the issue in Oracle application 11i.

Happy Learning !!!

REP-3000: Internal Error Starting Oracle Toolkit.

User reported that all reports are failing with the below error and when we did the sanity from our side we too got the same issue while opening the view log and view output of a concurrent request.

REP-3000: Internal Error Starting Oracle Toolkit.
REP-3000: Internal Error Starting Oracle Toolkit.

Report Bulider 6.0.828.0 -production Tue Apr 30 15:39:00

(c) copyright 1999 oracle corporation .All right reserved.

Enter username:
Program exited with status 1
Concurrent manager encountered an error while running Oracle*Report for your
concurrent request 1234567.
Review your concurrent request log and/out report output file more detailed information.

Metalink id:
=========

How To Perform Quick Checks for REP-3000: Internal Error Starting Oracle Toolkit. [ID 364838.1]

Solution:issue with the display.

Go to location script locatoin if it is Oracle application 11i/R12
cd $COMMON_TOP/admin/scritps/$CONTEXT_NAME

cd $ADMIN_SCRIPTS_HOME (OR) $INST_TOP/admin/scripts

grep for the display.
grep -i display adcmcctl.sh

(OR)

grep -i s_display $CONTEXT_FILE

Once you verified the display port,you can start the display on particular port.

cd /usr/local/adm/VCS

syntax: ./startup_x <instance name> <port no>

./startup_x ebsdev 0.0

Just submit the request and check it.issue will get fixed.

Thanks for visiing my blog !!!!!!!!!!!!!!!

Troubleshoot Oracle HTTP Server in Oracle ebs R12?

The configuration file for apache in R12 is located in the below location.
$ORA_CONFIG_HOME/10.1.3/Apache/Apache/conf/httpd.conf

For successful start of Apache exit code must be 0 ,
If this value is non zero like 150,152 or 204 then identify root cause of non zero exit code by examing below files.

1)First check Apache startup log file .
$LOG_HOME/appl/admin/log/adapcctl.txt

2) $LOG_HOME/ora/10.1.3/opmn/HTTP_Server~1.log

3) Check for apache access logs and error logs.
$LOG_HOME/ora/10.1.3/Apache

ls -tlrh error_log.*|tail
ls -tlrh access_log.*|tail

All about OPMN click on the below link.
http://abduulwasiq.blogspot.in/2013/05/opmn-in-oracle-apps-r12.html

Thanks for visiting my blog !!!
Enjoy the subject !!

ORA-04031: unable to allocate 42680 bytes of shared memory+("large pool",unknown object","session heap","ktspsrchche:L2s")

Error generating process :
------------------------------
ORA-04031: unable to allocate 42680 bytes of shared memory
("large pool",unknown object","session heap","ktspsrchche:L2s")

Solution:
--------

Issue is related to memory parameters

1)Shared_pool_size
2)large_pool_size
3)log_buffer

we had check the sizes with these queries
SQL>select component,current_size from v$sga_dynamic_components;

SQL> select * from v$sga;
================================
Previously the sizes of are :

large_pool_size big integer 250M
log_buffer integer 30411104
shared_pool_reserved_size big integer 135832K
shared_pool_size big integer 2464M
======================================

Here the when the user is trying to generate the plsql repot from frontend,he is getting the error ORA04031 .application is not able to generate the reports it is hitting the large_pool_size which is not sufficient to generate plsql report.

For this we had asked 30 min outage/downtime from the client.After getting the approval we had down the database.
1)Bring down middle tier servies
2) Bring down database and database listener
3) make sure that all processes regarding to database are completely down are not.

4)move the spfile so that you can change the parameter in pfile and when you give startup it will seach for

spfile .if it is not found it will start the database with the pfile.

5)We have increase the below parmeters
===============================
large_pool_size big integer 750M
log_buffer integer 30411104
shared_pool_reserved_size big integer 135832K
shared_pool_size big integer 3464M
=========================================

here we had increased large_pool_size and shared_pool_size and we tried to up the database.it starts up smoothy

1)sqlplus '/as sysdba'
2)startup

then check the parameters values
large_pool_size and shared_pool_size.

verification:
-------------
ping to the user to try to generate plsql reports from front end Application.
here in our case the plsql runs smoothly after changing the memory related parametrs.

Note:you can also change the parameters by using the below commands when database is up and running
1)alter system set shared_pool_size=3464M scope=spfile
2)alter system set large_pool_size=750M scope=spfile;
but the new values will affected after bouncing the database only.

ex: suppose shared_pool_size=2464M
database up and running.

alter system set shared_pool_size=3464M scope=spfile;
show parameter shared_ppol_size
it shows 2464M

after bouncing of database the new value will be affected
Bounce the database.

select status from v$instance==>opened
show parameter shared_ppol_size it shows 3464M.

Tuesday 21 May 2013

opmn in oracle apps R12

All about OPMN
=============

In R12 services are managed by OPMN(Oracle process manager and notification server).

OPMN COMPONENTS
==============
OPMN consists of two main components

1) Oracle Process Manager

2) Oracle Notification Server

1)Oracle Process Manager is responsible for below things.
=======================================
1) starting
2) stopping
3) restarting
4) monitoring the services it manages (this includes death detection and automatic restart of the process).

2) Oracle Notification Server

Oracle Notification Server is the transport mechanism for failure, recovery, startup, and other related notifications between components in AS.

Single configuration file(opmn.xml) is used OPMN to manage the services.
Config file location is given as $ORA_CONFIG_HOME/10.1.3/opmn/conf/opmn.xml

To see more in details
========================
http://docs.oracle.com/cd/B13597_05/core.904/b12057/common.htm#CACHJAGG

http://otndnld.oracle.co.jp/document/products/as10g/101300/B25221_03/core.1013/b15976/opmnctl.htm

wonderful document on opmn
==========================
http://isu.ifmo.ru/docs/IAS904/core.904/b12057/intro.htm#1015088

http://otndnld.oracle.co.jp/document/products/as10g/101300/B25221_03/core.1013/b15976/opmnctl.htm

OPMN SERVICES

Services managed by opmn are (grep process-type opmn.xml)

1) HTTP_Server
2) oacore
3) forms
4) oafm

Starting OPMN managed Services

Starting Complete OC4J container
=================================

./adopmnctl.sh startproc ias-component=OC4J

Starting individual process-type(s)

./adopmnctl.sh startproc ias-component=OC4J process-type=oafm
./adopmnctl.sh startproc ias-component=OC4J process-type=forms
./adopmnctl.sh startproc ias-component=OC4J process-type=oacore

Starting HTTP Server (Apache)

./adopmnctl.sh startproc ias-component=HTTP_Server

Stoping OPMN managed Services

Stoping Complete OC4J container

./adopmnctl.sh stopproc ias-component=OC4J


Stoping individual process-type(s)

./adopmnctl.sh stopproc ias-component=OC4J process-type= oafm
./adopmnctl.sh stopproc ias-component=OC4J process-type= forms
./adopmnctl.sh stopproc ias-component=OC4J process-type= oacore


Stoping HTTP Server (Apache)
./adopmnctl.sh stopproc ias-component=HTTP_Server

Benefits of OPMN

OPMN detects the death of the process which it manages and brings up in almost no time.
1) OS process is checked by OPMN for every 2 seconds.
2) forward ping: periodically OPMN pings the process for every 20 seconds and expects response
3) reverse ping: every 20 seconds managed process sends OPMN a ping notification.

Creating oc4j instances

=================

http://www.oracle.com/technology/tech/java/oc4j/1013/whitepapers/OC4J-FAQ-MGT-10131.pdf

Friday 17 May 2013

How to enable archive log in RAC?

How to put the database in archive mode in rac?

SQL> select name from v$database;

NAME
---------
EBSTEST

SQL> alter system set cluster_database=False scope=spfile;

System altered.

SQL>

srvctl status database -d ebstest

srvctl stop database -d ebstest

sqlplus "/as sysdba"

SQL> startup mount
ORACLE instance started.

Total System Global Area 9556852736 bytes
Fixed Size 2166288 bytes
Variable Size 6375346672 bytes
Database Buffers 3154116608 bytes
Redo Buffers 25223168 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +ARCH
Oldest online log sequence 380
Next log sequence to archive 382
Current log sequence 382
SQL> alter system set cluster_database=true scope=spfile;

System altered.

SQL> shutdown immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL>

srvctl start database -d ebstest

Monday 13 May 2013

What are the components of Oracle Applications technology layer?

Oracle Applications technology layer comprises the following products
• Oracle Applications DBA (AD)
• Oracle Applications object library (FND)
• Oracle Common Modules (AK)
• Oracle Applications Utilities (AU)
• Oracle Alert (ALR)
• Oracle Workflow (WF)
• Oracle Applications Framework (FWK)
• Oracle XML Publisher (XML)

Friday 10 May 2013

How to you know the product versions,patchset level?

Go to $AD_TOP/sql under that location you will find adutconf.sql file.
Connect to database as apps schema and run it and will create adutconf.lst in the same location.

[applmgr@apps sql]$ ls -ld /u02/apps/apps_st/appl/ad/12.0.0/sql/adutconf.sql
-rwxr-xr-x 1 applmgr dba 10612 Mar 27 2009 /u02/apps/apps_st/appl/ad/12.0.0/sql/adutconf.sql

[applmgr@apps sql]$ sqlplus apps/apps

SQL*Plus: Release 10.1.0.5.0 - Production on Fri May 10 23:51:14 2013

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @/u02/apps/apps_st/appl/ad/12.0.0/sql/adutconf.sql

--> Start of Application Information Gathering

--> Product Group Information

ID Product Group Name Appl Sys Name Release Type

---- ---------------------------- --------------- ------------ ----------

Arguments

--------------------

1 Default product group PROD 12.1.1 Standard

1 row selected.

--> Multi-Org enabled?

Yes

1 row selected.

--> Existing Operating Units

no rows selected

--> Multi-Currency enabled?

1 row selected.

180,1 5%

--> Registered Applications

ID Short name Basepath

------ ---------- --------

0 FND FND_TOP

1 SYSADMIN FND_TOP

3 AU AU_TOP

40 EMS EMS_TOP

41 PTX PTX_TOP

50 AD AD_TOP

60 SHT SHT_TOP

99 OAM OAM_TOP

101 SQLGL GL_TOP

140 OFA FA_TOP

160 ALR ALR_TOP

168 RG RG_TOP

170 CS CS_TOP

172 CCT CCT_TOP

174 ECX ECX_TOP

175 EC EC_TOP

177 POS POS_TOP

178 ICX ICX_TOP

185 XTR XTR_TOP

186 QRM QRM_TOP

190 AZ AZ_TOP

191 BIS BIS_TOP

200 SQLAP AP_TOP

201 PO PO_TOP

202 CHV CHV_TOP

203 AME AME_TOP

204 XLE XLE_TOP

205 IA IA_TOP

206 LNS LNS_TOP

207 IPM IPM_TOP

210 ZPB ZPB_TOP

222 AR AR_TOP

230 ITG ITG_TOP

231 BNE BNE_TOP

235 ZX ZX_TOP

240 PN PN_TOP

242 AMW AMW_TOP

250 QA QA_TOP

260 CE CE_TOP

265 FRM FRM_TOP

266 GCS GCS_TOP

270 EAA EAA_TOP

271 BSC BSC_TOP

272 ABM ABM_TOP

273 EVM EVM_TOP

274 FEM FEM_TOP

275 PA PA_TOP

278 IZU IZU_TOP

279 AS AS_TOP

280 ASN ASN_TOP

--> Product Installation Status, Version Info and Patch Level

Product Appl Status Version Patchset Level Update Date

-------- -------------- -------- -------------------- -----------------

AD Shared 12.0.0 R12.AD.B.1 27-Mar-2009

AHL Inactive 12.0.0 R12.AHL.B.1 27-Mar-2009

AK Installed 12.0.0 R12.AK.B.1 27-Mar-2009

ALR Installed 12.0.0 R12.ALR.B.1 27-Mar-2009

AME Inactive 12.0.0 R12.AME.B.1 27-Mar-2009

AMS Installed 12.0.0 R12.AMS.B.1 27-Mar-2009

AMV Shared 12.0.0 R12.AMV.B.1 27-Mar-2009

AMW Inactive 12.0.0 R12.AMW.B.1 27-Mar-2009

AP Installed 12.0.0 R12.AP.B.1 27-Mar-2009

AR Installed 12.0.0 R12.AR.B.1 27-Mar-2009

AS Installed 12.0.0 R12.AS.B.1 27-Mar-2009

ASF Installed 12.0.0 R12.ASF.B.1 27-Mar-2009

ASG Shared 12.0.0 R12.ASG.B.1 27-Mar-2009

ASL Installed 12.0.0 R12.ASL.B.1 27-Mar-2009

ASN Installed 12.0.0 R12.ASN.B.1 27-Mar-2009

ASO Installed 12.0.0 R12.ASO.B.1 27-Mar-2009

ASP Installed 12.0.0 R12.ASP.B.1 27-Mar-2009

AST Installed 12.0.0 R12.AST.B.1 27-Mar-2009

AU Shared 12.0.0 -- Not Available -- 27-Mar-2009

AX Installed 12.0.0 11i.AX.I 27-Mar-2009

AZ Installed 12.0.0 R12.AZ.B.1 27-Mar-2009

BEN Shared 12.0.0 R12.BEN.B.1 27-Mar-2009

BIC Inactive 12.0.0 R12.BIC.B.1 27-Mar-2009

BIL Installed 12.0.0 R12.BIL.B.1 27-Mar-2009

BIM Installed 12.0.0 R12.BIM.B.1 27-Mar-2009

BIS Installed 12.0.0 R12.BIS.B.1 27-Mar-2009

BIV Installed 12.0.0 R12.BIV.B.1 27-Mar-2009

BIX Shared 12.0.0 R12.BIX.B.1 27-Mar-2009

BNE Installed 12.0.0 R12.BNE.B.1 27-Mar-2009

BOM Installed 12.0.0 R12.BOM.C.1 27-Mar-2009

BSC Installed 12.0.0 R12.BSC.B.1 27-Mar-2009

CCT Shared 12.0.0 R12.CCT.B.1 27-Mar-2009

CE Installed 12.0.0 R12.CE.B.1 27-Mar-2009

CHV Installed 12.0.0 R12.CHV.B.1 27-Mar-2009

CLN Inactive 12.0.0 R12.CLN.C.1 27-Mar-2009

CN Shared 12.0.0 R12.CN.B.1 27-Mar-2009

CRP Installed 12.0.0 R12.CRP.B.1 27-Mar-2009

CS Installed 12.0.0 R12.CS.B.1 27-Mar-2009

CSC Installed 12.0.0 R12.CSC.B.1 27-Mar-2009

CSD Shared 12.0.0 R12.CSD.B.1 27-Mar-2009

CSE Inactive 12.0.0 R12.CSE.B.1 27-Mar-2009

CSF Shared 12.0.0 R12.CSF.B.1 27-Mar-2009

CSI Installed 12.0.0 R12.CSI.B.1 27-Mar-2009

CSL Inactive 12.0.0 R12.CSL.B.1 27-Mar-2009

CSM Inactive 12.0.0 R12.CSM.B.1 27-Mar-2009

CSP Inactive 12.0.0 R12.CSP.B.1 27-Mar-2009

CSR Inactive 12.0.0 R12.CSR.B.1 27-Mar-2009

CUA Shared 12.0.0 -- Not Available -- 27-Mar-2009

CUF Inactive 12.0.0 -- Not Available -- 27-Mar-2009

CUG Installed 12.0.0 R12.CUG.B.1 27-Mar-2009

CUI Inactive 12.0.0 -- Not Available -- 27-Mar-2009

CUP Inactive 12.0.0 -- Not Available -- 27-Mar-2009

CUS Inactive 12.0.0 -- Not Available -- 27-Mar-2009

CZ Installed 12.0.0 R12.CZ.B.1 27-Mar-2009

DDD Inactive 12.0.0 R12.DDD.C.1 27-Mar-2009

DDR Inactive 12.0.0 R12.DDR.B.1 27-Mar-2009

DNA Inactive 12.0.0 R12.DNA.C.1 27-Mar-2009

DOM Inactive 12.0.0 R12.DOM.B.1 27-Mar-2009

DPP Inactive 12.0.0 R12.DPP.B.1 27-Mar-2009

DT Shared 12.0.0 R12.DT.B.1 27-Mar-2009

EAM Inactive 12.0.0 R12.EAM.B.1 27-Mar-2009

EC Installed 12.0.0 R12.EC.B.1 27-Mar-2009

ECX Installed 12.0.0 R12.ECX.B.1 27-Mar-2009

EDR Installed 12.0.0 R12.EDR.B.1 27-Mar-2009

EGO Inactive 12.0.0 R12.EGO.C.1 27-Mar-2009

ENG Installed 12.0.0 R12.ENG.C.1 27-Mar-2009

ENI Inactive 12.0.0 R12.ENI.B.1 27-Mar-2009

FA Installed 12.0.0 R12.FA.B.1 27-Mar-2009

FEM Installed 12.0.0 R12.FEM.B.1 27-Mar-2009

FF Shared 12.0.0 R12.FF.B.1 27-Mar-2009

FII Installed 12.0.0 R12.FII.B.1 27-Mar-2009

FLM Shared 12.0.0 R12.FLM.B.1 27-Mar-2009

FND Installed 12.0.0 R12.FND.B.1 27-Mar-2009

FPA Inactive 12.0.0 R12.FPA.B.1 27-Mar-2009

FRM Installed 12.0.0 R12.FRM.B.1 27-Mar-2009

FTE Inactive 12.0.0 R12.FTE.B 27-Mar-2009

FTP Inactive 12.0.0 R12.FTP.B.1 27-Mar-2009

FUN Inactive 12.0.0 R12.FUN.B.1 27-Mar-2009

FV Installed 12.0.0 R12.FV.B.1 27-Mar-2009

GCS Inactive 12.0.0 R12.GCS.B.1 27-Mar-2009

GHR Installed 12.0.0 R12.GHR.B.1 27-Mar-2009

GL Installed 12.0.0 R12.GL.B.1 27-Mar-2009

GMA Installed 12.0.0 R12.GMA.B.1 27-Mar-2009

OE Inactive 12.0.0 R12.OE.B.1 27-Mar-2009

OKC Installed 12.0.0 R12.OKC.B.1 27-Mar-2009

OKE Inactive 12.0.0 R12.OKE.H 27-Mar-2009

OKI Installed 12.0.0 R12.OKI.B.1 27-Mar-2009

OKL Inactive 12.0.0 R12.OKL.B.1 27-Mar-2009

OKS Installed 12.0.0 R12.OKS.B.1 27-Mar-2009

OKX Installed 12.0.0 R12.OKX.B.1 27-Mar-2009

ONT Installed 12.0.0 R12.ONT.B.1 27-Mar-2009

OPI Shared 12.0.0 R12.OPI.B.1 27-Mar-2009

OTA Inactive 12.0.0 R12.OTA.B.1 27-Mar-2009

OZF Inactive 12.0.0 R12.OZF.B.1 27-Mar-2009

PA Installed 12.0.0 R12.PA.B.1 27-Mar-2009

PAY Shared 12.0.0 R12.PAY.B.1 27-Mar-2009

PER Installed 12.0.0 R12.PER.B.1 27-Mar-2009

PFT Installed 12.0.0 R12.PFT.B.1 27-Mar-2009

PJI Installed 12.0.0 R12.PJI.B.1 27-Mar-2009

PJM Installed 12.0.0 R12.PJM.B.1 27-Mar-2009

PMI Shared 12.0.0 R12.PMI.B.1 27-Mar-2009

PN Inactive 12.0.0 R12.PN.B.1 27-Mar-2009

PO Installed 12.0.0 R12.PO.B.1 27-Mar-2009

POA Installed 12.0.0 R12.POA.B.1 27-Mar-2009

POM Inactive 12.0.0 R12.POM.B.1 27-Mar-2009

PON Inactive 12.0.0 R12.PON.B.1 27-Mar-2009

POS Inactive 12.0.0 R12.POS.B.1 27-Mar-2009

PQH Installed 12.0.0 R12.PQH.B.1 27-Mar-2009

PQP Inactive 12.0.0 R12.PQP.B.1 27-Mar-2009

PRP Inactive 12.0.0 R12.PRP.B.1 27-Mar-2009

PSA Installed 12.0.0 R12.PSA.B.1 27-Mar-2009

PSB Installed 12.0.0 R12.PSB.B.1 27-Mar-2009

PSP Installed 12.0.0 R12.PSP.B.1 27-Mar-2009

--> Registered Data Groups

ID Data Group Name Dflt Created By Updated By

------ ----------------------------- ---- ----------- ------ ----------- ------

-99 Multiple Reporting Currencies No 09-09-1997 1 09-09-1997 1

0 Standard Yes 29-04-1992 1 29-04-1992 1

2 rows selected.

--> Base language and other Installed languages

Type Code NLS Language

--------- ---- ------------------------------

Base US AMERICAN

1 row selected.

--> NLS Settings

NLS_NCHAR_CHARACTERSET: AL16UTF16

NLS_CHARACTERSET......: UTF8

NLS_DATE_FORMAT.......: DD-MON-RR

NLS_NUMERIC_CHARACTERS: .,

NLS_LANGUAGE..........: AMERICAN

NLS_SORT..............: BINARY

--> Replication Package Installed?

Not Installed

--> End of Application Information Gathering

Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Pages

Thursday 23 May 2013

Symptoms

Tuesday 21 May 2013

Friday 17 May 2013

Monday 13 May 2013

Friday 10 May 2013