Patch failing because of Datapatch bug [SQL_PATCH=true]
Again I lost too many hours trying to solve an issue I got during upgrade of one 19c non-CDB database and plugging it into 21c CDB. When I execute the noncdb_to_pdb.sql script, I got following error: select cause, type, status, message from pdb_plug_in_violations where name=\'NINJAPDB\'; Non-CDB to PDB ERROR RESOLVED PDB plugged in is a ...
Database Upgrade using autoupgrade tool
This time I had to upgrade a SE2 12.2 database running on Windows on Azure Cloud to the version 19.3. I do not have such setup in my lab, so I was a little bit sceptical about it, and it will turn out – with a reason. So, I read a ton of a articles ...
Upgrade to 12c: ORA-38753: Cannot flashback if there is tablespace with FLASHBACK=NO !
Yesterday at customers site I had to upgrade one 11g database to 12c and stumbled upon a tricky issue. As I already upgraded a many dozens of databases, I think (or I thought at least), that I am pretty familiar with the whole process: planning, preparation, check list, pre-upgrade tasks and so on… But, yesterday ...
Unified Auditing: some gotchas to be aware of!
Database should be offline when you are enabling pure Unified Auditing or you will get this error: ORA-00600: internal error code, arguments: [krsh_fsga_sgaq.ds_not_found], [], [], [], [], [], [], [], [], [], [], [] By default, in 12c version the auditing runs in mixed-mode, which means you can combine traditional auditing with unified auditing. There ...
[Upgrade with DBUA + REMOTE_LISTENER with unresolvable SCAN => Fail] & [crsctl “-unsupported” supports you!]
I played with some troubleshooting tasks during database upgrade and stumbled upon some – how can I describe it? – a new findings for me. I have following environment: 2-node RAC environment with Grid Infrastructure version 12.1.0.2 1 RAC database still running on 11GR2 (11.2.0.3) Note: the parameter REMOTE_LISTENER is empty Scenario: That database should ...
Short list of some bugs to be aware of before upgrading to 12c
In the last couple of months I was doing a lot of upgrades to the version 12c. I followed the guidelines and the documentation I found on the Oracle homepage, MOS & many blogs, but unfortunately, not every upgrade went smoothly. As always, every new database version brings a couple of new bugs and it ...
Search Anything