Just a week back we upgraded two of our development laptops to Windows 8.1 64bit PRO, which were having Oracle 10g 10.2.0.3.0 locally installed.
Once after the upgrade, we realized that the Windows services panel totally missing the entries for Oracle services (yes WTF from our end as well)
There is a question thrown at http://stackoverflow.com/questions/19533791/not-able-to-see-oracle-services-in-windows-services-after-upgrading-to-win-8-1
which is yet to receive any answers. We were in the same situation and started our experiments to find a solution.
Without boring you with details, here is the complete solution
Re-configure your listener, do not delete, just re-configure using the GUI. This will re-create the Windows service for listener.
Use oradim to create a new service (Please note, this scenario is strictly for creating services while they are missing, if you want to recreate services which are already available, YOU must drop them)
From an elevated command prompt
set ORACLE_SID=<SID>
D:\oracle\product\10.2.0\db_1>oradim -new -sid %ORACLE_SID% -intpwd PASSWORD -st
artmode M -pfile D:\oracle\product\10.2.0\admin\sct\pfile\init.ora
There is a high possibility that you may find the init.ora file like following
D:\oracle\product\10.2.0\admin\sct\pfile>dir
Volume in drive D is New Volume
Volume Serial Number is 866B-F095
Directory of D:\oracle\product\10.2.0\admin\sct\pfile
10/31/2013 12:31 PM <DIR> .
10/31/2013 12:31 PM <DIR> ..
02/18/2013 09:24 AM 2,613 init.ora
02/18/2013 09:24 AM 2,613 init.ora.11820139272
10/31/2013 12:31 PM 745 sqlnet.log
3 File(s) 5,971 bytes
2 Dir(s) 97,706,209,280 bytes free
D:\oracle\product\10.2.0\admin\sct\pfile>
just copy the init.ora.NNNNNNNNNNN file to init.ora
Now start registry edit. This is required for the situation when you will notice the database service you have just created starts, however will not mount the database.
Navigate to
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE\KEY_OraDb10g_home1
(We are using Windows 8.1 64bit)
By the right side details panel, find the key “ORA_<SID>_AUTOSTART” which will have a value “FALSE”. Change this value to “TRUE” and get back to Windows services panel and start the database service.
That’s all folks
if you are not cursed, the Oracle database service must start, mount the database without any troubles.
referenced threads: https://forums.oracle.com/thread/541840
http://www.dba-oracle.com/tips_oradim_utility.htm
For Windows7bugs
raj