| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re:RE: Migration from HP-UX 10.20 to HP-UX 11 and Oracle 7.3
Lisa,
Regrettably I can't release any more specifics due to company "proprietary data" requirements, but we moved an application database from an HP9000 K570 4way to a L2000 2way. On the older machine it was taking 6 minutes to process a work order for the robotic line. We moved it to the L2000 with HP-UX 11.0 and Oracle 8.0.5 32 bit, result 3 minutes per work order. We then upgraded to 805 64 bit database (full exp/imp), result 1 minute per work order. Please note only the database changed. The application program remained on HP-UX 10.20 on the K570 and the test work order remained the same (same model number, bill of materials, and line configuration). Since the application has been recompiled on HP-UX 11 32 bit (due to 3rd party library) and it is now processing one work order every 30-45 seconds. This generated a problem in that the line can't process the work as fast as we can sequence it.
Dick Goulet
____________________Reply Separator____________________Subject: RE: Migration from HP-UX 10.20 to HP-UX 11 and Oracle 7.3.4 Author: "Koivu; Lisa" <lkoivu_at_qode.com>
Dick, you say that 64-bit is faster than 32-bit. We recently had to investigate whether or not to go 64-bit (we are also HP/UX 11.0) with the O/S and the RDBMS. I searched the net exhaustively trying to find something other than 'you can have an SGA larger than 2GB' for a reason to choose 64bit. I read that 64-bit was only really beneficial to very large OLTP systems (which we aren't, really).
Can you substantiate your statement below? I would be interested in any metrics, white papers, ANYTHING that would explain this in more detail. I understand the difference between 32-bit and 64-bit, I just am at a loss to understand what exactly this buys me.
I was also wary of choosing 64-bit for the RDBMS because we are HP/UX, the second tier for patches, upgrades, etc. Undesirable situation to be in, to begin with (in my opinion). I thought if we then went 64-bit RDBMS we would have to wait even longer for patches and upgrades.
Thanks in advance for your comments.
Happy Friday everyone, I'm off to Vegas!!
Lisa
Ft. Lauderdale, FL, USA
-----Original Message-----
From: dgoulet_at_vicr.com [mailto:dgoulet_at_vicr.com]
Sent: Friday, August 18, 2000 10:17 AM
To: Multiple recipients of list ORACLE-L
Subject: Re:Migration from HP-UX 10.20 to HP-UX 11 and Oracle 7.3.4 t
Rafiq,
It depends on whether your going to be on HP-UX 11 32 or 64 bit. HP-UX
10.2
was strictly 32 bit, but HP-UX 11 gives you a choice, somewhat dependent on
the
hardware. If your remaining on older HP9000 E,G,K class machines then your
stuck with 32 bit. If your headed for the newer L & N class then you have a
choice (BTW: take 64 bit if it's available, it is faster).
Now, from an Oracle perspective, If your staying with 32 bit then the
datafiles
are compatible & it's just a version upgrade. If it's 64 bit, then an
export,
database rebuild & import will be required. BUT, since you state that your
headed for new hardware (of whatever flavor) in the first place, this is an
optimum time for a little house cleaning so take it. Golden opportunities
like
this are few & far between.
Dick Goulet
____________________Reply Separator____________________ Author: "Mohammad Rafiq" <rafiq9857_at_hotmail.com> Date: 8/17/00 12:17 PM
Hi Gurus
I need expert guidance for our future move to HP-UX 11 from HP-UX 10.20.
Existing setup:
Platform HP
HP-UX 10.20
Oracle 7.3.4.5
Oracle Financials 10.7(Char) with Oracle Manufacturing/Bill Of Materials
Customized forms(2.3) and reports(2.5)
Future Move:
Platform HP
New Machine
HP-UX 11
Oracle 8.1.6
Oracle Financials Release 11i
Conversion of Customized Forms & Reports to Forms/Reports 6i
Please advise your experience or opinion to carry out above migration smoothly as Oracle Support guidance is so far contradictory.
Regards
Rafiq
-- Author: Mohammad Rafiq INET: rafiq9857_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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). -- Author: INET: dgoulet_at_vicr.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).Received on Fri Aug 18 2000 - 09:44:11 CDT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12">
<TITLE>RE: Migration from HP-UX 10.20 to HP-UX 11 and Oracle 7.3.4 t</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Dick, you say that 64-bit is faster than 32-bit. We
recently had to investigate whether or not to go 64-bit (we are also HP/UX 11.0) with the O/S and the RDBMS. I searched the net exhaustively trying to find something other than 'you can have an SGA larger than 2GB' for a reason to choose 64bit. I read that 64-bit was only really beneficial to very large OLTP systems (which we aren't, really). </FONT></P>
<P><FONT SIZE=2>Can you substantiate your statement below? I would be
interested in any metrics, white papers, ANYTHING that would explain this in more detail. I understand the difference between 32-bit and 64-bit, I just am at a loss to understand what exactly this buys me. </FONT></P>
<P><FONT SIZE=2>I was also wary of choosing 64-bit for the RDBMS because we are
HP/UX, the second tier for patches, upgrades, etc. Undesirable situation to be in, to begin with (in my opinion). I thought if we then went 64-bit RDBMS we would have to wait even longer for patches and upgrades.
</FONT></P>
<P><FONT SIZE=2>Thanks in advance for your comments. </FONT>
<BR><FONT SIZE=2>Happy Friday everyone, I'm off to Vegas!!</FONT>
<BR><FONT SIZE=2>Lisa</FONT>
<BR><FONT SIZE=2>Ft. Lauderdale, FL, USA</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: dgoulet_at_vicr.com [<A
HREF="mailto:dgoulet_at_vicr.com">mailto:dgoulet_at_vicr.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Friday, August 18, 2000 10:17 AM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>Subject: Re:Migration from HP-UX 10.20 to HP-UX 11 and Oracle
7.3.4 t</FONT>
</P>
<BR>
<P><FONT SIZE=2>Rafiq,</FONT>
</P>
<P><FONT SIZE=2> It depends on whether your going to be on
HP-UX 11 32 or 64 bit. HP-UX 10.2</FONT>
<BR><FONT SIZE=2>was strictly 32 bit, but HP-UX 11 gives you a choice, somewhat
dependent on the</FONT>
<BR><FONT SIZE=2>hardware. If your remaining on older HP9000 E,G,K class
machines then your</FONT>
<BR><FONT SIZE=2>stuck with 32 bit. If your headed for the newer L & N
class then you have a</FONT>
<BR><FONT SIZE=2>choice (BTW: take 64 bit if it's available, it is
faster).</FONT>
</P>
<P><FONT SIZE=2>Now, from an Oracle perspective, If your staying with 32 bit
then the datafiles</FONT>
<BR><FONT SIZE=2>are compatible & it's just a version upgrade. If it's
64 bit, then an export,</FONT>
<BR><FONT SIZE=2>database rebuild & import will be required. BUT,
since you state that your</FONT>
<BR><FONT SIZE=2>headed for new hardware (of whatever flavor) in the first
place, this is an</FONT>
<BR><FONT SIZE=2>optimum time for a little house cleaning so take it.
Golden opportunities like</FONT>
<BR><FONT SIZE=2>this are few & far between.</FONT>
</P>
<P><FONT SIZE=2>Dick Goulet</FONT>
</P>
<P><FONT SIZE=2>____________________Reply Separator____________________</FONT>
<BR><FONT SIZE=2>Author: "Mohammad Rafiq"
<rafiq9857_at_hotmail.com></FONT>
<BR><FONT SIZE=2>Date: 8/17/00 12:17
PM</FONT>
</P>
<P><FONT SIZE=2>Hi Gurus</FONT>
</P>
<P><FONT SIZE=2>I need expert guidance for our future move to HP-UX 11 from
HP-UX 10.20.</FONT>
</P>
<P><FONT SIZE=2>Existing setup:</FONT>
<BR><FONT SIZE=2>Platform HP</FONT>
<BR><FONT SIZE=2>HP-UX 10.20</FONT>
<BR><FONT SIZE=2>Oracle 7.3.4.5</FONT>
<BR><FONT SIZE=2>Oracle Financials 10.7(Char) with Oracle Manufacturing/Bill Of
Materials</FONT>
<BR><FONT SIZE=2>Customized forms(2.3) and reports(2.5)</FONT>
</P>
<BR>
<P><FONT SIZE=2>Future Move:</FONT>
<BR><FONT SIZE=2>Platform HP</FONT>
<BR><FONT SIZE=2>New Machine</FONT>
<BR><FONT SIZE=2>HP-UX 11</FONT>
<BR><FONT SIZE=2>Oracle 8.1.6</FONT>
<BR><FONT SIZE=2>Oracle Financials Release 11i</FONT>
<BR><FONT SIZE=2>Conversion of Customized Forms & Reports to Forms/Reports
6i</FONT>
</P>
<P><FONT SIZE=2>Please advise your experience or opinion to carry out above
migration</FONT>
<BR><FONT SIZE=2>smoothly as Oracle Support guidance is so far
contradictory.</FONT>
</P>
<P><FONT SIZE=2>Regards</FONT>
<BR><FONT SIZE=2>Rafiq</FONT>
</P>
<P><FONT
SIZE=2>________________________________________________________________________< /FONT>
<BR><FONT SIZE=2>Get Your Private, Free E-mail from MSN Hotmail at <A
HREF="http://www.hotmail.com" TARGET="_blank">http://www.hotmail.com</A></FONT>
</P>
<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: Mohammad Rafiq</FONT>
<BR><FONT SIZE=2> INET: rafiq9857_at_hotmail.com</FONT>
</P>
<P><FONT SIZE=2>Fat City Network Services -- (858)
538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>San Diego, California
-- Public Internet access / Mailing Lists</FONT>
<BR><FONT
SIZE=2>--------------------------------------------------------------------</FON T>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail
message</FONT>
<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
and in</FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB
ORACLE-L</FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed
from). You may</FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like
subscribing).</FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: </FONT>
<BR><FONT SIZE=2> INET: dgoulet_at_vicr.com</FONT>
</P>
<P><FONT SIZE=2>Fat City Network Services -- (858)
538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>San Diego, California
-- Public Internet access / Mailing Lists</FONT>
<BR><FONT
SIZE=2>--------------------------------------------------------------------</FON T>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail
message</FONT>
<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
and in</FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB
 |
 |