Andreas,
ORA-7445 is a very generic error and the arguments are
frequently irrelevant. You should log a tar with
support and upload the alert.log and trace files
generated by the ORA-7445 errors.
HTH,
- Anita
- Andreas Teich <teich_at_novedia.de> wrote:
> Dear All,
>
> two days ago, we created the following snapshot (see
> above) without any problems.
>
> CREATE SNAPSHOT ksa_dba.sys_schnr_webksa_max_repl
> STORAGE (
> INITIAL 40k
> NEXT 40k
> PCTINCREASE 0)
> TABLESPACE TS_SCH
> NOLOGGING
> BUILD IMMEDIATE
> USING INDEX STORAGE(
> INITIAL 40k
> NEXT 40k
> PCTINCREASE 0) TABLESPACE TS_IND1
> REFRESH COMPLETE WITH ROWID ON DEMAND
> AS
> SELECT 0 lfd_mod_2,sp.sparte, NVL((mlfd),0)
> max_lfd
> FROM repl_ksa.sys_sparte sp,
> (SELECT sparte, MAX(MOD(schnr,100000)) mlfd
> FROM repl_ksa.meld_sch
> WHERE
> anl >= TRUNC(SYSDATE,'YYYY')
> AND MOD(schnr,2) = 0
> GROUP BY sparte) sc
> WHERE
> sp.sparte < 10
> AND sc.sparte (+) =sp.sparte
> UNION
> SELECT 1 lfd_mod_2,sp.sparte, NVL((mlfd),0)
> max_lfd
> FROM repl_ksa.sys_sparte sp,
> (SELECT sparte, MAX(MOD(schnr,100000)) mlfd
> FROM repl_ksa.meld_sch
> WHERE
> anl >= TRUNC(SYSDATE,'YYYY')
> AND MOD(schnr,2) = 1
> GROUP BY sparte) sc
> WHERE
> sp.sparte < 10
> AND sc.sparte (+) = sp.sparte
> ;
>
> From yesterday, we still in trouble. If we try to
> create it from a client with sql*plus,
>
> we get an ORA-03113 (end-of-file on communication
> channel). On the server itself,
>
> with sql*plus we get a core dump file.
>
> In the trace file we get only the entry above:
>
> Tue May 15 16:14:46 2001
> Errors in file
>
/usr/local/oracle/8i/u01/app/oracle/admin/GLBL/udump/ora_9784.trc:
> ORA-07445: exception encountered: core dump [11] [0]
> [] [] [] []
>
> Has anybody ANY idea what happend to our instance
> ???
>
> TIA
>
> Andreas
>
> -- --
> Novedia AG, Hardenbergstraße 19
> Andreas Teich, Dipl.-Math. Tel +49
> 30 311889-57
> 10623 Berlin-Charlottenburg Fax +49
> 30 311889-19
> mailto:teich_at_novedia.de
> http://novedia.de
> -------
> One OS to rule them all, One OS to find them,
> One OS to bring them all and in the darkness bind
> them...
>
>
>
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
INET: abardeen1_at_yahoo.com
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: 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 Fri May 18 2001 - 10:59:13 CDT
