Install of Oracle 8.1.7 on Mandrake 8.1 Need Help

[SunnyFr]

I am trying to install Oracle on Mandrake 8.1. The installer is working (./runinstaller) but not until the end.(can not find some .so files)

 

Does somone know if I need to put a new patch for libc (needed for Mandrake 8)

 

Thanks

[Gowator]

Hi SunnyFr,

 

First off - Welcome to Mandrakeusers.org :D

 

Your right about the glibc version. Sorry, I haven't done this for a LONG TIME so this is largely from memory!

 

Somewhere between 8.0 and 8.2 (from memory) Mandrake changed glibc rather drastically.

 

You will have a hard time (I remember I did) depending both on the glibc version AND the JRE.

 

Actually getting the installer to work is perhaps ironically the biggest challenge, adfter that if you install the management tools (also Java) you will have the same problems.

 

Its a long time ago but I remember BIG differences between 8.1.5 and 8.1.7 under linux so far as the libraries were concerned. 8.1.7 was MUCH easier.

 

If I remember correctly 8.1.5 needed the specific blackdown jre to install/run the tools.

 

I have notes somewhere at home (on a mothballed disk) which I mighht be able to find.

 

I think if you use 8.2+ practically all the problems disappear.

I used 8.1.7 under 8.2 for quite a while and it worked really well.

Once you sort out the linker with the LD_LIBRARY_PATH and mess with the SHMEM to get it running it flies!!!

 

I presume this is a produciton server so your a bit stuck with the Mandrake version, if not then Id say upgrade it first!

 

The problem is the glibc2 to glibc6 changeover. This involved a whole load of backports etc. and compatibility and if you try messing you stand to break Mandrake 8.1.

 

8.1.7 itself though is really stable!

I'm sorry I have loads of work at home right now and so I can't easily resuract the old disk ....

If you have specific quesitons it will probably job my memory though.

 

I remember the install instructions don't actually work. Its just a few minor common sense errors but frustrating all the same.

 

If you don't want the GUI stuff on the production server (since you plan to use it remotely which is normal) you can just transfer the instance and set the envvar's etc by hand.

[SunnyFr]

Thanks Gowator

 

 

I managed to run the installer on the mandrake 8.1, the Japanese site below is helpful to install the glibc patch, although I still have other pb.

 

ah! I also needed to install gcc (with binutils) and make..something. to work.

but I still have error.

 

Do you remember if we need other packages?

 

I have to try with Mandrake 8.2, but the bandwidth is not here. (download too slow)

I fund a old redHat 7.2 to test it before I get Mandrake 8.2 (which I enjoyed much more)

 

a Bientot,

SunnyFr

 

 

 

***************************************************************

Oracle8i 8.1.7 Standard on Redhat7.2 install

 

http://www.dotfoward.jp/DB/Oracle/Oracle8i...o8i817RH72.html

Japanese web site very useful see below:

--------------------------------------------------------------------------------

[SunnyFr]

Just for the glibc:

 

Oracle has a patch for the linking problem. You

should ignore the error, complete the installation and apply the patch:

 

http://download.oracle.com/otn/linux/oracl....3-stubs.tar.gz

 

You will find instructions for apply the patch in the file README.stub inside

the package.

 

You will need an OTN valid login, Oracle give you an OTN account for free at:

 

http://otn.oracle.com/

 

If the URL of the patch does not work try to go to the Download seccion in the

OTN site, then select Oracle 8i on the archive products, then choose Oracle 8i

for linux and you will be able to reach the Oracle 8i installer and the patch.

[Gowator]

Yeah I got my OTN registration.

I eventually cancelled it becuase they kept sending me the norwegian version since I registered when I lived in Norway.

 

I can read the articles OK but the seminars, training etc. are all useless.

 

Sorry to say this here .... BUT.

If you want Oracle 8.1.7 to work then RH 7.2 will be better.

They made a REAL MESS in RH7.0 with their glibc changeover but it was fully fixed by 7.2 (7.1 having lots of patches but not a full changeover.)

 

I think the Mandrake 8.2 is equivalent in terms of it being fully upgraded to the newer glibc. So any Mandrke 8.2+ will cause you less problems.

 

Once I resurrect my home server I sould have both the binaries install and the patches for 8.1.7.

Are you in France? Europe?

I could post you the Mdk 9.1 Cd's + the oracle stuff ...

(perhaps even 9.2 when I get round to downloading it. )

Will depend on your timetable/deadline.

 

 

A+

Si vous preferez envoyer un <<pm>> en francaise.

Edited November 25, 2003 by Gowator

[SunnyFr]

Just tried with the RH7.2, (the attached O'relly version, shouldn't be a pb)

but the ./runInstaller doesn't start. I have checked the libraries and seems to be all there. (..)

 

At least this was starting in mdk 8.1

 

I got a 9.2 (and 9.1) but it seems to be worst for oracle 8.1.7.

even install it at home. (start to be very good, but not enough for my wife...)

Thanks for the offer.

The oracle stuff would be welcome. ( especially the patches maybe by email?)

 

I am coming back to mdk 8.1, and will check everything again.

 

 

Thanks

Ps:

Je suis en europe.

Pas en France.

[Gowator]

SunnyFr

If I remember the runInstaller is a bash script

Try with a sh -x (I seem to remember it threw up errors like envvar's not being set etc. so I added them etc. )

 

I remember it being a real hassle to install but worked like a dream once it was installed so its worth some effort.

 

As soon as I get my server back on line ill have a look for my own README that I made last time.

 

Europe post is all the same so no pb to mail it or email it.

p.s. I'm English but in France.....

Strange old world....

:P

[SunnyFr]

Hi Gowater,

 

I already install all the ENV in the .bash_profile so the ORACLE_HOME /_SID etc... seems ok.

 

The main pb when I run the ./runInstaller (or sh -x ./runinstaller) is these 2 errors

 

1.

"Thrown when the IP can not be determined"

-> this I thought should stop the install process

 

2.

"Error in invoke target install Make file"

->this happening for a lot of ".mk" files. One of them been $ORACLE_HOME/plsql/lib/ins_sql.mk

$ORACLE_HOME/sqlplus/lib/ins_sqlplus.mk

and others ".mk" files

 

Do you remember which extra PATH to set up?

or do you think it is due to the glibc?

 

Thanks

SunnyFr

eh oui what a strange world.

but I will not complain, except that I miss the cheeses.

[Gowator]

I'm still half guessing but...

1) If it can't find the IP does it have a valid and working tnsnames.ora ?

Although during a first install it shouldn't have one but yeah I guess it will fall over if it can't find its valid hostname or IP.

 

2) Heck I remember those now!!!!

If I remember these build the oracle catalogue (the internal tables)

However I think this is probably the PATH not the LD_LIB but now I wrote it Im not sure anymore.

 

Take heart, it is possible, I did it..... But it certainly involved a lot of messing about.

 

Perhaps post up the ORACLE part of the .bash_profile and see if it jogs my memory....

I remember just running a lot by hand and adding the envvar's or PATHs needed for each one!!!!

 

Lets see how far I get rebuilding my server tonight and I might find my README!!!

If not I guess you just do it the hard way!!!!

[SunnyFr]

oh OH !!

 

Allmost there, I have just fine mdk8.2 and did an upgrade.

 

I still have the Error 1

 

1.

"Thrown when the IP can not be determined"

-> this I thought should stop the install process

 

but the other errors are gone ... great allmost up to the end.

 

one bad thing is that another error came

Error 3.

"Error in writing to file

$ORACLE_HOME/Apache/Apache/conf/ssp.key/server.key"

 

But I guess that if I install everything from scratch (again) this one should go.

 

About the Error 1. , I am not sure why. maybe it is due to the fact that I had installed other services. ...

 

SunnyFr

[Gowator]

Heres what I had in my ORAINSTALL user .bashprofile

 

# .bash_profile

 

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

 

# User specific environment and startup programs

 

PATH=$PATH:$HOME/bin:/ora/bin

export ORACLE_HOME=/ora

export TNS_ADMIN=$ORACLE_HOME/network/admin

export LD_LIBRARY_PATH=$ORACLE_HOME/lib

export PATH

 

 

and my README, not as detailed as I remebered BUT its here anyway....

export LD_ASSUME_KERNEL=2.2.5

/usr/i386-glibc21-linux/bin/i386-glibc21-linux-env.sh

 

 

ORACLE_DOC

otherwise starts new directory tree.

ORACLE_BASE /mnt/prog/ORACLE/u01/app/oracle

 

Add Patch as root from ORACLE_HOME when fails,

then continue to end of install.

Netasst should start OK

 

 

Anyway, server back up so Ill search a bit deeper!!!

[SunnyFr]

HI gowator,

 

My .bash_profile is a bit different but I probably didn't go through the same installation process.

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

ORACLE_HOME=/u01/app/oracle/product/8.1.7; export ORACLE_HOME

ORACLE_SID=ora1; export ORACLE_SID

PATH=$PATH:/u01/app/oracle/product/8.1.7/bin; export PATH

CLASSPATH=.:/u01/app/oracle/product/8.1.7/jdbc/lib/classes111.zip; export CLASSPATH

LD_LIBRARY_PATH=/u01/app/oracle/product/8.1.7/lib; export LD_LIBRARY_PATH

 

 

I have re-install mdk8.2

 

the error 1

*************************************

1.

"Thrown when the IP can not be determined"

-> this I thought should stop the install process

************************************

was due (I think..) to the fact that I put DCPH on the IP setup, and doesn't seems to like it.

I also install the minimum this time: KDE, gcc, binutils, make, egcs(not sure if useful this one)

no other apache server or ftp server in case it creates pbs during install

 

the error 3

**********************************

"Error in writing to file

$ORACLE_HOME/Apache/Apache/conf/ssp.key/server.key"

**********************************

was solved when I re-installed everything from sratch.

 

and the errorS 2 disappear when using the mdk 8.2

 

 

 

EVERYTHING WENT FINE until the 99% of the install

 

ERROR 4

**************************************

ORA-03114: not connected to oracle.

**************************************

 

This probably due to the network, as it is share with some XP system I didn't configure it correctly?? I have to check.

 

PS:

I attached the procedure I have follow, works well with Mdk 8.2

Doesn't work with redHat 7.2 (without fix), not with Mdk 9.1 or Mdk 8.1 (without patches)

817.html

[SunnyFr]

TO summarized:

 

Works oracle 8.1.7 with Mdk8.2.

 

but I still have to fix the following

 

ERROR 4

**************************************

ORA-03114: not connected to oracle.

**************************************

 

I have choosen during the installation the network address:

 

linux1.localdomain

 

(linux1 refering to the host IP address of my machine)

I have to check and put something else than local domain, hopefully it will fix it

 

Thanks

[Gowator]

Oracle installer involvesa lot of static linking and stuff which the hostname and IP is needed for.

 

Experience has told me it hardcodes the fully qualified domain name (FQDN) into the startup scripts etc. if it had one at the time in was installed.

 

The best way around this (if you want to use dhcp) is probably to create a local /etc/hosts (even if you are using dhcp) and then set the nsswitch.conf (I think) to files,dns in that order.

You need to set-up the DHCP server to always allocate the same address to the NIC on the oracle machine.

 

Alternatively choose a static IP and put this in the /etc/hosts

 

If you have a firewall etc. then by default oracle uses port 1521 (if I remember) so you obviously need to let it through!

 

You particular error is actually solvable, (probably) I seem to remember the same thing so I started Oracle manually from the command line.

It should have created a script for this in rc2.d .. which might not work!!!

If it doesn't (which I seem to remember) I just ran through it line by line. Ironed out envvar's etc that weren't set and get it up and running.

 

From there the installer if my notes are correct starts netasst....

If it crashed here the easiest is to try starting it from the CLI.

 

If I remember theere's an executable in $ORACLE_HOME/bin which starts all the different java stuff and gets passed the actually java app as a command line option.

Alternatively, all it does is make your TNSNAMES.ORA file in $ORACLE_HOME/network/admin (or poss admin/network)

 

If you are familair with them you can just make your own in a text editor....

 

 

here's a sample

################

# Filename......: tnsnames.ora

# Date..........: Fri Oct 11 04:31:18 1999

################

 

mydb =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = TCP)

(Host = fi92-oraserver1.internal.local)

(Port = 1521)

)

)

(CONNECT_DATA =

(SID = mydb)

)

)

 

You can test you connections using the tnsping utility in the bin dir.

ie.

tnsping mydb

[SunnyFr]

AH voila...

 

It s working !!!

 

the last error (see below) was due to the database name.

I was using "linux1.localdomain"

 

now I use "ORA1.linux1"

 

linux1 been the name of my machine.

 

 

So If anybody want to use oracle 8.1.7 with Mandrake 8.2, follow the steps.

 

Thanks Gowator for your advices.

 

 

 

ERROR 4

**************************************

ORA-03114: not connected to oracle.

**************************************