| 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: 8.1.7.4 databases going bad
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 rich.jesse_at_qtiworld.com 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: Rich.Jesse_at_qtiworld.com
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: 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). Received on Tue Feb 11 2003 - 08:24:00 CST
 |
 |