Pages

▼
Tuesday, December 20, 2022

Re-Creating control file from existing database following ORA-00202: control file: ORA-27070: OSD-04006: Data error (cyclic redundancy check).

›
How to create a control file from existing database Real life example, Control files got corrupted due to HW issue Errors in file d:\softwar...
Tuesday, December 13, 2022

Golden Gate, Report process status from bash to a file

›
Report GG processes status to a file mkdir /software/ogg/191/gg_report mkdir /software/ogg/191/gg_report/scripts mkdir /software/ogg/191/gg_...
Monday, December 12, 2022

ORA-01489: result of string concatenation is too long

›
The Issue When running in sqlplus, the output is a long concatenated  String. In case row would overflow over 4000 characters, an error woul...
Saturday, December 10, 2022

Thread 1 cannot allocate new log, sequence 99999 Private strand flush not complete

›
=========== Issue =========== Frequent messages "Thread 1 cannot allocate new log, sequence 15123. Private strand flush not complete...
Wednesday, December 7, 2022

ORA-24247: network access denied by access control list (ACL)

›
============== Issue ============== When calling    UTL_SMTP.open_connection(mailhost, 25),  There is the error: ORA-24247: network access d...
Tuesday, December 6, 2022

ORA-14602: SUBPARTITION TEMPLATE is legal only for a composite partitioned table

›
ORA-14602: SUBPARTITION TEMPLATE is legal only for a composite partitioned table One cannot do TEMPLATE SUBPARTITION to a table that was no...
Saturday, December 3, 2022

Add Redo Log Group by Example. Fixing "log file switch" wait event

›
======================== Fixing "log file switch" wait event ======================== Fix "log file switch" wait event b...