Today I was installing Oracle XE 10g on windows 2008.
The installation was successful without any error or any warning. But after clicking on FINISH, the apex page was not found.
I checked the services of oracle & seen that all services are STOP.
I started all the services of oracle.
For servies, Goto Windows+R> Type "services.msc"> right click on service name & click START.
then i tried to test it manually & enter into sqlplus.
After logging in " /as sysdba" i got an error
Enter user-name: /as sysdba
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file 'C:\oraclexe\app\oracle\product\10.2.0\serv
er\dbs/spfileXE.ora'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
I also noticed that BIN folder is empty & no CTRL file, no LOG file, no DBF's in oradata folder.
It did not created database too.
Then i re-install it after removing it completely, re-installation is successful again. Even after successful re-installing there is no files in BIN folder & again no CTRL file, no LOG file, no DBF's in oradata folder, Also database has not been created again.
After too much struggle i came to know that there is compatibility issue of Oracle XE with windows server 2008 and some of the rights issue too.
This is the tip to make it work.
1. Go to the installer OracleXEUniv.exe
2. Right click --> Select Properties --> Compatibility --> click on Run this program in Compatibility Mode for: --> Windows 2003 Sp1
3. Run this OracleXEUniv.exe file as administrator.
After running this OracleXEUniv.exe you will notice that setup is taking more time to install that means its creating database too.
Remember to double check that everything works fine. This solution works for me.
Extra Tips:
Here are some common issues which can make barrier to install XE.
1) XE dump must be on local machine, not on network path.
2) XE must be installed by a local machine administrator, not a domain administrator.
3) XE requires several ports (1521, 8080) .
4) Firewalls and antivirus are known to crash the install.
5) Often point 3) will block the installation of the database.
Note that XE does not use any form of HTTP listener - the database listener does the basic work and passes HTTP requests into the database. So no Apache or IIS requires with XE
Your suggestions and queries are always warm welcomed.
