Yes, under Windows 2000 Server. We installed 8.1.7.0.0, then applied the 8.1.7.2.1 patch, then applied the 8.1.7.2.2 patch, and finally applied the 8.1.7.2.5 patch. Then I built the database and imported our old 8.1.6.0.0 data last weekend. Looks OK so far...less memory leakage...DBMS_Stats works nicely - it was a dog (in my limited trials) on 8.1.6.
Our DB is spread across about 340GB of datafiles on 20 disks, so there's a significant amount of data. Jack -------------------------------- Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -----Original Message----- Sent: Monday, January 07, 2002 2:11 PM To: Multiple recipients of list ORACLE-L Yes. Install 8.1.7, upgrade to 8.1.7.2.1, only then create databases. One of the interim patches between the two levels knocked out SNP processing in existing databases - no job would run. Unfortunately, testing jobs was not a part of the overall QA process so I don't know exactly which patch was bad. Oracle could not fix the problem and after battling it for a week I ended up rebuilding databases. There were other issues, specifically, Netassist wouldn't work with Names Server in 8.1.7.0, it would just crash, as well as some other setback I can't recall. Having said that, the patched up 8.1.7.2.1 on Win2k seems stable and solid. After running it for 6 months we are planning on moving into production shortly. If you're going Windows, this is the way to do it. Gary Weber Senior DBA Charles Jones, LLC||Superior Information Services, LLC 609-530-1144, ext 5529 -----Original Message----- L. Sent: Monday, January 07, 2002 2:51 PM To: Multiple recipients of list ORACLE-L Any experience with Oracle 8.1.7 on MS2000? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite 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).