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 …
Read More »Data Guard Vs SAN To SAN Replication
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 …
Read More »Comparison Between Oracle GoldenGate and DataGuard
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 …
Read More »Generating AWR Reports
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 …
Read More »RMAN Backup Script for Windows
RMAN Backup Script for Windows Create Batch file named as rmanbackup.cmd and copy the below given script in that batch file. set oracle_sid=orcl rman target sys/passwd nocatalog cmdfile=’c:\app\rman\rmanbkp.cmd’ log=’c:\app\rman\bkp_log.log’ ————— –rmanbackup.cmd run …
Read More »Find and Delete Older Files in Linux
Delete Older Files in Linux Files older than 1 day find /rman/arch/*.dbf -mtime +1 -exec mv {} /rman/archbkp/ \; Move files older than 25 hours find /rman/arch/*.dbf -mmin …
Read More »Where Can I Find EBS 12.2.7 Documentation?
[et_pb_section][et_pb_row][et_pb_column type=”4_4″][et_pb_text]Where Can I Find EBS 12.2.7 Documentation? By: Steven Chan| Senior Director EBS 12.2.7 is the latest update to E-Business Suite 12.2. It can be applied online — you do not need …
Read More »Office 365 ProPlus Certified with EBS 12.1 and 12.2
Office 365 ProPlus Certified with EBS 12.1 and 12.2 By: Steven Chan| Senior Director Microsoft Office 365 ProPlus versions of Excel, Word, and Outlook are certified with Oracle E-Business Suite 12.1 and 12.2. …
Read More »ORA-01157: cannot identify/lock data file 206 – see DBWR trace file
ERROR ORA-01157: cannot identify/lock data file 206 – see DBWR trace file ORA-01110: data file 206: ‘+DATA’ SOLUTION If you are using XML in your database and you are trying …
Read More »ORA-07445: exception encountered: core dump
ERROR ORA-07445: exception encountered: core dump [kglic0()+756] [SIGSEGV] [ADDR:0x430000010B8AE910] [PC:0x107AB7474] [Address not mapped to object] [] SOLUTION SQL> ALTER SYSTEM SET “_cursor_stats_enabled”=false SCOPE=SPFILE; Caution : This recommendation can be applied …
Read More »