ORA-06512

How to Resolve ORA-13780: SQL statement does not exist

by Ed Chen
February 7, 2023February 8, 2023

ORA-13780 Tried to create a SQL tuning task for specific SQL ID, but it failed with ORA-13780. SQL> select DBMS_SQLTUNE.CREATE_TUNING_TASK ( sql_id => '21zq47mj49f7w', scope… Read More »

How to Resolve ORA-06512: at PL/SQL line

by Ed Chen
October 22, 2021June 8, 2022

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-24247: network access denied by access control list (ACL)

by Ed Chen
August 27, 2021February 23, 2023
8 Comments

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-28232: invalid input length for obfuscation toolkit

by Ed Chen
July 17, 2021June 4, 2022

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-29283: invalid file operation

by Ed Chen
July 14, 2021March 30, 2023

ORA-29283 There're several error patterns of ORA-29283. ORA-29434 Someone tried to use UTL_FILE.FOPEN in a stored procedure to operate a file, but it sometimes failed… Read More »

How to Resolve ORA-20005: object statistics are locked (stattype = ALL)

by Ed Chen
June 19, 2021June 3, 2022

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-01031: Insufficient Privileges

by Ed Chen
June 24, 2020May 26, 2023
1 Comment

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 Restore RAC Database from RMAN Backup Set

by Ed Chen
July 4, 2019May 31, 2023
2 Comments

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 OCR and Voting Disk

by Ed Chen
June 30, 2019February 21, 2023

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 10g RAC Database from a Backup Set

by Ed Chen
June 26, 2019May 31, 2023
2 Comments

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 »

JavaScript is not enabled. Please enable it and reload the page.