DBA Arena

Symptoms:

Media Recovery Stopped on standby database after adding datafile on primary.
 

Error:

MRP0: Background Media Recovery terminated with error 1111
 
Alert Logfile:


Managed Standby Recovery not using Real Time Apply
MRP0: Background Media Recovery terminated with error 1111
Errors in file /u01/oracle/diag/rdbms/erpdr/ERPPROD/trace/ERPPROD_pr00_44120.trc:
ORA-01111: name for data file 58 is unknown - rename to correct file
ORA-01110: data file 58: '/u01/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00058'
ORA-01157: cannot identify/lock data file 58 - see DBWR trace file
ORA-01111: name for data file 58 is unknown - rename to correct file
ORA-01110: data file 58: '/u01/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00058'
Recovery Slave PR00 previously exited with exception 1111
MRP0: Background Media Recovery process shutdown (ERPPROD)

 
Read more...

Symptoms:

Concurrent request completing with Warning status.

Error:

The Concurrent Request logfile show the following error:

-- PUBLISH:
oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.xdo.oa.schema.server.TemplateNotYetValidException: START_DATE is still not coming yet.

Cause:

Having different date/time values on EBS nodes causes the run time error.
Make sure that all the EBS nodes have the same date/time settings.

In our case, the year was incorrect on the application server.
Read more...

Symptoms:

When attempting to run autoconfig on patch fs the following error occurs.


ERROR
-----------------------
Enter value for 1: Enter value for 2: Enter value for 3: ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

.end err out.


 
Read more...

Important: These steps must be carried out on the run file system. The FND_USER and FND_ORACLE_USERID tables should be backed up before any passwords are changed. Remove the backups after you have confirmed that the changes are successfully completed. Passwords for all the 3 schemas, APPS, APPLSYS and APPS_NE will be changed together while changing APPLSYS password.

1. Shut down the application tier services using the below script:

$INST_TOP/admin/scripts/adstpall.sh

2. Change the APPLSYS password using

 
There are 2 ways to change the APPLSYS password:
Read more...

Important: These steps must be carried out on the run file system. The FND_USER and FND_ORACLE_USERID tables should be backed up before any passwords are changed. Remove the backups after you have confirmed that the changes are successfully completed. Passwords for all the 3 schemas, APPS, APPLSYS and APPS_NE will be changed together while changing APPLSYS password.

1. Shut down the application tier services using the below script:

$INST_TOP/admin/scripts/adstpall.sh

2. Change the APPLSYS password using

 
There are 2 ways to change the APPLSYS password:
Read more...