mcorsi62
asked on
Oracle XE will not come up properly
I have installed the free version of Oracle (10G) onto my REHL 5 system. Everything installed without a hitch (other than having to increase my swap space). Then .... nothing.
I cannot connect to the web page http://127.0.0.1/apex . So I looked around and I found this buried entry:
" With the production version of Oracle XE the default is to not allow remote access to the web server. This sometimes causes even local access to not work. To fix run the following as sys:
exec dbms_xdb.setListenerLocalA ccess(fals e);
Access to the web server will now be enabled."
So now I want to log into sqlplus to run that command. After setting up ORACLE_HOME, ORACLE_SID AND ORACLE_BASE in my bash profile - because sqlplus will not start without these manual entries - I receive the following error message when loging into sqlplus:
">sqlplus system
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 3 14:25:59 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist"
Anyone have any idea what the next step is or how to proceed from here?
I cannot connect to the web page http://127.0.0.1/apex . So I looked around and I found this buried entry:
" With the production version of Oracle XE the default is to not allow remote access to the web server. This sometimes causes even local access to not work. To fix run the following as sys:
exec dbms_xdb.setListenerLocalA
Access to the web server will now be enabled."
So now I want to log into sqlplus to run that command. After setting up ORACLE_HOME, ORACLE_SID AND ORACLE_BASE in my bash profile - because sqlplus will not start without these manual entries - I receive the following error message when loging into sqlplus:
">sqlplus system
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 3 14:25:59 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist"
Anyone have any idea what the next step is or how to proceed from here?
To see what you have done check first if the firewall is off.
If you have installed the product by rinning firewall you have to do
the installation again.
After that go to Control Panel ---> administrative Tools ---> Services
and check if the Listener and the Oracle service are running.
start them.
Check the listener from command prompt:
lsnrctl status
lsnrctl services
Now try to logon using SQL*Plus.
If you have installed the product by rinning firewall you have to do
the installation again.
After that go to Control Panel ---> administrative Tools ---> Services
and check if the Listener and the Oracle service are running.
start them.
Check the listener from command prompt:
lsnrctl status
lsnrctl services
Now try to logon using SQL*Plus.
ASKER
Couple of things.....
This is a linux machine. I think your directions are for windows, but I am not in front of my box right now so maybe I am wrong and Red Hat added the GUI tools you mentioned. (I am a command line kind of guy for the most part).
... and yes, the listener is running and I am now able to log into SQL *Plus. However, the web based tool:
http://127.0.0.1/apex is still unavailable. The page will not load.
Also, I am on the machine itself, so I am not sure what your question about the firewall being off means. This server runs other externally available services including HTTP, SMTP, POP etc... and these are all available both on the machine as well as remotely.
This is a linux machine. I think your directions are for windows, but I am not in front of my box right now so maybe I am wrong and Red Hat added the GUI tools you mentioned. (I am a command line kind of guy for the most part).
... and yes, the listener is running and I am now able to log into SQL *Plus. However, the web based tool:
http://127.0.0.1/apex is still unavailable. The page will not load.
Also, I am on the machine itself, so I am not sure what your question about the firewall being off means. This server runs other externally available services including HTTP, SMTP, POP etc... and these are all available both on the machine as well as remotely.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I can now get into sqlplus (the SID is not the normal oracle default ORCL it is XE), however their webbased admin tool still refuses to launch. (Even though I ran the stored procdure :
exec dbms_xdb.setListenerLocalA
Any ideas? Does anyone know where I can find an error log that might give me some more information? From the command line, everthing appears to be honky dory. The page simply will not load.