wurlog Asked: 2010-10-22 05:35:33 +0800 CST2010-10-22 05:35:33 +0800 CST 2010-10-22 05:35:33 +0800 CST How to find out which version of Oracle is running? 772 I have an oracle database on a windows 2003 server which i can't start. How can i find out which version it is? EDIT: Some of the oldest files are from 2003 and I dunno know if it's the original server. oracle 3 Answers Voted Benoit 2010-10-22T05:54:44+08:002010-10-22T05:54:44+08:00 Locate and launch the "Oracle Universal Installer" in your start menu. Once it will be opened, click on the "Installed products" button (bottom left). It will show you every Oracle product installed on this server and you will be able to view the version of every components. You can also run the following command in a DOS prompt: %oracle_home%\OPAtch\Opatch lsinventory It will show you the list of the components installed in this Oracle Home and their version number. Nick O'Neil 2010-10-22T05:36:49+08:002010-10-22T05:36:49+08:00 run a query select * from v$version where banner like ‘Oracle%’; **update just noticed you had mentioned that you cannot start it. Check in the application directory or the add/remove software from control panel may show the version number. Best Answer Simon Catlin 2010-10-22T10:58:57+08:002010-10-22T10:58:57+08:00 Have you checked HKLM\Software\Oracle? I thought the Oracle version was held in the oracle homes section?
Locate and launch the "Oracle Universal Installer" in your start menu. Once it will be opened, click on the "Installed products" button (bottom left).
It will show you every Oracle product installed on this server and you will be able to view the version of every components.
You can also run the following command in a DOS prompt:
It will show you the list of the components installed in this Oracle Home and their version number.
run a query select * from v$version where banner like ‘Oracle%’;
**update just noticed you had mentioned that you cannot start it. Check in the application directory or the add/remove software from control panel may show the version number.
Have you checked HKLM\Software\Oracle? I thought the Oracle version was held in the oracle homes section?