Oracle: Add database components to a 23ai CDB
This is how to add database components to a 23ai CDB
Topic
Oracle
A collection of 27 issues
Oracle: Issues when patching Cloud Control 13.5 from RU25 to RU27
I got some errors while patching Cloud Control 13.5 from RU25 to RU27, this is how they could be resolved
Oracle: How to solve Oracle error ORA-01110
This night, I was woken up by a customer who had an issue with his software. Daily business was running fine, but some background jobs had issues.
What was the problem?
The first error looked like that:
2025-07-25 02:15:21 NOTE: AMB1 (index:1) registering with ASM instance as
Flashback: Sun Ultra 10
These are my memories how I used several Sun Ultra 10
Oracle: How to solve ORA-16810 ORA-16809 ORA-16854 in DataGuard
When moving Oracle manual standby database to DataGuard, 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
Oracle: Install Cloud Control Agent on Windows
This is how Cloud Control agent can be installed on Windows
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.