Here's a strange one...
I have a database which has recently been migrated from 8.1.7 to 9.2.0.1 (part of a group of 7 databases all on Sun Solaris) which is experiencing the following problem
In the trace file which is created the following error is givenCode:$ sqlplus /nolog SQL*Plus: Release 9.2.0.1.0 - Production on Fri Mar 14 10:37:28 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL> connect / as sysdba Connected. SQL> SELECT 2 REQUEST_FAILURES, 3 LAST_FAILURE_SIZE, 4 MAX_FREE_SIZE, 5 FREE_SPACE, 6 REQUEST_MISSES 7 FROM 8 V$SHARED_POOL_RESERVED; SELECT * ERROR at line 1: ORA-03113: end-of-file on communication channel
At first I thought it might be a DD corruption so I have rerun catalog, catproc but still the error occurs. Of the 7 databases I migrated this is the only one experiencing this problem, I've checked Metalink and no luck, has anyone else encounter this? I really don't want to go back to 8.1.7 and I don't want to have to recreate the database again and import the data (nearly 200Gb)Code:Exception signal: 10 (SIGBUS), code: 1 (Invalid address alignment), addr: 0x40 43, PC: [0x1796a1c, kghrsc()+472] *** 2003-03-14 10:55:13.971 ksedmp: internal or fatal error ORA-07445: exception encountered: core dump [kghrsc()+472] [SIGBUS] [Invalid a ddress alignment] [0x4043] [] []
Please feel free to point out my ineptitude if you spot any glaringly obvious mistakes
Cheers





Reply With Quote