Wednesday, July 29, 2015
Tuesday, July 14, 2015
Oracle EBS apache issue/error : 500 Internal Server Error
Oracle EBS 12.x apache issue/error : 500 Internal Server Error
Fix/Solution:
cd $INST_TOP/ora/10.1.3/j2ee/oacore/config
vi oc4j.properties
Fix/Solution:
cd $INST_TOP/ora/10.1.3/j2ee/oacore/config
vi oc4j.properties
| LONG_RUNNING_JVM=false >>> Change the Value to false |
Monday, July 13, 2015
RMAN-06094: datafile must be restored // RMAN-06094: datafile 50 must be restored
RMAN-06094: datafile <dbfNo.> must be restored
Error Message:
RMAN> RECOVER DATABASE NOREDO;
Starting recover at 13-JUL-15
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/13/2015 05:27:38
RMAN-06094: datafile 50 must be restored
CAUSE:
Backup of datafile <dbf> not available in RMAN catalog.
Solution:
Take fresh backup and restore by below comamnd,
RMAN>RECOVER DATAFILE 15;
Example:
RMAN> restore datafile 50;
Starting restore at 13-JUL-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00050 to /prod/data/data01/a_txn_data11.dbf
channel ORA_DISK_1: reading from backup piece /prod/backup/standby/Jul_13/FORSTANDB_dbf5028qbu25o_1_1
channel ORA_DISK_1: piece handle=/prod/backup/standby/Jul_13/FORSTANDB_dbf5028qbu25o_1_1 tag=DBF15
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:02:25
Finished restore at 13-JUL-15
RMAN duplicate failing with Error RMAN-05001: auxiliary file name '' conflicts with a file used by the target database
RMAN duplicate failing
RMAN-05001: auxiliary file name '<dbfile>' conflicts with a file used by the target database
Error Message:
RMAN-05001: auxiliary file name /prod/data/data02/a_uie_uid57.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /prod/data/data02/a_uie_uid56.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /prod/data/data01/maximo_interfaz_03.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /prod/data/data02/a_uie_data74.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /prod/data/data02/a_uie_data73.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /prod/data/data02/a_uie_data72.dbf conflicts with a file used by the target database
...
CAUSE:
Production and Auxiliary have same directory structure and are running on two different machines.
RMAN must be told not check that the target datafiles are sharing the same names as the duplicated files being created.
Otherwise, the following errors will be returned:
Solution :
User CLAUSE "NOFILENAMECHECK" in Rman Duplicate command before parameter 'DB_FILE_NAME_CONVERT' and 'LOG_FILE_NAME_CONVERT'
Example:
DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE
NOFILENAMECHECK
PARAMETER_VALUE_CONVERT '/prod/data','/prod/data','/prod/data','/prod/data'
SET "db_unique_name"="prod1stby" COMMENT "Is a duplicate"
set db_file_name_convert='/prod/oracle/','/prod/oracle/','/prod/oracle/','/prod/oracle/'
NOTE: Do not use NOFILENAMECHECK when target and destination database are on the same box because datafiles from target database will be overwritten !!
RMAN-05001: auxiliary file name '<dbfile>' conflicts with a file used by the target database
Error Message:
RMAN-05001: auxiliary file name /prod/data/data02/a_uie_uid57.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /prod/data/data02/a_uie_uid56.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /prod/data/data01/maximo_interfaz_03.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /prod/data/data02/a_uie_data74.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /prod/data/data02/a_uie_data73.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /prod/data/data02/a_uie_data72.dbf conflicts with a file used by the target database
...
CAUSE:
Production and Auxiliary have same directory structure and are running on two different machines.
RMAN must be told not check that the target datafiles are sharing the same names as the duplicated files being created.
Otherwise, the following errors will be returned:
Solution :
User CLAUSE "NOFILENAMECHECK" in Rman Duplicate command before parameter 'DB_FILE_NAME_CONVERT' and 'LOG_FILE_NAME_CONVERT'
Example:
DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE
NOFILENAMECHECK
PARAMETER_VALUE_CONVERT '/prod/data','/prod/data','/prod/data','/prod/data'
SET "db_unique_name"="prod1stby" COMMENT "Is a duplicate"
set db_file_name_convert='/prod/oracle/','/prod/oracle/','/prod/oracle/','/prod/oracle/'
NOTE: Do not use NOFILENAMECHECK when target and destination database are on the same box because datafiles from target database will be overwritten !!
Saturday, July 11, 2015
Standby MRP crashing due to ORA-00379: no free buffers available in buffer pool DEFAULT for block size 16K
Cause :
SQL> show parameter 16k
NAME TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
db_16k_cache_size big integer
0 <<<<<<<<<<< Not set value
Cause :
SQL> show parameter 16k
NAME TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
db_16k_cache_size big integer
0 <<<<<<<<<<< Not set value
SQL>
Solution :
1.)
SQL> alter system set db_16k_cache_size=512M scope=SPFILE;
System altered.
Note: value of this parameter must in multiple of 16k.
2.)Restart DB
>>>> Note : To take effect of this parameter value, DB restart is required.
Solution :
1.)
SQL> alter system set db_16k_cache_size=512M scope=SPFILE;
System altered.
Note: value of this parameter must in multiple of 16k.
2.)Restart DB
>>>> Note : To take effect of this parameter value, DB restart is required.
Friday, July 3, 2015
ORA-20011: Approximate NDV failed: ORA-16532: Data Guard broker configuration does not exist
ORA-20011: Approximate NDV failed: ORA-16532: Data Guard broker configuration does not exist
Oracle DB : Release 11.2
Oracle DB : Release 11.2
% dgmgrl
DGMGRL> connect /
DGMGRL> show configuration
ORA-16532: Data Guard broker configuration does not exist
Solution :
Disable the DataGuard broker:
SQL> alter system set dg_broker_start=false scope=both;
SQL> > exec dbms_stats.gather_fixed_objects_stats;
PL/SQL procedure successfully completed.
SQL> > exec dbms_stats.gather_fixed_objects_stats;
PL/SQL procedure successfully completed.
Thursday, July 2, 2015
EBS 12.x Linux, MT Services(oacore) not comping on 2nd host (MYHOST03), but was fine on Host : MYHOST02
| On EBS 12.x Linux, MT Services(oacore) not comping on 2nd host (MYHOST03), but was fine on Host : MYHOST02 |
| Issue : oacore not coming up |
| MSG_TEXT>Error reading config file {0}</MSG_TEXT> |
| <SUPPL_DETAIL><![CDATA[java.io.IOException: No locks available |
| at sun.nio.ch.FileDispatcherImpl.lock0(Native Method) |
| at sun.nio.ch.FileDispatcherImpl.lock(FileDispatcherImpl.java:90) |
| MSG_TEXT>Failed to acquire lock for /prod/product/1013/j2ee/home/applications/dms.war. It may fail to share the application with multiple oc4j instances.</MSG_TEXT> |
| >>> |
| Cause: /prod/product >>> Not mounted with lock option, So it was failing to lock above file : dms.war( By using this configuration file oacore was deployed) |
| Fix/Solution : Get it mounted with lockoption. |
| and after reboot host, issue got fixed & MT services started normally. |
Ebusiness12.1.x : Apache startup issue on Linux OS // Apache not coming up on EBS
| Ebusiness 12.1.x : Apache startup issue on Linux OS. Issue : Apache not coming up |
| Executing service control script: |
| /prod/inst/apps/PROD_MYHOST02/admin/scripts/adapcctl.sh start |
| script returned: |
| **************************************************** |
| ERROR : Timed out( 100000 ): Interrupted Exception |
| You are running adapcctl.sh version 120.7.12010000.2 |
| Starting OPMN managed Oracle HTTP Server (OHS) instance ... |
| 06/26/15-05:57:13 :: Removing gantt cache directory |
| **************************************************** |
| Fix/Solution : |
Login to apps(MT) node using applmgr user cd /prod/applmgr/common/webapps/oacore/html/cabo/images/cache |
mv gantt gantt.26June2015 |
Subscribe to:
Posts (Atom)