Fleet Maintenance: UPDATE_DB Fails In Apply PSU Step With Error "DBMS_QOPATCH.REPLACE_LOGSCRPT_DIRS' must be declared" For TDE Enabled Databases On Windows
(Doc ID 2732572.1)
Last updated on JULY 25, 2021
Applies to:
Enterprise Manager for Oracle Database - Version 13.3.1.0.0 and laterInformation in this document applies to any platform.
Symptoms
In Enterprise Manager Cloud Control, Fleet Maintenance UPDATE_DB on windows for TDE enabled databases fails in Apply PSU step with below error.d Databases On Windows
Command Snippet:
$ emcli db_software_maintenance -performOperation -name=Fleet -purpose=UPDATE_DB/UPDATE_RACDB -target_type=oracle_database/rac_database -target_list=ABC -normal_credential=ORACLE:SYSMAN -privilege_credential=ROOT:SYSMAN
Job Step Log:: Job Steps Log for Job :Apply PSU/Patches on the database
-----------------------------------------------------------------------------------
Applying patches to db
Version IS 18.0.0.0.0^M
major version is 18^M
Second version is 0Created the sql file successfully^M
Executing the command : C:\win_dbtgt\deploydb\obase\dbhome\bin\sqlplus.exe / as sysdba @C:\Windows\138668360555566\1599028034650\script.sql ^M
SQL*Plus: Release
18.0.0.0.0 - Production on Wed Sep 2 00:36:30 2020
Version 18.4.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Version 18.4.0.0.0
Connected.
BEGIN
dbms_qopatch.replace_logscrpt_dirs(); END;
ERROR at line 1
ORA-06550: line 1, column 7: PLS-00201: identifier 'DBMS_QOPATCH.REPLACE_LOGSCRPT_DIRS' must be declared
ORA-06550: line 1, column 7:PL/SQL: Statement ignored
Disconnected from Oracle Database
$ emcli db_software_maintenance -performOperation -name=Fleet -purpose=UPDATE_DB/UPDATE_RACDB -target_type=oracle_database/rac_database -target_list=ABC -normal_credential=ORACLE:SYSMAN -privilege_credential=ROOT:SYSMAN
Job Step Log:: Job Steps Log for Job :Apply PSU/Patches on the database
-----------------------------------------------------------------------------------
Applying patches to db
Version IS 18.0.0.0.0^M
major version is 18^M
Second version is 0Created the sql file successfully^M
Executing the command : C:\win_dbtgt\deploydb\obase\dbhome\bin\sqlplus.exe / as sysdba @C:\Windows\138668360555566\1599028034650\script.sql ^M
SQL*Plus: Release
18.0.0.0.0 - Production on Wed Sep 2 00:36:30 2020
Version 18.4.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Version 18.4.0.0.0
Connected.
BEGIN
dbms_qopatch.replace_logscrpt_dirs(); END;
ERROR at line 1
ORA-06550: line 1, column 7: PLS-00201: identifier 'DBMS_QOPATCH.REPLACE_LOGSCRPT_DIRS' must be declared
ORA-06550: line 1, column 7:PL/SQL: Statement ignored
Disconnected from Oracle Database
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |