TOP 10 common oracle error and solution


Listing down top 10 oracle error and solution faced mostly during database administration


You may click on individual ORA- error string to find more details in for of error details , cause and possible solution to fix in your environment.


#1  ORA-01031: insufficient privileges


#2  ORA-03114: not connected to ORACLE


#3  ORA-27037: unable to obtain file status



#4  ORA-12545:Connect failed because target host or object does not exist


#5  ORA-00600: internal error code, arguments: [kqd-objerror$]


#6  ORA-02049: timeout: distributed transaction waiting for lock


#7  ORA-1652: unable to extend temp segment


#8  ORA-15063: ASM discovered an insufficient number of disks for diskgroup


#9  ORA-01078: failure in processing system parameters


#10 ORA-01157: cannot identify/lock data file - see DBWR trace file


No comments:

Post a Comment