My knee-jerk would be to check the file dates on the 8.1.7.4's ORACLE_HOME to make sure that nothing changed accidentally. Perhaps a rogue libary or some such?
GL! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -----Original Message----- Sent: Monday, February 10, 2003 5:24 PM To: Multiple recipients of list ORACLE-L This is on our RS6000 test server running AIX 4.3.3. We've been gradually migrating our 8.1.7.x databases to 9i. We started by laying down the 9i software 3 months ago. No problem. Then we started up the 9.2.0.1 listener as the sole listener for the box 3 weeks ago, and still no problems. We then migrated a few small databases from 8.1.7.2/8.1.7.4 to 9i two weeks ago, no problems. Friday afternoon, we migrated another 8.1.7.4 database to 9i apparently with no problems. However, we come in on today to find various issues with the remaining 8.1.7.4 databases. The first issue is that utl_dir_file quit working on all 8.1.7.4 databases, but is fine on our 8.1.7.2 and 9i databases. All attempted operations elicits the invalid_path error. We've checked, and double-checked the utl_dir_file parameter and directory permissions, everything seems fine. The 2nd problem is that database links from all 8.1.7.4 WE8ISO9959P1 databases to remote UTF8 databases crash with ORA-3106 or ORA-3114, and again, they work fine on all 8.1.7.2 and 9i databases. Everything was looking good Friday night after the 9i upgrade, as witnessed by various batch processes that ran successfully after the upgrade. It was after bounces for cold backups on Saturday that all 8.1.7.4 databases began misbehaving. Any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).