Oracle 11g Error Codes and Solution Suggestions from ORA-00000 to ORA-00100 ORA-00000: normal, successful completion Cause: Normal exit. Action: None ORA-00001: unique constraint (string.string) violated Cause: An UPDATE or INSERT statement attempted to insert a duplicate key. For Trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists…
Category: Errors and Solutions
ORA-01031 Insufficient Privileges
If you want to add new dba user as domain user, you have to add ora_dba group on Windows Systems. If you do not add to this group, you get an error like ORA-01031 insufficient privileges. Error Solution
CRS-0184 Cannot Communicate With The Crs Daemon in Oracle
I got an error like CRS-0184 on Oracle 11g RAC system, because of interconnect network is down. After network was up, CRS Daemon did not start. You can take these errors like CRS-0184, CRS-2674, CRS-4534, CRS-4530.. I resolved that problem with below operations. CRS Stop and Start [root@node2 ~] cd $GRID_HOME/bin [root@node2 bin] ./crsctl stop…
Restore And Recover Oracle 11g R2 Database on Windows 2008 R2 Server
You can restore and recover Oracle 11g R2 Database from RMAN backup on Windows 2008 R2 Server with below operations. You have to execute Command Prompt as Administrator for all operations. Restore and Recover Database Install Oracle software Install Patch Create ORACLE_HOME and ORACLE_SID in Server Environment Path. Copy backup files to C:\orabackup Create Oracle…
ORA-03113: end-of-file on communication channel when startup
If your fra disk or archivelog directory full, your db can not process any transaction. When you increase disk size, database does not recover itself. You have to do some process. Error Solution