Objective: Upgrade Oracle database from 11.2.0.4 to 12.2.0.1 During the Oracle database upgrade process from 11.2.0.4 to 12.2.0.1 (Standard Edition), running on Windows Server 2012 R2 64bit, the following error was found while executing the
dbupgrade script.
C:>dbupgrade LOG FILES: (catupgrd*.log) exec_DB_script: catupgrd_catcon_6380_exec_DB_script.done did not need to be deleted before running a script open2: IO::Pipe: Can't spawn-NOWAIT: Resource temporarily unavailable at catcon.pm line 715. END failed--call queue aborted at catctl.pl line 1296.The error is related to parallelism; by default, dbupgrade runs in parallel to speed up the process, but this is just allowed on Oracle Enterprise Edition and not on Standard Edition. The following document explains the details about that script. https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/upgrading-parallel-upgrade-utility-catctl-pl.html#GUID-C667B51C-058F-48B6-86FE-12E9D82FDDBD In order to bypass the error, the script can be executed using just one process using the command "dbupgrade -n 1". It took around 50 minutes to complete successfully.
On this page
Share this
Share this
How to Fix the “Triggers on Memory-Optimized Tables Must Use WITH NATIVE_COMPILATION” Azure SQL Data Sync Error
How to Fix the “Triggers on Memory-Optimized Tables Must Use WITH NATIVE_COMPILATION” Azure SQL Data Sync Error
Jul 21, 2022 12:00:00 AM
1
min read
Unveiling the Power of Multi-IP Addresses in SQL Server Always On Listener
Unveiling the Power of Multi-IP Addresses in SQL Server Always On Listener
Jan 26, 2024 8:32:52 AM
5
min read
MSDTC and configuration details for cluster/Always On
MSDTC and configuration details for cluster/Always On
Oct 24, 2022 12:00:00 AM
8
min read
.svg){kind=small}
.svg){kind=small}