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 laterInformation in this document applies to any platform.
Symptoms
In Enterprise Manager Cloud Control, Fleet Maintenance UPDATE_DB tried to execute datapatch on standby database.
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 |