Yearly Archives: 2020

Oracle Cloud Infrastructure Announces Second Data Center Region in Japan

Oracle has announced that it’s possible to create a new cloud zone in Osaka, Japan. The domain’s name is ap-Osaka-1. The zone key is KIX, and this area contains availability…

Read More

Schema Refresh

SCHEMA REFRESH In this Post , Let us discuss the steps involved during schema refresh using datapump. Prerequisite to check on Before Export on SOURCE SIDE 1. Check the Schema…

Read More

RESTORE USING RMAN TO CREATE ORACLE 12C DATABASE ON SCRATCH SERVER

RESTORE USING RMAN TO CREATE ORACLE 12C DATABASE ON SCRATCH SERVER Overview Following is the scenario, All the hard drives of the production server have been damaged and we have…

Read More

Find Concurrent Manager status from Backend

select decode(CONCURRENT_QUEUE_NAME, ‘FNDICM’,’Internal Manager’, ‘FNDCRM’,’Conflict Resolution Manager’, ‘AMSDMIN’,’Marketing Data Mining Manager’, ‘C_AQCT_SVC’,’C AQCART Service’, ‘FFTM’,’FastFormula Transaction Manager’, ‘FNDCPOPP’,’Output Post Processor’, ‘FNDSCH’,’Scheduler/Prereleaser Manager’, ‘FNDSM_AQHERP’,’Service Manager: AQHERP’, ‘FTE_TXN_MANAGER’,’Transportation Manager’, ‘IEU_SH_CS’,’Session History Cleanup’,…

Read More

To check scheduled concurrent request in R12

SELECT cr.request_id, DECODE (cp.user_concurrent_program_name, ‘Report Set’, ‘Report Set:’ || cr.description, cp.user_concurrent_program_name ) NAME, argument_text, cr.resubmit_interval, NVL2 (cr.resubmit_interval, ‘PERIODICALLY’, NVL2 (cr.release_class_id, ‘ON SPECIFIC DAYS’, ‘ONCE’) ) schedule_type, DECODE (NVL2 (cr.resubmit_interval, ‘PERIODICALLY’,…

Read More

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…

Read More

ORA-01804: failure to initialize timezone information – issue while running AutoConfig during Upgrade Oracle Apps (EBS) to 12.2 ?

issue “ORA-01804: failure to initialize timezone information” in Post Database upgrade 11.2.0.4  step while running AutoConfig. 1. Running Autoconfig on Database tier as $ORACLE_HOME>/appsutil/bin/adconfig.sh ERROR: ORA-01804: failure to initialize timezone…

Read More

RC-30007 :Error while running adpreclone on DB Tier during 12.1.3 cloning

RC-30007: Stage area /ebsdb1/ebstest/db/tech_st/11.1.0/appsutil/clone/dbts [oracle@ebstemp ~]$ cd /ebsdb1/ebstest/db/tech_st/11.1.0/appsutil/clone [oracle@ebstemp clone]$ mv dbts dbts_bkp [oracle@ebstemp clone]$ mkdir dbts Run perl adpreclone.pl dbTire

Read More

Error while starting the application after cloning 12.1.3:-

Check the application status:- [applmgr@ebstemp scripts]$./adoacorectl.sh status Check the log file From the log file below error came HTTP listener is not responding Due to missing library.  /usr/lib/libdb.so.2 Solution:– *…

Read More

R12.2 Upgrade: Rapidwiz Prerequisite Check Fails With Message: DB Version Check Has Failed. Not able to check the Database version.

Issue: Oracle E-business suite R12.2 Upgrade File System Pre-install check Failed for : ——————-ADX Database Utility Finished————— DB Version Check has failed. Not able to check the Database version. Please…

Read More