Friday 4th of April 2025 03:25:40 AM

home

R12 Docs
patching procedures
sysadmin guide config
R12 Developers Guide

 

oracle R12.1.1 Install upgrade 12.1.3 concurrent managers

 

workflow concurrent program

CustomStepbyStep

GL

 Forms Reports Builder
Oas10g x11error register table glQuerys generate jsp
patching subdir&filetypes appsDDLpkg plsql notes relink forms
UPdateMimeTypes glbatch concSub Apps pl/sql dev autoconfig
fnd_global ICX session timeout R12clone java patching

 

find fnd_userid 

 
$INST_TOP use local disk - not nfs -possible issues storing log files on shared resources.
$LOG_HOME /u02/oracle/PROD/inst/apps/PROD_r410/logs
$ORA_CONFIG_HOME /u01/oracle/VIS/apps/apps_st/appl.
$APPL_CONFIG_HOME  
$OA_HTML html
$ADMIN_SCRIPTS_HOME

Location of startup scripts adstpall.sh adstrtal.sh Under $INST_TOP

/u02/oracle/VIS/inst/apps/VIS_r410/admin/scripts
$APPL_TOP/admin/TEST/log adadmin logs
$APPL_TOP/admin/<SID>/log ADPatch logs:
$APPLCSF /u02/oracle/PROD/inst/apps/PROD_r410//logs/appl/conc
$APPLCSF/log /u02/oracle/PROD/inst/apps/PROD_r410/logs/appl/conc/log

 

java

check java

$ADJVAPRG -version
echo $CLASSPATH
$AFJVAPRG -version
echo $AF_CLASSPATH

 

$ADMIN_SCRIPTS_HOME

adcmctl.sh start / stop the concurrent managers  
     
adstpall.sh stop all the apps processes adstpall.sh <user>/<pass>  
adstrtal.sh start all the apps processes adstrtal.sh <user>/<pass>  
     
adformsctl.sh start, stop and check the status of the forms oc4j instance  
adapcctl.sh start, stop and check the status of Oracle HTTP Server a wrapper on top of the opmnctl script

 

Find user_id for an apps username

SELECT user_id
FROM FND_USER
WHERE user_name = 'JOURNAL_IMPORT';

Find application ID

SELECT application_id
FROM FND_APPLICATION
WHERE application_short_name = 'SQLGL';

Find Responsibility ID

SELECT responsibility_id
  FROM FND_APPLICATION fa,FND_RESPONSIBILITY_TL fr
  WHERE fa.application_short_name = 'SQLGL'
  AND fa.application_id = fr.application_id 
  AND fr.responsibility_name = 'General Ledger Controller';

Run AutoConfig on the instance by running the command:

apps tier
$ADMIN_SCRIPTS_HOME/adautocfg.sh

db tier

sh <RDBMS_ORACLE_HOME>/appsutil/scripts/<CONTEXT_NAME>/adautocfg.sh

 

 

update mime types - this is a note for my reference only, 
please don't try it yourself. Open an SR if you think you may need to do this. 


1. Take a backup copy of fnd_mime_types_tl
2. Run the following statement select statement and confirmed that record similar as shown in Insert statement is not available in select * from fnd_mime_types_vl and then run insert statement and do commit;
select * from fnd_mime_types_vl
INSERT INTO fnd_mime_types_tl
   (file_format_code, mime_type, LANGUAGE, source_lang, created_by
   , creation_date, last_updated_by, last_update_date
   , last_update_login, description, allow_client_encoding)
   VALUES ('XLS', 'application/vnd.ms-excel', 'US', 'US', 1
   , SYSDATE, 1, SYSDATE
   , 0, 'Microsoft Excel', 'Y');
commit;
3. Ensure Profile Option 'Viewer: Text' is set to Browser

 

Apps DDL

APP-FND-01564: Oracle error 1 in CREATE_EVENT_DB_TRIGGER

when saving a new custom Event Alert.

This problem occurs because the APPS_DDL and APPS_ARRAY_DDL packages need to be compiled or recreated in the schema that owns the base table

1. To check current status of packages, run for defined schemas:

SELECT owner
      , object_name
      , object_type
      , status
FROM dba_objects 
WHERE object_name like 'APPS%DDL%' 
AND owner in ('APPLSYS','APPS','<schema name>');

 

adaddls.pls (grant CREATE PROCEDURE;

create APPS_DDL spec)
adaaddls.pls (create APPS_ARRAY_DDL spec)
adaddlb.pls (create APPS_DDL body)
adaaddlb.pls (create APPS_ARRAY_DDL body; revoke CREATE PROCEDURE; recompile APPS_DDL and APPS_ARRAY_DDL)

12.0.0]$ find . -name adaddls.pls -print
./patch/115/sql/adaddls.pls
12.0.0]$ find . -name adaaddls.pls -print
./patch/115/sql/adaaddls.pls
./admin/sql/adaaddls.pls
12.0.0]$ find . -name adaddlb.pls -print
./patch/115/sql/adaddlb.pls
12.0.0]$ find . -name adaaddlb.pls
./patch/115/sql/adaaddlb.pls
./admin/sql/adaaddlb.pls

 

 

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

 

Requirement: How do I run a unified driver patch on a multi-node system?
 
 

options=hotpatch

Added note: Fri September 12, 2014 7:39 PM