My Oracle Support Banner

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 DECEMBER 02, 2020

Applies to:

Enterprise Manager for Oracle Database - Version 13.3.1.0.0 and later
Information 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

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.