expdp error - Not Even Sure Where to Look
- From: David Barbour <david.barbour1@xxxxxxxxx>
- To: oracle-l mailing list <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 3 Sep 2014 10:55:11 -0500
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:
oracle@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.
Other related posts:
