To patch DBCS with Data Guard. We need to first apply the patch on the standby database then the primary. Follow below steps for applying the patch. Step -1Run the precheck for the patch on the standby database.
Opatch utility is used to apply patch to the database so before applying the patch you must check whether the existing Opatch is supported for the patch or not. You must use the OPatch utility version 12.2.0.1.14 or later to apply this patch. Oracle recommends that you use the latest rel...
To apply psu patch on physical standby database setup, 1st patch need to be applied on standby, and then on primary. Below are the steps.Download patch from oracle support. 1.Check the database_role for both dbs PRIMARY> select database_role from v$database; DATABASE_ROLE --- PRIMARY ...
Each guest domain that runs Oracle Database should have a minimum of 16 CPUs (2 CPU cores) and 4 GB of memory. Each control domain that provides virtual devices (virtual disk and virtual network) to an Oracle Database single-instance guest domain should have a minimum of 8 CPUs (1 CPU...
(http://www.oracle.com/technetwork/security-advisory/alert-cve-2018-3110-5032149.html), initially released on 8/10, says “patches for those versions and platforms were included in the July 2018 CPU”, which, if I am reading correctly, refers to Oracle Database 11.2.0.4 and 12.2.0.1 on...
This document presents an option to patch the SYSTEM rollback segment header when errors ORA-600 [4193] / ORA-600 [4194] are produced in the SYSTEM rollback segment. This situation could be avoiding the database to be opened. The supported procedure to fix this problem when the SYSTEM roll...
This document presents an option to patch the SYSTEM rollback segment header when errors ORA-600 [4193] / ORA-600 [4194] are produced in the SYSTEM rollback segment. This situation could be avoiding the database to be opened. The supported procedure to fix this problem when the SYSTEM roll...
Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and laterInformation in this document applies to any platform.GoalIs it or not necessary to apply OCW patches on my ORACLE_HOME even if I don't use ASM, RAC or CLUSTERWARE?It...
oracle@b2bdev:~$ dbca -silent -createDatabase -responseFile /export/home/oracle/db_create.rsp [WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards. CAUSE: a. Oracle recommends that the password entered should be at least 8 characters in lengt...
Version requirements may also come into play here. PTFs were added in Oracle Database 18c, whereas table SQL macros are first available in 19.6. But this should pose little concern.Support has ended for 18c, so if you're using this you should be moving to an up-to-date patch of 19c ...