My Oracle Support Banner

OEM 13c: Fleet UPDATE_DB Executes Datapatch On Standby Database Which Should Gets Skipped Fails With Error "ORA-16000: database or pluggable database open for read-only" (Doc ID 3030257.1)

Last updated on JULY 26, 2024

Applies to:

Enterprise Manager for Oracle Database - Version 13.4.0.0.0 and later
Information in this document applies to any platform.

Symptoms

In Enterprise Manager Cloud Control, Fleet Maintenance UPDATE_DB tried to execute datapatch on standby database.

Command Snippet:

emcli db_software_maintenance -performOperation -name=Fleet -purpose=UPDATE_DB -target_type=oracle_database -target_list=ABC -normal_credential=ORACLE:SYSMAN -privilege_credential=ROOT:SYSMAN


Job Step Log :

****** Applying patches to DB**********
Version IS 19.0.0.0.0
major version is 19
Second version is 0Created the
sql file successfully
Executing the command : /u01/app/oracle/product/19.0.0/dbhome_1/bin/sqlplus / as sysdba
@/var/tmp/17507477261874735/1717873580445/script.sql
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Jun 8 20:08:40 2024
Version
19.22.0.0.0

Copyright (c) 1982, 2023, Oracle. All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 -
Production
Version 19.22.0.0.0

Connected.
BEGIN dbms_qopatch.replace_logscrpt_dirs(); END;

*
ERROR at line 1:
ORA-16000: database or pluggable
database open for read-only access
ORA-06512: at "SYS.DBMS_QOPATCH", line 1647
ORA-16000: database or pluggable database open for read-only
access
ORA-06512: at "SYS.DBMS_QOPATCH", line 1590
ORA-06512: at "SYS.DBMS_QOPATCH", line 1521
ORA-06512: at line 1


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.