Oracle XE, the free personal version of the popular database Oracle should be added to portage.
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
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.
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
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.
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.
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.
I'm reopening the bug. All attachments now comply with the rules (hopefully).
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...
Created attachment 85769 [details] oracle-xe-10.2.0.1_p1.ebuild
Created attachment 85770 [details] files/oracle_configure.sh
Created attachment 85771 [details] files/oracle-xe
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.
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.
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).
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
Created attachment 85839 [details] files/oracle_configure.sh
Created attachment 85840 [details] files/oracle-xe init script
Created attachment 85841 [details] files/99oracle env.d file will also be installed by the ebuild
btw. i removed the "> /dev/null 2>&1"s so we can see whats going on...
Are you sure about the $ORACLE_LISTENER_HOME variable in files/oracle-xe? I think it is never set...
Comment on attachment 85772 [details] /etc/env.d/99oracle (commiting patches to the files might be better :))
(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.
maybe we should include oracle_configure.sh into pkg_config()?
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.
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
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.
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
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.
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.
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?
(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.
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!
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 ?
(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".
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
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.
I just tried Toffanin's updated ebuild... and there's no /etc/init.d/oracle-xe created.
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.
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.
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.
(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
(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
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.
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?
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.
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.
(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.
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.
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/ )
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
(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.
Hi, it's year 2010. What's the problem?
