| 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: Upgrade 8.1.5 -> 8.1.6
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFF89D.D860C43C
Content-Type: text/plain;
charset="iso-8859-1"
Has anyone upgraded from 8.1.5 to 8.1.6 32bit on HP UX 11.0? Does the large file error still exist for the 32bit version? I have 10gb files on large file systems on HP UX 11.0 Oracle 8.1.5 (32bit) without file errors. Did you have these large file errors before on 8.1.5? Just wondering if it is an Oracle 8.1.6 64bit issue?
Gene Sais
-----Original Message-----
From: Srinivas Katta [mailto:srinivas.katta_at_hartfordlife.com]
Sent: Friday, July 28, 2000 9:36 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Upgrade 8.1.5 -> 8.1.6
Hi Janardhan Babu,
Even we had very similar problem, when we upgraded to HP/UX 11.0 64bit. We were getting >error 27: File too large.
We were in touch with Oracle and HP. After that we had to apply close to 11
Patches on HP Unix,
related to Large files. Large files were not implemented properly on the
Unix.
HP Guys directed us to a set of documentation files (.txt files) on the UX
system to implement the large file systems.
After taking care of the same, it started working fine.
SA's checked the implementation of large files by doing some file open() functions on the large files on the UX system, then we started the Instance, after we were assured that the UNIX was able to open the large files.
Thanks,
Srinivas Katta
Janardhana Babu <jbdonga_at_ucdavis.edu> on 07/27/2000 03:54:05 PM
Please respond to ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
cc: (bcc: Srinivas Katta/HLIFE)
Subject: RE: Upgrade 8.1.5 -> 8.1.6
I have not run into any problems in 816 so far probably because Iam using 2GB datafiles in the test databases so far. I have a necessity to get the data from 816 database and import into 815 database and so I got all the problems. We are also on HP/UX 11.0 64bit. Some of my collegues are facing problems after upgrading to 816, probably they are using 5GB datafiles on the production databases. Iam attaching the messsage below about the problems they are facing. I too would be waiting for their problem to be solved before I upgrade my production databases to 816 as I too am using 5GB datafiles for production. If anybody knows the solution how to solve the below mentioned 816 problem, please let us know. It would be appreciated.
Here is the text:
>We have test instances on 2 of our new N4000 boxes, running HP-UX 11 and
>Oracle 8i (8.1.6), a Banner 3.x instance, and a Banner 4.x instance.
>
>Our database is about 40 GB, with several HP largefiles filesystems
>accommodating 5 and 10 GB tablespace datafiles. We are experiencing
>intermittent database crashes when Oracle (apparently) detects an HP-UX
>error 27: File too large.
>
>After working with HP and Oracle, we believe this error message is
>incorrect, 'tho we suspect that there is an as yet undocumented
>"feature" having to do with limits in the 64 bit architecture.
>
>But I emphasize, at this point we do not know what the problem is. All we
>do know is that sooner or later (at least once a day), our test instances
>are crashing.
>
>We are supposed to cutover to the new N4000 servers over Labor Day
>weekend, but as of now, that is not going to happen unless we can resolve
>this error.
-----Original Message-----
Sent: Thursday, July 27, 2000 9:09 AM
To: Multiple recipients of list ORACLE-L
Hello everyone -
I've seen a lot of talk about downgrading back to 8.1.5. May I ask what problems you ran into that made the downgrade necessary? I am interested in any comments or war stories anyone may have. We are looking at doing this in the next month or so - someone here is really bent out of shape about not having full DBMS_UTILITY functionality. That's his main reason for upgrading. We are HP/UX 11.0 64bit.
Thanks in advance...
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319
954.484.3191 x174 [voice] 954.484.2933 [fax] 954.309.4157 [cell]
"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."
-- Author: Janardhana Babu INET: jbdonga_at_ucdavis.edu 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: Srinivas Katta INET: srinivas.katta_at_hartfordlife.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). ------_=_NextPart_001_01BFF89D.D860C43C Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12"> <TITLE>RE: Upgrade 8.1.5 -> 8.1.6</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>Has anyone upgraded from 8.1.5 to 8.1.6 32bit on HP = UX 11.0? Does the large file error still exist for the 32bit = version? I have 10gb files on large file systems on HP UX 11.0 = Oracle 8.1.5 (32bit) without file errors. Did you have these = large file errors before on 8.1.5? Just wondering if it is an = Oracle 8.1.6 64bit issue?</FONT></P> <P><FONT SIZE=3D2>Gene Sais</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Srinivas Katta [<A = HREF=3D"mailto:srinivas.katta_at_hartfordlife.com">mailto:srinivas.katta_at_ha= rtfordlife.com</A>]</FONT> <BR><FONT SIZE=3D2>Sent: Friday, July 28, 2000 9:36 AM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: RE: Upgrade 8.1.5 -> 8.1.6</FONT> </P> <BR> <BR> <BR> <P><FONT SIZE=3D2>Hi Janardhan Babu,</FONT> </P> <P><FONT SIZE=3D2>Even we had very similar problem, when we upgraded = to HP/UX 11.0 64bit.</FONT> <BR><FONT SIZE=3D2>We were getting >error 27: File too large.</FONT> </P> <P><FONT SIZE=3D2>We were in touch with Oracle and HP. After that = we had to apply close to 11</FONT> <BR><FONT SIZE=3D2>Patches on HP Unix,</FONT> <BR><FONT SIZE=3D2>related to Large files. Large files were not = implemented properly on the Unix.</FONT> <BR><FONT SIZE=3D2>HP Guys directed us to a set of documentation files = (.txt files) on the UX</FONT> <BR><FONT SIZE=3D2>system to implement the large file systems.</FONT> <BR><FONT SIZE=3D2>After taking care of the same, it started working = fine.</FONT> </P> <P><FONT SIZE=3D2>SA's checked the implementation of large files by = doing some file open()</FONT> <BR><FONT SIZE=3D2>functions on the large files on the UX system, then = we started the Instance,</FONT> <BR><FONT SIZE=3D2>after we were assured that the UNIX was able to open = the large files.</FONT> </P> <P><FONT SIZE=3D2>Thanks,</FONT> <BR><FONT SIZE=3D2>Srinivas Katta</FONT> </P> <BR> <BR> <BR> <BR> <BR> <BR> <BR> <BR> <P><FONT SIZE=3D2>Janardhana Babu <jbdonga_at_ucdavis.edu> on = 07/27/2000 03:54:05 PM</FONT> </P> <P><FONT SIZE=3D2>Please respond to ORACLE-L_at_fatcity.com</FONT> <BR><FONT = SIZE=3D2> &nb= sp; &nb= sp; &nb= sp; &nb= sp; &nb= sp; &nb= sp; </FONT> <BR><FONT = SIZE=3D2> &nb= sp; &nb= sp; &nb= sp; &nb= sp; &nb= sp; &nb= sp; </FONT> <BR><FONT = SIZE=3D2> &nb= sp; &nb= sp; &nb= sp; &nb= sp; &nb= sp; &nb= sp; </FONT> </P> <BR> <P><FONT = SIZE=3D2> &nb= sp; &nb= sp; &nb= sp; &nb= sp; &nb= sp; </FONT> <BR><FONT = SIZE=3D2> &nb= sp; &nb= sp; &nb= sp; &nb= sp; &nb= sp; </FONT> <BR><FONT = SIZE=3D2> &nb= sp; &nb= sp; &nb= sp; &nb= sp; &nb= sp; </FONT> <BR><FONT SIZE=3D2> To: Multiple = recipients of list = ORACLE-L &nbs= p; </FONT> <BR><FONT = SIZE=3D2> = <ORACLE-L_at_fatcity.com> &n= bsp; &n= bsp; </FONT> <BR><FONT = SIZE=3D2> &nb= sp; &nb= sp; &nb= sp; &nb= sp; &nb= sp; </FONT> <BR><FONT SIZE=3D2> cc: (bcc: = Srinivas = Katta/HLIFE) = = </FONT> <BR><FONT = SIZE=3D2> &nb= sp; &nb= sp; &nb= sp; &nb= sp; &nb= sp; </FONT> <BR><FONT = SIZE=3D2> &nb= sp; &nb= sp; &nb= sp; &nb= sp; &nb= sp; </FONT> <BR><FONT = SIZE=3D2> &nb= sp; &nb= sp; &nb= sp; &nb= sp; &nb= sp; </FONT> <BR><FONT SIZE=3D2> Subject: RE: Upgrade 8.1.5 -> = 8.1.6 &= nbsp; &= nbsp; </FONT> <BR><FONT = SIZE=3D2> &nb= sp; &nb= sp; &nb= sp; &nb= sp; &nb= sp; </FONT> </P> <BR> <BR> <BR> <BR> <BR> <BR> <BR> <P><FONT SIZE=3D2>I have not run into any problems in 816 so far = probably because Iam using</FONT> <BR><FONT SIZE=3D2>2GB datafiles in the test databases so far. I = have a necessity to get the</FONT> <BR><FONT SIZE=3D2>data from 816 database and import into 815 database = and so I got all the</FONT> <BR><FONT SIZE=3D2>problems. We are also on HP/UX 11.0 64bit. Some of = my collegues are facing</FONT> <BR><FONT SIZE=3D2>problems after upgrading to 816, probably they are = using 5GB datafiles on</FONT> <BR><FONT SIZE=3D2>the production databases. Iam attaching the messsage = below about the</FONT> <BR><FONT SIZE=3D2>problems they are facing. I too would be waiting for = their problem to be</FONT> <BR><FONT SIZE=3D2>solved before I upgrade my production databases to = 816 as I too am using 5GB</FONT> <BR><FONT SIZE=3D2>datafiles for production. If anybody knows the = solution how to solve the</FONT> <BR><FONT SIZE=3D2>below mentioned 816 problem, please let us know. It = would be appreciated.</FONT> </P> <P><FONT SIZE=3D2>Here is the text:</FONT> <BR><FONT SIZE=3D2>>We have test instances on 2 of our new N4000 = boxes, running HP-UX 11 and</FONT> </P> <P><FONT SIZE=3D2>>Oracle 8i (8.1.6), a Banner 3.x instance, and a = Banner 4.x instance.</FONT> </P> <P><FONT SIZE=3D2>></FONT> </P> <P><FONT SIZE=3D2>>Our database is about 40 GB, with several HP = largefiles filesystems</FONT> </P> <P><FONT SIZE=3D2>>accommodating 5 and 10 GB tablespace datafiles. = We are experiencing</FONT> </P> <P><FONT SIZE=3D2>>intermittent database crashes when Oracle = (apparently) detects an HP-UX</FONT> </P> <P><FONT SIZE=3D2>>error 27: File too large.</FONT> </P> <P><FONT SIZE=3D2>></FONT> </P> <P><FONT SIZE=3D2>>After working with HP and Oracle, we believe this = error message is</FONT> </P> <P><FONT SIZE=3D2>>incorrect, 'tho we suspect that there is an as = yet undocumented</FONT> </P> <P><FONT SIZE=3D2>>"feature" having to do with limits in = the 64 bit architecture.</FONT> </P> <P><FONT SIZE=3D2>></FONT> </P> <P><FONT SIZE=3D2>>But I emphasize, at this point we do not know = what the problem is. All we</FONT> </P> <P><FONT SIZE=3D2>>do know is that sooner or later (at least once a = day), our test instances</FONT> </P> <P><FONT SIZE=3D2>>are crashing.</FONT> </P> <P><FONT SIZE=3D2>></FONT> </P> <P><FONT SIZE=3D2>>We are supposed to cutover to the new N4000 = servers over Labor Day</FONT> </P> <P><FONT SIZE=3D2>>weekend, but as of now, that is not going to = happen unless we can resolve</FONT> </P> <P><FONT SIZE=3D2>>this error.</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>Sent: Thursday, July 27, 2000 9:09 AM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> </P> <BR> <BR> <P><FONT SIZE=3D2>Hello everyone -</FONT> </P> <P><FONT SIZE=3D2>I've seen a lot of talk about downgrading back to = 8.1.5. May I ask what</FONT> <BR><FONT SIZE=3D2>problems you ran into that made the downgrade = necessary? I am interested in</FONT> <BR><FONT SIZE=3D2>any comments or war stories anyone may have. = We are looking at doing this</FONT> <BR><FONT SIZE=3D2>in the next month or so - someone here is really = bent out of shape about not</FONT> <BR><FONT SIZE=3D2>having full DBMS_UTILITY functionality. That's = his main reason for</FONT> <BR><FONT SIZE=3D2>upgrading. We are HP/UX 11.0 64bit.</FONT> </P> <P><FONT SIZE=3D2>Thanks in advance...</FONT> </P> <P><FONT SIZE=3D2>Lisa Rutland Koivu</FONT> <BR><FONT SIZE=3D2>Oracle Database Administrator</FONT> <BR><FONT SIZE=3D2>Qode.com</FONT> <BR><FONT SIZE=3D2>4850 North State Road 7</FONT> <BR><FONT SIZE=3D2>Suite G104</FONT> <BR><FONT SIZE=3D2>Fort Lauderdale, FL 33319</FONT> </P> <P><FONT SIZE=3D2>954.484.3191 x174 [voice]</FONT> <BR><FONT SIZE=3D2>954.484.2933 [fax]</FONT> <BR><FONT SIZE=3D2>954.309.4157 [cell]</FONT> <BR><FONT SIZE=3D2>lkoivu_at_qode.com [email]</FONT> <BR><FONT SIZE=3D2><A HREF=3D"http://www.qode.com" = TARGET=3D"_blank">http://www.qode.com</A> <<A = HREF=3D"http://www.qode.com" = TARGET=3D"_blank">http://www.qode.com</A>> [web]</FONT> </P> <BR> <P><FONT SIZE=3D2>"The information contained herein does not = express the opinion or position</FONT> <BR><FONT SIZE=3D2>of Qode.com and cannot be attributed to or made = binding upon Qode.com."</FONT> </P> <P><FONT SIZE=3D2>--</FONT> <BR><FONT SIZE=3D2>Author: Janardhana Babu</FONT> <BR><FONT SIZE=3D2> INET: jbdonga_at_ucdavis.edu</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed = from). You may</FONT> <BR><FONT SIZE=3D2>also send the HELP command for other information = (like subscribing).</FONT> </P> <BR> <BR> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Srinivas Katta</FONT> <BR><FONT SIZE=3D2> INET: srinivas.katta_at_hartfordlife.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------=Received on Fri Jul 28 2000 - 09:12:21 CDT
 |
 |