Oracle-L: RE: 7.3.4 on hp-ux11 upgrade problem

From: M Rafiq <rafiq9857_at_hotmail.com>
Date: Wed, 27 Aug 2003 13:24:28 -0800
Message-ID: <F001.005CD883.20030827132428@fatcity.com>

HP-UX 11 binaries are not compatible with 10.20. There is no upgrade path for 10.20 to HP 11 or 11.11 when you want to use Oracle.

As per Oracle Spoort sometimes in 2001-02 , install HP-11 on new box or existing box from scratch and apply all OS patches required for Oracle.

Install 7.3.4 binaries for HP-11. Copy over your datafiles/controlfiles/logfiles of 10.20 to HP11 and migrate first your 7.3.4 database. We did this sometime in 2001 with Oracle Financials 10.7 at my last employer hence no paper work available now with me.

Then onward you can move to 8i or 9i whatever and follow upgrade/migration Oracle docs.

Regards
Rafiq

Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Wed, 27 Aug 2003 07:34:26 -0800

I have read the manuals and conflicting posts on metalink and have asked first oracle what to do and they're advice was to take 10.20 cd's and install them on 11.11. This was done before this post.

If you want to know where to find this in manuals let me know.

Jeroen

-----Oorspronkelijk bericht-----

Van: Jesse, Rich [mailto:Rich.Jesse_at_qtiworld.com] Verzonden: woensdag 27 augustus 2003 16:49 Aan: Multiple recipients of list ORACLE-L Onderwerp: RE: 7.3.4 on hp-ux11 upgrade problem

Among changes like nearly the whole data dictionary, the format of the ROWIDs for every row in the DB is different. You need to migrate the DB. Kindly RTFM.

Rich

Rich Jesse                           System/Database Administrator
rjesse_at_qtiworld.com                  Quad/Tech Inc, Sussex, WI USA

-----Original Message-----

Sent: Wednesday, August 27, 2003 8:49 AM To: Multiple recipients of list ORACLE-L

Hi,

We're busy setting up an upgrade for oracle 7.3.4 hp-ux 10.20 to
oracle 9.0.1.0 on a different hp-ux 11.11 box.
In order to be able to migrate we installed 7.3.4 on this machine,

copied datafiles and config.ora, init.ora and listener.ora We only run the old listener (this starts correctly) and we try to bring up our copy on this
machine. We encounter the following problem

pablo:oracle>/opt/oracle/product/7.3.4/dbs $svrmgrl

Oracle Server Manager Release 2.3.4.0.0 - Production

ORA-12547: TNS:lost contact
SVRMGR> connect internal;
Password:
ORA-12547: TNS:lost contact
SVRMGR> startup
LCC-00161: ORACLE error (possible syntax error) parameter [NULL] ORA-12547: TNS:lost contact

Environment has been set to the right oracle_home, also tns_admin Any idea what causes this? Installation or configuration problem?

Thnx in advance,

Jeroen
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Jesse, Rich

INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


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

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Jeroen van Sluisdam

INET: jeroen.van.sluisdam_at_vrijuit.nl

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


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

To REMOVE yourself from this mailing list, send an E-Mail message

MSN 8: Get 6 months for $9.95/month http://join.msn.com/?page=dept/dialup

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: M Rafiq
INET: rafiq9857_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


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

To REMOVE yourself from this mailing list, send an E-Mail message