From:
Windows Registry Missing Autostart Attribute after In-place Upgrade of Oracle Database from 11.2.0.3 to 11.2.0.4 (document ID 19 63067.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 is 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'll need to detach old 11.2.0.3 Oracle_home first, that's where it'll delete Ora_autostart R Egistry entry.
Solution
As detach home operation is deleting registry entry, you'll need to add Ora_autostart registry entry manually after UPG Arde using below command:
Oradim-edit-sid-startmode autoreferencesnote:556610.1-Script to Collect DB upgrade/migrate Diagnostic information (dbupgdiag.sql)
"Translated from MoS article" When upgrading the db to 11.2.0.4 after using in-place upgrade, the Windows registry loses the Autostart property