Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 123663 - Please add Oracle XE database to portage
Summary: Please add Oracle XE database to portage
Status: CONFIRMED
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: New packages (show other bugs)
Hardware: All Linux
: High enhancement with 5 votes (vote)
Assignee: Default Assignee for New Packages
URL: http://www.oracle.com/technology/prod...
Whiteboard:
Keywords: EBUILD
Depends on:
Blocks:
 
Reported: 2006-02-21 16:12 UTC by nunogt
Modified: 2010-11-02 19:31 UTC (History)
13 users (show)

See Also:
Package list:
Runtime testing required: ---


Attachments
Tentative ebuild (oracle-xe.ebuild.tgz,4.45 KB, application/x-tgz)
2006-02-21 16:14 UTC, nunogt
Details
Fixed tentative ebuild (oracle-xe-10.2.0.1_p1.ebuild,4.00 KB, text/plain)
2006-02-22 03:27 UTC, nunogt
Details
configuration script (oracle_configure.sh,7.44 KB, application/x-shellscript)
2006-02-22 03:30 UTC, nunogt
Details
start-stop-script (oracle-xe,1.74 KB, text/plain)
2006-02-22 03:31 UTC, nunogt
Details
oracle-xe-10.2.0.1_p1.ebuild (oracle-xe-10.2.0.1_p1.ebuild,4.06 KB, text/plain)
2006-04-29 07:47 UTC, kevin
Details
files/oracle_configure.sh (oracle_configure.sh,7.45 KB, text/plain)
2006-04-29 07:48 UTC, kevin
Details
files/oracle-xe (oracle-xe,1.74 KB, text/plain)
2006-04-29 07:49 UTC, kevin
Details
/etc/env.d/99oracle (99oracle,463 bytes, text/plain)
2006-04-29 08:49 UTC, kevin
Details
oracle-xe-10.2.0.1_p1.ebuild (oracle-xe-10.2.0.1_p1.ebuild,4.00 KB, text/plain)
2006-04-30 09:48 UTC, e-spark
Details
files/oracle_configure.sh (oracle_configure.sh,8.81 KB, text/plain)
2006-04-30 09:49 UTC, e-spark
Details
files/oracle-xe (oracle-xe,1.74 KB, text/plain)
2006-04-30 09:50 UTC, e-spark
Details
files/99oracle (99oracle,431 bytes, text/plain)
2006-04-30 09:51 UTC, e-spark
Details
oracle-xe-10.2.0.1_p1.ebuild (oracle-xe-10.2.0.1_p1.ebuild,4.26 KB, text/plain)
2006-07-23 02:58 UTC, Tobias Scherbaum (RETIRED)
Details
dev-db/oracle-xe-10.2.0.1_p1-r1 (oracle-xe-10.2.0.1_p1-r1.ebuild,6.62 KB, text/plain)
2007-02-28 14:53 UTC, MT
Details
Fixed env dirs as suggested in the previous post (99oracle,440 bytes, text/plain)
2007-10-14 14:27 UTC, Stefano
Details
patched ebuild (oracle-xe-10.2.0.1_p1-r2.ebuild,6.58 KB, text/plain)
2009-10-02 19:50 UTC, Peter Triller
Details
Bug patched on high memory machines (oracle_configure.sh,8.89 KB, text/plain)
2009-10-02 19:52 UTC, Peter Triller
Details

Note You need to log in before you can comment on or make changes to this bug.
Description nunogt 2006-02-21 16:12:09 UTC
Oracle XE, the free personal version of the popular database Oracle should be added to portage.
Comment 1 nunogt 2006-02-21 16:14:17 UTC
Created attachment 80389 [details]
Tentative ebuild

Although it's not free as in freedom, the ebuild would require the user to manually download the application (thus agreeing to the licence), and merge it only after the move to /usr/portage/distfiles/ . The attached ebuild pretty much does it, although it fails in my system for some reason. Maybe someone more skilled could have a look at it. Please see http://forums.gentoo.org/viewtopic-t-397836.html
Comment 2 nunogt 2006-02-21 16:17:22 UTC
Error log:

>>> emerge (2 of 2) dev-db/oracle-xe-10.2.0.1_p1 to /
>>> md5 files   ;-) oracle-xe-10.2.0.1_p1.ebuild
>>> md5 files   ;-) files/digest-oracle-xe-10.2.0.1_p1
>>> md5 files   ;-) files/oracle_configure.sh
>>> md5 files   ;-) files/oracle-xe
>>> md5 src_uri ;-) oracle-xe-10.2.0.1-0.1.i386.rpm
>>> Unpacking source...
>>> Unpacking oracle-xe-10.2.0.1-0.1.i386.rpm
>>> Source unpacked.
>>> Test phase [not enabled]: dev-db/oracle-xe-10.2.0.1_p1

>>> Install oracle-xe-10.2.0.1_p1 into /var/tmp/portage/oracle-xe-10.2.0.1_p1/image/ category dev-db
 * Adding group 'dba' to your system ...
 *  - Groupid: next available
 * Adding user 'oraclexe' to your system ...
 *  - Userid: 106
 *  - Shell: /bin/bash
 *  - Home: /usr/lib/oracle/xe
 *  - Groups: dba
 *  - Creating /usr/lib/oracle/xe in /
/usr/local/portage/dev-db/oracle-xe/oracle-xe-10.2.0.1_p1.ebuild: line 46: bc: command not found
/usr/local/portage/dev-db/oracle-xe/oracle-xe-10.2.0.1_p1.ebuild: line 47: bc: command not found
/usr/local/portage/dev-db/oracle-xe/oracle-xe-10.2.0.1_p1.ebuild: line 48: bc: command not found
/usr/local/portage/dev-db/oracle-xe/oracle-xe-10.2.0.1_p1.ebuild: line 49: bc: command not found
/usr/local/portage/dev-db/oracle-xe/oracle-xe-10.2.0.1_p1.ebuild: line 50: [: -lt: unary operator expected
/usr/local/portage/dev-db/oracle-xe/oracle-xe-10.2.0.1_p1.ebuild: line 53: [: -lt: unary operator expected
man:
prepallstrip:
strip: i686-pc-linux-gnu-strip --strip-unneeded
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/agtctl
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/ctxkbtc
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/ctxlc
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/ctxload
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/cursize
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/dbfsize
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/dbv
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/dgmgrl
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/dumpsga
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/exp
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/expdp
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/extjob
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/extjobo
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/extproc
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/fmputl
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/fmputlhp
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/genksms
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/grdcscan
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/hsalloci
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/hsdepxa
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/hsodbc
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/hsots
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/imp
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/impdp
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/kfod
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/kgmgr
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/kgpmon
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/loadpsp
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/lsnrctl
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/lxchknlb
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/mapsga
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/maxmem
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/nid
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/ocrcheck
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/ocrdump
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/ons
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oradism
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/orapwd
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/osdbagrp
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/osh
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/rman
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sbttest
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlldr
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sysresv
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tg4pwd
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tkprof
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnsping
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/trcldr
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/trcroute
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tstshm
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/unzip
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/wrap
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/zip
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/bin/ctxhx
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/afsr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/assr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/awsr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/bentofio.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/csvsr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/dcasr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/dw4sr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/foliosr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/htmcnv.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/htmsr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/jtdsr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kp3dwrld.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpagrdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpanirdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpbmprdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpbmpwrt.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpcdrrdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpcgmrdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpcgmwrt.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpchtrdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpdcxrdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpdwgrdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpdxfrdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpemfrdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpepsrdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpgifrdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpicordr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpifcnvt.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpifutil.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpjavwrt.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpjpeg.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpjpgrdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpjpgwrt.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpmacrdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpmsordr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpp40rdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpp95rdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpp97rdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kppctrdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kppcxrdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kppdfrdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kppicrdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kppng.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kppngrdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kppngwrt.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpprerdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpprzrdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpsdwrdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpsgirdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpshwrdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpsunrdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kptgardr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kptifrdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpvsdrdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpwg2rdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpwmfrdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpwmfwrt.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpwpgrdr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kvexport.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kvgraph.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kvhtml.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kvolefio.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kvpie.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kvradar.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kvutil.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kvxpgsa.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kvxsssa.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kvxwpsa.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kwad.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/l123sr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/lasr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/libXML4CMessages.so.54.0
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/libicudata.so.26.1
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/libicuuc.so.26.1
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/libxml4c.so.54.0
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/mbsr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/mifsr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/misr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/mp3sr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/mppsr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/msgsr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/msw6sr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/mswsr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/mw6sr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/mw8sr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/mwsr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/mwssr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/oa2sr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/pdfsr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/qpssr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/rtfsr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/sosr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/unisr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/wkssr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/wosr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/wp6sr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/wpmap.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/wpmsr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/xlssr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/xmllib.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/xmlsr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/xywsr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/hsdb_odbc.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/hsdb_ora.so
i686-pc-linux-gnu-strip: Unable to recognise the format of the input file /var/tmp/portage/oracle-xe-10.2.0.1_p1/image/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/hsdb_ora.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libagtsh.so.1.0
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclntsh.so.10.1
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libclsra10.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libcorejava.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libcoresh10.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libcprts.so.5
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libcxa.so.3
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libcxa.so.5
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libdbcfg10.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libemmas10.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libhasgen10.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libheteroxa10.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libhsbase.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libhsnav.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libimf.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libirc.a
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libjox10.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libldapjclnt10.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libnjni10.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libnjssl10.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libnnz10.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libnque10.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libntcpaio10.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libocci.so.10.1
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libocijdbc10.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libocr10.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libocrb10.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libocrutl10.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libodm10.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libodmd10.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libons.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/liborasdk.so.10.2
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/liborasdkbase.so.10.2
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libqsmashr.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libskgxn2.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libskgxns.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libskgxp10.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libskgxpd.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libskgxpu.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libsqlplus.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libsqora.so.10.1
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libsrvm10.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libsrvmhas10.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libsrvmocr10.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libuini10.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libunwind.so.5
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libxdb.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/lib/libnldapj10.so
   usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/lib/libnoncj10.so
strip: i686-pc-linux-gnu-strip --strip-unneeded
scanelf: rpath_security_checks(): Security problem NULL DT_RPATH in /var/tmp/portage/oracle-xe-10.2.0.1_p1/image//usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libhasgen10.so

QA Notice: the following files contain insecure RUNPATH's
 Please file a bug about this at http://bugs.gentoo.org/
 For more information on this issue, kindly review:
 http://bugs.gentoo.org/81745
/ade/aime1_build2101/oracle/has/lib/:/ade/aime1_build2101/oracle/lib/:/ade/aime1_build2101/oracle/has/lib/: usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libhasgen10.so


!!! ERROR: dev-db/oracle-xe-10.2.0.1_p1 failed.
!!! Function dyn_install, Line 1057, Exitcode 0
!!! Insecure binaries detected
!!! If you need support, post the topmost build error, NOT this status message.
Comment 3 Jakub Moc (RETIRED) gentoo-dev 2006-02-22 00:17:07 UTC
Don't attach tarballs. Reopen with a plaintext ebuild.

http://www.gentoo.org/proj/en/devrel/handbook/handbook.xml?part=2&chap=3#doc_chap2
Comment 4 nunogt 2006-02-22 03:27:21 UTC
Created attachment 80417 [details]
Fixed tentative ebuild

OK, ebuild added. No tarballs this time. I will also include additional files present in /files dir, that are needed for configuration. Hope that's ok.
Comment 5 nunogt 2006-02-22 03:30:36 UTC
Created attachment 80418 [details]
configuration script

This was in the ebuild's /files dir. I suppose it would run the configuration script after the merge.
Comment 6 nunogt 2006-02-22 03:31:57 UTC
Created attachment 80419 [details]
start-stop-script

This was in the ebuild's /files dir. I suppose it's used to start/stop the database daemon.
Comment 7 nunogt 2006-02-22 03:34:52 UTC
I'm reopening the bug. All attachments now comply with the rules (hopefully).
Comment 8 e-spark 2006-04-25 02:36:19 UTC
the ebuild has a typo on line 131 
stysctl should be sysctl

But still does not work here, i installed it manually, but the oracle_configure.sh script hangs while running sqlplus...
Comment 9 kevin 2006-04-29 07:47:57 UTC
Created attachment 85769 [details]
oracle-xe-10.2.0.1_p1.ebuild
Comment 10 kevin 2006-04-29 07:48:44 UTC
Created attachment 85770 [details]
files/oracle_configure.sh
Comment 11 kevin 2006-04-29 07:49:05 UTC
Created attachment 85771 [details]
files/oracle-xe
Comment 12 kevin 2006-04-29 07:50:24 UTC
Comment on attachment 85769 [details]
oracle-xe-10.2.0.1_p1.ebuild

I fixed various errors. The ebuild seems to be working, please check.
Comment 13 kevin 2006-04-29 07:52:04 UTC
Sorry, I forgot: I changed the ebuild to install the universal version. For trying the normal version, just remove -univ from the MY_P="${PN}-univ-${MY_PV}.i386" line.
Comment 14 kevin 2006-04-29 08:49:10 UTC
Created attachment 85772 [details]
/etc/env.d/99oracle

You might want to place the attached 99oracle into /etc/env.d/ (env-update && source /etc/profile). It sets some environment variables, like ORACLE_HOME, to the appropriate values. The file is an adapted version from http://gentoo-wiki.com/HOWTO_Install_Oracle_10g .
The file should probably be cleaned up (not sure, if everything in there is required).
Comment 15 e-spark 2006-04-30 09:48:42 UTC
Created attachment 85838 [details]
oracle-xe-10.2.0.1_p1.ebuild

i also did the work and fixed this ebuild...

now there is still a security warning while installing, but works everything fine.

i moved some things into the oracle_configure.sh script
Comment 16 e-spark 2006-04-30 09:49:40 UTC
Created attachment 85839 [details]
files/oracle_configure.sh
Comment 17 e-spark 2006-04-30 09:50:32 UTC
Created attachment 85840 [details]
files/oracle-xe

init script
Comment 18 e-spark 2006-04-30 09:51:45 UTC
Created attachment 85841 [details]
files/99oracle

env.d file

will also be installed by the ebuild
Comment 19 e-spark 2006-04-30 09:55:16 UTC
btw. i removed the "> /dev/null 2>&1"s  so we can see whats going on...
Comment 20 kevin 2006-05-01 03:44:41 UTC
Are you sure about the $ORACLE_LISTENER_HOME variable in files/oracle-xe? I think it is never set...
Comment 21 kevin 2006-05-01 03:46:32 UTC
Comment on attachment 85772 [details]
/etc/env.d/99oracle

(commiting patches to the files might be better :))
Comment 22 e-spark 2006-05-01 04:24:53 UTC
(In reply to comment #20)
> Are you sure about the $ORACLE_LISTENER_HOME variable in files/oracle-xe? I
> think it is never set...
> 
I think LOG="$ORACLE_HOME_LISTNER/listener.log" is not used at all... but not sure yet.
Comment 23 e-spark 2006-05-01 04:31:13 UTC
maybe we should include oracle_configure.sh into pkg_config()?
Comment 24 kevin 2006-05-20 14:18:44 UTC
Perhaps the install path /usr/lib/oracle/ should be changed to be somewhere in /opt/. At least /usr/lib/oracle/ should be added as -b in /etc/prelink.conf.
Comment 25 Zoltán B. Vadász 2006-05-28 01:12:42 UTC
I get the same error described in comment #2 on amd64. The only difference is - naturally - that the strip is done with x86_64-pc-linux-gnu-strip.

(In reply to comment #2)
> Error log:
> 
> >>> emerge (2 of 2) dev-db/oracle-xe-10.2.0.1_p1 to /
[...]
> usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/lib/libnoncj10.so
> strip: i686-pc-linux-gnu-strip --strip-unneeded
> scanelf: rpath_security_checks(): Security problem NULL DT_RPATH in
> /var/tmp/portage/oracle-xe-10.2.0.1_p1/image//usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libhasgen10.so
Comment 26 Tobias Scherbaum (RETIRED) gentoo-dev 2006-07-23 02:58:22 UTC
Created attachment 92540 [details]
oracle-xe-10.2.0.1_p1.ebuild

Updated ebuild include changes made by stkn@g.o, also let users set recommended kernel parameters themselves. Please test this ebuild as I consider adding it to the tree quite soon if no problems occur.

Installing oracle-xe into /opt seems to be a no-go as the /usr/lib path is hardcoded in many files.
Comment 27 kevin 2006-08-14 12:28:10 UTC
I just tested the latest version of the ebuild, it worked flawlessly. Two suggestions / wishes:

- the ebuild installs the "Western European" version, a use flag (or second ebuild) for the "Universal" version would be nice. On an older version of the ebuild, exchangeing "oracle-xe-10.2.0.1-1.0" with "oracle-xe-univ-10.2.0.1-1.0" did the job.
- how is the swap / ram handled at the moment? oracle forces one to have at least the same amount of ram as swap, or at least 1GB (or something like this). Perhaps the "swap file" workaround could be offered / included in the ebuild

Cheers!
    Kevin
Comment 28 Bryan Halter 2006-08-23 18:35:42 UTC
I just installed this and all is good now but on a new install where the hostname might not be in DNS or hosts.  If this is the case are you try to run oracle-configure.sh it will fail and remove the contents of seeddb.  The result seems to be that you need to unmerge/emerge oracle-xe again and run oracle-configure once add the hostname to hosts/DNS.
Comment 29 Birgir Haraldsson 2006-10-16 02:08:48 UTC
The emerge worked perfectly, but I had problems with the oracle_configure.sh. It seemd to get stalled or something and did not continue until I started the listener, and it completed the configuration from there.

Also would like to see support for the universal version. The configure process there is quite different but the emerge itself is the same, so I guess a oracle_univ_configure.sh would solve that problem?

It would also be nice to see the filename of the downloaded file (SRC_URI) in the nofetch message.
Comment 30 Jurek Bartuszek (RETIRED) gentoo-dev 2006-11-24 02:37:55 UTC
Yes, same here. Emerge passed, but oracle_configure.sh got stalled as mentioned before. However, I've been using the ebuild provided here http://forums.gentoo.org/viewtopic-t-458196-highlight-oraclexe.html (by svaggu) for a few months now and there were no problems whatsoever.

Is this ebuild still planned to be added to the tree soon?
Comment 31 Tobias Scherbaum (RETIRED) gentoo-dev 2006-11-24 06:34:01 UTC
(In reply to comment #30)
> Is this ebuild still planned to be added to the tree soon?

Kind of. I'd prefer to create an oracle herd first and possibly attract other developers as I'm lacking the ressources (i.e. time) to fully support this ebuild. (Which is imho indispensable because we're handling enterprise-stuff here ...)
Nevertheless, at the moment this bug is merely low-priority for me. If you'd like to help out please talk to me on irc or contact me via email.
Comment 32 Tobias Scherbaum (RETIRED) gentoo-dev 2007-01-28 20:57:26 UTC
Ok, another update, looks like this package can make it into the main tree sometime "soon", hopefully before this bug's celebrating its first birthday ;)
I added a new version to my personal developer overlay (http://overlays.gentoo.org/dev/dertobi123/browser/dev-db/oracle-xe, use it via 'layman -a dertobi123'), only change is support for both the latin1 and the unicode version of Oracle XE. It defaults to the unicode one and supports the latin1 via optional USE flag. Please test and report back. Thanks!
Comment 33 Ivan Yosifov 2007-02-07 13:18:05 UTC
After installing the oracle-xe ebuild from http://overlays.gentoo.org/dev/dertobi123/browser/dev-db/oracle-xe revdep-rebuild came up with this:

  broken /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/bentofio.so (requires  libstdc++-libc6.2-2.so.3)
  broken /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/htmcnv.so (requires  libstdc++-libc6.2-2.so.3)
  broken /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpchtrdr.so (requires  libstdc++-libc6.2-2.so.3)
  broken /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpifutil.so (requires  libstdc++-libc6.2-2.so.3)
  broken /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpp97rdr.so (requires  libstdc++-libc6.2-2.so.3)
  broken /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kpwmfwrt.so (requires  libstdc++-libc6.2-2.so.3)
  broken /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kvgraph.so (requires  libstdc++-libc6.2-2.so.3)
  broken /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kvutil.so (requires  libstdc++-libc6.2-2.so.3)
  broken /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/kvxsssa.so (requires  libstdc++-libc6.2-2.so.3)
  broken /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/l123sr.so (requires  libstdc++-libc6.2-2.so.3)
  broken /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/libicuuc.so.26.1 (requires  libicudata.so.26 libstdc++-libc6.2-2.so.3)
  broken /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/libxml4c.so.54.0 (requires  libicudata.so.26 libicuuc.so.26 libstdc++-libc6.2-2.so.3)
  broken /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/oa2sr.so (requires  libstdc++-libc6.2-2.so.3)
  broken /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/xmllib.so (requires  libstdc++-libc6.2-2.so.3 libxml4c.so.54)
  broken /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libsqora.so.10.1 (requires  libclntsh.so.10.1 libodbcinst.so.1)

Is this a real problem or some kind of false positive ?
Comment 34 Dario Lopez-Kästen 2007-02-20 12:31:00 UTC
(In reply to comment #32)
> Ok, another update, looks like this package can make it into the main tree
> sometime "soon", hopefully before this bug's celebrating its first birthday ;)
> I added a new version to my personal developer overlay
> (http://overlays.gentoo.org/dev/dertobi123/browser/dev-db/oracle-xe, use it via
> 'layman -a dertobi123'), only change is support for both the latin1 and the
> unicode version of Oracle XE. It defaults to the unicode one and supports the
> latin1 via optional USE flag. Please test and report back. Thanks!
> 


hello, tried this and there is a slight error: the ebuild requires both the singlebyte and the universal package to be present in /usr/portage/distfiles, independent of which package you want to install. In effect you have to doanload both. This tested with USE="latin1".


Comment 35 Dario Lopez-Kästen 2007-02-20 12:58:39 UTC
hm... ignore comment #34. I now realize that I may have mixed things up a bit with the USE-flags. I will look it up more thoroughly on and report back if the problem persists.

Apologies for the noise.

/dario
Comment 36 MT 2007-02-28 14:53:15 UTC
Created attachment 111553 [details]
dev-db/oracle-xe-10.2.0.1_p1-r1

this ebuild:
- fix problem with wrong IUSE, making the ebuild portage compliant by using USE "unicode" instead of "latin1"; fix also problem reported at comment #34
- check the ~arch before to install
- check the minimun requirements before to install
- use elog functions
- fix problems about "missing dir/files" during installation process

probably there are other problems/bugs to fix, if possible please report all.
Comment 37 Ivan 2007-03-24 13:37:44 UTC
I just tried Toffanin's updated ebuild... and there's no /etc/init.d/oracle-xe created.
Comment 38 Stefano 2007-09-25 14:32:56 UTC
Just to point that with the 99oracle file provided the env vars are not set correctly.

Currantly you cannot add vars to env variable i.e: 
PATH=$PATH:$ORACLE_HOME/bin

The result will be a path set uncorrectly: 
/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/opt/bin:/usr/i686-pc-linux-gnu/gcc-bin/4.1.2:/usr/i686-pc-linux-gnu/gcc-bin/4.1.1:/opt/sun-jdk-1.4.2.15/bin:/opt/sun-jdk-1.4.2.15/jre/bin:/opt/sun-jdk-1.4.2.15/jre/javaws:$ORACLE_HOME/bin

By the way the ebuild posted by Toffanin works almost flawlessly.
Comment 39 Stefano 2007-10-14 14:27:57 UTC
Created attachment 133441 [details]
Fixed env dirs as suggested in the previous post

Changed all the occurences of ORACLE_HOME to %ORACLE_HOME% so the ebuild will sed it correctly.
Comment 40 valentin 2007-11-02 20:03:09 UTC
is there a way to install this on amd64 multilib and make it work?
i've tried to install it but i couldn't connect to database since i get a libaio missing problem even if i have libaio installed.
Comment 41 Heinrich Götzger 2007-11-15 12:35:52 UTC
(In reply to comment #40)
> is there a way to install this on amd64 multilib and make it work?
> i've tried to install it but i couldn't connect to database since i get a
> libaio missing problem even if i have libaio installed.
> 
So do I, there is a:
SQL> connect / as sysdba
oracleXE: error while loading shared libraries: libaio.so.1: wrong ELF class: ELFCLASS64
ERROR:
ORA-12547: TNS:lost contact

and after cheeting with LD_LIB_PATH 
and setting it to LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
I get following:
SQL> connect / as sysdba
oracleXE: error while loading shared libraries: libaio.so.1: wrong ELF class: ELFCLASS64
ERROR:
ORA-12547: TNS:lost contact

dev-libs/libaio is 0.3.106-r1 
and this is for an amd64

So I assume there is no chance to get it up'n'running on an amd64.

Any ideas, hints, etc...?

Cheers
Comment 42 Heinrich Götzger 2007-11-15 12:40:17 UTC
(In reply to comment #41)

> So do I, there is a: 
[edited, since this got wrong in the previous posting, sorry)
SQL>  connect / as sysdba
oracleXE: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS:lost contact

> and after cheeting with LD_LIB_PATH 
> and setting it to LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
> I get following:
> SQL> connect / as sysdba
> oracleXE: error while loading shared libraries: libaio.so.1: wrong ELF class:
> ELFCLASS64
> ERROR:
> ORA-12547: TNS:lost contact

Comment 43 Ludovic Gasc (GMLudo) 2008-06-11 21:30:25 UTC
I've tested this ebuild, I have no problems to install, it's easier than manual installation, and it works correctly.

Thanks you very much for this ebuild.
Comment 44 wikwam 2008-12-13 19:09:08 UTC
For me it doesn't work.

After merging the package (no errors) and "ebuild /var/db/pkg/dev-db/oracle-xe-10.2.0.1_p1/oracle-xe-10.2.0.1_p1.ebuild config" (no errors) i issued /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_configure.sh. I accepted default settings and entered password. Now the Problem begins.

---------------------------
specify a password to be used for database accounts.  Note that the same
password will be used for SYS, SYSTEM and FLOWS_020100.  Oracle recommends
the use of different passwords for each database account.  This can be done
after initial configuration:
Confirm the password:
Configuring Database...

ORA-44412: XE edition memory parameter invalid or not specified
select TO_CHAR(systimestamp,'YYYYMMDD HH:MI:SS') from dual
*
ERROR at line 1:
ORA-01034: ORACLE not available


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


select TO_CHAR(systimestamp,'YYYYMMDD HH:MI:SS') from dual
*
ERROR at line 1:
ORA-01034: ORACLE not available


Create controlfile reuse set database "XE"
*
ERROR at line 1:
ORA-01034: ORACLE not available


BEGIN dbms_backup_restore.zerodbid(0); END;

------------------

And so on. After setting correct memory option the following errors occur while trying oracle_configure.sh the second time:

------------------

Oracle Database 10g Express Edition Configuration
-------------------------------------------------
This will configure on-boot properties of Oracle Database 10g Express
Edition.  The following questions will determine whether the database should
be starting upon system boot, the ports it will use, and the passwords that
will be used for database accounts.  Press <Enter> to accept the defaults.
Ctrl-C will abort.

Specify the HTTP port that will be used for HTML DB [8080]:


Specify a port that will be used for the database listener [1521]:
Specify a password to be used for database accounts.  Note that the same
password will be used for SYS, SYSTEM and FLOWS_020100.  Oracle recommends
the use of different passwords for each database account.  This can be done
after initial configuration:
Confirm the password:
Configuring Database...

ORACLE instance started.

Total System Global Area   88080384 bytes
Fixed Size                  1257332 bytes
Variable Size              54526092 bytes
Database Buffers           29360128 bytes
Redo Buffers                2936832 bytes

TO_CHAR(SYSTIMEST
-----------------
20081213 08:03:13

Allocating device....
Specifying datafiles...
Specifing datafiles...
Restoring ...
declare
*
ERROR at line 1:
ORA-19624: operation failed, retry possible
ORA-19870: error reading backup piece
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/seeddb/xeseed.dfb
ORA-19505: failed to identify file
"/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/seeddb/xeseed.dfb"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5149
ORA-06512: at line 16



TO_CHAR(SYSTIMEST
-----------------
20081213 08:03:13

Create controlfile reuse set database "XE"
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/usr/lib/oracle/xe/oradata/XE/system.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


BEGIN dbms_backup_restore.zerodbid(0); END;

*
ERROR at line 1:
ORA-00210: cannot open the specified control file
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 4168
ORA-06512: at line 1


ORA-01507: database not mounted


ORACLE instance shut down.
ORACLE instance started.

Total System Global Area   88080384 bytes
Fixed Size                  1257332 bytes
Variable Size              54526092 bytes
Database Buffers           29360128 bytes
Redo Buffers                2936832 bytes
Create controlfile reuse set database "XE"
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/usr/lib/oracle/xe/oradata/XE/system.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3



System altered.

alter database "XE" open resetlogs
*
ERROR at line 1:
ORA-01507: database not mounted

------------------

So the problem seems to be, that directory: "/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/seeddb/xeseed.dfb" and file "/usr/lib/oracle/xe/oradata/XE/system.dbf" don't exist.

My system is x86_64 kernel 2.6.25-gentoo-r7. I also tried it in a 32bit chroot env but no way. same errors.

Any suggestions?

Comment 45 wikwam 2008-12-13 19:27:56 UTC
Ok, got it.

After copying "/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/seeddb/" from rpm to local installation oracle_configure.sh completes without errors. I suggest to add this step to ebuild.

Comment 46 Tobias Scherbaum (RETIRED) gentoo-dev 2008-12-29 17:21:45 UTC
re-assigning to maintainer-wanted@ - there's a working ebuild in my overlay, but i won't add it to the tree as i'm not interested in maintaining it long term.
Comment 47 wikwam 2009-04-16 17:21:28 UTC
(In reply to comment #45)
> After copying
>"/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/seeddb/" from rpm
>to local installation oracle_configure.sh completes without errors. I suggest
>to add this step to ebuild.
> 

Well for me it doesn't work.

Could you please paste your init.ora, so i can check my values.

---------
Oracle Database 10g Express Edition Configuration
-------------------------------------------------
This will configure on-boot properties of Oracle Database 10g Express
Edition.  The following questions will determine whether the database should
be starting upon system boot, the ports it will use, and the passwords that
will be used for database accounts.  Press <Enter> to accept the defaults.
Ctrl-C will abort.

Specify the HTTP port that will be used for HTML DB [8080]:

Specify a port that will be used for the database listener [1521]:

Specify a password to be used for database accounts.  Note that the same
password will be used for SYS, SYSTEM and FLOWS_020100.  Oracle recommends
the use of different passwords for each database account.  This can be done
after initial configuration:
Confirm the password:
Configuring Database...

ORACLE instance started.

Total System Global Area  536870912 bytes
Fixed Size                  1259904 bytes
Variable Size             150996608 bytes
Database Buffers          381681664 bytes
Redo Buffers                2932736 bytes

TO_CHAR(SYSTIMESTAMP,'YYYYMMDDHH:MI:SS')
---------------------------------------------------
20090416 07:15:32

Allocating device....
Specifying datafiles...
Specifing datafiles...
Restoring ...
Restore done.

PL/SQL procedure successfully completed.


TO_CHAR(SYSTIMESTAMP,'YYYYMMDDHH:MI:SS')
---------------------------------------------------
20090416 07:16:24


Control file created.


PL/SQL procedure successfully completed.

ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
ORA-44412: XE edition memory parameter invalid or not specified
Create controlfile reuse set database "XE"
*
ERROR at line 1:
ORA-01034: ORACLE not available

---------

That's all i got.

Thanks in advance.
Comment 48 Gabor Garami 2009-05-15 08:04:09 UTC
First, thanks your work.

Problems with r1 ebuild:
 - wtk-enterprise.eclass isn't a part of portage tree
 - overlay_pkg_setup is an unavailable command
 - In SRC_URI, please add a space after open parenthesis, and before closer parenthesis, because portage doesn't accept the ebuild now (ebuild command gives an error).
 - Replace this: elog "  ebuild /var/db/pkg/${CATEGORY}/${PF}/${PF}.ebuild config" with this: elog "  emerge --config =${CATEGORY}/${PF}". Let portage to find an ebuild correctly.
Comment 49 Peter Triller 2009-10-02 19:50:34 UTC
Created attachment 205870 [details]
patched ebuild

ebuild packed as suggested, and wtk-enterprise eclass removed since it only displays a warning on install  (see: https://wtk-overlay.svn.sourceforge.net/svnroot/wtk-overlay/wtk-enterprise/eclass/ )
Comment 50 Peter Triller 2009-10-02 19:52:33 UTC
Created attachment 205871 [details]
Bug patched on high memory machines

The script always gave the db a percentage of the available memory, but XE is limited to 1 Gb for the db. Added a cap to < 1Gb to the script so it wont fail on 4 Gb machines
Comment 51 Iwan Aucamp 2009-11-19 22:00:24 UTC
(In reply to comment #49)
> Created an attachment (id=205870) [details]
> patched ebuild
> 
> ebuild packed as suggested, and wtk-enterprise eclass removed since it only
> displays a warning on install  (see:
> https://wtk-overlay.svn.sourceforge.net/svnroot/wtk-overlay/wtk-enterprise/eclass/
> )


thanks - works well - was having problems with r1 also.

Comment 52 Robert Buzna 2010-03-08 09:29:57 UTC
Hi, it's year 2010. What's the problem?