首页 > 学院 > 开发设计 > 正文

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

2019-11-09 13:34:09
字体:
来源:转载
供稿:网友
在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 anyopen2: 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 OracleServiceC:/> 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/adminC:/> %ORACLE_HOME%/perl/bin/perl catctl.pl -n 6 -l %ORACLE_HOME%/diagnostics catupgrd.sql
发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表