Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Anyone checked out Oracle Express Edition? It's free, although limited.

3 views
Skip to first unread message

Snewber

unread,
Nov 1, 2005, 1:29:08 AM11/1/05
to

http://www.oracle.com/technology/products/database/xe/index.html

HansF

unread,
Nov 1, 2005, 3:23:56 PM11/1/05
to
On Tue, 01 Nov 2005 16:29:08 +1000, Snewber amused us by writing:

>
>
> http://www.oracle.com/technology/products/database/xe/index.html

It's working well under (fully patched) SuSE 9.3

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** Top posting guarantees I will not respond further ***

Snewber

unread,
Nov 1, 2005, 6:02:20 PM11/1/05
to
It is working great on windows as well. Very simple install and it was
straight up and running.

Jeremy

unread,
Nov 2, 2005, 12:38:01 PM11/2/05
to
In article <pan.2005.11.01....@telus.net>, HansF says...

> On Tue, 01 Nov 2005 16:29:08 +1000, Snewber amused us by writing:
>
> >
> >
> > http://www.oracle.com/technology/products/database/xe/index.html
>
> It's working well under (fully patched) SuSE 9.3
>
>

Does it include mod_plsql / http server? Cant find any refrences yet in
the doc?

--

jeremy

HansF

unread,
Nov 2, 2005, 2:44:47 PM11/2/05
to

Interesting question.

XE includes HTMLDB, and listens on an http port and it includes HTMLDB
(apparently version 2.1). Yet there is no Apache subdirectory and no
mod_plsql listed.

HTMLDB is not active until I start the database using the 'startdb.sh' in
the $ORACLE_HOME/scripts directory. That shell script does nothing other
than a traditional SQLPlus start followed by a lsnrctl start if the
database is up. But so far I don't see a database startup trigger either.

When I access http://{server}:8080 I see a directory listing. Drilling
in, I see many .gif files that are not on disk, or at least not found
using 'find' as root.

The listener does not have an entry to listen on port 8080.

And finally, only the traditional DB background processes are visible to a
"ps -ef | grep oraclexe"

Hmmmm.

Mark Townsend

unread,
Nov 3, 2005, 1:11:54 AM11/3/05
to HansF
HansF wrote:
> On Wed, 02 Nov 2005 17:38:01 +0000, Jeremy wrote:
>
>
>>In article <pan.2005.11.01....@telus.net>, HansF says...
>>
>>>On Tue, 01 Nov 2005 16:29:08 +1000, Snewber amused us by writing:
>>>
>>>
>>>>
>>>>http://www.oracle.com/technology/products/database/xe/index.html
>>>
>>>It's working well under (fully patched) SuSE 9.3
>>>
>>>
>>
>>Does it include mod_plsql / http server? Cant find any refrences yet in
>>the doc?
>
>
> Interesting question.
>
> XE includes HTMLDB, and listens on an http port and it includes HTMLDB
> (apparently version 2.1). Yet there is no Apache subdirectory and no
> mod_plsql listed.
>
> HTMLDB is not active until I start the database using the 'startdb.sh' in
> the $ORACLE_HOME/scripts directory. That shell script does nothing other
> than a traditional SQLPlus start followed by a lsnrctl start if the
> database is up. But so far I don't see a database startup trigger either.
>
> When I access http://{server}:8080 I see a directory listing. Drilling
> in, I see many .gif files that are not on disk, or at least not found
> using 'find' as root.
>
> The listener does not have an entry to listen on port 8080.
>
> And finally, only the traditional DB background processes are visible to a
> "ps -ef | grep oraclexe"
>
> Hmmmm.
>

XE uses the new built in HTTP listener and PL/SQL gateway that comes
with Oracle Database 10g Release 2. So the database is serving it;s own
HTTP requests. No Apache required (unless you want to offload or place
in a DMZ)
The GIF files you can see are for HTMLDB, and are stored in the database.

Jeremy

unread,
Nov 3, 2005, 3:23:05 AM11/3/05
to
In article <4369AA2A...@comcast.net>, Mark Townsend says...

Sounds very interesting. I am looking at the XE forum now and have come
across a thread "URL access to procedures" where someomne states that
Oracle has embedded the pl/sql gateway into the database and that you
can add your own DADs. So it suggests to me that we could potentially
ship a complete app (ours is all pl/sql via mod_plsql) with XE.

--

jeremy

Mark Townsend

unread,
Nov 3, 2005, 11:01:35 AM11/3/05
to Jeremy
Jeremy wrote:
> So it suggests to me that we could potentially
> ship a complete app (ours is all pl/sql via mod_plsql) with XE.


Sure. Enjoy :-) Note that you can also do this with any edition of
Oracle Database 10g Release 2 (i.e it's not just an XE thing)

Joel Garry

unread,
Nov 3, 2005, 5:14:27 PM11/3/05
to
How long until I get the email with the XE forum instructions? It's
been a couple of days... I expected it to be right away. What
title/author should I be expecting on the email?

jg
--
@home.com is bogus.
http://www.signonsandiego.com/uniontrib/20051102/news_1b2overland.html

HansF

unread,
Nov 3, 2005, 5:27:47 PM11/3/05
to
On Thu, 03 Nov 2005 14:14:27 -0800, Joel Garry wrote:

> How long until I get the email with the XE forum instructions? It's
> been a couple of days... I expected it to be right away. What
> title/author should I be expecting on the email?

Have you installed XE? If so, in your browser you fire up

http://{server_with_XE}:{XE-port}/htmldb

eg: http://fuzzybox:8080/htmldb

and click on the 'register' link. After that, you sign in to the otn
forums and see the XE link on the forum master page.


--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com

*** Top posting relies guarantees I won't respond. ***

Jeremy

unread,
Nov 4, 2005, 5:34:44 AM11/4/05
to
In article <436A345F...@comcast.net>, Mark Townsend says...

> Sure. Enjoy :-) Note that you can also do this with any edition of
> Oracle Database 10g Release 2 (i.e it's not just an XE thing)
>
>
Mark: are you saying that in 10g R2 there is no longer any dependency on
iAS if systems just want to use mod_plsql & http server?

thanks

--

jeremy

HansF

unread,
Nov 4, 2005, 9:33:49 AM11/4/05
to

Answering for Mark - That's right.

I've just confirmed that the XE provides an internal listener run by
DBMS_EPG and configured by DBMS_XDB packages. No external Apache, yet the
DAD and mod_plsql functionality is there, entirely in the DB.

Read the XML DB Developer's guide (10G R2) for a list of the limitations.
A few, and not horrible, but they exist.

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com

Joel Garry

unread,
Nov 4, 2005, 6:28:57 PM11/4/05
to
When I try to register, it takes me through a couple of screens ending
with one that shows:

------
Thank you for registering for the private Oracle Database XE Discussion
Forum hosted by Tom Kyte. A confirmation email containing the Forum URL
should arrive shortly.

Please note: If you have not received a confirmation email within 24
hours, please verify that the account under which you registered
contains a valid email address. If it does not, please create a new
account and then re-register.
-----
When I go to OTN, I'm still signed in with my account that I've had
since the last century. Ohhhhh... when I go to the forums, I'm a
guest. I click sign in, and now it is there on the discussion forums
page. Wow, wish they would have sent the email. This SSO stuff is too
strange.

Thanks Hans!

Whoa, can't believe they're even contemplating not allowing
archivelogged recoveries...

jg
--
@home.com is bogus.

http://www.signonsandiego.com/uniontrib/20051104/news_1b4guidant.html

amihay

unread,
Nov 5, 2005, 4:05:50 PM11/5/05
to
Does anyone has an idea , how can i take 10g2 enterprise edition +
htmldb installation and move that to work like oracle xe .
I know I need to define dad using dbms_epg , but what exact files
(like images of java scripts ) I need to put into the database (I
guess I will need to use xmldb somehow...) and to where.

I can research inside oracle xe database , but this will be a process
on trail & error . I wonder if anyone did that.


Sent via Archivaty.com

boobie

unread,
Nov 6, 2005, 10:17:35 PM11/6/05
to
dont understand ya


HansF

unread,
Nov 7, 2005, 10:40:22 AM11/7/05
to

OR ... you could read the documentation. Specifically the 10gR2 "PL/SQL
Packages and Types Reference" and "XML DB Developer's Guide"

Cris Carampa

unread,
Nov 21, 2005, 11:07:55 AM11/21/05
to
HansF wrote:

> I've just confirmed that the XE provides an internal listener run by
> DBMS_EPG and configured by DBMS_XDB packages. No external Apache, yet the
> DAD and mod_plsql functionality is there, entirely in the DB.

Hans,

are there any docs about that? I tried google, otn and asktom without
success.

Thank you. Kind regards,

--
Cris Carampa (cri...@operamail.com)
Assistente di laboratorio di Iconologia Braille
Facoltà di Irrilevanza Comparata


HansF

unread,
Nov 21, 2005, 12:54:30 PM11/21/05
to
On Mon, 21 Nov 2005 17:07:55 +0100, Cris Carampa wrote:

> HansF wrote:
>
>> I've just confirmed that the XE provides an internal listener run by
>> DBMS_EPG and configured by DBMS_XDB packages. No external Apache, yet the
>> DAD and mod_plsql functionality is there, entirely in the DB.
>
> Hans,
>
> are there any docs about that? I tried google, otn and asktom without
> success.
>
> Thank you. Kind regards,

Oracle Database 10g Release 2
'PL/SQL Supplied Packages and Procedures' manual
DBMS_EPG and DBMS_XDB sections provide the API reference

'XML DB Developer's Guide'
provides the dev overview.

Note that XE does not implement the HTTPS (yet).

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com

*** Top posting replies guarantees I won't respond. ***

Maxim Demenko

unread,
Nov 21, 2005, 2:30:39 PM11/21/05
to
HansF schrieb:

>
> Note that XE does not implement the HTTPS (yet).
>

This is correct in context of previous posts, however, i would like to
add, UTL_HTTP is available, thus HTTPS *from* XE (plsql webservices,
etc) is possible.

Best regards

Maxim

Cris Carampa

unread,
Nov 23, 2005, 5:35:34 AM11/23/05
to
HansF wrote:
>
> Oracle Database 10g Release 2
> 'PL/SQL Supplied Packages and Procedures' manual
> DBMS_EPG and DBMS_XDB sections provide the API reference

Thanks. I missed your previous reference to DBMS_EPG, so I was
investigating how to create a DAD with DBMS_XDB, obviously with no success!

Thanks to this article I quickly learned how to create a DAD with DBMS_EPG:

http://www.oracle-base.com/articles/10g/dbms_epg_10gR2.php

Now I'm trying to find a way to store database password in the DAD (just
like mod_plsql) in order to prevent the browser to ask it to the user.
Do you know if this is possibile?

Thanks again. Kind regards,

--
Cris Carampa (cri...@operamail.com)
Assistente di laboratorio di Storia della agricoltura antartica
Facoltà di Irrilevanza Comparata


Mark C. Stock

unread,
Nov 23, 2005, 9:03:38 AM11/23/05
to

"Cris Carampa" <cri...@operamail.com> wrote in message
news:4384461e$0$8476$5fc...@news.tiscali.it...

Mark C. Stock

unread,
Nov 23, 2005, 9:06:28 AM11/23/05
to

| "Cris Carampa" <cri...@operamail.com> wrote in message
news:4384461e$0$8476$5fc...@news.tiscali.it...

doc for DBMS_EPG:
http://download-east.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_epg.htm#BABFFDEH

PlsqlDatabaseUsername's equivalent is listed, but there's a note that says
"The PlsqlDatabasePassword attribute is not needed" -- haven't looked into
it yet, thoug.

++ mcs


Cris Carampa

unread,
Nov 23, 2005, 9:20:59 AM11/23/05
to
Mark C. Stock wrote:

> PlsqlDatabaseUsername's equivalent is listed, but there's a note that says
> "The PlsqlDatabasePassword attribute is not needed" -- haven't looked into
> it yet, thoug.

It's not needed because IIUC database username and password are asked by
XDB before to process the URL and pass it to EPG system, so it's not an
EPG thing, it's an XDB thing. I have to investigate further, though.

Thank you. Kind regards,

--
Cris Carampa (cri...@operamail.com)
Supplente di Lingue ugro-romanze
Facoltà di Irrilevanza Comparata


0 new messages