Author: Syed Saad Ali
ERROR
Oracle error – 20001: ORA-20001: FND_CANT_INSERT_USER_ROLE
(USERNAME=SYSADMIN)
(ROLENAME=FND_RESP|FND|FND_FUNC_ADMINI|STANDARD)
(ROUTINE=FND_USER_RESP_GROUPS_API.Insert_Assignment) has
been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT
SOLUTION
This Issue exists in default R12 installation
Step 1. Run the concurrent program “Workflow Directory Services User/Role Validation” with parameters : 100000, Yes, Yes, No
Step 2. Bounce all services under oacore or bounce opmnctl .
Reference Oracle Note id : 454988.1
Data Guard Vs SAN to SAN Replication |
||
Oracle Data Guard |
SAN-to-SAN |
|
Implementation Cost |
Low | High |
Database Aware |
Yes | No |
Granularity of Replication |
Transaction level | Disk Block Level |
Distance Limitations |
No Limitations | Limitations Exist |
Recovery from human error or corruption |
Easy to detect and can be recovered by replaying logs | Replicates block as it is and possible that corrupt blocks gets replicated. |
Comparison Between Oracle GoldenGate and DataGuard |
||
Technical Points |
Oracle Dataguard / Active Dataguard |
Oracle Golden Gate |
| Operating System | Primary Database and Standby Database Should be same. (But 11g Onwards it supports Heteregenous Data Guard Configurations. Example : We can imeplement Oracle Data Guard between Oracle Linux server 6.2 (x86_64) and Microsoft Windows 2008 Server R2 (x64) | Primary Database and Standby Database need not be same. |
| Database | Should be Oracle Database in both Source and Target. | Database can be different in Source and Target. Example :Source database can be Oracle and Target database can be MY SQL/MS SQL server. |
| Database Version | Primary Database and Standby Database Should be same. | Primary Database and Standby Database need not be same. (Including Database Software). |
| Replication method | Data movement will be in-form of Log Files. | It moves Data Transaction wise through Extract and Replicat process from Source to Target, when commits. |
| Database mode | Source: Read write mode Target: Recovery Mode / Open Read Only. |
Source: Read write mode Target: Read write mode |
| Replication Type | Unidirectional. (Data movement will happen in single direction). | Multi-Directional. |
| Integrated Feature | No additional software to install. Oracle Data Guard /Active Data Guard includes in Enterprise Edition. | Oracle GoldenGate software to install in Source as well as Target. |
| License Cost | No additional license required for Oracle Data Guard to install. Oracle Active Data Guard is an enterprise option with Oracle Enterprise Edition. | Oracle GoldenGate Software Licence required in Source and Target Databases. |
| Database Edition | Source: Oracle Enterprise Edition Target: Oracle Enterprise Edition. |
Source: Can be Oracle Enterprise Edition/Oracle Standard Edition/Oracle Standard Edition One Target: Oracle Enterprise Edition/Oracle Standard Edition/Oracle Standard Edition One |
Generating AWR Reports
You can generate AWR reports by running SQL scripts, as described below :-
# Generating an AWR Report
@$ORACLE_HOME/rdbms/admin/awrrpt.sql
# To generate an AWR report on a specific database instance:
@$ORACLE_HOME/rdbms/admin/awrrpti.sql
# To generate an AWR report in an Oracle RAC environment:
@$ORACLE_HOME/rdbms/admin/awrgrpt.sql
#To generate an AWR report on a specific database instance in an Oracle RAC environment:
@$ORACLE_HOME/rdbms/admin/awrgrpti.sql
# To generate an AWR report for a particular SQL statement:
@$ORACLE_HOME/rdbms/admin/awrsqrpt.sql
# To generate an AWR report for a particular SQL statement on a specified database instance:
@$ORACLE_HOME/rdbms/admin/awrsqrpi.sql
#To generate an AWR Compare Periods report:
@$ORACLE_HOME/rdbms/admin/awrddrpt.sql
# To generate an AWR Compare Periods report in an Oracle RAC environment:
@$ORACLE_HOME/rdbms/admin/awrgdrpt.sql
# To generate an AWR Compare Periods report on a specified database instance:
@$ORACLE_HOME/rdbms/admin/awrddrpi.sql
# To generate an AWR Compare Periods report on a specified database instance in an Oracle RAC environment:
@$ORACLE_HOME/rdbms/admin/awrgdrpi.sql
# To generate an ASH report:
@$ORACLE_HOME/rdbms/admin/ashrpt.sql
# To generate an ASH report on a specified database instance:
@$ORACLE_HOME/rdbms/admin/ashrpti.sql
# To generate an ASH report in an Oracle RAC environment:
@$ORACLE_HOME/rdbms/admin/ashrpti.sql