I’ve been working with the Oracle Express Edition for 32 bit environments for long, as it is easy to have the features of an Oracle Enterprise Database without the need of installing it. However installing the Oracle Express Edition (XE) on a 64 bit is not always successful. You can get you XE work on your first installation itself if you know the trick. Oracle has not provided a separate installer of Oracle XE 11g for 64 bit, but you can download the 32 bit version and install on the 64 bit operating system. Follow the tricks below for a successful installation of Oracle XE.
1. Disable Windows Firewall / any other firewall in your system.
2. Unplug the network cable.
3. Run the installer and complete the setup.
4. Open command prompt, and execute hostname command to get the name of the system where you are installing. Assume the command produces “MySystem” as output.
5. Navigate to <drive>:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN folder. Makesure that the host name from Step 4 matches the entry in the tnsnames.ora file found under the folder. The tns entry should like the following:
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = MySystem)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
Thats is it. WOLA !!! You have made it. Your installation of Oracle XE is successful. You can plug your network cable back on, and enable the firewall.
It worked like a charm. Actually disable the network adapter is enough
Thanks a lot