expdp error - Not Even Sure Where to Look

[David Barbour]

RHEL 6.4 Oracle 11.2.0.3.o

Had a request to export a schema. No problem. Set up a directory, granted
rights, made sure directory ownership and permissions on the server were
correct and issued the command:

***@rchr1p04 P244 /tmp_mnt/P24_Dump $ expdp system/<password>@P244
schemas=MSFPRD,TLMPRD directory=P24_Dump
dumpfile=MSFPRD_TLMPRD_09022014.dmp logfile=MSFPRD_TLMPRD_09022014.log

Got this back:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 -
64bit Production
With the Real Application Clusters and Automatic Storage Management options
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user SYSTEM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1569
ORA-39062: error creating master process DM00
ORA-39107: Master process DM00 violated startup protocol. Master error:
ORA-01821: date format not recognized

Huh?


Alert log shows:

DM00 started with pid=53, OS id=21595, job SYSTEM.SYS_EXPORT_SCHEMA_01
opidrv aborting process DM00 ospid (21595) as a result of ORA-447
Wed Sep 03 10:17:00 2014
ALTER SYSTEM SET service_names='SYS$SYS.KUPC$
S_4_20140903101659.P24.LENNOXINTL.COM','P244.lennoxintl.com' SCOPE=MEMORY
SID='P244';
ALTER SYSTEM SET service_names='P244.lennoxintl.com' SCOPE=MEMORY
SID='P244';

DM00 Trace file shows:

*** 2014-09-03 10:16:59.659
*** SESSION ID:(950.153) 2014-09-03 10:16:59.659
*** CLIENT ID:() 2014-09-03 10:16:59.659
*** SERVICE NAME:(SYS$USERS) 2014-09-03 10:16:59.659
*** MODULE NAME:() 2014-09-03 10:16:59.659
*** ACTION NAME:() 2014-09-03 10:16:59.659

KUPP: Error 1821 detected in master process DM00
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-31666: Master process DM00 had an unhandled exception.
ORA-01821: date format not recognized

Any ideas?

This actually happened yesterday as well and I've tried some different
things with NLS and Googled the heck out of this and looked through MOS
with no luck. Put in an SR with this information and they want the full
command (was provided), the error (was provided) and the alert log contents
(were provided). Not sure if they read the submission. Not sure why I
even try that route any more.

[Freek D'Hooge]

David,

Checkout MOS note: How To Find The Tables From Data Dictonary Which Are
Generating ORA-1801 While Running The Export? (Doc ID 1364321.1)
It is not the exact same error, but it seems plausible to me.


regards,

Freek

Post by David Barbour
RHEL 6.4 Oracle 11.2.0.3.o
Had a request to export a schema. No problem. Set up a directory,
granted rights, made sure directory ownership and permissions on the
schemas=MSFPRD,TLMPRD directory=P24_Dump
dumpfile=MSFPRD_TLMPRD_09022014.dmp
logfile=MSFPRD_TLMPRD_09022014.log
Connected to: Oracle Database 11g Enterprise Edition Release
11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user SYSTEM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1569
ORA-39062: error creating master process DM00
ORA-01821: date format not recognized
Huh?
DM00 started with pid=53, OS id=21595, job
SYSTEM.SYS_EXPORT_SCHEMA_01
opidrv aborting process DM00 ospid (21595) as a result of ORA-447
Wed Sep 03 10:17:00 2014
ALTER SYSTEM SET service_names='SYS$SYS.KUPC
$S_4_20140903101659.P24.LENNOXINTL.COM','P244.lennoxintl.com'
SCOPE=MEMORY SID='P244';
ALTER SYSTEM SET service_names='P244.lennoxintl.com' SCOPE=MEMORY
SID='P244';
*** 2014-09-03 10:16:59.659
*** SESSION ID:(950.153) 2014-09-03 10:16:59.659
*** CLIENT ID:() 2014-09-03 10:16:59.659
*** SERVICE NAME:(SYS$USERS) 2014-09-03 10:16:59.659
*** MODULE NAME:() 2014-09-03 10:16:59.659
*** ACTION NAME:() 2014-09-03 10:16:59.659
KUPP: Error 1821 detected in master process DM00
ORA-00447: fatal error in background process
ORA-31666: Master process DM00 had an unhandled exception.
ORA-01821: date format not recognized
Any ideas?
This actually happened yesterday as well and I've tried some different
things with NLS and Googled the heck out of this and looked through
MOS with no luck. Put in an SR with this information and they want
the full command (was provided), the error (was provided) and the
alert log contents (were provided). Not sure if they read the
submission. Not sure why I even try that route any more.

[Powell, Mark]

I am not sure either of these support notes fits your problem but neither is very involved so these should be worth a look. If nothing else you can list these as not being the problem on an SR if note 13654321.1 already recommended is not helpful.

-- not enough database processes
Data Pump Export Fails With ORA-39062 and ORA-31613: Master Process DM00 Failed During Startup (Doc ID 1368180.1)
- - synonym exists with same name as exporting user
DataPump Export Or Import (EXPDP Or IMPDP) Fails With Errors ORA-31626 ORA-6533 ORA-31637 (Doc ID 1068435.1)
--
From: oracle-l-***@freelists.org [mailto:oracle-l-***@freelists.org] On Behalf Of Freek D'Hooge
Sent: Wednesday, September 03, 2014 12:55 PM
To: ***@gmail.com
Cc: oracle-l mailing list
Subject: Re: expdp error - Not Even Sure Where to Look

David,

Checkout MOS note: How To Find The Tables From Data Dictonary Which Are Generating ORA-1801 While Running The Export? (Doc ID 1364321.1)
It is not the exact same error, but it seems plausible to me.


regards,

Freek


On wo, 2014-09-03 at 10:55 -0500, David Barbour wrote:
RHEL 6.4 Oracle 11.2.0.3.o

Had a request to export a schema. No problem. Set up a directory, granted rights, made sure directory ownership and permissions on the server were correct and issued the command:

***@rchr1p04 P244 /tmp_mnt/P24_Dump $ expdp system/<password>@P244 schemas=MSFPRD,TLMPRD directory=P24_Dump dumpfile=MSFPRD_TLMPRD_09022014.dmp logfile=MSFPRD_TLMPRD_09022014.log

Got this back:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user SYSTEM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1569
ORA-39062: error creating master process DM00
ORA-39107: Master process DM00 violated startup protocol. Master error:
ORA-01821: date format not recognized

Huh?


Alert log shows:

DM00 started with pid=53, OS id=21595, job SYSTEM.SYS_EXPORT_SCHEMA_01
opidrv aborting process DM00 ospid (21595) as a result of ORA-447
Wed Sep 03 10:17:00 2014
ALTER SYSTEM SET service_names='SYS$SYS.KUPC$S_4_20140903101659.P24.LENNOXINTL.COM<http://S_4_20140903101659.P24.LENNOXINTL.COM>','P244.lennoxintl.com<http://P244.lennoxintl.com>' SCOPE=MEMORY SID='P244';
ALTER SYSTEM SET service_names='P244.lennoxintl.com<http://P244.lennoxintl.com>' SCOPE=MEMORY SID='P244';

DM00 Trace file shows:

*** 2014-09-03 10:16:59.659
*** SESSION ID:(950.153) 2014-09-03 10:16:59.659
*** CLIENT ID:() 2014-09-03 10:16:59.659
*** SERVICE NAME:(SYS$USERS) 2014-09-03 10:16:59.659
*** MODULE NAME:() 2014-09-03 10:16:59.659
*** ACTION NAME:() 2014-09-03 10:16:59.659

KUPP: Error 1821 detected in master process DM00
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-31666: Master process DM00 had an unhandled exception.
ORA-01821: date format not recognized

Any ideas?

This actually happened yesterday as well and I've tried some different things with NLS and Googled the heck out of this and looked through MOS with no luck. Put in an SR with this information and they want the full command (was provided), the error (was provided) and the alert log contents (were provided). Not sure if they read the submission. Not sure why I even try that route any more.