Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Oracle XE will not come up properly

Posted on 2009-04-03
9
Medium Priority
?
1,247 Views
Last Modified: 2013-12-18
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.setListenerLocalAccess(false);
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?
0
Comment
Question by:mcorsi62
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
9 Comments
 

Author Comment

by:mcorsi62
ID: 24063359
UPDATE:

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.setListenerLocalAccess(false);

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.
0
 
LVL 48

Expert Comment

by:schwertner
ID: 24084346
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.
0
 

Author Comment

by:mcorsi62
ID: 24084418
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.
0
 
LVL 48

Accepted Solution

by:
schwertner earned 2000 total points
ID: 24085858
Of course!
To launch APEX (this is for Oracle 11g, but read the list!):


1.To enable Oracle XML DB HTTP server:
connect sys/reksreks@bugf as sysdba
EXEC DBMS_XDB.SETHTTPPORT(8080);
COMMIT;

To disable Oracle XML DB HTTP server:
EXEC DBMS_XDB.SETHTTPPORT(0);
COMMIT;


2.To configure the embedded PL/SQL gateway:
 
@ ?/apex/apxconf

login as: oracle
oracle@oralin1.bg.icw.int's password:
Last login: Fri May  9 17:22:21 2008 from shvertner.bg.icw.int
[oracle@oralin1 ~]$ mc

[oracle@oralin1 u03]$ sqlplus /nolog

SQL*Plus: Release 11.1.0.6.0 - Production on Sat May 10 12:20:23 2008

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

SQL> connect sys/reksreks@bugf as sysdba
Connected.
SQL> @ ?/apex/apxconf

      PORT
----------
      8080

Enter values below for the XDB HTTP listener port and the password for the Application Express ADMIN user.
Default values are in brackets [ ].
Press Enter to accept the default value.


Enter a password for the ADMIN user              [] reksreks
Enter a port for the XDB HTTP listener [      8080]
...changing HTTP Port

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


Session altered.

...changing password for ADMIN

PL/SQL procedure successfully completed.


Commit complete.

SQL>


3.Unlock the ANONYMOUS account:

SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;

User altered.

SQL>


4. Access Oracle Application Express

http://oralin1:8080/apex

http://oralin1:8080/apex/apex_admin   ----> Administrator Page

Administrator Page:
User: admin
pass: reksreks

Version: Application Express 3.0.1.00.08
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question