Archive for April, 2007

Versions of components in Oracle Apps

Posted on April 18, 2007. Filed under: Scripts, Version |

How to find versions of oracle components associated with Oracle Apps in Windows Environment

Many times we find ourselves in a situation where we just couldnt get the steps to ascertain the versions of components associated with our instance, be it on Unix/Windows. I had listed the steps below to ascertain the version for each component. All the steps can be used in both Unix/Windows environment , except for Developer6i version. We also have a shell script which will give all this information in a table format which was not tested till now on a Windows environment. If interested put a comment, we will write the script in a post.

Database

Connect as apps user;
<you should be getting the banner with oracle version information>. Alternatively you can also execute
Select * from v$version;


Apps Version

Connect as apps user
select release_name from apps.fnd_product_Groups;


Apache/iAS Version

%IAS_ORACLE_HOME%\Apache\Apache\apache.exe -version


Developer 6i PatchSet

cd %ORACLE_HOME% (806 Oracle Home)
cd bin
Ifrun60.exe help=yAbove command will pop-up a window simillar to this

Forms PatchSet WindowThumbrule : Subtract the fourth integer by 9 to get the patchset level.
Ie., 6.0.8.24.1
Fourth integer => 24
Dev6i PS => 24-9 = 15


Discoverer 4i Version

cd %APPL_TOP%\admin
grep -I s_disco_ver_comma *<sid>*xml


Jinitiator Version

cd %APPL_TOP%\admin
grep -i s_jinit_ver_dot *<sid>*xml


JDK/Java Version

java -version


OJSP Version

cd %OA_HTML%
echo “<%= application.getAttribute(“oracle.jsp.versionNumber”) %>” > test.jspLaunch Browser and enter urlhttp://<hostname>.<domain>:port/OA_HTML/test.jsp


JDBC Version

http://<hostname&gt;.<domain>:port/OA_HTML/jsp/fnd/aoljtest.jspLook for String ” JDBC driver version” under Connection String


OA Framework Version

Option 1http://<hostname&gt;.<domain>:port/OA_HTML/OAInfo.jspOption 2adident Header %FND_TOP%/html/OA.jsp
adident Header %OA_HTML%/OA.jsp
Note: OA.jsp should be of the same version in both the places


AD PatchSet Level

Connect as apps user
select patch_level from fnd_product_installations where patch_level like ‘%AD%’;Note: above sql can be used to identify any modules patchset level by replacing AD with the module name eg., BNE


Portal Version

select fnd_oracle_schema.getouvalue(‘PORTAL’) from dual;FND_ORACLE_SCHEMA.GETOUVALUE(‘PORTAL’)
——————————————————————————–
PORTAL30 <= to retrieve the portal userselect version from PORTAL30.wwc_version$;

VERSION
——————————————————————————–
3.0.9.8.1


For gathering version information on Unix Flavours click this linkDo you have a better way of finding the version. Feel free to comment.

cheers,

OraclePitStop

Read Full Post | Make a Comment ( 11 so far )

11.5.x to 11.5.9 Upgrade Issues

Posted on April 17, 2007. Filed under: Oracle Apps Upgrade |

1159 Maintenance Pack & Consolidated Update Patches 2669606 (MP), 3171663 (CU2)

Issues & Resolutions

Based on the personal experience on performing various Oracle Apps Upgrades, we had listed down issues which we had faced during 11.5.x to 11.5.9 Upgrade. Feel free to put a comment and to add more issues and solutions.

Issue:

FAILED: file oklskhdc.sql on worker  2.
 
@/sid/applmgr/1158/okl/11.5.0/patch/115/sql/ oklskhdc.sql
sqlplus -s APPS/***** @/sid/applmgr/1158/okl/11.5.0/patch/115/sql/ oklskhdc.sql
  l_stmv_rec               OKL_STREAMS_PUB.stmv_rec_type;
                           *
ERROR at line 13:
ORA-06550: line 13, column 28:
PLS-00905: object APPS.OKL_STREAMS_PUB is invalid
ORA-06550: line 13, column 28:
PL/SQL: Item ignored
ORA-06550: line 207, column 9:
PLS-00320: the declaration of the type of this expression is incomplete or
malformed
ORA-06550: line 207, column 9:
PL/SQL: Statement ignored
ORA-06550: line 214, column 48:
PLS-00320: the declaration of the type of this expression is incomplete or
malformed
ORA-06550: line 208, column 9:
PL/SQL: Statement ignored

Resolution:

Conn apps/xxxxxxx
SQL> alter package OKL_STM_PVT compile;
Package altered.
SQL> alter package OKL_STREAMS_PVT compile;
Package altered.
SQL> alter package OKL_STREAMS_PUB compile;
Package altered


Issue:

FAILED: file egoimctx.sql on worker  1.
 
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Adwork log has the following errors:
 
HIDEPW: sqlplus -s APPS/xxxx @/talini/applmgr/1158/ego/11.5.0/patch/115/sql/ egoimctx.sql APPS CTXSYS EGO
sqlplus -s APPS/***** @/talini/applmgr/1158/ego/11.5.0/patch/115/sql/egoimctx.sql &un_apps CTXSYS &un_ego
**** Creating EGO_ITEM_TEXT_CTX_PKG package spec
 
PL/SQL procedure successfully completed.
 
**** Creating EGO_ITEM_TEXT_CTX_PKG package body
 
PL/SQL procedure successfully completed.
 
**** Compiling EGO_ITEM_TEXT_CTX_PKG package
DECLARE
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at line 6

Resolution:

Apply patch 3714619


Issue:

FAILED: file egoimdrp.sql on worker  1 for product ego username EGO
sqlplus -s APPS/***** @/tamdbi/applmgr/1157/ego/11.5.0/patch/115/sql/ egoimdrp.sql
   
**** Drop iMT index and truncate text table
DECLARE
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body “APPS.EGO_ITEM_TEXT_PVT” has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 6

Resolution:

1. SQL> select password from dba_users where username like ‘CTXSYS’;
PASSWORD
——————————
F76EF8143CF3A2F4
2. SQL> alter  user ctxsys identified by ctxsys ;
User altered.
3. SQL> select password from dba_users where username like ‘CTXSYS’;
PASSWORD
——————————
24ABAB8B06281B4C
4.  Follow Metalink Note.265414.1to fix the issues of egoimdrp.sql .
5.
SQL> alter user ctxsys identified by values ‘F76EF8143CF3A2F4’;
User altered.
6.
SQL> select password from dba_users where username like ‘CTXSYS’;
PASSWORD
——————————
F76EF8143CF3A2F4
SQL>
6. Re-started the failed worker.
 
Or
1.Connect ctxsys/ctxsys
2.grant all on CTX_OUTPUT to APPS;
3.alter package APPS.EGO_ITEM_TEXT_PVT compile;
4.Restarted the worker.


Issue:

Failure on: invtable.ldt

Resolution:

Apply Patch 2773876
Or
do following:
delete from fnd_index_columns
where application_id = 401
and table_id = 67636
and index_id = 19358
and column_sequence = 0
and column_id < 0;
commit;
Restart worker.


Issue:

Failure on: wmsrule.odf

Resolution:

Apply Patch 3073795


Issue:

Failure on: edwwhtab.ldt and wmstable.ldt

Resolution:

Apply Patch 3139883


Issue:

Updating the master archive with command:
   
adjava -mx128m -nojit oracle.apps.ad.jri.adjcopy @/taveni/applmgr/1158/admin/
<SID>/out/apps.cmd
AutoPatch error:
ERROR Updating the master archive.
AutoPatch error:
Error updating master archive
An error occurred while Updating Oracle Applications Java files.
Continue as if it were successful [No] :
Error in the u2669606.log

Resolution:

Change ADJREOPTS to “-mx256m” from “-mx128m”


Issue:

File:    paupgr27.sql
Error: ORA-20001: Updating pa_projects_all:ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE

Resolution:

Per Note:- 243208.1
select INDEX_NAME, STATUS, GLOBAL_STATS, DOMIDX_STATUS, DOMIDX_OPSTATUS
from DBA_INDEXES
where TABLE_NAME = ‘PA_PROJECT_CTX_SEARCH’;
   
INDEX_NAME                     STATUS   GLO DOMIDX_STATU DOMIDX
—————————— ——– — ———— ——
PA_PROJECT_CTX_SEARCH_U1       VALID    NO
PA_PROJECT_CTX_SEARCH_C1       VALID    NO  VALID        FAILED
   
1. Drop the index PA_PROJECT_CTX_SEARCH_C1
2. Run the following to recreate the index:
sqlplus -s APPS/xxx @$PA_TOP/patch/115/sql/ paxincx1.sql (enter PA when
prompted)
   
INDEX_NAME                     STATUS   GLO DOMIDX_STATU DOMIDX
—————————— ——– — ———— ——
PA_PROJECT_CTX_SEARCH_U1       VALID    NO
PA_PROJECT_CTX_SEARCH_C1       VALID    NO  VALID        VALID
 
Restart worker


Issue:

File:    potxns.ldt

Resolution:

See note 160474.1. After implementing this (XML parser), do following:
SQL> select ‘alter package ‘|| OBJECT_NAME||’ compile;’ from user_objects
where status=’INVALID’ and object_name  like ‘ECX%’ and object_type =’PACKAGE’;
 
SQL> select ‘alter package ‘|| OBJECT_NAME||’ compile body;’ from user_objects
where status=’INVALID’ and object_name  like ‘ECX%’
and object_type =’PACKAGE BODY’;
   
SQL> select ‘alter view ‘|| OBJECT_NAME||’ compile;’ from user_objects
where status=’INVALID’ and object_name  like ‘ECX%’ and object_type =’VIEW’;
 
Restart worker


Issue:

File:    egoimdrp.sql
Error:     PLS-00904: insufficient privilege to access object CTXSYS.CTX_OUTPUT

Resolution:

SQL> connect ctxsys/ctxsys
SQL> grant execute on CTX_OUTPUT  to apps;
SQL> grant execute on CTX_OUTPUT  to ego;
Restart worker


Issue:

FAILED: file jtfihdpfpp.ldt

Resolution:

Modify $JTF_TOP/ patch/115/import/ jtfdpf.lct by replacing
UPLOAD JTF_DPF_LGCL_FLOW_PARAMS
open c1(l_flow_id, :PARAMETER_SEQUENCE);
fetch c1 into l_last_updted_by;  <- change l_last_updted_by to l_last_updated_by
close c1;

and

UPLOAD JTF_DPF_LGCL_FLOW_PARAMS
l_flow_id := jtf_dpf_logical_flows_pkg.find_oldest_prefer_owned_by
(:LOGICAL_FLOW_NAME, :LOGICAL_FLOW_APPLICATION_ID, user_id);  <-  replace user_id  by l_user_id
Restart worker


Issue:

FAILED: file pat351.odf   on worker  1.
 FAILED: file pat254.odf   on worker  2.
Reading table PA_TASKS  …
 
===== Table PA_TASKS all columns match.
===== Index PA_TASKS_N1 all columns match.
===== Index PA_TASKS_N10 all columns match.
*******************************************************
The table is missing the index PA_TASKS_N11
or index PA_TASKS_N11 exists on another table.
Create it with the statement:
 
Start time for statement below is: Wed Feb 02 2005 04:40:53
 
CREATE INDEX PA.PA_TASKS_N11 ON PA.PA_TASKS (JOB_BILL_RATE_SCHEDULE_ID)
 LOGGING STORAGE (INITIAL 4K NEXT 4M MINEXTENTS 1 MAXEXTENTS UNLIMITED
 PCTINCREASE 0 FREELIST GROUPS 4 FREELISTS 4 ) PCTFREE 10 INITRANS 11
 MAXTRANS 255 COMPUTE STATISTICS TABLESPACE PAX
 
Statement executed.
 
The CREATE INDEX statement above failed because there is
another index on the same columns.
Looking for the existing index on the same columns…
 
AD Worker error:
Unable to find existing index on the same columns
 
AD Worker error:
Unable to compare or correct tables or indexes or keys because of the error above

Resolution:

as per bug 3268290
sqlplus apps/<appspwd>
drop index apps.PA_PROJECTS_N10;
drop index apps.PA_TASKS_N11;
drop index apps.PA_TASKS_N12;
drop index apps.PA_PROJECTS_N8 ;
drop index apps.PA_TASKS_N13;
drop index apps.PA_PROJECTS_N9;

Restarted worker


Issue:

FAILED: file b3059755.sql on worker  1.
Start time for statement below is: Fri Feb 04 2005 06:40:32

CREATE index HZ_DQM_SYNC_INTERFACE_N3 on HZ_DQM_SYNC_INTERFACE ( PARTY_ID )
PCTFREE 10 INITRANS 4 MAXTRANS 255 TABLESPACE ARX STORAGE ( INITIAL 4K
NEXT 256K MINEXTENTS 1 MAXEXTENTS 60 PCTINCREASE 0 ) COMPUTE STATISTICS

AD Worker error:
The following ORACLE error:

ORA-01630: max # extents (60) reached in temp segment in tablespace ARX

Resolution:

Update /dhyp2i/applmgr/1158/ar/11.5.0/patch/115/sql/ b3059755.sql,
maxextents for HZ_DQM_SYNC_INTERFACE_N3 and for HZ_DQM_SYNC_INTERFACE_N4

Change maxextents to 500    from 50.
Make a backup of file b3059755.sql
Vi the file and change the value of MAXEXTENTS from 50 to 500.
 
Restart worker


Issue:

Failed on poorgdef.sql

Resolution:

Restart worker


Issue:

Worker failed
FAILED: file cskbmi7.sql  on worker  4.
 
sqlplus -s APPS/***** @/sid/applmgr/1158/cs/11.5.0/patch/115/sql/ cskbmi7.sql
DECLARE
*
ERROR at line 1:
ORA-29881: failed to validate indextype
ORA-06512: at line 64

Resolution:

sqlplus apps/<appspwd>
drop index cs.CS_KB_SETS_TL_N3;
drop index cs.CS_KB_SETS_TL_N5;
@$CS_TOP/patch/115/sql/ cskbctxp.sql apps cs ctxsys      (-> apps username, cs username, ctxsys username)
@$CS_TOP/patch/115/sql/ cskbctxc.sql cs <cspwd> APPS   (-> cs username, cs password, apps username)
Restarted worker


Issue:

11.5.9 MP completed with following error:
AutoPatch error:
ORA-01403: no data found
ORA-06512: at “APPS.AD_VERSION_UTIL”, line 245
ORA-06512: at “APPS.AD_VERSION_UTIL”, line 279
ORA-06512: at “APPS.AD_VERSION_UTIL”, line 347
ORA-06512: at line 1
 
Error in adphistUpdatePatchLevel(CLN, A)
 
AutoPatch error: Error calling adphistUpdateRlseAndPatchLvl().

Resolution:

Apply Patch 2644311
 
Make sure that following files are removed before applying patch 2644311:
 
$APPL_TOP/admin/$TWO_TASK/ applprod.tmp
$APPL_TOP/admin/$TWO_TASK/ applUS.tmp
 
Verification after running 2644311:
select fa.APPLICATION_ID, fp.STATUS, fa.APPLICATION_SHORT_NAME asn
from fnd_product_installations fp, fnd_application fa
where fa.APPLICATION_ID=fp.APPLICATION_ID and fa.APPLICATION_SHORT_NAME in (‘JTF’,’IBC’,’IBE’,’OKL’ ,’AMF’,’BNE’,’CSM’,’DDD’,’DOM’,’EGO’,’PJI’,’PON’,’QOT’,’QRM’,
‘CLN’,’EDR’,’PRP’,’XNB’,’ZFA’,’ZSA’);
 
Should give 20 rows


Issue:

FAILED: file XLIFFImporter.class on worker  1.
FAILED: file XLIFFImporter.class on worker  2.
FAILED: file XLIFFImporter.class on worker  3.
FAILED: file XLIFFImporter.class on worker  4.
FAILED: file XLIFFImporter.class on worker  5.
FAILED: file XLIFFImporter.class on worker  6.
 
Checked the  worker logs
adwork01.log
===============
adjava -mx256m -nojit oracle.jrad.tools.trans.imp.XLIFFImporter
&fullpath:prp:mds/component/webui/ESA:
ComponentCreateTrainButtonBarRN.xlf  -username &un_apps
-password &pw_apps -dbconnection &jdbc_db_addr
 
 
Reading language information from applUS.txt …
  Temporarily resetting CLASSPATH to:
  “/PNATUI/applmgr/1158/ad/11.5.0/java/adjri.zip:/PNATUI/applmgr/common/util
/jre/1.1.8/lib/rt.jar:/PNATUI/applmgr/common/util/jre/1.1.8/lib/i18n.jar:/PNATUI/
applmgr/common/java/appsborg.zip:/PNATUI/product/806/forms60/java:/PNATUI/
applmgr/common/java”
 
  Calling /PNATUI/applmgr/common/util/jre/1.1.8/bin/jre …
Could not import translations in repository  : “/oracle/apps/prp/component/webui/
ComponentCreateTrainButtonBarRN” not found in repository.

Resolution:

After patch completes, verify the failed imports
grep XLIFF adwork*log | sort | uniq | wc -l
Put all the failed imports in a shell script (xliff_imports )and run it
run $HOME/xliff_imports to complete the imports
 
Steps to create the shell script :forvRunning XLIFFImport jobs “manually”
 
grep XLIFF adwork*log > ~/xliff_imports_ja
cd
vi xliff_imports_ja
:%s/adwork..\.log://
:wq
mv xliff_imports_ja xliff_imports_ja_2
grep “^adjava” xliff_imports_ja_2 > xliff_imports_ja
vi xliff_imports_ja
:%s/&un_apps/apps/
:%s/&pw_apps/apps_password/
:%s/&jdbc_db_addr/”(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)
(HOST=auohsnatu01)(PORT=10010))(CONNECT_DATA=(SID=PNATUI)))”
:%s!&fullpath:!$APPL_TOP/!
:%s!:!/11.5.0/!
:%s!:!/!
:wq
chmod 755 xliff_imports_ja
./xliff_imports_ja 2>&1 | tee xliff_imports_ja.log
note: lines starting with “:” are commands for the vi editor.


Issue:

Start of adlibout session
Date/time is  Wed Mar 24 04:42:55 PST 2004
Log file is  /wnappi/applmgr/1156/admin/WNAPPI/log/adlibout.log
Command line arguments are
“filelist=/wnappi/applmgr/1156/admin/WNAPPI/out/ paoapp00.txt”
 adlibout: PLATFORM environment variable not set.
End of adlibout session
Date/time is  Wed Mar 24 04:42:55 PST 2004
**********************************************************
An error occurred while extracting files from library.
Continue as if it were successful [No] :

Resolution:

Source the environment file.
Restart the patch.


Issue:

invimro2.sql (Database portion)
 
ALTER table MTL_ITEM_REVISIONS rename to MTL_ITEM_REVISIONS_B
AD Worker error:
The following ORACLE error:
ORA-26563: renaming this table is not allowed
occurred while executing the SQL statement:
ALTER table MTL_ITEM_REVISIONS rename to MTL_ITEM_REVISIONS_B
Error occurred in file
/wnappi/applmgr/1156/inv/11.5.0/patch/115/sql/ invimro2.sql
with arguments ‘&un_inv &pw_inv &un_apps &pw_apps’.

Resolution:

Drop snapshot log
Recreate Snapshot log using:-
Create snapshot log on inv.mtl_item_revisions tablespace invd storage
(initial 100m next 50m maxextents unlimited pctincrease 0) with rowid,
(inventory_item_id, organization_id)
Restart Failed worker.


Issue:

adexpath(); Unable to get txk_jdbc_zip from Env.

Resolution:

Per note 253920.1 made manual adjustment to
$FND_TOP/admin/template/ adjborg2.txt
and reran adconfig.sh.  Apply 2902755 as prereq to 11.5.9 MP as
permanent solution


Issue:

FAILED: file ECXOXTAS.pls on worker  3 for product ecx username ECX.
ORA-04021: timeout occurred while waiting to lock object APPS.ECX_OXTA_PKG

Resolution:

conn apps/xxxxxx
Connected.
SQL> exec dbms_aqadm.stop_queue (‘ECX_OUTBOUND’);   
PL/SQL procedure successfully completed.
 
After the maintenance pack, we need to run the following….
   
exec dbms_aqadm.start_queue (‘ECX_OUTBOUND’);


Issue:

failed @13k Jobs
 
 
   Uploading FND_PROFILE_OPTION_VALUES 10001 ** Site **
    Error occured for FND_PROFILE_OPTION_VALUES key name LEVEL_VALUE_APP
with value  and parent key   value ICX_DEFAULT_EUL
    A database error occurred:
    ORA-01422: exact fetch returns more than requested number of rows
    ORA-06512: at line 66

Resolution:

Run the following SQL statement login as apps user
select * from FND_PROFILE_OPTION_VALUES
where PROFILE_OPTION_ID = 3568
and APPLICATION_ID = 178
and LEVEL_ID = 10001
and LEVEL_VALUE = 0;
   
2.This statment will return 2 rows.
3.Delete one row with the following sql command
   
delete FND_PROFILE_OPTION_VALUES where profile_option_id = 3568
and level_value_application_id is null;


Issue:

asocruls.sql

Resolution:

Modify asocruls.sql
From:
create index &&3..AQ$_ASO_ORDER_FTH_TEMP ON
&&3..AQ$_ASO_ORDER_FEEDBACK_T_H (subscriber#)
nologging parallel pctfree 0;
To:
create index &&3..AQ$_ASO_ORDER_FTH_TEMP ON
&&3..AQ$_ASO_ORDER_FEEDBACK_T_H (subscriber#)
storage ( maxextents unlimited)
nologging parallel pctfree 0;


Issue:

cevw.odf has been running for the last 3.5 hrs

Resolution:

At around 43k jobs, verify that these two view are valid, otherwise compile them…
SQL> alter view apps.CE_222_REVERSAL_V  compile;
View altered.
SQL> alter view apps.CE_REVERSAL_TRANSACTIONS_V compile;
View altered.
SQL>


Issue:

adjava -mx128m -nojit oracle.apps.ad.jri.adjcopy @/dte
rji/applmgr/1158/admin/DTERJI/out/ apps.cmd
AutoPatch error:
ERROR Updating the master archive.
AutoPatch error:
Error updating master archive
An error occurred while Updating Oracle Applications Java files.
Continue as if it were successful [No] :

Resolution:

Modified the ADJREOPTS to 512 in $APPL_TOP/admin/adovars.env & $APPL_TOP/admin/
<SID>_hostanme.xml.
Restarted the patch.


Issue:

FAILED: file pat351.odf   on worker  1.
FAILED: file pat254.odf   on worker  5.

Resolution:

The indexes are supposed to be owned by PA and not APPS, as found above.
Dropped these indexes. Restarted the failed workers
OWNER        INDEX_NAME    
———— ——————————–                       
APPS         PA_TASKS_N11  
APPS         PA_PROJECTS_N10
APPS         PA_TASKS_N12  
APPS         PA_PROJECTS_N8
APPS         PA_TASKS_N13  
APPS         PA_PROJECTS_N9


Issue:

Failure when running wsmcrind.sql:

Resolution:

vi $WSM_TOP/patch/115/sql/ wsmcrind.sql
Change from (maxextents changed from 50 to 200):
CREATE INDEX WIP_ENTITIES_N_TMP
                    ON WIP_ENTITIES ( GEN_OBJECT_ID )
    STORAGE (INITIAL 4K NEXT 100K MINEXTENTS 1 MAXEXTENTS 50 PCTINCREASE 0 FREELISTS 4)
To:
CREATE INDEX WIP_ENTITIES_N_TMP
                    ON WIP_ENTITIES ( GEN_OBJECT_ID )
    STORAGE (INITIAL 4K NEXT 100K MINEXTENTS 1 MAXEXTENTS 200 PCTINCREASE 0 FREELISTS 4)
Restart worker


Issue:

Failure when running wsmcrind.sql:

Resolution:

vi $WSM_TOP/patch/115/sql/ wsmcrind.sql
Change from (maxextents changed from 50 to 200):
CREATE INDEX WIP_ENTITIES_N_TMP
ON WIP_ENTITIES ( GEN_OBJECT_ID )
STORAGE (INITIAL 4K NEXT 100K MINEXTENTS 1 MAXEXTENTS 50 PCTINCREASE 0 FREELISTS 4)
To:
CREATE INDEX WIP_ENTITIES_N_TMP
ON WIP_ENTITIES ( GEN_OBJECT_ID )
STORAGE (INITIAL 4K NEXT 100K MINEXTENTS 1 MAXEXTENTS 200 PCTINCREASE 0 FREELISTS 4)
Restart worker

Read Full Post | Make a Comment ( 1 so far )

Learnings (Issues faced) during Oracle Apps R12 Installation

Posted on April 16, 2007. Filed under: R12 |

Following are the issues which were faced during Oracle Apps R12 installation on Windows.

1. DVD Staging Error

We proceeded with the installation with 75% of staging but RapidInstaller has intelligence built in to verify the complete staging before starting installation. Installation errored out at this stage. Only option is to stage all the DVD’s before starting installation. 🙂

DVD Error

2. Invalid Microsoft VC location

Visual Studio directory value shouldnt be set including the bin directory, if set will result in cl.exe is not available error.

VC directory with bin value

cl.exe not available error window

VC and cl

3. Missing Host Entries

Post install checks failed due to missing host entries. The primary reason being the server was not registered with the DNS and rapidinstall couldnt resolve the hostname with the IP address. Made entry in C:\windows\system32\drivers\etc\hosts and restarted OPMN service which didnt start due to missing registry entry. Check this link for more information.

Missing Host Entry

Missing Host Entry2

Missing Host Entry3

After making entries in host file and starting OPMN serivce all post install checks went through sucessfully.

Post Install checks

cheers,
OraclePitStop.

Read Full Post | Make a Comment ( 4 so far )

Post R12 Installation Problem and Solutions on Windows

Posted on April 15, 2007. Filed under: R12 |

Post installation of R12, I was able to launch the url, logged in sucessfully as SYSADMIN user and even J2SE 5.0 (alternate for Jinitiator) installed on my laptop perfectly fine upon clicking System Administrator responsibility. But forms got errored out with FRM-92101.

FRM92101

As you know FRM-92101 is one of the vague error you could ever encounter in Oracle Apps which requires some amount of digging to understand/identify the base issue. I tried implementing Windowstraditional first aid medicine, yes, Restarting the server. After the box came up i realised not only Forms is a problem i also have below issues:

1. Concurrent Manager wont startup.2. OPMN Service doesnt get started from Control Panesl -> Services window, but able to start from command prompt using adopmnctl.cmd script. The problem is missing ORACLE HOME entry in the registry.

>>>adopmnctl.cmd start
Thu 03/22/2007 06:13 AM
Starting Oracle Process Manager (OPMN) …
Registry does not contain value SOFTWARE\ORACLE\KEY_APPS_JAVA_HOME\ORACLE_HOMEopmnctl: opmn started
exiting with status 0
ERRORCODE = 0 ERRORCODE_END
So on the whole i had three issues to deal with – FRM92101, CM and OPMN missing registry entry.

After some research came across something called as “Desktop Heap” in windows. Desktop Heap is a memory portion in windows which is primarily used by GUI applications to render the GUI. The trick to resolve the FRM-92101 issue and the Concurrent manager startup issue is to enable these services to use the Desktop Heap while starting and maintaing the services. I seriously dont understand as to why Oracle Applications Background services has to use Desktop Heap which is meant only for GUI applications. The problem here is (which i feel) Oracle Development doesnt have much data/clue as to how Microsoft OS is being designed and what type of applications will use which type of memory.

How to enable services to use Desktop Heap

Control Panel -> Services (or Start -> Run -> services.msc) -> Right Click “Service Name” eg: Oracle Process Manager” -> Click Log On Tab -> Check “Allow Services to interact with Desktop”.

Enabling desktop heap and restarting the server helped in resolving two issues.

1. Concurrent Manager came up without any issues.
2. Actual error for FRM-92101 had been identified.

Missing mesg directory

This convinced me a little for enabling Desktop Heap for OPMN (Forms Service) which helped in rendering the actual GUI popup error message but still not for CM service.

FRM-92101 error was due to missing mesg directory under 10.1.2 ORACLE HOME/forms directory. It was looking for fmcus.msb under mesg directory whereas mesg directory itself was missing. But the best part is all the 128 .msb files were available under forms directory instead of under mesg directory.

I manually created the mesg directory and copied all .msb files and bounced the service. Voila, now iam able to access forms without any issues.

This leaves me with one more issue to handle, ie., OPMN service doesnt get started from Control Panel -> Services.

As the error stated, ORACLE HOME entry was missing in Registry under OPMN settings. Manually made the entry in registry and bounced the services.

Now all my issues stands resolved :-).

Later i tried disabling Desktop Heap usage for OPMN (Forms Service) and Concurrent Manager. OPMN (Forms) behaved as normal whereas CM didnt.

If you had encountered any kind of issue post fresh installation of Oracle Apps R12 (On Windows or anyother OS) feel free to put in a comment with that. This will help us in maintaining one single page with all possible Post R12 Installation issues and solutions.

Take Care.

cheers,
OralcePitStop

Read Full Post | Make a Comment ( 16 so far )

Multi-Instance Appl Top Sharing

Posted on April 14, 2007. Filed under: Configuration |

You would have heard about Shared Appl Top concept and even implemented it. Iam not going to explain or talk about in detail as to what shared appltop is or how to implement it, rather iam going talk about a new environment which I had come across recently.

Oracle’s description of Shared Appltop – “Single Instance running on multiple nodes sharing single appltop”.

But have you heard about multiple instances (4 to be precise) running on single node sharing one appltop. Yeah you heard me right.Infact even 806 and iAS techstack components are also shared by the 4 instances and this setup had been performed way back in 2004 when Shared Appltop itself was not that popular and sharing of 806 and iAS was no-where in the picture during those days. To top it all this configuration is performed in !!! WINDOWS !!! yes windows.The system availability is 99.99%, can you believe that.

The architecture is like this,

4 databases (2 nodes with 2 instances each viz., DBServerA with Instance1 and Instance2 and DBServerB with Instance3 and Instance4) configured with 6 mid tiers. Each of mid tiers has a local copy of appl top, 806 and iAS and all the 4 instances are configured on each mid tier to share a single APPL TOP and techStack. Doesn’t it sound a little complicated, yes it is but its interesting.

I happened to work on this environment recently and it’s really a new learning experience to have such architecture that too on Windows.

Lemme know if you need more information on this configuration.

Cheers,
OraclePitStop.

Read Full Post | Make a Comment ( 2 so far )

Step by Step Installation of Oracle Apps R12 on Windows

Posted on April 14, 2007. Filed under: R12 |

This blog is being written on the personal experience of installing Oracle Apps R12 Vision Demo Instance on a Windows 2003 server. All comments posted are my own.

Pre-Requisites

1. Microsoft Visual Studio 2005

Install Visual C++ 8.0 included in the Microsoft Visual Studio 2005.

2. MKS Toolkit

Version 9 or higher. Use any of the Developer series (for Developers, for Professional Developers, or for Enterprise Developers). Obtain this software from the MKS Web site at: http://www.mks.com

Note: While MKS Toolkit is recommended, Cygwin can be used in its place. See Using Cygwin to Maintain Oracle E-Business Suite Release 12 on Windows on OracleMetaLink (Doc ID: 414992.1) for information.

3. GNU Make (Shareware)

Version 3.81 is required. Download and unzip patch 5897842. This patch contains the GNU Make source files and the pre-built executable file, gnumake.exe.
Copy gnumake.exe (located in make-3.81/WinRel/) to the UNIX Toolkit installation directory, for example, C:\MKS90\mksnt.

Note: Installation of GNU Make is not required when using Cygwin. The GNU Make comes as a part of the Cygwin distribution

4. Microsoft Visual C++ 2005 Redistributable Package (x86)

If you have a multi-node Oracle Applications system and do not have Microsoft Visual Studio 2005 on the node hosting the database tier, the Microsoft Visual C++ 2005 Redistributable Package is required.

The Microsoft Visual C++ 2005 Redistributable Package (x86) is available from the Microsoft Web site. Download and install the package on the database tier node. Review the information at:

Note: The Visual C++ 2005 Redistributable Package is not needed if you are using the full version of Microsoft Visual Studio 2005 on the database tier node.

5. Download Active Perl

The perl version shipped by MKS is not certified: instead, use ActivePerl, which you can also download from http://www.activeperl.com/.

Click Join – Top right corner
Click Downloads – All downloads
Click ActivePerl
Click Free Download
Click Download

For contact details (optional) Click Continue

Click MSI under Windows x86 or Windows 64-bit based on the processor.

Pre-req Installation Points

Pre-requisite softwares should not be installed on following locations

1)C:\Program Files directory or system directory
2)Desired APPL_TOP directory
3)Any directory which has a space viz., C:\
4)Directory name should not contain spaces viz., C:\MSVC 2005 and should be like C:\MSVC2005.

Steps to be performed before installing any new software on the server.

Obtain Screenshots/details of the following and update it in the instance specific installation document. This will help in determining new processes, new registry entries etc.

1)Task Manager Process – select all user processess (Start -> Run -> Taskmgr -> Maximise Window -> Click Process Tab)
2)Export Registry Settings (Start -> Run -> regedit -> File -> Export)
3)Services (Start -> Run -> services.msc -> click Status column Heading to sort based on services started -> Click Export List – this option will also export the descriptions, hence click on View -> Add/Remove Columns -> Click Description -> Remove -> Click ok. After Exporting, Click View -> Add/Remove Columns -> Click Description -> Add -> Click ok)
4)Environment Variables (Start -> Run -> cmd -> type set)
5)Record PATH Environment Variable Value (Start -> Run -> explorer -> Right Click on My computer -> Properties -> Advanced -> Environment Variables -> Under System Variables -> Double Click Path -> Copy the value)

To get ScreenShots

Click Print Screen Button [Prnt Scrn] -> Start -> Run -> MsPaint -> Control + V

Windows Shortcuts

To Launch Run -> WindowsKey + R
To Launch Explorer -> WindowsKey + E

Set TMP Environment Variable

Rapid Install uses the temporary directory defined by TMP environment variable and this directory should have a minimum of 500MB free space.

Preferred location: C:\TEMP

Start -> Run -> explorer -> Right Click on My computer -> Properties -> Advanced -> Environment Variables -> Scroll for TMP Variable

Operating System User

The user who runs Rapid Install owns the file system for all components (both the database file system and the Oracle Applications file system).

Before you install Oracle Applications, make sure the user account for the installation has full local administrative privileges, and permission to print to either local or network printers. It’s recommended to create a new domain-level account (for example, oracle) and make it a member of these groups:

• Administrators (local user)
• Domain Users (domain user)

This account does not need to be a member of any other group, and must not be a member of the GUEST group. Refer to Windows Help for information on creating accounts and assigning accounts to groups.

Space Requirements

Node Size
Applications node file system (includes AS 10.1.2 ORACLE_HOME, AS 10.1.3
ORACLE_HOME, COMMON_TOP,APPL_TOP, and INST_TOP)
28 GB
Database node file system (Fresh install) 45 GB
Database node file system (Vision Demo database) 133 GB

The total space required for a standard system, not including the stage area, is 73 GB for a fresh install with a production database, and 161 GB for a fresh install with a Vision Demo database.

Note: The database node disk space requirements for both the production database and the Vision Demo database include database (.dbf) and the 10g R2 database ORACLE_HOME.

Installing Pre-reqs


Install MS Visual Studio 2005 (this satisfies MS VC++ 8.0 requirement too)
Install CYGWIN – Refer Metalink Note: 414992.1
Include cygwin\bin in system path.
Install ActivePerl

Before executing RapidInstall refer Metalink Note: 402311.1 for latest updates.

Staging

Staging the CD’s require atleast 30GB of free space.
Make sure Perl (ActivePerl) location is available in the path – this perl will be used to stage the CD’s.

Post Installation

Apply database Patch 13 (5735481).
Applying Application Server Patch 5689224 & Patch 4742501.

Installation Procedure

Change directory to the Stage location (startCD -> rapidwiz)
Enter command rapidwiz.cmd

Screen 1

Screen 2

Screen 3

Screen 4

First time installation, select “Create a new configuration”.

Restarting an installation or installing on additional mid tier, use the configuration file created under base directory eg., E:\\inst\apps\_\conf_.txt

Screen 5

Screen 6

Screen 7

Screen 8

Screen 9

Screen 10


Note:

UNIX Toolkit Directory value to be set with bin directory eg: C:\Cygwin\bin
Visual Studio Directory value to be set only upto VC eg: C:\MSVS8\VC

Service Group Description/Supports
Root Service Group Oracle Process Manager (OPMN)
Web Entry Point Services HTTP Server
Web Application Services OACORE OC4J
Forms OC4J
OAFM OC4J
Batch Processing Services Applications TNS Listener
Concurrent Managers
Fulfillment Server
Other Service Group Oracle Forms Services
Oracle MWA Service

Screen 11

Screen 12

Screen 13

To add additional nodes/servers, click on Add Server and provide the details.

Port Verification

Screen 14

Screen 15

Make sure all the categories has a tick mark before clicking on Next button.

Screen 17

DVD’s Staging Verification

Screen 18

Installation Screens

Screen 19

Screen 20

Screen 21

Screen 22

Click on Connect to Oracle Applications Release 12 to launch the login screen. Voila !!!

Screen 23 Login Screen

All the best for your installation [if you are trying one ;-)].

Take care,

OraclePitStop

Technology Blogs - Blog Top Sites

Read Full Post | Make a Comment ( 34 so far )

Liked it here?
Why not try sites on the blogroll...