How to run Oracle 9.2 with glibc 2.3.1-r3

ebrostig · Last edited by ebrostig on Sat Mar 08, 2003 1:24 am; edited 1 time in total

There has been several threads on this board asking how to run Oracle 9.2 with glibc 2.3.1. The symptoms has been that the startup process takes a long time, finally erroring out with an ORA-03113, the alert.log could also report an ORA-07445 or ORA-00600 error.

We have now identified the problem and it is actually a typo in the glibc source code that resulted in the errors seen above.

We have opened a bug with the glibc development team and the fix should be in the next release of glibc. In the mean time, here is how to fix the problem:

1. Unpack the latest glibc source

rizzo · Posted: Wed Feb 12, 2003 10:13 pm Post subject:

Until the glibc code is fixed, could someone write a patch for the gentoo ebuild to fix these lines automatically in the src_unpack() stage of glibc?

psp · Posted: Thu Feb 20, 2003 2:38 pm Post subject:

I am writing just to confirm that the above patch did indeed work for me. I am using "Gentoo Base System version 1.4.2.8", glibc-2.3.1-r2 (+patches) and gcc-3.2.1-r6.

The only other problem I had was the "Error in invoking target install of makefile $ORACLE_HOME/ctx/lib/ins_ctx.mk". This easily resolved using the install guide from here

Thanks alot for this...

javabug · n00b Joined: 15 Feb 2003 Posts: 4

deathdruid · Posted: Fri Feb 28, 2003 9:53 pm Post subject: emere -u world needed?

Do we have to recompile our whole Gentoo system if we do this glibc recompile?

Thanks,
Rahul

javabug · n00b Joined: 15 Feb 2003 Posts: 4

psp · Posted: Mon Mar 03, 2003 12:19 pm Post subject:

Updating oracle 9.2.0.1 to 9.2.0.2 also works. But when installing the latest security fixes, using the OPatch utility, I've found that one script needs minor tweaking.

You need to change the absolute path to basename from /bin/basename to /usr/bin/basename in the script: ${ORACLE_HOME}/bin/genagtsh

rizzo · Posted: Thu Mar 06, 2003 4:14 pm Post subject:

I'm trying to run TOra on a box that I've installed Oracle 9.2.0.1 client on. It would crash when I tried to connect to my Oracle 7.3.4 hp-ux server. The client is a gentoo 1.4 box with gcc3 and the fixed glibc (per your instructions).

gdb reveals this:

ebrostig · Posted: Fri Mar 07, 2003 12:03 am Post subject:

Rizzo:
Easy! 9.2.x client CAN NOT be used to connect to a 7.3.x server.

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

rizzo · Posted: Fri Mar 07, 2003 1:27 am Post subject:

Ah. I was beginning to suspect this. I've been using a 9.0.1 client just fine on my gcc2 box. I'll install 9.0.1 on the box and see if it works then.

edit: OK I searched around and saw some official notices. I'll assume that 9.0.1 client will talk to 9.2.0.1 server, as that is what I'm migrating our 7.3.4 server to this year.

ebrostig · Posted: Sat Mar 08, 2003 1:22 am Post subject:

If you have access to MetaLink (metalink.oracle.com), you should look at <Note:189908.1> ALERT: Oracle9i Release 2 (9.2) Support Status and Alerts
(Just put the note number into the search box)

This note contains a link to another document which discusses connections to 7.x (Name of document: Connections from Oracle 9.2 to 7.X are Not Supported )

Hope this helps you

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

piusvii · n00b Joined: 13 Feb 2003 Posts: 12

I'm pretty new to gentoo but I'm trying to get oracle 9.2 running. I am following the http://www.puschitz.com instructions but get the following error:

Initializing Java Virtual Machine from /tmp/OraInstall2003-04-09_11-11-02AM/jre/bin/java. Please wait...
/tmp/OraInstall2003-04-09_11-11-02AM/jre/bin/i386/native_threads/java: error while loading shared libraries: libstdc++-libc6.1-1.so.2: cannot open shared object file: No such file or directory

I am using glibc 2.3.1r4 so perhaps I'm having the issues that 2.3.1r3 had. There was a note that this was fixed in 2.3.2 but I can't find it in the emerge system. Any help?

piusvii · n00b Joined: 13 Feb 2003 Posts: 12

OK, I got 2.3.2 updated via emerge and re-ran the Oracle installer but got the same error message as above from (apparently) java. Any ideas?

ebrostig · Posted: Wed Apr 09, 2003 10:45 pm Post subject:

Hmm, not sure why it complains about that library.

Here are the path to my copies of them:

psp

sandoz · Posted: Thu Apr 24, 2003 1:15 am Post subject:

Emerging lib-compat worked for me. Well, to run the Java installer at least. We'll see if I need to upgrade glibc in order to run the database when I get to that point.

Thanks psp!

taskara · Posted: Fri May 02, 2003 12:05 am Post subject:

any progress on the whole oracle on gentoo side?

what kernel do you guys use ?

and how tightly have you secured your box?
_________________
Kororaa install method - have Gentoo up and running quickly and easily, fully automated with an installer!

ebrostig · Posted: Fri May 02, 2003 10:54 pm Post subject:

What do you mean?
If you are asking for an ebuild, just forget it.
The installation process of Oracle is not something that can be done through an ebuild, this is not your average software package. I doubt that there exist any more complex commercial software today than Oracle Enterprise Edition. Oh, forgot to mention, it consists of 3 CD's that can be downloaded. From there on, installation happens as user oracle, not as root..

I have tried to create an ebuild, but the problem is with the install process and creating and changing users during the install phase. In addition to that, you need to change several kernel parameters throug /proc/sys/kernel to accomodate the big shared memory segments that Oracle needs.

I run Oracle with both 2.4.20 and 2.5.68. The most important part is actually glibc, where I run 2.3.2 now.

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

taskara · Posted: Fri May 02, 2003 11:20 pm Post subject:

yeah.. well I was sort of meaning in terms of security for a stand alone, dedicated oracle box.

I had already installed oracle on my gentoo box, but I've been informed to forget oracle on gentoo, so I guess I'll go redhat

_________________
Kororaa install method - have Gentoo up and running quickly and easily, fully automated with an installer!

ebrostig · Posted: Fri May 02, 2003 11:41 pm Post subject:

If you are going to use Oracle in a production environment and you pay for supoort, then you have to move to a supported platform.

Speaking of RedHat, that means RedHat AS or ES 2.1 when it comes to Oracle 9.2. Anything else means no support from Oracle.

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

TexanBrit · n00b Joined: 22 Apr 2003 Posts: 1 Location: Houston, TX

Please note that you can also get support for Suse, in fact Suse have more developers at Oracle than Red Hat.

Also documentation for installing on suse is streets ahead of RH, see http://www.suse.com/oracle
_________________
Let the good times roll

tg2003 · n00b Joined: 12 Aug 2003 Posts: 9

Hi Gentoo Team,

I have downloadad the Oracle 9i installer.

When I do "runinstaller", the Universal Installer luanches and I get a nice window for a split second. Then I lose the contents of the window expect for th upper right corner.

I can use keyboard commands and move forward, but why can't I see the whole window?

Any ideas?

I did not burn a CD...I just ran the files from my spare hard disk.

Tim

I have a screen shot I can mail out if anyone wants to see it...

ebrostig

leon_73 · Guru Joined: 13 Mar 2003 Posts: 505 Location: Milano

Hi all,

could some of you tell how much space do I need to install just the client on my gentoo

Thanks to all.

Leo

ebrostig · Posted: Thu Aug 14, 2003 6:04 pm Post subject: