【翻译自mos文章】当使用原地升级的方法将db升级到11.2.0.4之后,windows注册表丢失autostart属性

来源:互联网 发布:vs2013怎么用c语言 编辑:程序博客网 时间:2024/04/20 07:31

来源于:

Windows Registry Missing Autostart Attribute after In-Place Upgrade of Oracle Database from 11.2.0.3 to 11.2.0.4 (文档 ID 1963067.1)

APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.2.0.1.0 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

SYMPTOMS

The database auto start attribute in windows registry was removed on upgrade of Oracle database from 11.2.0.3 to 11.2.0.4 (In place upgrade). This prevents Oracle Database to restart on reboot of the system.

CAUSE

For In-place upgrade you will need to detach old 11.2.0.3 ORACLE_HOME first , that is where it will delete ORA_AUTOSTART registry entry.
 

SOLUTION

As detach home operation is deleting registry entry , you will need to add ORA_AUTOSTART registry entry manually after upgarde using below command:

oradim -EDIT -sid -startmode AUTO

REFERENCES

NOTE:556610.1 - Script to Collect DB Upgrade/Migrate Diagnostic Information (dbupgdiag.sql)

0 0