Oracle Express, Go To Database Home Page problem

twins

unread,

Dec 11, 2005, 1:59:50 PM12/11/05

to

Hello,

I have downloaded Oracle Express 10G. I install it with no errors but
when I try to open the "Go To Database Home Page" I get "the page
cannot be displayed".

I have not changed anytning and try to connect to
http://127.0.0.1:8080/htmldb

I use WinXP sp2. I have tried using different regional settings
(Engilsh US is one of them) with no luck. I dont use a local FW. When I
run a netstat -a I see that the system does not listen to port 8080.

Any Idéas why this does not work or how I can fix the problem?

Thanks!

Message has been deleted

Mark Townsend

unread,

Dec 11, 2005, 5:59:42 PM12/11/05

to twins

There are multiple causes for this problem. I suggest you register and
logon to the XE forum on OTN for help.

Some things to check
1) Is the database actually started ?

From the SQL Command Line, type the following (as the user you
installed the database as)

connect / as sysdba;

If you get 'Connected', check the database is open with the following query
select count(*) from hr.employees;

If you get 'Connected to an idle instance', type
startup;
Once the database is started, type the query above to see if the
database opened correctly

Any problems please report them on the forum

2) What port is XE listening on for http requests ? (Type the command
lsnrctl status from the DOS command line)

twins

unread,

Dec 12, 2005, 3:27:20 AM12/12/05

to

1) I tried the sql query on the DB and it worked fine
O/P
SQL> select count(8) from hr.employees;

COUNT(8)
----------
107

2)

C:\Documents and Settings\Roshan>lsnrctl

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Beta on 12-DEC-2005
08:20:34

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> help
The following operations are available
An asterisk (*) denotes a modifier or extended command:

start stop status
services version reload
save_config trace change_password
quit exit set*
show*

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version
10.2.0.1.0 - Beta
Start Date 11-DEC-2005 16:42:54
Uptime 0 days 15 hr. 38 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File
C:\oraclexe\app\oracle\product\10.2.0\server\network\a
dmin\listener.ora
Listener Log File
C:\oraclexe\app\oracle\product\10.2.0\server\network\l
og\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Link)(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
LSNRCTL>

I still cant get to the home page. Please do let me know what the
problem is?
Thanks

Turkbear

unread,

Dec 12, 2005, 9:47:38 AM12/12/05

to

"twins" <rohan...@gmail.com> wrote:

Is the Oracle HTTP service installed and running ( or ANY http ?).On what port?
Do you have any other web server running on that machine ( IIS, Apache, etc)..

Mark Townsend

unread,

Dec 12, 2005, 10:56:58 AM12/12/05

to

twins wrote:

Cool - so the database is up. It's not showing up (registering) in the
listener however. Try the following

From the SQL Command Line, as the user you installed Oracle as, type

connect / as sysdba;
alter system register;

Then from the DOS command line, type lsnrctl status again

We are looking to see an entry in the listener status that says that the
service XE is available, and also to see an entry for which port the
database is using to listern for HTTP requests on - it should be 8080

Mark Townsend

unread,

Dec 12, 2005, 10:58:07 AM12/12/05

to

Turkbear wrote:

Oracle Database XE comes with it's own built in http listener. It
doesn't need an external one (although one can be used). The problem so
far for the OP is that the database is not registering with the
listener. Once it does we will see entry's for both TCP/IP and HTTP.

twins

unread,

Dec 12, 2005, 1:25:08 PM12/12/05

to

I tried the following

1)
SQL*Plus: Release 10.2.0.1.0 - Beta on Mon Dec 12 18:21:44 2005

SQL> connect
Enter user-name: system
Enter password:
Connected.
SQL> alter system register;

System altered.

SQL>

2)
C:\Documents and Settings\Roshan>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Beta on 12-DEC-2005

18:23:09

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))

STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version
10.2.0.1.0 - Beta

Start Date 12-DEC-2005 10:07:05
Uptime 0 days 8 hr. 16 min. 8 sec

Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File
C:\oraclexe\app\oracle\product\10.2.0\server\network\a
dmin\listener.ora
Listener Log File
C:\oraclexe\app\oracle\product\10.2.0\server\network\l
og\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Link)(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

It still doesnt show me anything on the internet explorer address
http://127.0.0.1:8080/htmldb (Cannot find server)
A little sad that couldnt get started with Oracle yet :(

Turkbear

unread,

Dec 12, 2005, 2:28:26 PM12/12/05

to

Mark Townsend <markbt...@comcast.net> wrote:

But, IIRC, the http service is still a windows service and may need to be started - if it is set to autostart and does not,
then there is some problem that needs to be resolved ( probably will have entries in the event log)

It sounds like, from the OP's messages, that he does not have any http service running at 8080..

Twins: Try just connecting to http://localhost:8080

Or use your PCs actual IP address or name

HansF

unread,

Dec 12, 2005, 7:33:57 PM12/12/05

to

The http service is actually dbms_epg running in the database. It
tells the Oracle listener to monitor for connection requests on a port
(8080).

In sqlplus, you want to run

select gethttpport() from dual;

to determine the port that should be used for http requests.

OP's problem is either something is intercepting the port, the listener
is not aware which port is to be used, or epg is not responding to the
listener requests for connection.

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** Top posting [replies] guarantees I won't respond. ***

Norman Dunbar

unread,

Dec 14, 2005, 3:49:45 PM12/14/05

to

I've has a similar problem just today.

The installation is broken on Windows - especially if you are using the
new improved installer whihc installs on systems with slightly less that
256 Mb RAM.

The logs directory (c:\oracleex\<something>\config\logs - if I remember
correctly) will show problems in the log for postscripts.log and
postDBCreation.log I suspect.

My problems were as folows :

cannot access the database home page PLUS
cannot restart the database after shutting it down.

What I found was that there is a bug in ex.sql where the call to 'host'
to create the initXE.ora file is found. This call has a '/' instead of a
'\' in the spfile = full_path_to_spfile line.

Also, in postscripts.sql (or PostDBCreation.sql - I'm away from the
Windows stuff at the moment) fails to create the spfile as there is a
similar '/' rather than a '\' in it.

Being unable to restart the database after creating the spfile causes
most of the latter half of postscripts.sql and postDBCreation.sql to fail.

There is also a missing script - something like dbmsmml.sql - which
cannot be run as it (obviously) isn't there.

The fix is to proceed as follows :

run sqlplus command line
login a sys/password as sysdba
create spfile='path_to_dbs\spfile.ora' from pfile;
shutdown database
login as sys again
startup

Go through postscripts.sql and postDBCreation.sql line by line.

http:127.0.0.1:8080/htmldb should then work.

Good luck.

Cheers,
Norm.

Mark Townsend

unread,

Dec 14, 2005, 2:57:11 AM12/14/05

to

Norman Dunbar wrote:

Norman - can you post either here or on the OTN forum (or to my email)
the exact problems you found. I don't think we have a problem with a /
vs a \ in the spfile, as we have literally had tens of thousands of
installs of the beta on Windows platforms, and are seeing less than a
10% failure rate. And the 1 in 10 that are failing are boiling down to a
few well understood problems that we have since fixed. To date I have
seen nothing like what you have described, so want to get to the bottom
of it (preferably before we go production :-) )

norman...@lfs.co.uk

unread,

Dec 14, 2005, 3:41:03 AM12/14/05

to

Hi Mark,

I'll post here later on, but I have a zip of my logfiles ready and
waiting. If you want them, drop me an email with your email details
please to :

Norman dot dunbar at environment hyphen agency dot gov dot uk

please and I'll send them over.

Cheers,
Norm.

norman...@lfs.co.uk

unread,

Dec 14, 2005, 6:31:39 AM12/14/05

to

Ok Mark, here are the grusome details :

Fresh download of the latest Windows version of XE.
Clean install onto Windows 200 SP4 with 256 Mb RAM (minus about 6M for
Graphics card etc.).
Only Oracle 9i client installed on this PC.

The installer runs, asks requisite questions etc. I only have to change
the port for the recovery service as the 9i client has hogged the
default port. I accept the offered port number.

Installer finishes and offers me the chance to connect to the database
home page - I accept. Explorer comes up and shows a load of text about
the ftp port being wrong etc etc. There is nothing there the resembles
the expected page.

Check services and all are running except the JobScheduler which is
disabled.

Try to connect via the SQLPlus option on start | programs | Oracle
Database 10g Express edition. Connect sys/password as sysdba and I get
connected to an idle instance. Startup fails - cannot find the spfile.

Check through the logs in
C:\oraclexe\app\oracle\product\10.2.0\server\config\log and find the
following :

BEGIN POSTSCRIPTS.LOG CONTENTS :

SQL>
@C:\oraclexe\app\oracle\product\10.2.0\server\rdbms\admin\dbmssml.sql;
SP2-0310: unable to open file
"C:\oraclexe\app\oracle\product\10.2.0\server\rdbms\admin\dbmssml.sql"

SQL>
@C:\oraclexe\app\oracle\product\10.2.0\server\rdbms\admin\dbmsclr.plb;

SQL> DROP PUBLIC DATABASE LINK DBMS_CLRDBLINK;
Database link dropped.

Directory created.
PL/SQL procedure successfully completed.
Commit complete.

timing for: Load Start
Elapsed: 00:00:09.12

Directory dropped.
PL/SQL procedure successfully completed.
Commit complete.

ERROR:
ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.
SP2-0640: Not connected
SP2-0641: "EXECUTE" requires connection to server
SP2-0640: Not connected

END POSTSCRIPTS.LOG CONTENTS

Now, the connection to SYS as sysdba has failed here for some reason,
whihc is unusual as the scriopt has connected a couple of times using
the same password already. The PostDBCreation.sql then runs as follows
:

BEGIN POSTDBCREATION.LOG CONTENTS

SQL> connect "SYS"/"&&sysPassword" as SYSDBA
ERROR:
ORA-01017: invalid username/password; logon denied

SQL> set echo on
SQL> //create or replace directory DB_BACKUPS as
'C:\oraclexe\app\oracle\flash_recovery_area';
SP2-0640: Not connected

SQL> begin
2 dbms_xdb.sethttpport('8080');
3 dbms_xdb.setftpport('0');
4 end;
5 /
SP2-0640: Not connected

SQL> create
spfile='C:\oraclexe\app\oracle\product\10.2.0\server\dbs/spfileXE.ora'
FROM
pfile='C:\oraclexe\app\oracle\product\10.2.0\server\config\scripts\init.ora';
SP2-0640: Not connected

SQL> shutdown immediate;
ORA-01012: not logged on

SQL> connect "SYS"/"&&sysPassword" as SYSDBA
ERROR:
ORA-01017: invalid username/password; logon denied

SQL> startup ;
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file
'C:\oraclexe\app\oracle\product\10.2.0\server\dbs/spfileXE.ora'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

SQL> select 'utl_recomp_begin: ' || to_char(sysdate, 'HH:MI:SS') from
dual;
SP2-0640: Not connected

SQL> execute utl_recomp.recomp_serial();
SP2-0640: Not connected
SP2-0641: "EXECUTE" requires connection to server

SQL> select 'utl_recomp_end: ' || to_char(sysdate, 'HH:MI:SS') from
dual;
SP2-0640: Not connected

SQL> alter user hr password expire account lock;
SP2-0640: Not connected

SQL> alter user ctxsys password expire account lock;
SP2-0640: Not connected

SQL> alter user outln password expire account lock;
SP2-0640: Not connected

SQL> spool off;

END POSTDBCREATION.LOG CONTENTS

So the connection failed, the startup failed - the spfile was never
created within the script. This is *not* as I reported last night, due
to the '/' in the filename (whihc can be seen above) as I have
subsequently tested a creation with a mix of separators and the file
was created fine.

I have managed to get the system up and running and followed the
'getting started guide' quite happily simply by starting up the
database and running the failed parts of the two scripts identified
above.

Cheers,
Norm.

twins

unread,

Dec 14, 2005, 1:12:33 PM12/14/05

to

HI Guys,

I still cant get to the hompage using the "Go To Database Home Page"
shortcut on the Database.
I tried to reinstall the DB and still it doesnt work. There were no
error messages.
also tried localhost and 127.0.0.1 as the Ip still doesnt work.

Any more ideas?

Norman Dunbar

unread,

Dec 14, 2005, 2:56:14 PM12/14/05

to

twins wrote:
> HI Guys,

Hi Twins,

>
> I still cant get to the hompage using the "Go To Database Home Page"
> shortcut on the Database.
> I tried to reinstall the DB and still it doesnt work. There were no
> error messages.

Do you mean the installer didn't show any errors, or, there were no
errors in the logs directory ?

If the former, then go to
c:\oraclexe\app\oracle\product\10.2.0\server\config\logs (I think) and
check the log files in there. There may be problems as per one of my
previous posts.

If you mean the latter then is the database up and running ?

Are the services in Control Panel running (the
Oracle<something>JobScheduler service will be disabled - don't worry)
but the database, listener and MTS(?) recovery services should all be
running.

Other then that, I've got no idea at present - I only got mine working
after going through postScripts.sql (and .log) and PostDBCreation.sql
(and log) and running all the commands as SYS as SYSDBA.

Have you tried stopping and starting the database using the entries
under Start | programs | Oracle database 10G Express Edition ?

If, as mine did, it refuses to start then you have a problem - possibly
the same as mine.

> also tried localhost and 127.0.0.1 as the Ip still doesnt work.
>
> Any more ideas?
>

See above !

Mine works ok on http://127.0.0.1/htmldb.

Cheers,
Norman.

Mark Townsend

unread,

Dec 15, 2005, 12:20:01 AM12/15/05

to twins

With the listener started (lsnrctl start from the DOS command line)
please provide the following info

From the DOS cmd line
1) The output of lsnrctl status
2) The output of netstat -a

From the SQL command line, the output of
connect / as sysdba;
select dbms_xdb.gethttpport() from dual;

Make sure this machine is not on the internet as the netstat -a output
could provide readers with information that could compromise your
system. If you are concerned about this please register for the XE forum
on OTN, where you can post the output securely (to an upload site, not
to the OTN forum).