| Issue in export [message #661907] |
Wed, 05 April 2017 17:15  |
chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad
|
Senior Member |
|
|
Hello Friends,
Today, i stuck while exporting schema export. I am taking export everyday but today it can not performing. please guide me to come out of it.
Quote:
[mydb@mydbhost ~]$ expdp post08/post08
Export: Release 11.2.0.1.0 - Production on Thu Apr 6 03:32:28 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-31638: cannot attach to job SYS_EXPORT_SCHEMA_02 for user POST08
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 428
ORA-39077: unable to subscribe agent KUPC$A_1_20170406033228 to queue "KUPC$C_1_
20170406033228"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 250
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Thanks,
Chintan
|
|
|
|
|
|
| Re: Issue in export [message #661912 is a reply to message #661911] |
Thu, 06 April 2017 00:50  |
chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad
|
Senior Member |
|
|
Dear Michel
1/ Are you in RAC?
Answer : No
2/ Are you running in parallel?
Answer : No
3/ What is the value of your DATA_PUMP_DIR directory?
SQL> select * from dba_directories where DIRECTORY_NAME like '%DATA_PUMP%';
OWNER DIRECTORY_NAME DIRECTORY_PATH
------------------------------ ------------------------------ ------------------------------
SYS DATA_PUMP_DIR /mydb/odb/OH1/rdbms/log/
4/ What is the result of the following queries:
SQL> SELECT "SYS"."AQ$_KUPC$DATAPUMP_QUETAB_1_N".CURRVAL val# FROM DUAL;
SELECT "SYS"."AQ$_KUPC$DATAPUMP_QUETAB_1_N".CURRVAL val# FROM DUAL
*
ERROR at line 1:
ORA-08002: sequence AQ$_KUPC$DATAPUMP_QUETAB_1_N.CURRVAL is not yet defined in this session
SQL> SELECT "SYS"."AQ$_KUPC$DATAPUMP_QUETAB_N".CURRVAL val# FROM DUAL;
SELECT "SYS"."AQ$_KUPC$DATAPUMP_QUETAB_N".CURRVAL val# FROM DUAL
*
ERROR at line 1:
ORA-08002: sequence AQ$_KUPC$DATAPUMP_QUETAB_N.CURRVAL is not yet defined in this session
Regards
Chintan
|
|
|
|
|
|
| Re: Issue in export [message #661914 is a reply to message #661911] |
Thu, 06 April 2017 00:56 |
chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad
|
Senior Member |
|
|
Dear Michel
Here is the result.
SQL> SELECT "SYS"."AQ$_KUPC$DATAPUMP_QUETAB_1_N".NEXTVAL val# FROM DUAL;
VAL#
----------
1000251
SQL> SELECT "SYS"."AQ$_KUPC$DATAPUMP_QUETAB_N".NEXTVAL val# FROM DUAL;
VAL#
----------
1
Regards
Chintan
|
|
|
|
|
|
| Re: Issue in export [message #661918 is a reply to message #661916] |
Thu, 06 April 2017 01:06 |
chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad
|
Senior Member |
|
|
Dear Michel,
As i understand, I've to reinstall the package related to EXPDP utility. For that I've to shutdown my running instance and startup in nomount stage to run the below mentioned scripts. Please suggest.
Regards
Chintan
|
|
|
|
|
|
| Re: Issue in export [message #661920 is a reply to message #661919] |
Thu, 06 April 2017 01:21 |
chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad
|
Senior Member |
|
|
Dear Michel,
So I can strait away run this scripts in my database, as currently it is open and running good for the application users. Do I need to stop the applications users (live transactions) as a safety measure while performing the running of suggested scripts? Please let me know finally.
Regards
Chintan
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
