SUMMARY: RE: Max data file size on NTFS partition
I wanted to post a summary because maybe some of you have also run into problems with autoextent/max data file size on NT. After a lot of hunting and gathering, I found that the 4GB limit is only on the FAT32 file system. We are running NTFS on Windows 2000 server, so it does not apply to us. According to Microsoft, individual file sizes can reach up around 2TB in size for a NTFS volume. The limit with within Oracle. Given our db block size of 8kb we can create files of up to 32GB with Oracle 8i 8.1.6.0 - Oracle 8i 8.1.6.3 (according to Oracle tech support). So why was our database crashing? Our problem is a known bug (to everyone except me, apparently. Hey, I'm new) in Oracle 8i 8.1.6.0.0. The database crashes when data file extends or is resized onto a 4GB boundary. Disabling autoextend is the best solution since autoextend also creates massive fragmentation. Tech support feels we should have no problem manually resizing dbfs over the 4GB boundary. The bug isn't with the file size, but with autoextend. For the meantime, I'll upgrade to the latest patch (should have anyway) set for Oracle 8i Standard 8.1.6.3.0 then to 8.1.6.3.8. The latest patch should fix most of the bugs we have encountered thus far and many we haven't. We should be able to produce files up to 32GB with the latest patch set. That about sums it up, now onto patching fun -Original Message- Sent: Wednesday, December 19, 2001 2:27 PM To: Multiple recipients of list ORACLE-L Thanks for replying Ed. We did set disable AUTOEXTEND once we realized it was playing one of the "starring" roles in our problem. I opened TAR in Metalink and I'll post the answer when I get a response. Thanks, Ashley -Original Message- Sent: Wednesday, December 19, 2001 12:47 PM To: Multiple recipients of list ORACLE-L Hi Ashley, Sorry, don't know exact answer, but the problem doesn't always come from OS side. There are *Oracle* limits on some platforms. It seems you use AUTOEXTEND=ON for your files. If so then you may encountered some bugs when your files had extended through size limits. At least there were some bugs in the past. I prefer disabling this option in order to get more control over db and add files when needed. All files are of equal size. Regards, Ed > Hello to all my most favorite DBAs... > > Yes, believe it or not, I checked the archives, Metalink and Oracle > documentation, but all come up with a different answer to my question. > What is the max data file size for an NTFS partition on Advanced Server? > > > I'm running Oracle 8i Release 2 8.1.6 Standard...soon to be Enterprise. > The Oracle 8i documentation states 80EB on an NTFS partition, but I've > seen reference to 4GB limits everywhere else. Quite different, wouldn't > you say? > > The reason I'm asking the question is we keep running into errors. The > most common were, write/open error block X invalid parameter passed and > unable to extend file X. > > I would appreciate any help. I'm new, so please be gentle... > > Ashley -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward Shevtsov INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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.com -- Author: Gilbert, Ashley INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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.com -- Author: Gilbert, Ashley INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include
RE: Max data file size on NTFS partition
Thanks for replying Ed. We did set disable AUTOEXTEND once we realized it was playing one of the "starring" roles in our problem. I opened TAR in Metalink and I'll post the answer when I get a response. Thanks, Ashley -Original Message- Sent: Wednesday, December 19, 2001 12:47 PM To: Multiple recipients of list ORACLE-L Hi Ashley, Sorry, don't know exact answer, but the problem doesn't always come from OS side. There are *Oracle* limits on some platforms. It seems you use AUTOEXTEND=ON for your files. If so then you may encountered some bugs when your files had extended through size limits. At least there were some bugs in the past. I prefer disabling this option in order to get more control over db and add files when needed. All files are of equal size. Regards, Ed > Hello to all my most favorite DBAs... > > Yes, believe it or not, I checked the archives, Metalink and Oracle > documentation, but all come up with a different answer to my question. > What is the max data file size for an NTFS partition on Advanced Server? > > > I'm running Oracle 8i Release 2 8.1.6 Standard...soon to be Enterprise. > The Oracle 8i documentation states 80EB on an NTFS partition, but I've > seen reference to 4GB limits everywhere else. Quite different, wouldn't > you say? > > The reason I'm asking the question is we keep running into errors. The > most common were, write/open error block X invalid parameter passed and > unable to extend file X. > > I would appreciate any help. I'm new, so please be gentle... > > Ashley -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward Shevtsov INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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.com -- Author: Gilbert, Ashley INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Max data file size on NTFS partition
Hello to all my most favorite DBAs... Yes, believe it or not, I checked the archives, Metalink and Oracle documentation, but all come up with a different answer to my question. What is the max data file size for an NTFS partition on Advanced Server? I'm running Oracle 8i Release 2 8.1.6 Standard...soon to be Enterprise. The Oracle 8i documentation states 80EB on an NTFS partition, but I've seen reference to 4GB limits everywhere else. Quite different, wouldn't you say? The reason I'm asking the question is we keep running into errors. The most common were, write/open error block X invalid parameter passed and unable to extend file X. I would appreciate any help. I'm new, so please be gentle... Ashley -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gilbert, Ashley INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Enterprise Versus Standard
I didn't relize we couldn't send binary attachments. If anyone else needs the document, let me know and I'll send it to you directly. Ashley -Original Message- Sent: Thursday, November 15, 2001 8:25 AM To: Multiple recipients of list ORACLE-L I received the attachment from my Oracle License Manager when we were moving toward purchasing Oracle Standard Edition. It compares SqlServer2000, Oracle9i and DB2. It's very handy if your in a heterogeneous environment. After reviewing the document it was clear to us Enterprise Edition was the way to go. Hope it helps. Ashley -Original Message- Sent: Wednesday, November 14, 2001 12:05 PM To: Multiple recipients of list ORACLE-L Does anyone have a good Oracle Standard to Oracle Enterprise comparison Chart ?? I am looking on the various Oracle ran sites and most of the docs seem to try and steer you to Enterprise. Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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.com -- Author: Gilbert, Ashley INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Enterprise Versus Standard
I received the attachment from my Oracle License Manager when we were moving toward purchasing Oracle Standard Edition. It compares SqlServer2000, Oracle9i and DB2. It's very handy if your in a heterogeneous environment. After reviewing the document it was clear to us Enterprise Edition was the way to go. Hope it helps. Ashley -Original Message- Sent: Wednesday, November 14, 2001 12:05 PM To: Multiple recipients of list ORACLE-L Does anyone have a good Oracle Standard to Oracle Enterprise comparison Chart ?? I am looking on the various Oracle ran sites and most of the docs seem to try and steer you to Enterprise. Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). O9COMPETMATRIX.DOC Description: MS-Word document
RE: Intelligent Agent
I've fixed the problem now. For some reason the Intelligent agent didn't install properly the first time around. After re-installation and another run of the root.sh script, she's running like a dream. Thanks to Ruth, Brian and Ross for trying to help. Ash -Original Message- Sent: Tuesday, October 02, 2001 4:35 PM To: Multiple recipients of list ORACLE-L I don't have 8.0.3 or Tru64 UNIX to look at, but on HPUX we have $ORACLE_HOME/network/lib in the SHLIB_PATH. Check if the library it is looking for is in $OH/network/lib, and try adding that to your env. > I recently installed Compaq's Tru64 UNIX 5.1a on an Alpha > 2100 server I had > lying around. It is to be used for minimal software > development with Oracle > and general testing. > > I was able to get Oracle installed (8.0.3) without much of a > hitch. The > problem arose when I tried starting the listener (lsnrctl > start). It gave > the Fatal Error: Cannot map library libclntsh.so.1.0. I was > able to fix the > problem by resetting the LD_LIBRARY_PATH variable to include > $ORACLE_HOME/lib and $ORACLE_HOME/obackup. After the change, > the listener > started up, and I was able to mount the database. > > My issue is with the Enterprise Manager's Intelligent Agent - > dbsnmp. When > I try to run dbsnmp_start under lsnrctl, I'm getting the > library map error > again, but the variable is set correctly. Is there another > variable I'm not > aware of? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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.com -- Author: Gilbert, Ashley INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).