Skip to Main Content

Oracle Database Express Edition (XE)

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!

Going to Database Homepage failure

514726Jul 11 2006 — edited Jul 18 2006
Any clues why I get
"ORA-31112: fail to unregister for HTTP port using xdb configuration"
after trying
SQL> exec dbms_xdb.sethttpport(8080);

Context:
1) Troubleshooting Going to Database Homepage failure
(Firefox; no error messages; empty html source)
2) netstat -an does not show port 8080
3) Reinstalled/rebooted too many times with Zonealarm & anti-virus disabled
4) Windows 2000 SP4 ; registry cleaned of all oracle stuff before install
5) DB is up; SQL returns results from select * from hr.employees
6) LISTENER TNSLSNR reports port 1521. (See below)
But TNSLSNR does NOT report for port 8080 nor for http
Is there a 'service' for running the HTTP server, aka Ellisons' Apache
=================================================

SQL> connect / as sysdba
Connected.
SQL> exec dbms_xdb.sethttpport(8080);
BEGIN dbms_xdb.sethttpport(8080); END;

*
ERROR at line 1:
ORA-31112: fail to unregister for HTTP port using xdb configuration
ORA-06512: at "XDB.DBMS_XDB", line 382
ORA-06512: at "XDB.DBMS_XDB", line 521
ORA-06512: at line 1

================================================

Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.

C:\>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 08-JUL-2006 21:35:43

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Start Date 08-JUL-2006 20:59:37
Uptime 0 days 0 hr. 36 min. 5 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\oracleExpress\app\oracle\product\10.2.0\server\network\admin\listener.ora
Listener Log File C:\oracleExpress\app\oracle\product\10.2.0\server\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tokoloshi)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

C:\>
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 15 2006
Added on Jul 11 2006
16 comments
794 views