{"id":298,"date":"2025-12-17T09:14:47","date_gmt":"2025-12-17T08:14:47","guid":{"rendered":"https:\/\/oracledba.fr\/?p=298"},"modified":"2026-03-02T09:02:53","modified_gmt":"2026-03-02T08:02:53","slug":"unsupported-named-object-type-for-bind-parameter-at-sqlpatch-pm-line-6072","status":"publish","type":"post","link":"https:\/\/oracledba.fr\/?p=298","title":{"rendered":"Unsupported named object type for bind parameter at sqlpatch.pm line 6072"},"content":{"rendered":"\n

When running datapatch on your database you may encounter this error:<\/p>\n\n\n\n

Adding patches to installation queue and performing prereq checks\u2026done
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED PDB1 PDB2 PDB3
The following interim patches will be rolled back:
37102264 (OJVM RELEASE UPDATE: 19.26.0.0.250121 (37102264))
26749785 (PERF_DIAG NEED TO HAVE MORE CONTROL IN DICTIONARY FOR AUTO_STATS_ADVISOR_TASK)
27605010 (DST UPGRADE SLOW (BEGIN_UPGRADE AND UPGRADE_DATABASE) EVEN WITH PATCH 19704999)
37470729 (DATAPUMP BUNDLE PATCH 19.26.0.0.0)
Patch 38291812 (Database Release Update : 19.29.0.0.251021 (38291812)):
Apply from 19.26.0.0.0 Release_Update 250122025807 to 19.29.0.0.0 Release_Update 251018113041
The following interim patches will be applied:
38194382 (OJVM RELEASE UPDATE: 19.29.0.0.251021 (38194382))
38535360 (DATAPUMP BUNDLE PATCH 19.29.0.0.0)

Unsupported named object type for bind parameter at \/oracle\/app\/oracle\/product\/19.29.0.0.251021-214\/sqlpatch\/sqlpatch.pm line 6072.<\/pre>\n\n\n\n
This error happens because one TEMP tablespace is missing a tempfile or have a tempfile corrupt.<\/p>\n\n\n\n
Lets find out which database is missing a tempfile.<\/p>\n\n\n\n
SQL> show pdbs;\n\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\n---------- ------------------------------ ---------- ----------\n         2 PDB$SEED                       READ ONLY  NO\n         3 PDB1                      READ WRITE NO\n         5 PDB2                      READ WRITE NO\n         7 PDB3                      READ WRITE NO\n\nSQL> select distinct CON_ID from cdb_temp_files;\n\n    CON_ID\n----------\n         7\n         1\n         3\n<\/code><\/pre>\n\n\n\n
We can see that a tempfile is missing from our PDB number 5.<\/p>\n\n\n\n
SQL> alter session set container=PDB2;\n\nSession altered.\n\n\nSQL> select name from v$tempfile;\n\nNAME\n-----------------------------------------------------------------------------\n+DATA3\/CDBPRE3A\/3C166BEB280301E4E063AC131CAE7139\/TEMPFILE\/temp.315.1208871765\n<\/code><\/pre>\n\n\n\n
so we have a file. Lets try to add a new one on the tablespace<\/p>\n\n\n\n
SQL> alter tablespace temp add tempfile;\nalter tablespace temp add tempfile\n*\nERROR at line 1:\nORA-01122: database file 207 failed verification check\nORA-01110: data file 207: '+DATA\/CDB3A\/4D277CFC391410F5F174BD242DBF8240\/TEMPFILE\/temp.315.1208871765'\nORA-01203: wrong incarnation of this file - wrong creation SCN<\/code><\/pre>\n\n\n\n
So our tempfile is from an old incarnation. We can see the same error on the alert log. To fix this, we recreate a new temporary tablespace because Oracle won’t let you drop the datafile.<\/p>\n\n\n\n
SQL> create temporary tablespace temp2;\n\nTablespace created.\n\nSQL> alter database default temporary tablespace temp2;\n\nDatabase altered.\n\nSQL> drop tablespace temp including contents and datafiles;\n\nTablespace dropped.\n\nSQL> create temporary tablespace temp;\n\nTablespace created.\n\nSQL> alter database default temporary tablespace temp;\n\nDatabase altered.\n\nSQL> drop tablespace temp2 including contents and datafiles;\n\nTablespace dropped.<\/code><\/pre>\n\n\n\n
one recreated, you can rerun datapatch<\/p>\n","protected":false},"excerpt":{"rendered":"
When running datapatch on your database you may encounter this error: Adding patches to installation queue and performing prereq checks\u2026doneInstallation queue:For the following PDBs: CDB$ROOT PDB$SEED PDB1 PDB2 PDB3The following interim patches will be rolled back:37102264 (OJVM RELEASE UPDATE: 19.26.0.0.250121 (37102264))26749785 (PERF_DIAG NEED TO HAVE MORE CONTROL IN DICTIONARY FOR AUTO_STATS_ADVISOR_TASK)27605010 (DST UPGRADE SLOW (BEGIN_UPGRADE … <\/p>\n
Continue reading “Unsupported named object type for bind parameter at sqlpatch.pm line 6072”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-298","post","type-post","status-publish","format-standard","hentry","category-non-classe"],"_links":{"self":[{"href":"https:\/\/oracledba.fr\/index.php?rest_route=\/wp\/v2\/posts\/298","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oracledba.fr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracledba.fr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracledba.fr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oracledba.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=298"}],"version-history":[{"count":5,"href":"https:\/\/oracledba.fr\/index.php?rest_route=\/wp\/v2\/posts\/298\/revisions"}],"predecessor-version":[{"id":308,"href":"https:\/\/oracledba.fr\/index.php?rest_route=\/wp\/v2\/posts\/298\/revisions\/308"}],"wp:attachment":[{"href":"https:\/\/oracledba.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=298"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracledba.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=298"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracledba.fr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=298"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}