Oracle APPS DBA

Adding responsibility to SYSADMIN user resulted ORA-20001: FND_CANT_INSERT_USER_ROLE

OracleEBSerror

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 »

How To Add Redo Logfiles In Standby Database

configure

How To Add Redo Logfiles In Standby Database   Step 1. First, Check MEMBER present in Standby Database. SQL> select member from v$logfile; MEMBER ———————————- E:\STANDBYLOGS\REDO03.LOG E:\STANDBYLOGS\REDO02.LOG E:\STANDBYLOGS\REDO01.LOG   Step 2. …

Read More »