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