Re: Anyone had problems upgrading from Oracle v7.1 to v7.3?

I just wrote the following for an earlier posting, and basically have copy and pasted it for you here in case you missed it.

Currently we are running a 7.1.6.2 database on one DEC Unix 3.2 machine and I have just installed a 7.3.3 database on another DEC Unix 4 box. Installation of 7.3.3 database was fairly easy with one patch obtained from Oracle taking the database to 7.3.3.3. I've just copied all the backup scripts across and with a little tweaking backup scripts now appear to be working fine. My last job is to export the database from the 7.1.6.2 database and import it into the 7.3.3.3 database. I hope this will be problem free. Biggest problem will most likely be moving all the developers across to the new db
(ungrateful mob that they are).

Problems I had with 7.3.3.3 install were: 1) First installation failed because I didn't have the X motif libraries installed under /usr/lib (I think that was the directory). Oracle installer complains when it can't find the libraries but allows you to proceed. However later when the installer relinks all libraries it can't find the motif libraries and chucks a wobbly
(allright, that didn't sound so technical but who cares?).
2) Once installed running sqlplus username/password worked fine, but using sqlplus username/password_at_oracle_sid resulted in an TNS error. According to Oracle this is known bug which has yet to be fixed. Oracle has a workaround which you can place in your sqlnet.ora. Unfortunately the workaround makes it impossible for a connect internal into server manager and therefore you can't shutdown and startup your database for backups etc (doh!).

Sorry, can't give you patch numbers or bug numbers from Oracle cause I'm writing this from home. If your really desparate for them either email during business week where I can give you more help or drop Oracle support a line.

Hope this is useful.

My email address is: c-muir_at_mits-wa.co-m.a-u Just remove dashes from address because I don't like spam. Also sorry if you see my .sig below which is telling you the same stuff about my email address. I'm using a new news-reader and I'm not sure it works correctly yet (ie is it sending the signature?).

Chris Muir
Software Engineer
MITS (Western Australia) Ltd

All information is my own and does not represent that of my employer.

I dont promise all information that I give is 100% accurate.

The email address in the from header in this message has been changed to avoid spam. Please remove all dashes and spaces from the following address to email me: c muir_at_-mits-wa.co-m.au Received on Sat Oct 04 1997 - 00:00:00 CDT