Home » RDBMS Server » Backup & Recovery » Trying to understand EXP error (11.1.0.7.0)
Trying to understand EXP error [message #489460] Sun, 16 January 2011 17:43 Go to next message
newDBACE
Messages: 3
Registered: January 2011
Junior Member
Hello,

As a newbie to the world of Oracle, I have been assigned the task of determining what this error means and how to resolve it.

We have a CRON job that runs the following command on a Solaris box:
exp SYSTEM/PASSWORD@dbinstance file=myexport.pipe statistics=none consistent=y

The following error is returned:
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "DMSYS.DBMS_DM_IMP_INTERNAL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "DMSYS.DBMS_DM_IMP_INTERNAL"
ORA-06512: at "DMSYS.DBMS_DM_MODEL_EXP", line 303
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling DMSYS.DBMS_DM_MODEL_EXP.schema_info_exp


I have researched the error but cannot find an explanation as to what it means or how to resolve it step by step.

Any help would be GREATLY apprecieated.

Thank You in advance.
Re: Trying to understand EXP error [message #489461 is a reply to message #489460] Sun, 16 January 2011 18:15 Go to previous messageGo to next message
BlackSwan
Messages: 26759
Registered: January 2009
Location: SoCal
Senior Member
When was last the time this job succeeded?
What changed since then?

Why still using "exp" with V11; instead of faster expdp?
exp operates in 1 of 3 modes; full=y, owner=schema_name, or TABLES=
which of the three do you desire?

>exp SYSTEM/PASSWORD@dbinstance
is command of issued directly on local DB Server?
Re: Trying to understand EXP error [message #489463 is a reply to message #489461] Sun, 16 January 2011 19:15 Go to previous messageGo to next message
newDBACE
Messages: 3
Registered: January 2011
Junior Member
BlackSwan,

I am not exactly sure if the backup was completely successful. From the messages, it seems that it did.

EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "DMSYS.DBMS_DM_IMP_INTERNAL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "DMSYS.DBMS_DM_IMP_INTERNAL"
ORA-06512: at "DMSYS.DBMS_DM_MODEL_EXP", line 303
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling DMSYS.DBMS_DM_MODEL_EXP.schema_info_exp
. exporting statistics
<exported rows from many tables here>
Export terminated successfully with warnings.

I do realize the EXP command is depricated in Version 11G, but I am not sure if the EXPDP will fix the current issue.

This command is being run on the DB server.

I'm trying to gather as much info before presenting a course of direction to my manager.

Thank You
Re: Trying to understand EXP error [message #489464 is a reply to message #489463] Sun, 16 January 2011 19:23 Go to previous messageGo to next message
BlackSwan
Messages: 26759
Registered: January 2009
Location: SoCal
Senior Member
>I am not exactly sure if the backup was completely successful.
Yesterday? Last week? Last Month? Last Year? Ever?

reposting the same error added nothing new to this discussion

>This command is being run on the DB server.
then "@dbinstance" is superfluous.

does a schema level export succeed without error?
Re: Trying to understand EXP error [message #489465 is a reply to message #489464] Sun, 16 January 2011 19:40 Go to previous message
newDBACE
Messages: 3
Registered: January 2011
Junior Member
The CRON job runs daily and the last message that is listed is
Export terminated successfully with warnings.
The DBA who is no longer with us said the backup completed but my manager is not so sure seeing these errors.

You are correct, "@dbinstance" is a superfluous name.

Being new to the world of ORACLE (background is more of a developer), I'm trying to understand these messages.

I do know that a full RMAN backup is performed on the weekend, and that the EXP is used incase of a failure during the week.

Unfortunately, I do not know if a schema level export has been done...
Previous Topic: Rman backup backupset question
Next Topic: date time changes
Goto Forum:
  


Current Time: Wed Mar 03 06:27:12 CST 2021