NID-00600: Internal Error - [30] [3113] [0] [0] and ORA-00600: internal error code, arguments: [control file RSBY_RDI/IC mismatch], [3], []

Issue:

Below errors are encountered when a renaming a standby database to use as cloned instance.

NID-00600: Internal Error - [30] [3113] [0] [0]
ORA-00600: internal error code, arguments: [control file RSBY_RDI/IC mismatch], [3], []


Symptoms:

Trying to convert standby to clone instance.

Cause:

Controlfile was created for standby and same controlfile is used during rename.

Fix:

Take a trace from the database.

Rename existing controlfiles.

Create fresh controlfiles from the trace.

Open the database with resetlogs.

 

ORA-19566: exceeded limit of 0 corrupt blocks for file "/u01/db/oracle/db/apps_st/data/system09.dbf" while taking rman backup for fresh install of 12.1.1.

Issue:

After a fresh Install of 12.1.1, trying to take RMAN backup which failed with below errors.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/12/2013 11:49:40
ORA-19566: exceeded limit of 0 corrupt blocks for file /u01/db/oracle/db/apps_st/data/system09.dbf


Fix:

alter database datafile "/u01/db/oracle/db/apps_st/data/system09.dbf" resize 1000m;

dbv file=/u01/db/oracle/db/apps_st/data/system09.dbf

Re-initiate the backup.

perl adcfgclone.pl appsTier fails with coredump error on AIX

Issue:

On AIX server, perl adcfgclon.pl appsTier is failing with below errors.

$ perl adcfgclone.pl appsTier
Enter the APPS password [APPS]:


First Creating a new context file for the cloned system.
The program is going to ask you for information about the new system:

sh: 758236 Illegal instruction(coredump)
ERROR: context creation not completed successfully.
Please check /tmp/adcfgclone_1515866.err file for errors


$ cat  /tmp/adcfgclone_1515866.err
        stackpointer=2ff207f0
JVMXM004: JVM is performing abort shutdown sequence
JVMDG217: Dump Handler is Processing a Signal - Please Wait.
JVMDG303: JVM Requesting Java core file
JVMDG304: Java core file written to /u01/app/comn/clone/bin/javacore1413304.1369742403.txt
JVMDG215: Dump Handler has Processed Exception Signal 4.


Cause:

The cause of the issue is because the symbolic links were missing from either $IAS_ORACLE_HOME/appsoui/jre/1.3.1 or $COMMON_TOP directory.


Fix:

1. Go to /<COMMON_TOP>/clone/jre. 
2. mv lib lib.old 
3. mv bin bin.old 
4. ln -s jre/bin bin 
5. ln -s jre/lib lib 
6. Repeat the steps in $IAS_ORACLE_HOME/appsoui/jre/1.3.1 
7. Run the perl adcfgclone.pl AppsTier again.

Procedure to take backup and recover OCR and Voting Disks in RAC

To take backup of OCR Disk:

Execute below command to take backup of OCR Disks as root user:

10g:

# ocrconfig -export <OCR export_filename> -s online

11g:

# ocrconfig -manualbackup

To Take backup Voting Disk:

Pre-11g:

Execute below command as root user:

# dd if=voting_disk_name of=backup_file_name

11g:

For 11.2+, it is no longer required to back up the voting disk. The voting disk data is automatically
backed up in OCR as part of any configuration change. The voting disk files are backed up
automatically by Oracle Clusterware if the contents of the files have changed in the following ways:

Configuration parameters, for example misscount, have been added or modified
After performing voting disk add or delete operations
The voting disk contents are restored from a backup automatically when a new voting disk is added or
replaced.

To List the backup:

# ocrconfig -showbackup

To Recover using backup:

# ocrconfig -import <OCR export_filename>

To check the health of OCR:

# ocrcheck

Concurrent Program failed with Error ORA-20003: FAILURE: AppServ Notification for Profile

Issue:

In ASCP, Concurrent Program using utl_http package has failed with below error in the log file:

ORA-20003: FAILURE: AppServ Notification for Profile ID=461Failed Return value: <!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">

<HTML><HEAD>

<TITLE

Cause:

Pval in sys_params under Demantra Schema (MDSEM in our case) table has wrong value for pname AppServerURL 

Verification:

SQL>  select pname,PVAL

  2  from msdem.sys_params

  3  where PNAME='AppServerURL';

PNAME         PVAL

------------  --------------------------------------------

AppServerURL  http://demuatapp01.xyz.com:7778/demantra_uat

Solution:

SQL> update msdem.sys_params

set pval='http://demuatapp01.xyz.com:7778/demantra_uat11' 

where pname='AppServerURL';

SQL> Commit;

Now restart demantra application services.

Collect Shipment and Booking History failed with ORA-24247: network access denied by access control list (ACL) error

Issue:

"Collect Shipment and Booking History" in ASCP completed with below errors in the log file:

ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1722
ORA-24247: network access denied by access control list (ACL)

Cause:

Demantra schema in ASCP does not have "connect" grant on the network ACL.

Verification:


SYS-UAT> select * from dba_network_acls;

HOST  LOWER_PORT UPPER_PORT ACL                        ACLID
----- ---------- ---------- -------------------------- -------------------------
*                           /sys/acls/OracleEBS.xml    71572A92FE0405D0B59100B2A

SYS-UAT> SELECT DECODE(DBMS_NETWORK_ACL_ADMIN.check_privilege('OracleEBS.xml', 'MSDEM', 'connect'),1, 'GRANTED', 0, 'DENIED', NULL) privilege FROM dual;

PRIVILE

-------

Solution:

Grant connect on ACL to demantra schema (MSDEM in this case)

BEGIN

DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl=>'/sys/acls/OracleEBS.xml',

   principal => 'MSDEM',

   is_grant  => true,

   privilege => 'connect');

COMMIT;

END;

/

Verfication:

SYS-UAT> SELECT DECODE(DBMS_NETWORK_ACL_ADMIN.check_privilege('OracleEBS.xml', 'MSDEM', 'connect'),1, 'GRANTED', 0, 'DENIED', NULL) privilege FROM dual;

PRIVILE

-------

GRANTED

Now, rerun the program and it completes successfully without any issues.

Diagnostics not functioning in Oracle Applications after upgrading to 12.1.3

Issue:

After upgrading to R12, when user is following below navigation for diagnostics:

Help -> Diagnostics -> Examine

getting below error:

"Function Not Available for this responsibility. Change responsibilities or contact your system administrator"

Resolution:

Beginning with Release 12.1.3, access to the above Diagnostics submenu items can be controlled by the profile Utilities:Diagnostics or by security functions using Role-Based Access Control (RBAC). Whether or not a submenu item is available is checked on an "as-needed" basis by the system when the user selects the submenu item. If the menu item is not available to the user, the message "Function not available to this responsibility. Change responsibilities or contact your System Administrator."

To fix this error, set the following profile option to Yes at user level for the user to whom this is required.

Utilities:Diagnostics 

After setting this profile to Yes, clear the cache and bounce Apache to reflect the same.

Clear Cache in Oracle Apps R12 from backend (server).

Aim: How to clear cache in Oracle Apps R12 without logging into Applications.

Procedure:  Login to Middletier and use below commands.


$ cd $ADMIN_SCRIPTS_HOME
$ adapcctl.sh stop
$ find $LOG_HOME/ora/10.1.3 -name '*' -type f |xargs rm -f
$ adoacorectl.sh stop
$ adoacorectl.sh start
$ adapcctl.sh start

How to send mail using utl_mail from PL/SQL?

Aim: To send a mail using utl_mail from SQL.

Procedure:
$ cd $ORACLE_HOME/rdbms/admin
$ sqlplus '/as sysdba'

SQL> @utlmail.sql

Package created.

Synonym created.

SQL> @prvtmail.plb

Package created.

Package body created.

Grant succeeded.

Package body created.

No errors.
SQL> GRANT EXECUTE ON UTL_MAIL TO PUBLIC;

Grant succeeded.

Test:


SQL> BEGIN
  2    EXECUTE IMMEDIATE 'ALTER SESSION SET smtp_out_server = ''mail.testhost.com''';
  3    UTL_MAIL.send(sender => 'vbadam@testhost.com',
  4                  recipients => 'veda.santosh@gmail.com',
  5                     subject => 'Test Mail',
  6                     message => 'Hello World',
  7                   mime_type => 'text; charset=us-ascii');
  8  END;
  9  /

PL/SQL procedure successfully completed.



And a test mail is received at veda.santosh@gmail.com