terima kasih pa leonard
namun sebelumnya saya pernah coba untuk catexp.sql
nya, tapi tetap exp full db tidak berjalan namun
dengan error yang berbeda, tapi setelah saya coba
jalankan catmeta.sql exp full nya bisa berjalan.
mungkin saya akan coba lagi catexp.sql pa
best regards Herry
dear all
sory, mungkin ada yang pernah berpengalaman maintain
oracle database, JDEdwards E811, barang kali bisa
saling share .. terima kasih
--- Leonard Sukendro <[EMAIL PROTECTED]> wrote:
>
> tp pak herry
>
> ini coba saya bagi artikel dr metalink, errornya
> mirip2.. dia blg kejadiannya di versi 10.1.0.2, tp
> sapa tau kejadiannya sama di versi bapak.. thx.
>
> Applies to:
> Oracle Server - Enterprise Edition - Version:
> 10.1.0.2.0
> This problem can occur on any platform.
>
> Symptoms
> The alert.log reports the following ORA-7445 error:
>
> ORA-07445: exception encountered: core dump
> [ACCESS_VIOLATION] [0xF0183D] [] [] [] []
> Current SQL statement for this session:
> SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$),
> XMLFORMAT.createFormat2('XMLSCHEMA_T', '7')), 0 FROM
> SYS.KU$_XMLSCHEMA_VIEW KU$ WHERE
> KU$.OWNER_NAME=:SCHEMA1
>
> The export errors are as follows:
>
> EXP-00056: ORACLE error 24324 encountered
> ORA-24324: service handle not initialized
> EXP-00056: ORACLE error 24324 encountered
> ORA-24324: service handle not initialized
> EXP-00056: ORACLE error 24324 encountered
> ORA-24324: service handle not initialized
> EXP-00000: Export terminated unsuccessfully
>
> Cause
> Invalid objects in the database:
> DBMS_REPCAT_EXP
> DBMS_LOGREP_IMP SYS
> DBMS_LOGREP_EXP SYS
> DBMS_RULE_EXP_UTL
>
> Solution
> Run catexp.sql and try the export again.
>
> regards,
> [L]
>
> --- HERRY WAHYUDINATA <[EMAIL PROTECTED]>
> wrote:
>
> > dear all
> > mohon bantuan,
> > saya mempunyai database 9.2.0.5 production live
> > 90GB, ada kendala
> > dengan proses export database, untuk exp full db
> dan
> > per-schema
> > selalu muncul error
> > EXP-00056 : ORACLE error 24234 encountered
> > ORA-24324 : service handle not initialized
> > EXP-00056 : ORACLE error 24234 encountered
> > ORA-24324 : service handle not initialized
> > EXP-00000 : Export terminated unsuccessfully
> >
> > lalu saya coba menjalankan sql di
> %oraclehome%\ora92
> > \rdbms\admin\catmeta.sql, pada saat saya jalankan
> > catmeta.sql ada
> > muncul banyak transaction yang tidak
> lancar..hingga
> > ke commit
> > (percobaan tersebut saya lakukan di backup
> database
> > sever), namun
> > efek-nya exp full database jadi bisa jalan..
> >
> > yang menjadi kendala saya, apakah proses
> catmeta.sql
> > jika dijalankan
> > di prod db, tidak akan bermasalah ?
> > atau mungkin ada cara lain untuk menghilangkan
> error
> > diatas.
> >
> > mohon pencerahan
> >
> > thanks alot
> >
> >
> >
> >
>
>
>
>
>
____________________________________________________________________________________
> Looking for last minute shopping deals?
> Find them fast with Yahoo! Search.
>
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
>
____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search.
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
