Himanshu Sinha - Oracle Apps DBA , Oracle DBA, Oracle Cloud DBA , Enterprise Architect.

Check the below tables:   select T.nls_territory from fnd_territories_vl T, v$nls_valid_values V where T.nls_territory = V.value and V.parameter = 'TERRITORY'; Should return the data if below error  Error : 1. ORA-00600: internal error code, arguments: [1350], [1], [23], [], [], [], [], [], [], [], [], [] 2. Some time you will not be able to Save data on address form in HRMS modules. It will through some CTXSYS. and some trigger issue.    Cause : The error is raised when the environment variable ORA_NLS10 is set incorrectly or pointing to a wrong location. Executing the query as APPS results to ora-00600 Solution: Create nls/data/9idata directory On the database server node, as the owner of the Oracle RDBMS file system and database instance, run the $ORACLE_HOME/nls/data/old/cr9idata.pl script to create the $ORACLE_HOME/nls/data/9idata directory. 1. cd $ORACLE_HOME/nls/data/ 2. mv 9idata 9idata_old 3. perl $ORACLE_HOME/nls/...

Cloning Principle ———————— 1. Cloning is creating replica of your source instance (prod,..) to target (test,dev..) so that patch level & data in target instance is same as source instance. 2. Overview of cloning steps 2.1 Ensure you are autoconfig enabled on both Application Tier & Database tier (This is for Rapid Clone) 2.2 Maintain snapshot is executed at least once after any patches(tech stack) or database changes(adding new tablespace) 2.3 Run Preclone on DB Tier (on Source ) 2.4 Run Preclone on Apps Tier (on Source) 2.5 Copy source instance file system to target instance 2.6 Run postclone/config on DB Tier (on Target Instance) 2.7 Run postclone/config on Apps Tier (on Target Instance) 2.8 Update Profile option (server, responsibility, user level), Printer, workflow config settings What changed in Rapid Clone from 11i to R12/12i ————————————————— 1. adpreclone.pl script in 11i is in $COMMON_TOP/admin/scripts/$CONTEXT_NAME where as same perl scri...

11gR2:Oracle Online Patching Online patching is new feature introduced in 11.1.0.6 and oracle started delivering patches with 11.2.0.2. This patch allows you to apply patch to live database i.e we do not need to shutdown database. This feature is only available for RDBMS home and can be installed/enabled using opatch. RDBMS Online Patching Aka Hot Patching [ID 761111.1] explains internals of how this patching works. I tested it while working on Database corruption issue caused by Bug 10205230 ORA-600 / corruption possible during shutdown in RAC. This bug is present in 11.2.0.2 database which causes corruption when you try to use shutdown immediate/normal/transactional option to shutdown RAC database. As per MOS note 1318986.1, Data corruption occurs around shutdown one or more of the RAC instances * One of the following ORA-600 asserts: – ORA-600 [kclchkblk_3] – ORA-600 [kclwcrs_6] – ORA-600 [ktubko_1] – ORA-600 [kcratr_scan_lostwrt] – ORA-600[3...

Issue while running adcfgclone on target database node, I can see below error messages in logfiles.. ERROR: perl adcfgclone.pl dbTechStack RC-00110: Fatal: Error occurred while relinking of ApplyDBTechStack Perl lib version (v5.8.8) doesn’t match executable version (v5.10.0) at /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/ Config.pm line 46. Compilation failed in require at /u01/oracle/product/11.2.0/appsutil/clone/ ouicli.pl line 35. BEGIN failed–compilation aborted at /u01/oracle/product/11.2.0/appsutil/clone/ ouicli.pl line 35. AutoConfig is exiting with status 1 RC-50013: Fatal: Instantiate driver did not complete successfully. /u01/oracle/product/11.2.0/appsutil/driver/ regclone.drv SOLUTION: 1. Make a backup copy of your existing Database Contextfile. 2. Modify the context file as shown. BEFORE : … <PERL5LIB oa_var=”s_perl5lib” osd=”unix”>/<complete path>/db/tech_st/11.2.0/perl/lib/5.8.3: \\ /<complete path>/db/tech_st/11.2.0/per...

Find Concurrent manager logs on Oracle Apps Concurrent Mangers log files are located in the $APPLCSF/$APPLLOG location. cd $APPLCSF/$APPLLOG For ICM Log                                       –> ls -lrt *$TWO_TASK* For Standard manager Log                  –> ls -lrt w*.mgr For Conflict Resolution manager Log –> ls -lrt c*.mgr We can also get the ICM manager logfile location with below query SELECT ‘ICM_LOG_NAME=’ || fcp.logfile_name FROM fnd_concurrent_processes fcp, fnd_concurrent_queues fcq WHERE fcp.concurrent_queue_id = fcq.concurrent_queue_id AND fcp.queue_application_id = fcq.application_id AND fcq.manager_type = ‘0’ AND fcp.process_status_code = ‘A'; Sample Output: SQL> SELECT ‘ICM_LOG_N...

ADOP – Applications DBA Online Patching Tool  ADOP: Oracle E-Business R12.2 introduced new patching mechanism that allow the application of patches while your environment is up and running which is called as Online patch. The online patching cycle consists of a number of phases: 1) Prepare – Prepare the instance for patch application. 2) Apply – Apply patches (to the patch edition). 3) Finalize – Ready the instance for cutover. 4) Cutover – Make the patch edition the new run edition. 5) Cleanup – Drop obsolete objects and data from old editions. Steps to apply patch on R12.2 using ADOP: 1) Download and unzip the patch, Before proceeding with patching activity please go through the patch radme. 2) Source the environment. $ source <run APPL_TOP path>/APPS<CONTEXT_NAME>.env 3) Check the staus of adop using below command. $ adop -status 4) Prepare the system for patching. $ adop phase=prepare 5) Apply the patch to patch edition. $ adop phase=appl...

How to apply apps patch using adpatch 11i or R12 STEP 1 : Before applying a patch you must check whether the patch is already there or not. For this we query the database: su oracle Run the environment variable db tire sqlplus apps/<apps password> SQL> select * from AD_BUGS where bug_number='<patch number>' Ex:-  SQL> select * from AD_BUGS where bug_number='********' STEP 2 : Download the patch. From your  pc and transfer it to Unix Server *login to oracle metalink.( www.metalink.oracle.com ) *Select the patches option then select the search type. *Query for patch by writing the patch no. & platform on which you want to download the patch. *Click download If you have downloaded the patch at desktop then move it to directory where you want it to unzip. With winscp or whatever software Winscp download link    http://winscp.net/eng/download.php#download STEP 3 :Unzip the patch. And set th...