Description : The cloned instance and all managers and OPP services were up and running. However users were reporting of XML reports completed in Error. Issue Log : [OPPServiceThread0] java.sql.SQLException:…
Read MoreDescription : When attempting to run a concurrent program which is accessing file “reports.log” in directory $APPLCSF/$APPLLOG then following error occurs Error: emsg:was terminated by signal 25 Cause : File…
Read MoreDescription: This script mainly used for monitoring database alert log from a table. Instead of login in the Unix and start doing vi and tail to see the contents of…
Read MoreDescription : If we lost adapcctl.sh, adalnctl.sh, and adcmctl.sh scripts. we can re-generate it, By running autoconfig. Solution : [applabc@apps scripts]$ ls -ltrh adapcctl.sh adalnctl.sh adcmctl.sh No such file directory…
Read MoreDescription : This script is very useful for calculate and report to database growth in day/week/month/year wise. Script: SELECT (select min(creation_time) from gv$datafile) “Create Time”, (select name from gv$database) “Database…
Read MoreDescription: This Document for configuring oracle Statspack, schedule auto snapshot and report generation. The Statspack tool is instead of AWR report because AWR is licensed Statspack is non licensed. Steps:…
Read MoreDescription: After Clone the Oracle Application R12.1.3 and login the application this error occurs. Solution: Check the Server ID in fnd_node table . Select server_id from fnd_node; Take a backup…
Read MoreDescription: Oracle have lot of printing option to configuring in Solaris 10, this is also one method will follow to setup printer on EBSR12 in Solaris Sparc 10 Steps: Login…
Read MoreDescription: Oracles have lot of trace utility the oradebug is one the utility to trace particular running concurrent request using oracle spid. Steps: Check Request ID from Find Concurrent request…
Read MoreDescription: The user was running RDF report and concurrent completed with error That issue occur on the prefs.ora file is missing or non-accessible owner Solution: copy the prefs.ora file from…
Read More