ORA-06512

How to Resolve ORA-24247 Oracle Error Message

by Ed Chen
August 27, 2021September 12, 2021

ORA-24247: network access denied by access control list (ACL) There're two error patterns of ORA-24247 in this post. Resolve or Connect Privilege Debug Mode in… Read More »

How to Resolve ORA-28232 Oracle Error Message

by Ed Chen
July 17, 2021August 30, 2021

ORA-28232: invalid input length for obfuscation toolkit Developers tried to obfuscate data by DBMS_OBFUSCATION_TOOLKIT in a database with multi-byte character set and got this error.… Read More »

How to Resolve ORA-29283 Oracle Error Message

by Ed Chen
July 14, 2021August 30, 2021

ORA-29283: invalid file operation: nonexistent file or path [29434] Someone tried to use UTL_FILE.FOPEN in a stored procedure to operate a file, but it sometimes… Read More »

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

by Ed Chen
June 19, 2021August 27, 2021

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, 2020September 22, 2021

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 is scattering… Read More »

How to Restore 12c RAC Database from a Backup Set

by Ed Chen
July 4, 2019August 27, 2021

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 12c Clusterware OCR Voting Disk

by Ed Chen
June 30, 2019August 27, 2021

For 10g clusterware, you may check: How to Restore 10g Clusterware. Suppose we have lost all disk groups as well as OCR data, voting disk… Read More »

How to Restore 10g RAC Database from a Backup Set

by Ed Chen
June 26, 2019August 27, 2021

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 Resolve SPFILE in DB_UNKNOWN

by Ed Chen
June 23, 2019August 27, 2021

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 »

ORA-06502 due to Character Type Conversion

How to Resolve ORA-06502: PL/SQL: numeric or value error: character to number conversion error

by Ed Chen
May 26, 2019August 27, 2021
4 Comments

ORA-06502 ORA-06502 means that PL/SQL engine cannot convert a character-typed string into a number or a subset of arithmetic for overall evaluation. Mostly, it's because… Read More »