Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

APEX HTTP access problems or possible listener errors

481211Jul 30 2006 — edited Aug 1 2006
Would appreshiate some assistance:

Environment: Windows 2003 Standard Server
Oracle: APEX 2.0 production
Server: IBM x206, 1G RAM, 80GB SATA HDD

We have been running system in production for 3-4 months without any real errors. Now it seems to be one.

Since 28.07 DB is not accessible over web on local and remote machine (tried "Go TO Database Home Page" from local machine.

Tryed to log in using SQLPlus [conn sys/password as sysdba] - successful:
Start up database - [startup] - database mounted and everything elso normal.

Tryed to open database from local machine - successful.

NOW

Now I am trying to log in from web interface, and empty page appears. If I am opening database home page again (Firefox can't establish a connection to the server at 127.0.0.1:8080) appears. Note: It opened a few seconds ago.

Going back to SQLPlus and trying to shut down database, using [shutdown] command, the following error message appears:

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

Checking listener status - ONLINE, everything is normal there. Trying to restart this service under Windows, the same. Everything is ok there.

Reading listener.log file and found following moment:

28-JULY-2006 22:20:15 * service_update * xe * 0
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mmserver.MMeedia)(PORT=8080))(Presentation=HTTP)(Session=RAW))
28-JULY-2006 22:21:06 * service_died * xe * 12537

Since that time, database has been down. Every time I am restarting the server, the following message appears:

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mmserver.MMeedia)(PORT=8080))(Presentation=HTTP)(Session=RAW))

but then after few minutes:

No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mmserver.MMeedia)(PORT=8080))(Presentation=HTTP)(Session=RAW))

I was thinking, that maybe I do not have enough Hard Disk Space, because Oracle is installed on smaller partitin that has approx: 500MB of free space. If that may be the issue, please inform (it's a bit tricky to free this space up without any real reason).

SOME OTHER HINTS:

- when connecting conn sys/password
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

- when connecting conn sys/password as sysdba
Connected to an idle instance.

- when trying to give some command, like:
BEGIN dbms_xdb.sethttpport(8000)

*
ERROR at line 1:
ORA-01034: ORACLE not available

So if anyone can give me any hints, I would appreshiate.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 29 2006
Added on Jul 30 2006
5 comments
596 views