Thursday, April 21, 2011

Unable to open Log File-EXPDP & IMPDP error

ORA-39002
ORA-39070
ORA-29283
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283

Check out expdp with default directory.If this ok.Then check out drive security.There is no SYSTEM user in SECURITY Tab.Add system user to SECURITY.Then try.

Cheers!!!

Tuesday, April 5, 2011

ORA-01000 maximum open cursors exceeded

Cause: A host language program attempted to open too many cursors. The initialization parameter OPEN_CURSORS determines the maximum number of cursors per user.

Action: Modify the program to use fewer cursors. If this error occurs often, shut down Oracle, increase the value of OPEN_CURSORS, and then restart Oracle.

ALTER SYSTEM SET open_cursors = 400 SCOPE=BOTH;

Try to find out application to see why cursors are staying open.