My Oracle Support Banner

datapatch on Windows fails with error:"ORA-20000: Unable to analyze TABLE <table_name>" (Doc ID 2451838.1)

Last updated on SEPTEMBER 28, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Microsoft Windows x64 (64-bit)

Symptoms

Receiving the following issue during Datapatch execution :

The following patches will be applied:
27162953 (WINDOWS DB BUNDLE PATCH 12.1.0.2.180116 (64bit): 27162953)
DBD :: Oracle :: db do failed: ORA-16000: database or integrable database for
read-only access opened
ORA-06512: in "SYS.DBMS_SQLPATCH", line 253
ORA-06512: in line 1 (DBD ERROR: OCIStmtExecute) [for Statement "BEGIN
dbms_sqlpatch.clear_state; END; "]

 

D:\oracle\12102\OPatch>
D:\oracle\12102\OPatch>datapatch -apply 25632533 -pdbs PDB1,PDB2 -force -bundle_series DBBP
SQL Patching tool version 12.1.0.2.0 Production on Mon May 14 17:50:29 2018
Copyright (c) 2012, 2018, Oracle. All rights reserved.

Connecting to database...OK
Note: Datapatch will only apply or rollback SQL fixes for PDBs
that are in an open state, no patches will be applied to closed PDBs.
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)
Determining current state...done
Adding patches to installation queue and performing prereq checks...done
Installation queue:
For the following PDBs: PDB1 PDB2
Nothing to roll back
The following patches will be applied:
25632533 (WINDOWS DB BUNDLE PATCH 12.1.0.2.170418(64bit):25632533)

Installing patches...
Patch installation complete. Total patches installed: 1

Validating logfiles...
Patch 25632533 apply (pdb ): WITH ERRORS
logfile: D:\oracle\cfgtoollogs\sqlpatch\25632533\21160653/25632533_apply_2018Mai14_17_50_30.log (errors)
Error at line 106351: ORA-20000: Unable to analyze TABLE "SYS"."AW$", insufficient privileges or does
Error at line 106362: ORA-20000: Unable to analyze TABLE "SYS"."PS$", insufficient privileges or does
Error at line 106373: ORA-20000: Unable to analyze TABLE "SYS"."AW_OBJ$", insufficient privileges or
Error at line 106384: ORA-20000: Unable to analyze TABLE "SYS"."AW_PROP$", insufficient privileges or

 

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


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