Today we are going to have look at the “MONITORING ALERT LOG ORA-ERRORS”. With help of this script DBA can monitor all the ORA-Errors from the alert log and used to send to our mailboxes, he schedules this through a cronjob. Being DBA we all are aware of the importance of Alert Log. For managing the backup […]

Read More

Errors:- (ORA-01450: maximum key length (3215) exceeded)

Today we are going to have look on the topic of the Rebuilding index. In this post we are going to learn why do we need rebuilding the index? It explains the steps we use to solve the error. While we rebuild the index we face the problem. 06:19:09 [SYS][TEST]>> ALTER index PRS.UK_F_HEADER rebuild online; ALTER index […]

Read More

ORA-16179 incremental changes to “log_archive_dest_10” not allowed with SPFILE

You might encounter ORA-16179 error while changing the archive destination.

There is syntax error in above command . It should be like log_archive_dest_n [n is a integer from 1 to 31]=’LOCATION=path_for_archive_log’ example :

Thank you for giving your valuable time to read the above information. If you want to be updated with all […]

Read More