I installed Oracle 11g XE in Windows 7 x64, then Windows 8.1 (install new OS, not perform an upgrade of the previously Windows 7 x64 installation). Can be possible to install Oracle 11g XE over the existing directory to use the database that was created with Windows 7 like Postgres do when the Data Directory exists?
Oracle 11g XE – How to Install and Use Data Files from Another Instance
installationoracle-11goracle-xe
Related Solutions
Just guesswork, but do you select "Upgrade an existing database" early on:
and "advanced install" later on:
The docs do look as if they are referring to the 10g installer.
From this link:
An old ORACLE_HOME had not been deinstalled/removed correctly and the following registry information still existed:
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OracleMTSRecoveryService]
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OracleMTSRecoveryService\Protid_0]
"Name"="HTTP"
"Host"="hostname"
"Port"="49155"
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OracleMTSRecoveryService\Setup]
"NumberOfInstalls"=dword:00000001
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OracleMTSRecoveryService\Setup\All Versions]
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OracleMTSRecoveryService\Setup\All Versions\1]
"Version"="11.2.0.1.0"
"Home"="SOFTWARE\\ORACLE\\KEY_OraDb11g_home2"
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OracleMTSRecoveryService\Setup\Current Version]
"Version"="11.2.0.1.0"
"Home"="SOFTWARE\\ORACLE\\KEY_OraDb11g_home2"
Please do the following,
Verify that: the above registry keys exist in the Windows registry, and they point to an old %ORACLE_HOME% which no longer exists on the server If the registry keys do not exist or if they point to a valid %ORACLE_HOME% on the server, there is another cause for the error which needs to be investigated further. Do not perform step 2.
After verifying both of the above points, remove the above registry keys and perform the 11.2 installation again. The error should no longer occur.
Related Question
- Oracle 11g install on Debian Wheezy does not start
- PostgreSQL Upgrade – How to Perform a Minor Upgrade on Windows (e.g., 9.3.0 to 9.3.1)?
- Firebird 2.5 on Windows 8.1 – Can’t Connect to Any Database
- Oracle XE – Installation Process Overview
- How to import data into oracle 11g r2 using a `.dmp` file and a `.par` file
- Oracle 11g XE vs 18c XE – Differences and Usage Comparison
- Oracle 11g R2 – Command Line Installation Parameters
Best Answer
I see no reason you can't do this.
Typically, you would perform the following steps.
*.dbffiles found in%ORACLE_BASE%\oradata\to a safe place.%ORACLE_BASE%\fast_recovery_area\to a safe place.%ORACLE_HOME%\database\spfileXE.orato a safe place.oracle-xe configurecommand.You would also need to make sure that you specified the same settings during installation as you used with your previous database (
ORACLE_HOME,ORACLE_SID, listener port etc.), otherwise your instance won't start. Ideally I would recommend you doing silent installation with response files (described in Oracle Database Express Edition Installation Guide for Microsoft Windows). This would ensure that you've used the same settings across operating system upgrades/reinstall.