APPS DBA

Enable/Disable Maintenance Mode without using ADADMIN We can Enable or Disable Maintenance mode without using ADADMIN through following given procedure: Enable Maintenance Mode: $sqlplus apps/appspassword SQL>$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE Disable Maintenance Mode: …

How to Add Responsibility to User from Back End SYNTAX fnd_user_pkg.addresp(username => Application User Name ,resp_app => Responsiblity_Application_Short_Name ,resp_key => Responsibility_Key ,security_group => Security_Group ‘Mostly it is ‘STANDARD’ so it …

ERROR Routine AFPGCP cannot create a process ID for your concurrent manager process ORACLE error 8004 in FDUUID Cause: FDUUID failed due to ORA-08004: sequence FND_CONCURRENT_PROCESSES_S.NEXTVAL exceeds MAXVALUE and cannot …

Different Statuses of Concurrent Manager   PENDING STATUS Normal – Request is waiting for the next available manager. Currently all manager are running other requests. Standby – Program to run request is incompatible with …

How to Stop Concurrent Manager Properly Step 1. Go to Oracle Application Scripts Home $cd /apps/ebs/inst/apps/PROD_apps/admin/scripts Step 2.  Stop Concurrent Manager with the following script $adcmctl.sh stop  <appsusername/password> Step 3. …

ERROR ORA-12157: TNS:internal network communication error 

ERROR The below error observed from error.log. [error] mod_ossl: Cannot allocate memory for the ‘shmcb’ session cache\n [error] mod_ossl: Cannot allocate memory for the ‘shmcb’ session cache\n [warn] pid file …

ERROR System Administrator Responsibility Missing In Sysadmin

ERROR OPP Error in the Log file: ———————————————————————— The Output Post-processor is running but has not picked up this request. No further attempts will be made to post-process this request, …

ERROR Outpost Processot has encoutered the below error. This error can be found in OPP logs: —————————————- [GC 14000K->8604K(32459K), 0.0068459 secs] ProcessorException: Unable to determine SMTP server to use: set …