在Windows平台上手工升级Oracle database到12.1时遇到的问题

在Windows平台上手工升级到12.1时遇到的问题:
参考自:
Error "....Log file directory does not exist or is not writeable.." during upgrade to 12.1 on Windows (Doc ID 2229600.1)

APPLIES TO:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]
Microsoft Windows x64 (64-bit)

SYMPTOMS

During manual upgrade of database to 12.1 on Windows platform, below error message is received -

catcon: See C:\app\b2patso3\product\12.1.0\dbhome_1\diagnostics/catupgrd_*.lst files for spool files, if any
open2: IO::Pipe: Can't spawn-NOWAIT: No such file or directory at catcon.pm line 470

  

CHANGES

 

CAUSE

 Oracle Service for source version still existed when upgrade command was executed. Upgrade should be carried on Windows only once old service is deleted and new service with target home version has been created.

 

SOLUTION

1. Delete old service -

C:\> NET STOP OracleService
C:\> ORADIM -DELETE -SID

2. Create new service from target home -

C:\> ORADIM -NEW -SID -INTPWD -STARTMODE AUTO -PFILE %ORACLE_HOME%\DATABASE\INIT.ORA

3. Now, perform the upgrade -

C:\> cd %ORACLE_HOME%\rdbms\admin
C:\> %ORACLE_HOME%\perl\bin\perl catctl.pl -n 6 -l %ORACLE_HOME%\diagnostics catupgrd.sql