Topic

Oracle

A collection of 23 issues

Oracle: How to solve ORA-16810 ORA-16809 ORA-16854 in DataGuard

When moving Oracle manual standby database, I got these eror: [...] Error: ORA-16810: multiple errors or warnings detected for the member [...] Warning: ORA-16854: apply lag could not be determined [...] ERROR I tried several things, like clearing log files: SQL> alter database clear logfile group 1; But I get this error:

Oracle: Apply many OneOff patches at once

This is how to apply different OneOff patches at one time

Oracle: Database Appliance (ODA) used for other things

My thoughts on what you could also do with your ODA

The Ten Commandments for DBAs

I recently read a great blog entry from Fritz Lechnitz, who wrote about the Ten Commandments for a SQL Server DBA. As I am - and mostly was over many years - an Oracle DBA, who had some excursions to other RDBMS (SQL Server, DB/2, Informix, MySQL, PostgreSQL ), I&

Oracle: How to solve ORA-06520

After migrating an Oracle database to a new server, ORA-06520 occurs. This is how to solve it.

Oracle: How to solve ORA-28040

This is how to solve connection error ORA-28040

Oracle: Use CheckMk for Oracle Database monitoring

This is how to easily use CheckMk for Oracle monitoring

Oracle: DataPatch fails with error PLS-00302

This is how to solve PLS-00302 when executing DataPatch

Oracle: Create or drop database link for/from different schema

You can't create a database link for another user than the one you logged in. Neither you can drop it. Here's a workaround...