Thursday, June 5, 2008

Cannot open Oracle XE database home page

Sometimes when you install Oracle XE on your desktop and try to access the home page through the internet explorer, it may not open and IE displays an error page. There are two things that seem to fix the problem

1. When you install Oracle XE on your desktop, login as local administrator instead of your company domain account. The install instruction says as long your domain account has administration rights on the computer it will work. But that's not the case when I installed XE. So I uninstalled oracle xe, logged off as domain user, logged back-in as local adminstrator.

The username for local administrator is usually "administrator." If you don't remember the password, you can just reset it by logging in as domain user.

If you are trying to open the database home from a different machine than the machine running Oracle XE, you may want to do the following

1. Make sure remote connection is allowed to this database. For that you will have to goto the machine where the database is running and change the setting. The option is available under administrative task.

2. Also make sure the firewall is not enable on machine where the database is running. If the firewall is enabled, it may block the calls to communicate with the database. Chaning the fire wall settings is very easy. Select the LAN connection properties. Click advanced tab and then click settings. Here you can enable\disable firewall.