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 MoreSCHEMA 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 MoreRESTORE 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 Moreselect 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 MoreSELECT 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 MoreADOP: 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 Moreissue “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 MoreRC-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 MoreCheck 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 MoreIssue: 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