View previous topic :: View next topic |
Author |
Message |
andreask Apprentice
Joined: 09 Sep 2003 Posts: 282 Location: Aachen, Germany
|
|
Back to top |
|
|
Blood Fluke Apprentice
Joined: 15 Sep 2005 Posts: 224
|
Posted: Wed Nov 02, 2005 12:34 am Post subject: |
|
|
Use rpm2cpio to extract it, then examine its contents for yourself. |
|
Back to top |
|
|
tranquilcool Veteran
Joined: 25 Mar 2005 Posts: 1179
|
Posted: Wed Nov 09, 2005 5:56 pm Post subject: |
|
|
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 |
|
|
andreask Apprentice
Joined: 09 Sep 2003 Posts: 282 Location: Aachen, Germany
|
Posted: Thu Nov 10, 2005 6:44 pm Post subject: |
|
|
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 |
|
|
xces Guru
Joined: 11 Oct 2002 Posts: 515
|
Posted: Thu Nov 10, 2005 10:19 pm Post subject: |
|
|
@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 |
|
|
samuel.penn Tux's lil' helper
Joined: 14 Dec 2003 Posts: 114 Location: UK
|
Posted: Fri Nov 11, 2005 9:16 am Post subject: Free to distribute? |
|
|
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 |
|
|
samuel.penn Tux's lil' helper
Joined: 14 Dec 2003 Posts: 114 Location: UK
|
Posted: Fri Nov 11, 2005 11:38 am Post subject: Web interface? |
|
|
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 |
|
|
tranquilcool Veteran
Joined: 25 Mar 2005 Posts: 1179
|
Posted: Fri Nov 11, 2005 11:03 pm Post subject: |
|
|
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 |
|
|
samuel.penn Tux's lil' helper
Joined: 14 Dec 2003 Posts: 114 Location: UK
|
Posted: Tue Nov 15, 2005 10:55 am Post subject: Web server |
|
|
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 |
|
|
ukasbadu n00b
Joined: 08 Oct 2005 Posts: 9 Location: Opole, PL
|
Posted: Thu Nov 17, 2005 4:08 pm Post subject: |
|
|
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 |
|
|
samuel.penn Tux's lil' helper
Joined: 14 Dec 2003 Posts: 114 Location: UK
|
Posted: Thu Nov 17, 2005 5:53 pm Post subject: libaio |
|
|
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 |
|
|
ukasbadu n00b
Joined: 08 Oct 2005 Posts: 9 Location: Opole, PL
|
Posted: Thu Nov 17, 2005 6:42 pm Post subject: |
|
|
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 |
|
|
samuel.penn Tux's lil' helper
Joined: 14 Dec 2003 Posts: 114 Location: UK
|
|
Back to top |
|
|
ukasbadu n00b
Joined: 08 Oct 2005 Posts: 9 Location: Opole, PL
|
Posted: Thu Nov 17, 2005 9:25 pm Post subject: |
|
|
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 |
|
|
samuel.penn Tux's lil' helper
Joined: 14 Dec 2003 Posts: 114 Location: UK
|
Posted: Fri Nov 18, 2005 9:04 am Post subject: |
|
|
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 |
|
|
tranquilcool Veteran
Joined: 25 Mar 2005 Posts: 1179
|
Posted: Fri Nov 18, 2005 5:39 pm Post subject: |
|
|
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 |
|
|
giacomo.78 n00b
Joined: 01 Dec 2005 Posts: 31
|
Posted: Thu Dec 01, 2005 7:27 am Post subject: configuration problems |
|
|
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 |
|
|
giacomo.78 n00b
Joined: 01 Dec 2005 Posts: 31
|
Posted: Fri Dec 02, 2005 8:07 am Post subject: |
|
|
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 |
|
|
Almad n00b
Joined: 29 Apr 2005 Posts: 17
|
Posted: Sat Dec 03, 2005 3:30 am Post subject: Still not running |
|
|
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 |
|
|
Almad n00b
Joined: 29 Apr 2005 Posts: 17
|
Posted: Sat Dec 03, 2005 12:50 pm Post subject: Solved |
|
|
Hi,
well, I tried being brave enough and typed emerge oracle-xe.
Works like a charm. |
|
Back to top |
|
|
ParaDoXke n00b
Joined: 28 Jun 2005 Posts: 9
|
Posted: Thu Dec 15, 2005 2:06 pm Post subject: |
|
|
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 |
|
|
M@rijn Tux's lil' helper
Joined: 28 Jan 2004 Posts: 145 Location: Zierikzee (The Netherlands)
|
Posted: Thu Dec 22, 2005 12:33 pm Post subject: |
|
|
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
_________________ Gentoo is just an Aston Martin, "Power, beauty and soul" |
|
Back to top |
|
|
andreask Apprentice
Joined: 09 Sep 2003 Posts: 282 Location: Aachen, Germany
|
Posted: Thu Dec 22, 2005 1:41 pm Post subject: |
|
|
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 |
|
|
johnfredcee n00b
Joined: 31 Dec 2005 Posts: 10
|
Posted: Sat Dec 31, 2005 1:46 am Post subject: |
|
|
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. |
|
Back to top |
|
|
lnthai2002 Apprentice
Joined: 04 Nov 2005 Posts: 260
|
Posted: Sun Jan 08, 2006 7:49 pm Post subject: |
|
|
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 |
|
|
|