I just installed OracleXE on a computer running windows small business server 2008. Everything installed just fine using the defaults, but when I try to access the database home page, I get a page cannot be displayed error. When I choose 'diagnose connection problems' on the error page, it tells me "'127.0.0.1' is not setup to establish a connection on port '8080' with this computer."
Has anybody else ran into this before?
Yes. Many times.
Perhaps the installer has not completed all its tasks, the database is not up, and/or the listener are not running. If the installer doesn't quite get your host particulars correct, Apex pages will not work.
Is the listener running? If its not running the Apex pages have no chance of working. In a command box, try:
If Apex is running you will see the presentation http entry for 8080 under the Endpoints. If that is not present, the "home page" is not going to work.
Step Two, is the database running, same thing, if the database is down there is no chance the Apex pages will work.
... password ...
I don't recall the installer saying anything was wrong. The listener is running, and according to windows the Oracle service is running, but when I try to login as system, I get the following:
ORA-01034: ORACLE not available
ORA- 27101: shared memory realm does not exist.
Most likely installer didn't get to finish creating and starting up the database.
And usually installer won't give much indication when it does. There is a log file for the installer, but finding useful information in the installer log can be frustratingly difficult.
Try a startup in a command box:
connect /as sysdba;
... connected to idle instance ...
... -- will probably fail, usually it reports a controlfile problem ...
Try the uninstall steps at http://docs.oracle.com/cd/E17781_01/install.112/e18803/toc.htm#CIHDDHJD then give it another go.
And verify your NIC configuration. If you have a wireless adapter, VPN interface, virtual box network device, or other interfaces besides your "main" IP address in the Networks applet, disable them until after the installer completes.
When I did the startup command, this is what it gave me:
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file 'C:\oraclexe\app\oracle\product\10.2.0\serv
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'm going to try to uninstall and reinstall today. The computer may very well have a wireless adapter - it's sitting in the spare bedroom at my lead developer's house, and I'm remoting into it. So if it fails a second time I may just have to let him handle it. :)
I'll let you know what happens - thanks for your assistance so far.
Well, after uninstalling and re-installing, the database and tns listener were not even running. I think I may have to turn this one over to my lead dev - just because he's there and knows the box better than me.
Like it states in the documentation, "You must be part of the Administrators group on Windows to install Oracle Database XE." see http://docs.oracle.com/cd/E17781_01/install.112/e18803/toc.htm#BABIHEJC in the "Permission Requirement ..." section.
Check the local Administrators group, in Start/Run lusrmgr.msc the Local Users and Groups applet. The user running the installer has to be an admin, to set up the services and other tasks. If that requirement isn't satisfied the installer experience will be ... very unsatisfactory.
If you didn't get an ora-12560 protocol error with a connect /as sysdba; the windows database service was running. As far as the extra NIC adaptor, that can cause glitches for Apex but the database install and setup has to work first.
Apparently I was not a network administrator - I was just a standard user with administrative links. So I changed myself to a network administrator (apparently one of my links gave me the authority to do that :) ) So then I uninstalled Oracle and re-installed it and... no luck - same issue.
It was an ORA-12560 error.
Guideline here, what does one do with the PDC and the backup DCs? Ensure they are Up. And Nothing Else.
The server admins ought to be rather upset at non-DC software installs on the DCs. Outside of ensuring the domain services stuff is running, nothing else should be happening to a DC. Yes, it would be good to find a different host for trying out XE (or any other software) ...
I agree it would be a very dumb idea in any normal company, but we're very small - 3 guys. The domain controller is also the web server as well as test bed server. It's the latter usage where Oracle comes in. The user's are wanting to remote to the machine and run our app against Oracle in a test setting.