How to Resolve ORA-06512: at PL/SQL line
ORA-06512 In fact, ORA-06512 does not throw the actual error it encountered. Instead, it points out the problem line in the PL/SQL program unit in… Read More »How to Resolve ORA-06512: at PL/SQL line
ORA-06512
How to Resolve ORA-24247: network access denied by access control list (ACL)
ORA-24247 There're two error patterns of ORA-24247 in this post. Resolve or Connect Privilege Debug Mode in SQL Developer A. Resolve or Connect Privilege For… Read More »How to Resolve ORA-24247: network access denied by access control list (ACL)
How to Resolve ORA-28232: invalid input length for obfuscation toolkit
ORA-28232 Developers tried to obfuscate data by DBMS_OBFUSCATION_TOOLKIT in a database with multi-byte character set and got this error. ORA-28232: invalid input length for obfuscation… Read More »How to Resolve ORA-28232: invalid input length for obfuscation toolkit
How to Resolve ORA-29283: invalid file operation
ORA-29283 Someone tried to use UTL_FILE.FOPEN in a stored procedure to operate a file, but it sometimes failed with ORA-29283. ORA-29283: invalid file operation: nonexistent… Read More »How to Resolve ORA-29283: invalid file operation
How to Resolve ORA-20005: object statistics are locked (stattype = ALL)
ORA-20005 When we tried to gather some statistics on a table which has never been analyzed, we saw ORA-20005 like this: SQL> exec dbms_stats.gather_table_stats(ownname =>… Read More »How to Resolve ORA-20005: object statistics are locked (stattype = ALL)
How to Resolve ORA-01031: Insufficient Privileges
ORA-01031 ORA-01031: Insufficient Privileges means that the current user did not use the right privilege to process the SQL statement. Since this error can be… Read More »How to Resolve ORA-01031: Insufficient Privileges
How to Restore RAC Database from RMAN Backup Set
For 10g RAC database restoration, you may check: How to Restore 10g RAC Database from a Backup Set. Suppose we have restored 12c clusterware back.… Read More »How to Restore RAC Database from RMAN Backup Set
How to Restore OCR and Voting Disk
There're 2 procedures of restoring OCR and voting disk in this post. They are: Restore OCR and Voting Disk For 12c Clusterware Restore OCR and… Read More »How to Restore OCR and Voting Disk
How to Restore 10g RAC Database from a Backup Set
For 12c RAC database restoration, you may check: How to Restore 12c RAC Database from a Backup Set. Suppose we have recovered 10g CRS and… Read More »How to Restore 10g RAC Database from a Backup Set
How to Resolve SPFILE in DB_UNKNOWN
SPFILE in DB_UNKNOWN When I tried to restore SPFILE to the default location at nomount state, I found that SPFILE was restored to a DB_UNKNOWN… Read More »How to Resolve SPFILE in DB_UNKNOWN