Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
Install free Oracle 10g XE on Gentoo?
View unanswered posts
View posts from last 24 hours

Goto page 1, 2  Next  
Reply to topic    Gentoo Forums Forum Index Portage & Programming
View previous topic :: View next topic  
Author Message
andreask
Apprentice
Apprentice


Joined: 09 Sep 2003
Posts: 282
Location: Aachen, Germany

PostPosted: Tue Nov 01, 2005 11:48 pm    Post subject: Install free Oracle 10g XE on Gentoo? Reply with quote

Hi!

The free XE version of Oracle 10g (also free for commercial use!) is distributed as an RPM package (AFAIK).
http://www.oracle.com/corporate/press/2005_oct/103105_databasexe_finalsite.html
http://www.oracle.com/technology/products/database/xe/index.html

It should work with Suse, Red Hat... and Debian 3.1! Do you think it could be installed on Gentoo? How?

Do you think there could be an ebuild? But how to get the files from RPM - and what about the dependencies?


best regards
Andreas
Back to top
View user's profile Send private message
Blood Fluke
Apprentice
Apprentice


Joined: 15 Sep 2005
Posts: 224

PostPosted: Wed Nov 02, 2005 12:34 am    Post subject: Reply with quote

Use rpm2cpio to extract it, then examine its contents for yourself.
Back to top
View user's profile Send private message
tranquilcool
Veteran
Veteran


Joined: 25 Mar 2005
Posts: 1051

PostPosted: Wed Nov 09, 2005 5:56 pm    Post subject: Reply with quote

installed it and it's working fine with gentoo.
just do;

rpm --nodeps -ivh orocle-xe-10.2.0.1-0.1.i386.rpm

that installs it.
to configure do;

/etc/init.d/oracle-xe configure
accept the default values
accept to start at boot time.
do
nano -w /etc/ini.t.d/oracle-xe
comment out the following lines
. /etc/init.d/functions (line 16)
init_status (line99)

after that you can start the database with
/etc/init.d/oracle-xe start
and stop with
/etc/init.d/oracle-xe stop

if you want to start at boot rc-update add wont work just put the start line in your /etc/conf.d/local.start
_________________
this is a strange strange world.
Back to top
View user's profile Send private message
andreask
Apprentice
Apprentice


Joined: 09 Sep 2003
Posts: 282
Location: Aachen, Germany

PostPosted: Thu Nov 10, 2005 6:44 pm    Post subject: Reply with quote

thanks a lot!

What about creating an ebuild? There are some ebuilds for packages, distributed in RPM format in portage (e.g. acroread, icc, realplayer, ati-drivers, openoffice-bin...)

Using RESTRICT in the ebuild can make sure that people download the RPM manually (accept license...).

The ebuilds mentioned above use the rpm.eclass to extract the files from the RPM archive. That's different from the way you suggest or suggested in DB2-HOWTO: http://tldp.org/HOWTO/DB2-HOWTO/gentoo.html

So what about using rpm.eclass and create an ebuild for Oracle XE?
Back to top
View user's profile Send private message
xces
Guru
Guru


Joined: 11 Oct 2002
Posts: 515

PostPosted: Thu Nov 10, 2005 10:19 pm    Post subject: Reply with quote

@andreask: Making an ebuild for Oracle 10g XE is not trivial as the RPM makes some changes to the system (e. g. entries to /etc/sysctl.conf).
If you are brave enough, you can try http://217.160.176.49/~xces/oracle-xe.ebuild.tgz. Extract it to your PORTDIR_OVERLAY and test it out.
Back to top
View user's profile Send private message
samuel.penn
Tux's lil' helper
Tux's lil' helper


Joined: 14 Dec 2003
Posts: 114
Location: UK

PostPosted: Fri Nov 11, 2005 9:16 am    Post subject: Free to distribute? Reply with quote

Given that they claim that the final release of Oracle XE will be free to distribute, does this mean it can become part of a free Linux distribution? i.e. Gentoo can install it with a simple "emerge oracle-xe" without needing the user to download it manually? (assuming a suitable ebuild is written).

My reading of the FAQ seems to suggest that this is the case, though the beta seems to be slightly more restrictive.
Back to top
View user's profile Send private message
samuel.penn
Tux's lil' helper
Tux's lil' helper


Joined: 14 Dec 2003
Posts: 114
Location: UK

PostPosted: Fri Nov 11, 2005 11:38 am    Post subject: Web interface? Reply with quote

I've installed XE from the RPM as described above, and the listener is running, as are a number of ora_xe processes (after much work - it was picking up the environment from my previous failed attempts to install the full 10G).

I get the impression there should be a web interface running on port 8080. This is not running however (in fact nothing is running on 8080).

If I try to run sqlplus with sqlplus sys/oracle@XE I get the error "TNS:listener: all appropriate instances are blocking new connections". I'm assuming the SID of the database it initially creates is XE, since that is what is listed in tnsnames.ora.

So... something isn't starting correctly, but I'm not entirely sure what it is.

Anyone any ideas?
Back to top
View user's profile Send private message
tranquilcool
Veteran
Veteran


Joined: 25 Mar 2005
Posts: 1051

PostPosted: Fri Nov 11, 2005 11:03 pm    Post subject: Reply with quote

make sure you start the database;

/etc/init.d/oracle-xe start

then open firefox and do

http://your-domain:8080/htmldb/ (if you accepted the default port during install it's 8080)
your-domain could be localhost depending on how you set your box

in your .bashrc write this to set the oracle evn.
. /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh (i'd say copy and paste-see the dot?)

then open ya console and do

sqlplus /nolog
sql> connect system/'the-password-you-gave-during-install' as sysdba (no commas in the password)

this should do.
_________________
this is a strange strange world.
Back to top
View user's profile Send private message
samuel.penn
Tux's lil' helper
Tux's lil' helper


Joined: 14 Dec 2003
Posts: 114
Location: UK

PostPosted: Tue Nov 15, 2005 10:55 am    Post subject: Web server Reply with quote

Finally seems to be working. I was getting confused because if you browse to http://localhost:8080/, what you get is a number of directories containing image files - basically what looks like a broken installation.

If you browse to /htmldb, you get something that is actually useful (even though /htmldb doesn't show up if you browse from the root).

Cheers.

Now to try getting Documentum 5.3 running...
Back to top
View user's profile Send private message
ukasbadu
n00b
n00b


Joined: 08 Oct 2005
Posts: 9
Location: Opole, PL

PostPosted: Thu Nov 17, 2005 4:08 pm    Post subject: Reply with quote

tranquilcool wrote:
make sure you start the database;
sqlplus /nolog
sql> connect system/'the-password-you-gave-during-install' as sysdba (no commas in the password)
this should do.


I get this:

SQL> connect system
Enter password:
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

Any ideas ? I tried to install libaio through portage and from source, however I still can't get it working :-(.
Back to top
View user's profile Send private message
samuel.penn
Tux's lil' helper
Tux's lil' helper


Joined: 14 Dec 2003
Posts: 114
Location: UK

PostPosted: Thu Nov 17, 2005 5:53 pm    Post subject: libaio Reply with quote

I think I used libaio-0.3.98-17.src.rpm, and installed it using rpm. At least that's the copy I've got sitting on the server. Can't remember where I got it from.
Back to top
View user's profile Send private message
ukasbadu
n00b
n00b


Joined: 08 Oct 2005
Posts: 9
Location: Opole, PL

PostPosted: Thu Nov 17, 2005 6:42 pm    Post subject: Reply with quote

Thanks for your reply. I've tried with the exact same version with no luck. Did you run oracle on AMD64 ? I have AMD64, maybe that's the reason ?
Back to top
View user's profile Send private message
samuel.penn
Tux's lil' helper
Tux's lil' helper


Joined: 14 Dec 2003
Posts: 114
Location: UK

PostPosted: Thu Nov 17, 2005 9:16 pm    Post subject: libaio Reply with quote

This was actually in a VMware session, so x86 equivalent.

Have you tried: http://oss.oracle.com/projects/libaio-oracle/
Back to top
View user's profile Send private message
ukasbadu
n00b
n00b


Joined: 08 Oct 2005
Posts: 9
Location: Opole, PL

PostPosted: Thu Nov 17, 2005 9:25 pm    Post subject: Reply with quote

There is some improvement. I can now start and stop the server whithout erros, however when I try to connect throught sqlplus I get the same error.
Back to top
View user's profile Send private message
samuel.penn
Tux's lil' helper
Tux's lil' helper


Joined: 14 Dec 2003
Posts: 114
Location: UK

PostPosted: Fri Nov 18, 2005 9:04 am    Post subject: Reply with quote

ukasbadu wrote:
There is some improvement. I can now start and stop the server whithout erros, however when I try to connect throught sqlplus I get the same error.


Sounds like it might be the environment. Is something setup in the environment for the start/stop scripts which isn't setup from the shell when you run sqlplus?

Can you connect to the web front end? http://localhost:8080/htmldb
Back to top
View user's profile Send private message
tranquilcool
Veteran
Veteran


Joined: 25 Mar 2005
Posts: 1051

PostPosted: Fri Nov 18, 2005 5:39 pm    Post subject: Reply with quote

cd ~/
wget "ftp://ftp.suse.com/pub/suse/i386/9.1/suse/src/libaio-0.3.102.src.rpm
rpm2targz libaio-0.3.102.src.rpm
tar zxf libaio-0.3.102.src.tar.gz
tar jxf libaio-0.3.102.tar.bz2
cd libaio-0.3.102
make
make install

you should not have libaio probs anymore
_________________
this is a strange strange world.
Back to top
View user's profile Send private message
giacomo.78
n00b
n00b


Joined: 01 Dec 2005
Posts: 31

PostPosted: Thu Dec 01, 2005 7:27 am    Post subject: configuration problems Reply with quote

Hi to everybody.

I tried to install Oracle XE 10g Beta using rpm.
Before installing I have emerged libaio 0.3.104.

Everything works fine but

Code:
/etc/init.d/oracle-xe configure


fails with

Code:
Configuring Database...
/etc/init.d/oracle-xe: line 131: /etc/sysconfig/oracle-xe-config: No such file or directory
Starting Oracle Net Listener.
/etc/init.d/oracle-xe: line 493: /sbin/chkconfig: No such file or directory
You need to configure Oracle Database 10g Express Edition before you can start it.


Can anyone help me, please?

Thanks.
Back to top
View user's profile Send private message
giacomo.78
n00b
n00b


Joined: 01 Dec 2005
Posts: 31

PostPosted: Fri Dec 02, 2005 8:07 am    Post subject: Reply with quote

Hi again.
After somework and Internet surfing, I was able to solve the problem.
First, make a directory not present in gentoo distribution but needed by the configure process.
Code:
mkdir /etc/sysconfig

Create a file named chkconfig in /sbin with this text:
Code:
#! /bin/sh
logger -t $0 "called with args $*"

Make it executable:
Code:
chmod +x /sbin/chkconfig

Create functions in /etc/init.d:
Code:
success()
{
 echo " [ok]
}
failure()
{
 echo " [failed]"
}

Convert Oracle XE rpm in a tgz using rpm2tgz.
Unpack the archive and copy the seeddb.
Code:
mkdir /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/seeddb
cp path-to-archive/.../seeddb/* /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/seeddb/

Now run the configure step.
Back to top
View user's profile Send private message
Almad
n00b
n00b


Joined: 29 Apr 2005
Posts: 17

PostPosted: Sat Dec 03, 2005 3:30 am    Post subject: Still not running Reply with quote

Hello,

I tried all variants of installation methods here, however I'm still not successfull. Configure step and server start seems to work OK, however I still do not have running http interface. In fact, only this oracle process is running:

5474 ? Ss 0:00 /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr LISTENER -inherit

When trying to connect with sqlplus, I get this error:

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

Where the problem could be? :-]
Back to top
View user's profile Send private message
Almad
n00b
n00b


Joined: 29 Apr 2005
Posts: 17

PostPosted: Sat Dec 03, 2005 12:50 pm    Post subject: Solved Reply with quote

Hi,

well, I tried being brave enough and typed emerge oracle-xe.

Works like a charm.
Back to top
View user's profile Send private message
ParaDoXke
n00b
n00b


Joined: 28 Jun 2005
Posts: 9

PostPosted: Thu Dec 15, 2005 2:06 pm    Post subject: Reply with quote

Hi, i've been trying for 3 days now to get it working, but i can't login. When i try loggin in using sqlplus i get this:
Code:
SQL> connect system/mypassword
ERROR:
ORA-12162: TNS:net service name is incorrectly specified


and when i try loggin in using http://127.0.0.1/htmldb/ i get:
Code:
Invalid Login Credentials



any ideas?

tnx
_________________
<Penguin Powered>
Back to top
View user's profile Send private message
M@rijn
Tux's lil' helper
Tux's lil' helper


Joined: 28 Jan 2004
Posts: 145
Location: Zierikzee (The Netherlands)

PostPosted: Thu Dec 22, 2005 12:33 pm    Post subject: Reply with quote

Has somebody Oracle XE running with a configuration made with a commandline?

Because i've been trying running Oracle XE on a server without the webinterface, but i get errors all the time. I can do conn / as sysdba and not more then that.

Everytime i get an "Not connected to ORACLE error", but there's no good tutorial about configuring Oracle XE from the commandline
:roll:
_________________
Gentoo is just an Aston Martin, "Power, beauty and soul"
Back to top
View user's profile Send private message
andreask
Apprentice
Apprentice


Joined: 09 Sep 2003
Posts: 282
Location: Aachen, Germany

PostPosted: Thu Dec 22, 2005 1:41 pm    Post subject: Reply with quote

xces wrote:
@andreask: Making an ebuild for Oracle 10g XE is not trivial as the RPM makes some changes to the system (e. g. entries to /etc/sysctl.conf).
If you are brave enough, you can try http://217.160.176.49/~xces/oracle-xe.ebuild.tgz. Extract it to your PORTDIR_OVERLAY and test it out.

Works very well for me (thanks a lot btw.!), what about submitting this ebuild to bugs.gentoo.org (and perhaps cc "radek" who is the maintainer of dev-db/oracle-instantclient-basic)?

Is someone else interested in maintaining such a package in portage?

best regards
Andreas
Back to top
View user's profile Send private message
johnfredcee
n00b
n00b


Joined: 31 Dec 2005
Posts: 10

PostPosted: Sat Dec 31, 2005 1:46 am    Post subject: Reply with quote

The supplied ebuild works ok over here, too. Which is nice since I'd been beating myself up since Xmas to get Oracle XE working on my Gentoo box!

Thx. :D
Back to top
View user's profile Send private message
lnthai2002
Apprentice
Apprentice


Joined: 04 Nov 2005
Posts: 260

PostPosted: Sun Jan 08, 2006 7:49 pm    Post subject: Reply with quote

Hi,
I am noop. I am learning a database course this semester so i want to install oracle 10g on gentoo(i did it on CentOS but i prefer using gentoo). However, i am confused since people here talking a bout oracle XE 10g, what is the different between these 2? Although installing oracle at home is optional(my school offers a lab of oracle 9i installed), i want to learn how to do it for my future career. Thus, if anyone know how to install oracle 10g on gentoo, please let me know.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Portage & Programming All times are GMT
Goto page 1, 2  Next
Page 1 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum