My Oracle Support Banner

EM 13c Fleet: UPDATE_DB Fails to Run Datapatch Step on Database With Error ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance (Doc ID 2699763.1)

Last updated on SEPTEMBER 01, 2021

Applies to:

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

Symptoms

EM 13c fleet command execution for UPDATE_DB

$emcli db_software_maintenance -performOperation -name="Update DB" -purpose=UPDATE_DB -target_type=oracle_database -target_list=<DB_NAME> -normal_credential="<CredName>:SYSMAN" -privilege_credential="<credentials>" -database_credential="<credentials>"

Fails with following error:

Apply PSU step failed with below error :

Step : Apply PSU/Patches on the database

Running command <DB_HOME>/bin/sqlplus / as sysdba @/tmp/1130227114464941/1596135335688/comp_status.sql >> /tmp/1130227114464941/1596135335688/<DB_NAME>_pre_patch_comp_status.txt
Error code is 0
SQL Script /tmp/1130227114464941/1596135335688/comp_status.sql Completed
Opening database in upgrade mode..
Running patch sqls..
SID is <SID NAME>
ORACLE HOME is <DB_HOME>
Script /tmp/1130227114464941/1596135335688/prepatch.sql found.
Running command <DB_HOME>/bin/sqlplus / as sysdba @/tmp/1130227114464941/1596135335688/prepatch.sql >> /tmp/1130227114464941/1596135335688/prepatch.sql.log

SQL*Plus: Release 18.0.0.0.0 - Production on Thu Jul 30 19:56:06 2020
Version 18.11.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.11.0.0.0

ORACLE instance shut down.
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 8388606240 bytes
Fixed Size 8677664 bytes
Variable Size 1476395008 bytes
Database Buffers 6878658560 bytes
Redo Buffers 24875008 bytes
Database mounted.
Database opened.
Disconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.11.0.0.0

Error code is -1 [ERROR] - Error occured while executing /tmp/1130227114464941/1596135335688/prepatch.sql

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.