Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re:RE: RE: Migration from HP-UX 10.20 to HP-UX 11 and Oracle

Re:RE: RE: Migration from HP-UX 10.20 to HP-UX 11 and Oracle

From: <dgoulet_at_vicr.com>
Date: Fri, 18 Aug 2000 11:56:38 -0400
Message-Id: <10593.114972@fatcity.com>


--IMA.Boundary.773416669

Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Description: cc:Mail note part

Yes, it is a rare & much savored moment!!

____________________Reply Separator____________________
Subject: RE: RE: Migration from HP-UX 10.20 to HP-UX 11 and Oracle 7. Author: "Koivu; Lisa" <lkoivu_at_qode.com>
Date: 8/18/00 10:58 AM

Thanks Dick for your comments.
I really appreciate you taking the time to respond.

What a great situation to be in - database is too fast for your 'line'. How often will someone come to you and say 'Your database is too fast'. HA!

Lisa

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

From: dgoulet_at_vicr.com [mailto:dgoulet_at_vicr.com] Sent: Friday, August 18, 2000 10:44 AM
To: Koivu; Lisa; 'ORACLE-L_at_fatcity.com'
Subject: 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>
Date: 8/18/00 10:36 AM

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



Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

--

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).
<!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.&nbsp; 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.&nbsp; 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.&nbsp; I read that 64-bit was only really beneficial to very large
OLTP systems (which we aren't, really).&nbsp; </FONT></P>

<P><FONT SIZE=2>Can you substantiate your statement below?&nbsp; I would be interested in any metrics, white papers, ANYTHING that would explain this in more detail.&nbsp; I understand the difference between 32-bit and 64-bit, I just
am at a loss to understand what exactly this buys me.&nbsp; </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.&nbsp; Undesirable situation
to be in, to begin with (in my opinion).&nbsp; I thought if we then went 64-bit
RDBMS we would have to wait even longer for patches and upgrades.&nbsp; </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>&nbsp;&nbsp;&nbsp; It depends on whether your going to be on HP-UX 11 32 or 64 bit.&nbsp; 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.&nbsp; If your remaining on older HP9000 E,G,K class
machines then your</FONT>
<BR><FONT SIZE=2>stuck with 32 bit.&nbsp; If your headed for the newer L &amp; 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 &amp; it's just a version upgrade.&nbsp; If it's
64 bit, then an export,</FONT>
<BR><FONT SIZE=2>database rebuild &amp; import will be required.&nbsp; 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.&nbsp; Golden opportunities like</FONT>
<BR><FONT SIZE=2>this are few &amp; far between.</FONT> </P>

<P><FONT SIZE=2>Dick Goulet</FONT>
</P>

<P><FONT SIZE=2>____________________Reply
Separator____________________</FONT>

<BR><FONT SIZE=2>Author: &quot;Mohammad Rafiq&quot; &lt;rafiq9857_at_hotmail.com&gt;</FONT>
<BR><FONT SIZE=2>Date:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 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 &amp; 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>&nbsp; INET: rafiq9857_at_hotmail.com</FONT>
</P>

<P><FONT SIZE=2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT> <BR><FONT SIZE=2>San Diego,
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
-- 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).&nbsp; 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>&nbsp; INET: dgoulet_at_vicr.com</FONT>
</P>

<P><FONT SIZE=2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT> <BR><FONT SIZE=2>San Diego,
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
-- 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).&nbsp; You may</FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like subscribing).</FONT>
</P>

</BODY>
</HTML>  

--IMA.Boundary.773416669

Content-Type: text/basic; name="note.txt"
Content-Transfer-Encoding: 7bit
Content-Description: MS-DOS text file
Content-Disposition: inline; filename="note.txt"

<!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: RE: Migration from HP-UX 10.20 to HP-UX 11 and Oracle 7.3</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Thanks Dick for your comments.&nbsp; </FONT>
<BR><FONT SIZE=2>I really appreciate you taking the time to respond.</FONT>
</P>

<P><FONT SIZE=2>What a great situation to be in - database is too fast for your 'line'.&nbsp;&nbsp; How often will someone come to you and say 'Your database is too fast'.&nbsp; HA!</FONT></P>

<P><FONT SIZE=2>Lisa</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:44 AM</FONT>
<BR><FONT SIZE=2>To: Koivu; Lisa; 'ORACLE-L_at_fatcity.com'</FONT>
<BR><FONT SIZE=2>Subject: Re:RE: Migration from HP-UX 10.20 to HP-UX 11 and Oracle 7.3</FONT>
</P>
<BR>

<P><FONT SIZE=2>Lisa,</FONT>
</P>

<P><FONT SIZE=2>&nbsp;&nbsp;&nbsp; Regrettably I can't release any more specifics due to company &quot;proprietary</FONT>
<BR><FONT SIZE=2>data&quot; requirements, but we moved an application database from an HP9000 K570</FONT>
<BR><FONT SIZE=2>4way to a L2000 2way. On the older machine it was taking 6 minutes to process a</FONT>
<BR><FONT SIZE=2>work order for the robotic line.&nbsp; We moved it to the L2000 with HP-UX 11.0 and</FONT>
<BR><FONT SIZE=2>Oracle 8.0.5 32 bit, result 3 minutes per work order.&nbsp; We then upgraded to 805</FONT>
<BR><FONT SIZE=2>64 bit database (full exp/imp), result 1 minute per work order.&nbsp; Please note</FONT>
<BR><FONT SIZE=2>only the database changed.&nbsp; The application program remained on HP-UX 10.20 on</FONT>
<BR><FONT SIZE=2>the K570 and the test work order remained the same (same model number, bill of</FONT>
<BR><FONT SIZE=2>materials, and line configuration).&nbsp; Since the application has been recompiled</FONT>
<BR><FONT SIZE=2>on HP-UX 11 32 bit (due to 3rd party library) and it is now processing one work</FONT>
<BR><FONT SIZE=2>order every 30-45 seconds.&nbsp; This generated a problem in that the line can't</FONT>
<BR><FONT SIZE=2>process the work as fast as we can sequence it.</FONT>
</P>

<P><FONT SIZE=2>Dick Goulet</FONT>
</P>

<P><FONT SIZE=2>____________________Reply Separator____________________</FONT>
<BR><FONT SIZE=2>Subject:&nbsp;&nbsp;&nbsp; RE: Migration from HP-UX 10.20 to HP-UX 11 and Oracle 7.3.4 </FONT>
<BR><FONT SIZE=2>Author: &quot;Koivu; Lisa&quot; &lt;lkoivu_at_qode.com&gt;</FONT>
<BR><FONT SIZE=2>Date:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8/18/00 10:36 AM</FONT> </P>
<P><FONT SIZE=2>Dick, you say that 64-bit is faster than 32-bit.&nbsp; We recently had to</FONT>
<BR><FONT SIZE=2>investigate whether or not to go 64-bit (we are also HP/UX 11.0) with the</FONT>
<BR><FONT SIZE=2>O/S and the RDBMS.&nbsp; I searched the net exhaustively trying to find something</FONT>
<BR><FONT SIZE=2>other than 'you can have an SGA larger than 2GB' for a reason to choose</FONT>
<BR><FONT SIZE=2>64bit.&nbsp; I read that 64-bit was only really beneficial to very large OLTP</FONT>
<BR><FONT SIZE=2>systems (which we aren't, really).&nbsp; </FONT>
</P>

<P><FONT SIZE=2>Can you substantiate your statement below?&nbsp; I would be interested in any</FONT>
<BR><FONT SIZE=2>metrics, white papers, ANYTHING that would explain this in more detail.&nbsp; I</FONT>
<BR><FONT SIZE=2>understand the difference between 32-bit and 64-bit, I just am at a loss to</FONT>
<BR><FONT SIZE=2>understand what exactly this buys me.&nbsp; </FONT> </P>
<P><FONT SIZE=2>I was also wary of choosing 64-bit for the RDBMS because we are HP/UX, the</FONT>
<BR><FONT SIZE=2>second tier for patches, upgrades, etc.&nbsp; Undesirable situation to be in, to</FONT>
<BR><FONT SIZE=2>begin with (in my opinion).&nbsp; I thought if we then went 64-bit RDBMS we would</FONT>
<BR><FONT SIZE=2>have to wait even longer for patches and upgrades.&nbsp; </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>&nbsp;&nbsp;&nbsp; It depends on whether your going to be on HP-UX 11 32 or 64 bit.&nbsp; HP-UX</FONT>
<BR><FONT SIZE=2>10.2</FONT>
<BR><FONT SIZE=2>was strictly 32 bit, but HP-UX 11 gives you a choice, somewhat dependent on</FONT>
<BR><FONT SIZE=2>the</FONT>
<BR><FONT SIZE=2>hardware.&nbsp; If your remaining on older HP9000 E,G,K class machines then your</FONT>
<BR><FONT SIZE=2>stuck with 32 bit.&nbsp; If your headed for the newer L &amp; 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</FONT>
<BR><FONT SIZE=2>datafiles</FONT>
<BR><FONT SIZE=2>are compatible &amp; it's just a version upgrade.&nbsp; If it's 64 bit, then an</FONT>
<BR><FONT SIZE=2>export,</FONT>
<BR><FONT SIZE=2>database rebuild &amp; import will be required.&nbsp; 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.&nbsp; Golden opportunities</FONT>
<BR><FONT SIZE=2>like</FONT>

<BR><FONT SIZE=2>this are few &amp; far between.</FONT> </P>

<P><FONT SIZE=2>Dick Goulet</FONT>
</P>

<P><FONT SIZE=2>____________________Reply Separator____________________</FONT>
<BR><FONT SIZE=2>Author: &quot;Mohammad Rafiq&quot; &lt;rafiq9857_at_hotmail.com&gt;</FONT>
<BR><FONT SIZE=2>Date:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 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 &amp; 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 http://www.hotmail.com</FONT> </P>
<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: Mohammad Rafiq</FONT>
<BR><FONT SIZE=2>&nbsp; INET: rafiq9857_at_hotmail.com</FONT>
</P>

<P><FONT SIZE=2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing Lists</FONT>
<BR><FONT SIZE=2>--------------------------------------------------------------------</FONT>
<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).&nbsp; 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>&nbsp; INET: dgoulet_at_vicr.com</FONT> </P>
<P><FONT SIZE=2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing Lists</FONT>
<BR><FONT SIZE=2>--------------------------------------------------------------------</FONT>
<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).&nbsp; You may</FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like subscribing).</FONT>
<BR><FONT SIZE=2>&lt;!DOCTYPE HTML PUBLIC &quot;-//W3C//DTD HTML 3.2//EN&quot;&gt;</FONT>
<BR><FONT SIZE=2>&lt;HTML&gt;</FONT>
<BR><FONT SIZE=2>&lt;HEAD&gt;</FONT>
<BR><FONT SIZE=2>&lt;META HTTP-EQUIV=&quot;Content-Type&quot; CONTENT=&quot;text/html; charset=iso-8859-1&quot;&gt;</FONT>
<BR><FONT SIZE=2>&lt;META NAME=&quot;Generator&quot; CONTENT=&quot;MS Exchange Server version 5.5.2650.12&quot;&gt;</FONT>
<BR><FONT SIZE=2>&lt;TITLE&gt;RE: Migration from HP-UX 10.20 to HP-UX 11 and Oracle 7.3.4 t&lt;/TITLE&gt;</FONT>
<BR><FONT SIZE=2>&lt;/HEAD&gt;</FONT>
<BR><FONT SIZE=2>&lt;BODY&gt;</FONT>
</P>

<P><FONT SIZE=2>&lt;P&gt;&lt;FONT SIZE=2&gt;Dick, you say that 64-bit is faster than 32-bit.&amp;nbsp; We</FONT>
<BR><FONT SIZE=2>recently had to investigate whether or not to go 64-bit (we are also HP/UX 11.0)</FONT>
<BR><FONT SIZE=2>with the O/S and the RDBMS.&amp;nbsp; I searched the net exhaustively trying to find</FONT>
<BR><FONT SIZE=2>something other than 'you can have an SGA larger than 2GB' for a reason to</FONT>
<BR><FONT SIZE=2>choose 64bit.&amp;nbsp; I read that 64-bit was only really beneficial to very large</FONT>
<BR><FONT SIZE=2>OLTP systems (which we aren't, really).&amp;nbsp; &lt;/FONT&gt;&lt;/P&gt;</FONT> </P>
<P><FONT SIZE=2>&lt;P&gt;&lt;FONT SIZE=2&gt;Can you substantiate your statement below?&amp;nbsp; I would be</FONT>
<BR><FONT SIZE=2>interested in any metrics, white papers, ANYTHING that would explain this in</FONT>
<BR><FONT SIZE=2>more detail.&amp;nbsp; I understand the difference between 32-bit and 64-bit, I just</FONT>
<BR><FONT SIZE=2>am at a loss to understand what exactly this buys me.&amp;nbsp; &lt;/FONT&gt;&lt;/P&gt;</FONT>
</P>

<P><FONT SIZE=2>&lt;P&gt;&lt;FONT SIZE=2&gt;I was also wary of choosing 64-bit for the RDBMS because we are</FONT>
<BR><FONT SIZE=2>HP/UX, the second tier for patches, upgrades, etc.&amp;nbsp; Undesirable situation</FONT>
<BR><FONT SIZE=2>to be in, to begin with (in my opinion).&amp;nbsp; I thought if we then went 64-bit</FONT>
<BR><FONT SIZE=2>RDBMS we would have to wait even longer for patches and upgrades.&amp;nbsp;</FONT>
<BR><FONT SIZE=2>&lt;/FONT&gt;&lt;/P&gt;</FONT> </P>
<P><FONT SIZE=2>&lt;P&gt;&lt;FONT SIZE=2&gt;Thanks in advance for your comments. &lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;Happy Friday everyone, I'm off to Vegas!!&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;Lisa&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;Ft. Lauderdale, FL, USA&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;/P&gt;</FONT>
</P>

<P><FONT SIZE=2>&lt;P&gt;&lt;FONT SIZE=2&gt;-----Original Message-----&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;From: dgoulet_at_vicr.com [&lt;A</FONT>
<BR><FONT SIZE=2>HREF=&quot;<A HREF="mailto:dgoulet_at_vicr.com">mailto:dgoulet_at_vicr.com</A>&quot;&gt;<A HREF="mailto:dgoulet_at_vicr.com">mailto:dgoulet_at_vicr.com</A>&lt;/A&gt;]&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;Sent: Friday, August 18, 2000 10:17 AM&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;To: Multiple recipients of list ORACLE-L&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;Subject: Re:Migration from HP-UX 10.20 to HP-UX 11 and Oracle</FONT>
<BR><FONT SIZE=2>7.3.4 t&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;/P&gt;</FONT>

<BR><FONT SIZE=2>&lt;BR&gt;</FONT>
</P>
<P><FONT SIZE=2>&lt;P&gt;&lt;FONT SIZE=2&gt;Rafiq,&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;/P&gt;</FONT>
</P>

<P><FONT SIZE=2>&lt;P&gt;&lt;FONT SIZE=2&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; It depends on whether your going to be on</FONT>
<BR><FONT SIZE=2>HP-UX 11 32 or 64 bit.&amp;nbsp; HP-UX 10.2&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;was strictly 32 bit, but HP-UX 11 gives you a choice, somewhat</FONT>
<BR><FONT SIZE=2>dependent on the&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;hardware.&amp;nbsp; If your remaining on older HP9000 E,G,K class</FONT>
<BR><FONT SIZE=2>machines then your&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;stuck with 32 bit.&amp;nbsp; If your headed for the newer L &amp;amp; N</FONT>
<BR><FONT SIZE=2>class then you have a&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;choice (BTW: take 64 bit if it's available, it is</FONT>
<BR><FONT SIZE=2>faster).&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;/P&gt;</FONT>
</P>
<P><FONT SIZE=2>&lt;P&gt;&lt;FONT SIZE=2&gt;Now, from an Oracle perspective, If your staying with 32 bit</FONT>
<BR><FONT SIZE=2>then the datafiles&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;are compatible &amp;amp; it's just a version upgrade.&amp;nbsp; If it's</FONT>
<BR><FONT SIZE=2>64 bit, then an export,&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;database rebuild &amp;amp; import will be required.&amp;nbsp; BUT,</FONT>
<BR><FONT SIZE=2>since you state that your&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;headed for new hardware (of whatever flavor) in the first</FONT>
<BR><FONT SIZE=2>place, this is an&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;optimum time for a little house cleaning so take it.&amp;nbsp;</FONT>
<BR><FONT SIZE=2>Golden opportunities like&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;this are few &amp;amp; far between.&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;/P&gt;</FONT>
</P>

<P><FONT SIZE=2>&lt;P&gt;&lt;FONT SIZE=2&gt;Dick Goulet&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;/P&gt;</FONT>
</P>
<P><FONT SIZE=2>&lt;P&gt;&lt;FONT SIZE=2&gt;____________________Reply Separator____________________&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;Author: &amp;quot;Mohammad Rafiq&amp;quot;</FONT>
<BR><FONT SIZE=2>&amp;lt;rafiq9857_at_hotmail.com&amp;gt;&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;Date:&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; 8/17/00 12:17</FONT>
<BR><FONT SIZE=2>PM&lt;/FONT&gt;</FONT>

<BR><FONT SIZE=2>&lt;/P&gt;</FONT>
</P>
<P><FONT SIZE=2>&lt;P&gt;&lt;FONT SIZE=2&gt;Hi Gurus&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;/P&gt;</FONT>
</P>

<P><FONT SIZE=2>&lt;P&gt;&lt;FONT SIZE=2&gt;I need expert guidance for our future move to HP-UX 11 from</FONT>
<BR><FONT SIZE=2>HP-UX 10.20.&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;/P&gt;</FONT>
</P>
<P><FONT SIZE=2>&lt;P&gt;&lt;FONT SIZE=2&gt;Existing setup:&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;Platform HP&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;HP-UX 10.20&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;Oracle 7.3.4.5&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;Oracle Financials 10.7(Char) with Oracle Manufacturing/Bill Of</FONT>
<BR><FONT SIZE=2>Materials&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;Customized forms(2.3) and reports(2.5)&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;/P&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;</FONT>
</P>

<P><FONT SIZE=2>&lt;P&gt;&lt;FONT SIZE=2&gt;Future Move:&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;Platform HP&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;New Machine&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;HP-UX 11&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;Oracle 8.1.6&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;Oracle Financials Release 11i&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;Conversion of Customized Forms &amp;amp; Reports to Forms/Reports</FONT>
<BR><FONT SIZE=2>6i&lt;/FONT&gt;</FONT>

<BR><FONT SIZE=2>&lt;/P&gt;</FONT>
</P>
<P><FONT SIZE=2>&lt;P&gt;&lt;FONT SIZE=2&gt;Please advise your experience or opinion to carry out above</FONT>
<BR><FONT SIZE=2>migration&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;smoothly as Oracle Support guidance is so far</FONT>
<BR><FONT SIZE=2>contradictory.&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;/P&gt;</FONT>
</P>

<P><FONT SIZE=2>&lt;P&gt;&lt;FONT SIZE=2&gt;Regards&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;Rafiq&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;/P&gt;</FONT>
</P>
<P><FONT SIZE=2>&lt;P&gt;&lt;FONT</FONT>
<BR><FONT SIZE=2>SIZE=2&gt;________________________________________________________________________&lt;</FONT>
<BR><FONT SIZE=2>/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;Get Your Private, Free E-mail from MSN Hotmail at &lt;A</FONT>
<BR><FONT SIZE=2>HREF=&quot;http://www.hotmail.com&quot; TARGET=&quot;_blank&quot;&gt;http://www.hotmail.com&lt;/A&gt;&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;/P&gt;</FONT>
</P>

<P><FONT SIZE=2>&lt;P&gt;&lt;FONT SIZE=2&gt;-- &lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;Author: Mohammad Rafiq&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;&amp;nbsp; INET: rafiq9857_at_hotmail.com&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;/P&gt;</FONT>
</P>
<P><FONT SIZE=2>&lt;P&gt;&lt;FONT SIZE=2&gt;Fat City Network Services&amp;nbsp;&amp;nbsp;&amp;nbsp; -- (858)</FONT>
<BR><FONT SIZE=2>538-5051&amp;nbsp; FAX: (858) 538-5051&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;San Diego, California&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;</FONT>
<BR><FONT SIZE=2>-- Public Internet access / Mailing Lists&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT</FONT>
<BR><FONT SIZE=2>SIZE=2&gt;--------------------------------------------------------------------&lt;/FON</FONT>
<BR><FONT SIZE=2>T&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;To REMOVE yourself from this mailing list, send an E-Mail</FONT>
<BR><FONT SIZE=2>message&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')</FONT>
<BR><FONT SIZE=2>and in&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;the message BODY, include a line containing: UNSUB</FONT>
<BR><FONT SIZE=2>ORACLE-L&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;(or the name of mailing list you want to be removed</FONT>
<BR><FONT SIZE=2>from).&amp;nbsp; You may&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;also send the HELP command for other information (like</FONT>
<BR><FONT SIZE=2>subscribing).&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;-- &lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;Author: &lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;&amp;nbsp; INET: dgoulet_at_vicr.com&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;/P&gt;</FONT>
</P>

<P><FONT SIZE=2>&lt;P&gt;&lt;FONT SIZE=2&gt;Fat City Network Services&amp;nbsp;&amp;nbsp;&amp;nbsp; -- (858)</FONT>
<BR><FONT SIZE=2>538-5051&amp;nbsp; FAX: (858) 538-5051&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;San Diego, California&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;</FONT>
<BR><FONT SIZE=2>-- Public Internet access / Mailing Lists&lt;/FONT&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT</FONT>
<BR><FONT SIZE=2>SIZE=2&gt;--------------------------------------------------------------------&lt;/FON</FONT>
<BR><FONT SIZE=2>T&gt;</FONT>
<BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;To REMOVE yourself from this mailing list, send an E-Mail</FONT>
<BR><FONT SIZE=2>message&lt;/FONT&gt;</FONT> <BR><FONT SIZE=2>&lt;BR&gt;&lt;FONT SIZE=2&gt;to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')</FONT> Received on Fri Aug 18 2000 - 10:56:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US