How to fix UDI-31623 error in Oracle?
Yesterday I've tried to import another dump as a new Oracle schema and failed to to limited space. So the impdp (Data Pump Import) exited with an error. I've successfully deleted outdated schemas using the sysadmin account and then tried to start the import again. Now it always throws the following error code and I've not yet found a solution; text is in German which is what the system is set to output:
oracle@team1:~/admin/QS1/dpdump$ !impdp
impdp PARFILE=../scripts/ecg/userid.conf DUMPFILE=expdp_epl_prod__30-08-2010.dmp SCHEMAS=EPPROD REMAP_SCHEMA=EPPROD:LIVE_SQL_FINAL REMAP_TABLESPACE=EPL:USERS
Import: Release 11.1.0.7.0 - 64bit Production on Mittwoch, 01 September, 2010 9:44:44
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Angemeldet bei: Oracle Database 11g Release 11.1.0.7.0 - 64bit Production
UDI-31623: Vorgang hat ORACLE-Fehler generiert 31623
ORA-31623: Ein Job ist dieser Session nicht über das angegebene Handle zugeordnet
ORA-06512: in "SYS.DBMS_DATAPUMP", Zeile 2862
ORA-06512: in "SYS.DBMS_DATAPUMP", Zeile 4052
ORA-06512: in Zeile 1
Translated error output is:
UDI-31623: ORACLE error process has generated 31623
ORA-31623: A job is not assigned to this session via the specified handle
ORA-06512: in "SYS.DBMS_DATAPUMP", line 2862
ORA-06512: in "SYS.DBMS_DATAPUMP", line 4052
ORA-06512: in line 1
Any ideas what might be wrong and how I can fix this?
database
edited Sep 9 '18 at 2:25
Burgi
3,84992542
asked Sep 1 '10 at 7:56
Daniel BleisteinerDaniel Bleisteiner
10114
add a comment |
Yesterday I've tried to import another dump as a new Oracle schema and failed to to limited space. So the impdp (Data Pump Import) exited with an error. I've successfully deleted outdated schemas using the sysadmin account and then tried to start the import again. Now it always throws the following error code and I've not yet found a solution; text is in German which is what the system is set to output:
oracle@team1:~/admin/QS1/dpdump$ !impdp
impdp PARFILE=../scripts/ecg/userid.conf DUMPFILE=expdp_epl_prod__30-08-2010.dmp SCHEMAS=EPPROD REMAP_SCHEMA=EPPROD:LIVE_SQL_FINAL REMAP_TABLESPACE=EPL:USERS
Import: Release 11.1.0.7.0 - 64bit Production on Mittwoch, 01 September, 2010 9:44:44
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Angemeldet bei: Oracle Database 11g Release 11.1.0.7.0 - 64bit Production
UDI-31623: Vorgang hat ORACLE-Fehler generiert 31623
ORA-31623: Ein Job ist dieser Session nicht über das angegebene Handle zugeordnet
ORA-06512: in "SYS.DBMS_DATAPUMP", Zeile 2862
ORA-06512: in "SYS.DBMS_DATAPUMP", Zeile 4052
ORA-06512: in Zeile 1
Translated error output is:
UDI-31623: ORACLE error process has generated 31623
ORA-31623: A job is not assigned to this session via the specified handle
ORA-06512: in "SYS.DBMS_DATAPUMP", line 2862
ORA-06512: in "SYS.DBMS_DATAPUMP", line 4052
ORA-06512: in line 1
Any ideas what might be wrong and how I can fix this?
database
edited Sep 9 '18 at 2:25
Burgi
3,84992542
asked Sep 1 '10 at 7:56
Daniel BleisteinerDaniel Bleisteiner
10114
community.oracle.com/thread/2169442?tstart=0 , blog.csdn.net/tianlesoftware/article/details/6139542
– Sun
May 27 '16 at 22:49
add a comment |
Yesterday I've tried to import another dump as a new Oracle schema and failed to to limited space. So the impdp (Data Pump Import) exited with an error. I've successfully deleted outdated schemas using the sysadmin account and then tried to start the import again. Now it always throws the following error code and I've not yet found a solution; text is in German which is what the system is set to output:
oracle@team1:~/admin/QS1/dpdump$ !impdp
impdp PARFILE=../scripts/ecg/userid.conf DUMPFILE=expdp_epl_prod__30-08-2010.dmp SCHEMAS=EPPROD REMAP_SCHEMA=EPPROD:LIVE_SQL_FINAL REMAP_TABLESPACE=EPL:USERS
Import: Release 11.1.0.7.0 - 64bit Production on Mittwoch, 01 September, 2010 9:44:44
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Angemeldet bei: Oracle Database 11g Release 11.1.0.7.0 - 64bit Production
UDI-31623: Vorgang hat ORACLE-Fehler generiert 31623
ORA-31623: Ein Job ist dieser Session nicht über das angegebene Handle zugeordnet
ORA-06512: in "SYS.DBMS_DATAPUMP", Zeile 2862
ORA-06512: in "SYS.DBMS_DATAPUMP", Zeile 4052
ORA-06512: in Zeile 1
Translated error output is:
UDI-31623: ORACLE error process has generated 31623
ORA-31623: A job is not assigned to this session via the specified handle
ORA-06512: in "SYS.DBMS_DATAPUMP", line 2862
ORA-06512: in "SYS.DBMS_DATAPUMP", line 4052
ORA-06512: in line 1
Any ideas what might be wrong and how I can fix this?
database
edited Sep 9 '18 at 2:25
Burgi
3,84992542
asked Sep 1 '10 at 7:56
Daniel BleisteinerDaniel Bleisteiner
10114
Yesterday I've tried to import another dump as a new Oracle schema and failed to to limited space. So the impdp (Data Pump Import) exited with an error. I've successfully deleted outdated schemas using the sysadmin account and then tried to start the import again. Now it always throws the following error code and I've not yet found a solution; text is in German which is what the system is set to output:
oracle@team1:~/admin/QS1/dpdump$ !impdp
impdp PARFILE=../scripts/ecg/userid.conf DUMPFILE=expdp_epl_prod__30-08-2010.dmp SCHEMAS=EPPROD REMAP_SCHEMA=EPPROD:LIVE_SQL_FINAL REMAP_TABLESPACE=EPL:USERS
Import: Release 11.1.0.7.0 - 64bit Production on Mittwoch, 01 September, 2010 9:44:44
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Angemeldet bei: Oracle Database 11g Release 11.1.0.7.0 - 64bit Production
UDI-31623: Vorgang hat ORACLE-Fehler generiert 31623
ORA-31623: Ein Job ist dieser Session nicht über das angegebene Handle zugeordnet
ORA-06512: in "SYS.DBMS_DATAPUMP", Zeile 2862
ORA-06512: in "SYS.DBMS_DATAPUMP", Zeile 4052
ORA-06512: in Zeile 1
Translated error output is:
UDI-31623: ORACLE error process has generated 31623
ORA-31623: A job is not assigned to this session via the specified handle
ORA-06512: in "SYS.DBMS_DATAPUMP", line 2862
ORA-06512: in "SYS.DBMS_DATAPUMP", line 4052
ORA-06512: in line 1
Any ideas what might be wrong and how I can fix this?
database
database
edited Sep 9 '18 at 2:25
Burgi
3,84992542
asked Sep 1 '10 at 7:56
Daniel BleisteinerDaniel Bleisteiner
10114
edited Sep 9 '18 at 2:25
Burgi
3,84992542
asked Sep 1 '10 at 7:56
Daniel BleisteinerDaniel Bleisteiner
10114
edited Sep 9 '18 at 2:25
Burgi
3,84992542
edited Sep 9 '18 at 2:25
Burgi
3,84992542
edited Sep 9 '18 at 2:25
Burgi
3,84992542
3,84992542
asked Sep 1 '10 at 7:56
Daniel BleisteinerDaniel Bleisteiner
10114
asked Sep 1 '10 at 7:56
Daniel BleisteinerDaniel Bleisteiner
10114
asked Sep 1 '10 at 7:56
Daniel BleisteinerDaniel Bleisteiner
10114
10114
community.oracle.com/thread/2169442?tstart=0 , blog.csdn.net/tianlesoftware/article/details/6139542
– Sun
May 27 '16 at 22:49
add a comment |
community.oracle.com/thread/2169442?tstart=0 , blog.csdn.net/tianlesoftware/article/details/6139542
– Sun
May 27 '16 at 22:49
community.oracle.com/thread/2169442?tstart=0 , blog.csdn.net/tianlesoftware/article/details/6139542
– Sun
May 27 '16 at 22:49
community.oracle.com/thread/2169442?tstart=0 , blog.csdn.net/tianlesoftware/article/details/6139542
– Sun
May 27 '16 at 22:49
add a comment |
1 Answer
1
active
oldest
votes
Have you assigned the correct rights and roles ?
Ensure you have assigned create session, create table, create procedure, imp_full_database to the user importing the dump file.
Also, assign read and write rights to the datapump directory.
grant read, write on directory <directory_name> to <user-name>
edited Aug 2 '18 at 0:08
JakeGould
31k1093137
answered Sep 1 '10 at 13:26
Sathyajith Bhat♦Sathyajith Bhat
52.7k29154252
The user is sys! That error occurs since the broken import from before... all things have been setup properly. Oracle produces different errors since than. For example I'm also not able to export data using exp or expdp.
– Daniel Bleisteiner
Sep 1 '10 at 13:32
@Daniel broken import ? What happens when you try to export using exp & import using imp ?
– Sathyajith Bhat♦
Sep 1 '10 at 19:15
EXP-00056: ORACLE-Fehler 1455 aufgetreten ORA-01455: Überlauf von Integer-Datentyp bei Umwandlung der Spalte EXP-00000: Der Export-Vorgang endete mit Fehlern
– Daniel Bleisteiner
Sep 2 '10 at 9:48
...just an example
– Daniel Bleisteiner
Sep 2 '10 at 9:48
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f183366%2fhow-to-fix-udi-31623-error-in-oracle%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Have you assigned the correct rights and roles ?
Ensure you have assigned create session, create table, create procedure, imp_full_database to the user importing the dump file.
Also, assign read and write rights to the datapump directory.
grant read, write on directory <directory_name> to <user-name>
edited Aug 2 '18 at 0:08
JakeGould
31k1093137
answered Sep 1 '10 at 13:26
Sathyajith Bhat♦Sathyajith Bhat
52.7k29154252
The user is sys! That error occurs since the broken import from before... all things have been setup properly. Oracle produces different errors since than. For example I'm also not able to export data using exp or expdp.
– Daniel Bleisteiner
Sep 1 '10 at 13:32
@Daniel broken import ? What happens when you try to export using exp & import using imp ?
– Sathyajith Bhat♦
Sep 1 '10 at 19:15
EXP-00056: ORACLE-Fehler 1455 aufgetreten ORA-01455: Überlauf von Integer-Datentyp bei Umwandlung der Spalte EXP-00000: Der Export-Vorgang endete mit Fehlern
– Daniel Bleisteiner
Sep 2 '10 at 9:48
...just an example
– Daniel Bleisteiner
Sep 2 '10 at 9:48
add a comment |
Have you assigned the correct rights and roles ?
Ensure you have assigned create session, create table, create procedure, imp_full_database to the user importing the dump file.
Also, assign read and write rights to the datapump directory.
grant read, write on directory <directory_name> to <user-name>
edited Aug 2 '18 at 0:08
JakeGould
31k1093137
answered Sep 1 '10 at 13:26
Sathyajith Bhat♦Sathyajith Bhat
52.7k29154252
The user is sys! That error occurs since the broken import from before... all things have been setup properly. Oracle produces different errors since than. For example I'm also not able to export data using exp or expdp.
– Daniel Bleisteiner
Sep 1 '10 at 13:32
@Daniel broken import ? What happens when you try to export using exp & import using imp ?
– Sathyajith Bhat♦
Sep 1 '10 at 19:15
EXP-00056: ORACLE-Fehler 1455 aufgetreten ORA-01455: Überlauf von Integer-Datentyp bei Umwandlung der Spalte EXP-00000: Der Export-Vorgang endete mit Fehlern
– Daniel Bleisteiner
Sep 2 '10 at 9:48
...just an example
– Daniel Bleisteiner
Sep 2 '10 at 9:48
add a comment |
Have you assigned the correct rights and roles ?
Ensure you have assigned create session, create table, create procedure, imp_full_database to the user importing the dump file.
Also, assign read and write rights to the datapump directory.
grant read, write on directory <directory_name> to <user-name>
edited Aug 2 '18 at 0:08
JakeGould
31k1093137
answered Sep 1 '10 at 13:26
Sathyajith Bhat♦Sathyajith Bhat
52.7k29154252
Have you assigned the correct rights and roles ?
Ensure you have assigned create session, create table, create procedure, imp_full_database to the user importing the dump file.
Also, assign read and write rights to the datapump directory.
grant read, write on directory <directory_name> to <user-name>
edited Aug 2 '18 at 0:08
JakeGould
31k1093137
answered Sep 1 '10 at 13:26
Sathyajith Bhat♦Sathyajith Bhat
52.7k29154252
edited Aug 2 '18 at 0:08
JakeGould
31k1093137
edited Aug 2 '18 at 0:08
JakeGould
31k1093137
edited Aug 2 '18 at 0:08
JakeGould
31k1093137
31k1093137
answered Sep 1 '10 at 13:26
Sathyajith Bhat♦Sathyajith Bhat
52.7k29154252
answered Sep 1 '10 at 13:26
Sathyajith Bhat♦Sathyajith Bhat
52.7k29154252
answered Sep 1 '10 at 13:26
Sathyajith Bhat♦Sathyajith Bhat
52.7k29154252
52.7k29154252
The user is sys! That error occurs since the broken import from before... all things have been setup properly. Oracle produces different errors since than. For example I'm also not able to export data using exp or expdp.
– Daniel Bleisteiner
Sep 1 '10 at 13:32
@Daniel broken import ? What happens when you try to export using exp & import using imp ?
– Sathyajith Bhat♦
Sep 1 '10 at 19:15
EXP-00056: ORACLE-Fehler 1455 aufgetreten ORA-01455: Überlauf von Integer-Datentyp bei Umwandlung der Spalte EXP-00000: Der Export-Vorgang endete mit Fehlern
– Daniel Bleisteiner
Sep 2 '10 at 9:48
...just an example
– Daniel Bleisteiner
Sep 2 '10 at 9:48
add a comment |
The user is sys! That error occurs since the broken import from before... all things have been setup properly. Oracle produces different errors since than. For example I'm also not able to export data using exp or expdp.
– Daniel Bleisteiner
Sep 1 '10 at 13:32
@Daniel broken import ? What happens when you try to export using exp & import using imp ?
– Sathyajith Bhat♦
Sep 1 '10 at 19:15
EXP-00056: ORACLE-Fehler 1455 aufgetreten ORA-01455: Überlauf von Integer-Datentyp bei Umwandlung der Spalte EXP-00000: Der Export-Vorgang endete mit Fehlern
– Daniel Bleisteiner
Sep 2 '10 at 9:48
...just an example
– Daniel Bleisteiner
Sep 2 '10 at 9:48
The user is sys! That error occurs since the broken import from before... all things have been setup properly. Oracle produces different errors since than. For example I'm also not able to export data using exp or expdp.
– Daniel Bleisteiner
Sep 1 '10 at 13:32
The user is sys! That error occurs since the broken import from before... all things have been setup properly. Oracle produces different errors since than. For example I'm also not able to export data using exp or expdp.
– Daniel Bleisteiner
Sep 1 '10 at 13:32
@Daniel broken import ? What happens when you try to export using exp & import using imp ?
– Sathyajith Bhat♦
Sep 1 '10 at 19:15
@Daniel broken import ? What happens when you try to export using exp & import using imp ?
– Sathyajith Bhat♦
Sep 1 '10 at 19:15
EXP-00056: ORACLE-Fehler 1455 aufgetreten ORA-01455: Überlauf von Integer-Datentyp bei Umwandlung der Spalte EXP-00000: Der Export-Vorgang endete mit Fehlern
– Daniel Bleisteiner
Sep 2 '10 at 9:48
EXP-00056: ORACLE-Fehler 1455 aufgetreten ORA-01455: Überlauf von Integer-Datentyp bei Umwandlung der Spalte EXP-00000: Der Export-Vorgang endete mit Fehlern
– Daniel Bleisteiner
Sep 2 '10 at 9:48
...just an example
– Daniel Bleisteiner
Sep 2 '10 at 9:48
...just an example
– Daniel Bleisteiner
Sep 2 '10 at 9:48
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f183366%2fhow-to-fix-udi-31623-error-in-oracle%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
community.oracle.com/thread/2169442?tstart=0 , blog.csdn.net/tianlesoftware/article/details/6139542
– Sun
May 27 '16 at 22:49