Installing Oracle 9.2.0.1.0 Client on Gentoo 1.4

drumz · Apprentice Joined: 10 Nov 2002 Posts: 213

This whole situation brings up several questions:

1. If gcc 3 breaks it under Linux, does the same issue exist under Solaris?

2. (Yes, I know Oracle does not now, past or future plan to support Gentoo, but this is a generalized question about Gentoo configurability). Since Gentoo builds everything from scratch when doing a stage 1 install, if after the emerge sync would it be possible to 'stick' it at gcc2.95? And I wonder what side affects this would have (we've had instances where some software has actually required gcc3 and would not compile under gcc2.95 - I wonder what packages/updates under Gentoo would have the same issue?)?

:?:

Drumz

ebrostig · Posted: Fri Jan 03, 2003 9:20 pm Post subject: Re: 9i under Gentoo 1.4rc

drumz · Apprentice Joined: 10 Nov 2002 Posts: 213

Sorry, shoulda specified Sparc Solaris. That's a relief to know, before the SA decides to do me a favor and update the compiler to gcc 3 without telling me ;-)

For Gentoo, I didn't mean installing both gcc 2.95 and 3. What I meant was that (haven't verified this) that at some point during the install a version of gcc is downloaded and installed (I'm thinking after doing the 'emerge sync'). So what I'm thinking that could be done is after the 'emerge sync', editing a config file so that the version of the compiler that is downloaded and installed is stuck at 2.95, not 3 possibly solving the Oracle under Gentoo 1.4rc issue. This throws up several questions:

1. Can this be done? If so, how.
2. What side affects might there be? As stated in my previous post, we've come across one piece of software that specifically requires gcc 3. I wonder if there is anything in Gentoo 1.4 that might react badly to this.

Drumz

Sasun · n00b Joined: 07 May 2002 Posts: 15

on a gentoo.14_rc1 system:

DamageCo · n00b Joined: 19 Nov 2002 Posts: 5

I've exactly got the same problem. Since've upgrade to glic-2.3.1, no more Oracle 9 !!!

What is the right way to return to glibc-2.2.5 ? I've try to emerge the right version of glibc but after removing glibc-2.3.1 the system hang with error like this for every command "/lib/libc.so.6: version `GLIBC_2.3' not found".

Help !

Sasun · n00b Joined: 07 May 2002 Posts: 15

ebrostig

drumz · Apprentice Joined: 10 Nov 2002 Posts: 213

I did successfully downgrade my laptop's glibc. The steps that I did are as follows:

1. su'd to root
2. cd /usr/portage/..... to directory containing glibc ebuild scripts
3. emerge ./proper.ebuild.script
4. Once completed, I got the same errors about not finding libraries and couldn't launch a new shell, and most commands didn't work.
5. I then did the 'ldconfig' command.
6. I was then able to launch new shells and everything seemed to work fine
7. Took a chance, rebooted and everything was still fine.

I will say this: Be carefull messing around with glibc. It's a nifty way of quickly destorying an install.

Drumz

drumz · Apprentice Joined: 10 Nov 2002 Posts: 213

I have question. If this whole issue revolves around the version of gcc (pertaining to linking), then why does it work fine under Redhat 8 (yes I know it's not supported). Redhat 8 has gcc 3.2...... Now that I've had to revert back to Redhat for my laptop, it's running Oracle fine under Redhat 8.

Drumz

ebrostig

ebrostig · Posted: Wed Feb 12, 2003 10:01 pm Post subject:

The problem has been identified and fixed.

Please see How to run Oracle 9.2 with glibc 2.3.1-r3 for detailed instructions on how to fix the problem.

Glibc was the problem

Erik
_________________
'Yes, Firefox is indeed greater than women. Can women block pops up for you? No. Can Firefox show you naked women? Yes.'

funeagle · Posted: Mon Sep 01, 2003 5:40 pm Post subject:

After long searchings on the internet how to install oracle I'm trying to install Oracle9i Developer Suite Release 2 (9.0.2) first and then I'll try to install Oracle9i Release 2 (9.2.0.1.0)
(is this the way I'm supposed to do it anyway ?)

I've created two scripts to install the Developer Suite:

jonnevers

I didn't read every post in this thread, but I'd like to state as a fact, that oracle 9i 9.2.0.1.0 does install totally and completely under gentoo 1.4

1.4rc3 to be exact with gcc 3.2.3

I've been running the database stabily for over a month and have over the last weekend update it to 9.2.0.4.0

one thing to note: if you have less then a gigabyte of ram, you should probably serisouly think about another db solution. if you have less then a 1.5GHZ process, you should probably serisouly think about another db solution. oracle isn't designed to be installed on any machine by anyone. if you want to actually use the machine for other tasks while the db is running, you should probably serisouly think about another db solution.

it took me the best of a month to even get the installer to complete, let alone have a working stable db instance. i started on redhat a long time ago......

- the install can be done over VNC but local terminal connect is the best,
- X windows is required for installation but not for running the database
- correctly setting up a unique ORACLE user and group is MANDATORY
- correctly setting up the DBA group is MANDATORY
- you cannot "connect / as sysdba" unless you are in the dba group
- having a .bashrc script that sets your oracle ENV settings BEFORE
starting the install process can practically automate the process

example:

export LD_ASSUME_KERNEL=2.4.1
export ORACLE_BASE=/oracle
export ORACLE_HOME=/oracle/u01
export ORACLE_SID="u01"
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
export LD_LIBRARY_PATH

export PATH=$PATH:$ORACLE_HOME/bin
export DISPLAY=:0.0

export EDITOR=vi
export PS1='\[\033[01;34m\]\u\[\033[01;37m\] \[\033[00;37m\]\W\[\033[01;37m\] \$ \[\033[00m\]'

with a script like that, the oracle installer will pull the installation settings from those ENVs - LIFE == GOOD

- and for the love of everything holy, READ ORACLES DOCUMENTATION
- of course you can't read it all, they have tomes full of VERY USEFUL
information - but read the ENTIRE installation guide and then read the
ADMINISTRATION guide

it is possible to run oracle 9.2.0.4.0 on gentoo 1.4 with gcc 3.2.3-r1 and glibc 2.3.2-r1, i know because I run a system exactly like that. the oracle listener works, and it is possible to remotely use TOAD (if you don't know what it is an dyou use oracle, google it immediately, your life will improve), to manipulate the db, pro*c compiles and interacts with the db correctly.

Jon

ebrostig · Posted: Wed Sep 03, 2003 9:33 pm Post subject:

You will not be able to get Oracle Developer Suite to work under Gentoo.

The database should be fine, but there are a few areas, occi is one of them, that will not work.

I'm running 9.2.0.4 without a hitch.

(edit) If you like Toad (only on Windows) try: emerge tora

Erik
_________________
'Yes, Firefox is indeed greater than women. Can women block pops up for you? No. Can Firefox show you naked women? Yes.'

uberfoo · n00b Joined: 24 Jul 2002 Posts: 9 Location: Dallas, TX

I have successfully installed a fully working instance of Oracle 9i 9.2.0.4 Enterprise with the current stable versions of the usual suspects:

gcc 3.2.3
glibc 2.3.2
binutils 2.14.90.0.6

Java management utilities (dbca, et al), Label Security, interMedia, etc... it's all there and it all works.

see http://uberfoo.net/oracle_gentoo.jpeg

If interest is expressed I'll cook up some instructions for all (maybe even an ebuild?!). The only caveat is that you can only get 9.2.0.1 from OTN (http://otn.oracle.com) and I could only get everything to successfully link with the 9.2.0.4 patch set from MetaLink (Oracle support contract / partnership required).

Gentoo was the only distro that could steal me away from my Slackware and I can finally run it everywhere. I personally don't give a flying fignut about "Certified Platforms", I like my Gentoo and finally I can embrace it throughout my datacenter.

I do believe this recent progress (and a case of Bawls) has given me the juice for an all-nighter to get my Gentoo Oracle 9i RAC Firewire Cluster Development Environment OCFS EVMS2 Thingy up and running for tomorrows all-night code fest... Oh it is a glorious day...

Once again, let any other Gentooers out there desiring the bloated beauty of Oracle on their boxen make themselves heard and I shall find the time to document the hell that is Oracle.

rugueux6767 · n00b Joined: 25 Aug 2003 Posts: 8

I've downloaded the archive twice, but when I run cpio, nothing happens ! I've tried to remerge cpio, but nothing happend !

Can so tell me what should I do ?
Thanks

incubator · Guru Joined: 05 Jun 2003 Posts: 584 Location: Belgium

uhm, wwell, perhaps you could tell them to reimplement the Oracle Navigator, I used it a lot in 8i, but didnt find it anymore in 9i. Shame though, was usefull to make new accounts.
Now I have no idea of how to make a new dba or any other user for that matter :/

ebrostig · Posted: Fri Oct 10, 2003 9:12 pm Post subject: Re: Success!

incubator · Guru Joined: 05 Jun 2003 Posts: 584 Location: Belgium

I was talking about the windows version actually.
I hada copy of oracle 8i Personal edition wich had oracle 8i Navigator (to view tables, users , etc in an explorer style windows). Now I downloaded oracle 9i from oracle.com but i cant seem to find that navigator anymore

And I looked into this enterprise manager, but I cant really work with it, I keep clicking for ages looking for a way to add users but eventually end up closing it since I cant find it anymore.
And our teachers never told us of how to create users, dba's in the SQL*Plus terminal.
Too bad though that oracle 9i wont work in gentoo 1.4 :S
I found it an interesting concept since we're getting PL/SQL in oracle this year, and at home I try to avoid windows now. And since I saw a linux version of oracle it looked like a good idea

Oh well....will have to stick to mysql here then ....

ebrostig · Posted: Fri Oct 10, 2003 10:42 pm Post subject:

you can run 9i under Gentoo but there are a couplke of things that will not work.

Also the navigator that you mentioned were only in the Personal Edition. I suggest that you use tora, it's a great tool and there is an ebuild for it.

Creating users in Oracle from SQL*Plus is easy;

incubator · Guru Joined: 05 Jun 2003 Posts: 584 Location: Belgium

ah thnx

but ehm, exactly what things wont work?

rugueux6767 · n00b Joined: 25 Aug 2003 Posts: 8

I've still this problem with cpio... I've the latest archive from the oracle server.. but cpio do nothing..
Do you know what to do ebrotig ?

ebrostig · Posted: Mon Oct 13, 2003 6:30 pm Post subject:

I'm not sure what kind of a problem you have extracting the archive as it should be working smoothly.

Here is the instructions from otn.oracle.com:

RikBlankestijn · Posted: Sat Feb 21, 2004 3:19 pm Post subject:

just for future reference by anyone, here is another thread that you might find usefull: Installing an Oracle database on my Gentoo machine. (Oracle9i Database 9.2.0.1.0)

andyfaeglasgow · Apprentice Joined: 09 Sep 2004 Posts: 170

I know this is an old thread, hope nobody minds a quick question.

Why should the gcc version affect an Oracle installation anyway? Surely it comes pre-compiled and would not need to use gcc.