What is Oracle Database Lite 10g

Last updated on September 15th, 2016 at 05:30 amOracle Database Lite 10g extends the power of grid computing to a mobile workforce with a complete, integrated, secure database for building, deploying, and managing mobile applications for a broad range of mobile devices. Oracle Database Lite 10g enables persistent access to critical information and applications without requiring continuous connectivity to back-end enterprise systems. As a result, … Continue reading What is Oracle Database Lite 10g »

Output post Processor(OPP)

Last updated on April 14th, 2017 at 03:25 pmThe Output Post Processor (OPP) is an enhancement to Concurrent Processing and is designed to support XML Publisher as post-processing action for concurrent requests. If a request is submitted with an XML Publisher template specified as a layout for the concurrent request output, then after the concurrent manager finishes running the concurrent program, it will contact the … Continue reading Output post Processor(OPP) »

Oracle DBA: Hanganalyze and system state dump

Last updated on August 31st, 2016 at 01:11 pmMany times Oracle database get hangs due to locks or latching issue and Nobody can login to the system. It becomes critical and  And Usually we do shutdown abort to immediately resolve the issue. But  it is good to take system state dump/hanganalyze  at 1 min interval to analyze the locking or latching  issue afterwards before doing … Continue reading Oracle DBA: Hanganalyze and system state dump »

how to perform relink in Oracle

Last updated on August 31st, 2016 at 01:30 pmSometimes Oracle components may start giving strange issues like coredump  or the Operating system is patched, In these cases it is always recommended to try oracle relink to resolve the issues.A Oracle relink is also necessary whenever you install a new release or a patchset or when there is a patch or upgrade to the OS environment. Oracle … Continue reading how to perform relink in Oracle »

Oracle DBA: How to schedule jobs in Oracle Database

Last updated on August 31st, 2016 at 05:09 pmWe often wants to run pre-defined jobs at different schedule. Oracle database provides dba_jobs/dbms_scheduler (Oracle Database job scheduler) for the scheduling of pre-defined jobs. Information about DBA_JOBS ( Till 9i) Query to see the jobs running through dba_jobs select /*+ rule */ * from dba_jobs_running; or select /*+ ordered */ * from dba_jobs_running; Common Reason why jobs don’t execute … Continue reading Oracle DBA: How to schedule jobs in Oracle Database »

Core file for oracle concurrent manager

Last updated on August 25th, 2016 at 04:01 amOracle concurrent managers consists of many executable and we often faced various issues with it.When an executable ends with a segmentation fault or signal 11, a core file for oracle concurrent manager  should be created. If you are not finding that a core file is created, then the ulimit may be set to 0 for core files … Continue reading Core file for oracle concurrent manager »

Concurrent Manager troubleshooting part 1

Last updated on November 23rd, 2015 at 03:40 pmConcurrent Manager troubleshooting part 1 If a PL/SQL Concurrent Program can’t write to an external file, you will receive an error message similar to: MSG-00102: Error Message :ORA-20100: File o0000071.tmp creation for FND_FILE failed. You will find more information on the cause of the error in request log. ORA-06512: at “APPS.FND_FILE”, line 378 ORA-06512: at “APPS.FND_FILE”, line … Continue reading Concurrent Manager troubleshooting part 1 »

11g Alert log new features

Last updated on November 28th, 2015 at 11:58 am11g Alert log new features Beginning with Release 11g of Oracle Database, the alert log is written as both an XML-formatted file and as a text file, as in earlier releases.Both these log files are stored inside the ADR home.The ADR root directory is known as ADR BASE.The Automatic Diagnostic Repository (ADR) is a directory structure that … Continue reading 11g Alert log new features »

How to Clone Application Server

Last updated on September 15th, 2016 at 05:40 amHere are the steps outlined  to How to Clone Application Server Given  source machine is SUN1 and target machine is SUN2. Prepare steps 1) On the source and target ensure that the PERL5LIB variable is set. 2) $ export PERL5LIB=$ORACLE_HOME/perl/lib/5.6.1:$ORACLE_HOME/perl/lib/site_perl/5.6.1 3) cd $ORACLE_HOME/clone/bin 4) ./prepare_clone.pl ORACLE_HOME=$ORACLE_HOME Create tar file and copy to target system 5) Create a … Continue reading How to Clone Application Server »

How to recreate redo log files

Last updated on September 15th, 2016 at 05:30 amWe often get situation where we need to increase the size of the redo log files as log switches are very frequent.Increasing the redo log files sizes decreases the log switches and  improves the performance of the database.There is no resize command for redo log files, it has to be recreated inorder to increase or decrease the … Continue reading How to recreate redo log files »

Oracle apps: R12 start and stop scripts

Last updated on November 23rd, 2015 at 03:41 pmR12 start and stop scripts $ADMIN_SCRIPTS_HOME ($INST_TOP/admin/scripts) adstpall.sh – stop all services adstrtal.sh – start all services adapcctl.s – start/stop/status Apache adformsctl.sh – start/stop/status OC4J Forms adoacorectl.sh – start/stop/status OC4J oacore adoafmctl.sh – start/stop/status OC4J oafm adopmnctl.sh – start/stop/status opmn adalnctl.sh – start/stop RPC listeners (FNDFS/FNDSM) adcmctl.sh – start/stop Concurrent Manager jtffmctl.sh – start/stop Fulfillment Server adformsrvctl.sh … Continue reading Oracle apps: R12 start and stop scripts »

Top 5 ASM queries every DBA should know

Last updated on August 24th, 2016 at 06:48 pmASM is being used as storage environment in various organization.Here are Top 5 ASM queries every DBA  should know QUERY TO FIND THE FILES IN USE BY AN ASM INSTANCE col full_path format a50 col full_alias_path format a50 SELECT concat(‘+’||gname, sys_connect_by_path(aname, ‘/’)) full_alias_path FROM (SELECT g.name gname, a.parent_index pindex, a.name aname, a.reference_index rindex FROM v$asm_alias a, v$asm_diskgroup g … Continue reading Top 5 ASM queries every DBA should know »