Oracle Management Cloud

Introduction to Oracle Management Cloud We have been seeing so many products of Oracle off late. A new suite from Oracle named Oracle Manage...

Friday, April 12, 2013

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
at No comments:
Labels: , , ,

Thursday, April 4, 2013

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.




at No comments:
Labels: , ,

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.


at No comments:
Labels:
Subscribe to: Posts (Atom)

Most Viewed Posts