I started up the install, with LD_ASSUME_KERNEL set to 2.2.5 as always. The install stopped with an error linking in ins_precomp.mk. At that point I installed the glibc patch, and that let me continue for a bit. But now I'm stuck on ins_oemagent.mk, getting the same ctype errors Guan describes.

I found this thread discussing the problem, which doesn't look good...

http://www.redhat.com/archives/taroon-beta-list/2003-September/msg00238.html

Has anyone managed to get past this?

One note: I haven't installed compat-glibc-6.2-2.1.3.2.i386.rpm (which is actually from Red Hat 7.3). Is this package necessary? And where exactly should __ctype_b be defined?

It would be cool if we had a database of successful OpenACS installs with Linux distribution, database version, etc., so I could verify that this combination actually exists in production environments. I really don't want to go back to Red Hat 8.0.

I installed Oracle 8.1.7 (and then the patch 8.1.7.4) on a repackaged distribution of RHEL 3.0.

The installation required very little fidling and some hacks that make me think that this way of installing it might not be a production-ready setup but at least it works for OpenACS 5.1 / Oracle 8i on development.

When you install RHEL 3, make sure you have all the compat-* RPMs installed. Before starting runInstaller, make sure you issue export LD_ASSUME_KERNEL=2.2.5 and that you have the glibc-stubs patch from Oracle as well. I also did:

# cd /usr/bin
# mv gcc gcc32
# ln -s gcc296 gcc

I get the makefile target errors but I ignore them. And the Net8 assistant for the listener also craps out ... killall jre was my friend at that stage but the netca produced all the necessary files.

I also had to copy in $ORACLE_HOME/bin, lsnrctl0 to lsnrctl, tnslsnr0 to tnslsnr and extproc0 to extproc . And then go to $ORACLE_HOME/ctx/bin/ and copy ctxhx0 to ctxhx.

After that, I could start my oracle DB and my listener as well.

Of course, all this assumes that you have modified the kernel parameters as recommended by Oracle, that you have access to a machine already running Oracle 8i just in case, so that you can get the proper working listener.ora and tnsnames.ora in case netca doesn't work for you.

At least this works fine for me ...

Just my 2 cents

Cheers

I like to try to find the minimum set of steps needed to do these things, so I didn't install the compat RPMs or any of the other extra steps people mentioned (yet, anyway).

Here are the steps I've followed so far:

1. make sure LD_ASSUME_KERNEL is set to 2.2.5
2. run through the 8.1.7.0 install, choosing ignore for all errors
3. at the second root.sh prompt, run root.sh and then apply the glibc patch
4. the Net8 Assistant never comes up, which hangs the install, so kill it at this point
5. run netca by hand, and kill it again when it hangs because lsnrctl doesn't exist (it needs to be created as Bruno mentioned above)
6. install 8.1.7.4 patch, choosing ignore for all errors
7. apply the glibc patch again
8. run a script to cp and chmod files that are missing or have permissions set wrong (see below)
9. run dbassist and save files to disk
10. manually run the first file dbassist creates

error while loading shared libraries: libskgxp8.so: cannot open shared object file: No such file or directory

This is absolutely correct - that file does not exist. I do have libskgxp8.a, but I don't know how to get from here to there. I found a few threads on this in Google but no answers. There are no errors related to this library in the make log, so I don't think the answer is that a step failed (though I could certainly be wrong).

In fact, after having spent an inordinate amount of time trying to figure out why this file isn't getting built, I realized that I don't have it on any of my other Oracle installations either. They all have just the .a. So now I'm *really* confused. Why would it be looking for a .so on this system when it has obviously never needed one before?

Any suggestions? My next thought is to try changing the gcc version, like Bruno suggested, but I've spent so much time on this already I thought I'd solicit other opinons before spinning my wheels any further.

Here is the script I'm using to fix up the files and permissions, in case anyone else needs it. I created this by comparing the output from "ls -l" on this system and on one of my other ones. This is probably more than actually matters, but since I don't know what many of these programs do I figured it wouldn't hurt to clean things up a bit.

chmod 751 agtctlO
cp agtctlO agtctl
chmod 751 cmadminO
chmod 751 cmgwO
chmod 751 cmctlO
chmod 751 ctxloadO
chmod 751 ctxsrvO
chmod 751 cursizeO
chmod 751 dbfsizeO
chmod 751 dbvO
cp dbsnmpO dbsnmp
chmod 751 exp
chmod 751 extprocO
cp extprocO extproc
chmod 751 hsallociO
cp hsallociO hsalloci
chmod 751 hsdepxaO
cp hsdepxaO hsdepxa
chmod 751 hsotsO
cp hsotsO hsots
chmod 751 imp
chmod 751 kgmgrO
chmod 751 loadpspO
chmod 751 lsnrctlO
cp lsnrctlO lsnrctl
chmod 751 maxmemO
chmod 751 migO
chmod 751 namesctlO
chmod 751 namesO
cp oemeventO oemevent
chmod 751 onrsdO
chmod 751 oracleO
chmod +s oracleO
cp oracleO oracle
chmod 751 orapwdO
cp oratclshO oratclsh
chmod 751 otrccolO
chmod 751 otrccrefO
chmod 751 otrcfmtO
chmod 751 otrcrepO
chmod 751 rman
chmod 751 sbttestO
chmod 751 sqlldr
chmod 751 sqlplusO
chmod 751 svrmgrlO
chmod 751 tkprof
chmod 751 tnslsnr*
chmod 751 tnspingO
chmod 751 trcasstO
chmod 751 trcroute
chmod 751 trcrouteO
chmod 751 tstshmO
chmod 751 wrapO

[oracle@abyssinian bin]$ svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.

oraclemuffin: error while loading shared libraries: libskgxp8.so: cannot open shared object file: No such file or directory
oraclemuffin: error while loading shared libraries: libskgxp8.so: cannot open shared object file: No such file or directory
ORA-12547: TNS:lost contact

I didn't install http or advanced replication either, or a couple of other things we never use (I forget the exact names now). But I always skip those so it should be ok.

The listener error is more generic:

[oracle@abyssinian bin]$ lsnrctl start

LSNRCTL for Linux: Version 8.1.7.4.0 - Production on 08-JUN-2004 09:52:55

(c) Copyright 1998 Oracle Corporation.  All rights reserved.

Starting /export/oracle/product/8.1.7/bin/tnslsnr: please wait...

TNS-12545: Connect failed because target host or object does not exist
 TNS-12560: TNS:protocol adapter error
  TNS-00515: Connect failed because target host or object does not exist
   Linux Error: 2: No such file or directory

I just did an "strace -fF -o strace.out svrmgrl" and then checked on the "strace.out" file and I can't see any reference (not even file not found) to libsk* ... Can you do an strace and see when it's loading (or trying to load it?) and where it's looking for it?

/B

[oracle@abyssinian bin]$ ldd oracle
        libskgxp8.so => not found
        libjox8.so => /export/oracle/product/8.1.7/lib/libjox8.so (0xb725d000)
        libobk.so => /export/oracle/product/8.1.7/lib/libobk.so (0xb7254000)
        libdl.so.2 => /lib/libdl.so.2 (0xb7251000)
        libm.so.6 => /lib/i686/libm.so.6 (0xb722e000)
        libpthread.so.0 => /lib/i686/libpthread.so.0 (0xb71dd000)
        libc.so.6 => /lib/i686/libc.so.6 (0xb70a4000)
        /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0xb75eb000)

I did that (editing setup_stubs.sh) a few days ago and this is what I got:

I get this error when linking oracle

/usr/bin/ld: /export/oracle/product/8.1.7/rdbms/lib/oracle: hidden symbol `__fixunssfdi' in /usr/lib/gcc-lib/i386-redhat-linux/3.2.3/libgcc.a(_fixunssfdi.oS) is referenced by DSO

This one when linking extproc, agtctl, hsalloci, hsots, hsdepxa

/usr/bin/ld: /export/oracle/product/8.1.7/rdbms/lib/extproc: hidden symbol `stat64' in /usr/lib/libc_nonshared.a(stat64.oS) is referenced by DSO

The ctype errors when linking oemagent, dbsnmp, oratclsh, tnslsnr, lsnrctl

then ins_precomp.mk errors out without building anything because it tries to execute

rm -f /export/oracle/product/8.1.7/bin/

which of course doesn't work

Then these errors when linking ctxhx

/lib/libdl.so.2: undefined reference to `__ctype_b_loc@GLIBC_2.3'
/lib/libdl.so.2: undefined reference to `_dl_addr@GLIBC_PRIVATE'
/lib/libdl.so.2: undefined reference to `_dl_open@GLIBC_PRIVATE'
/lib/libdl.so.2: undefined reference to `_dl_close@GLIBC_PRIVATE'
/lib/libdl.so.2: undefined reference to `_dl_sym@GLIBC_PRIVATE'
/lib/libdl.so.2: undefined reference to `_dl_vsym@GLIBC_PRIVATE'

So some are ctype errors and some aren't.

I might be able to fix some of these by installing the compat packages, but that won't fix the ctype errors.

Clues, suggestions, etc?

thanks,

janine

Anyway, I stopped trying to get the compile to work at that point.

Francisco,

I don't know which file you are refering to but you might find what you need to know in order to install Oracle 8.1.7 on RedHat 9 at http://www3.sympatico.ca/arothmel/oracle/817.html.

/Bart
the Code Mill