TIP #11: Export failed, generate ORA-07745 error

Export of any schema failed on 10.1.0.4.2.It does not matter whether using exp or data pump.It also creates ORA-07745 error in Alert log.
Export log reports the followings:
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

The root of this problem is MDSYS account.Unlocking this account resolves the issue.

1 comment:

suresh said...

Shervin,

Hit the direct problem and provide the perfect solution.
With this solution i resolve my problem that was pending from 36hrs.
I searched all the site but only i got the right answer.

I lucky i got this site and shervin.

with thanks
Suresh Kumar (ORACLE_DBA)
+919873919043