Question: I am running a Data Pump import
(impdp) and I get the following ORA-31623 error:
ORA-31623: a job is not attached to this session
via the specified handle
How do I fix the ORA-31623 error: a job is not attached to
this session via the specified handle?
Answer:
Data Pump import and export job use queues, streams and java
objects.
If we see any job component is invalid (e.g. dbms_java,
queue dictionary scripts not run, rdbms/admin/utlrp.sql not run) we
may see the ORA-31623 error.
The ORA-31623 can also happens if you are not current with
patches (running catupgrd.sql and/or catpatch.sql ), see
MOSC for details.
To troubleshoot the ORA-31623 error, look for entries in
dba_registry where “status=”invalid” and check dba_objects for
object that are granted owned by SYS that are invalid.
If you want to download a pre-tested script check for
invalid objects, see the
BC Oracle
script download.
The oerr utility provide the solution for the ORA-31623 error, to
use a valid handle name:
ORA-31623: A
job is not attached to this session via the specified handle
Cause: An attempt to
reference a job using a handle which is invalid or no longer valid
for the current session.
Action: Select a handle
corresponding to a valid active job or start a new job.
Also see MOSC
note 308388.1 for details on diagnosing and tracing the ORA-31623
error.
|
|
 |
|
Guarantee your Success!
Oracle is the
world's most complex, robust and flexible database, considered
impossible to master without a mentor.
That's why all BC
Oracle trainers are working professionals, experts in Oracle who
share their tips and secrets. |
|
| |
|
Burleson is the American Team
Note:
This Oracle
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
Oracle forum.
Verify
experience!
Anyone
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
publish
their Oracle
qualifications.
Errata?
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
feedback. Just
e-mail:
 and include the URL for the page.
Copyright ? 1996 - 2012
All rights reserved.
Oracle ?
is the registered trademark of Oracle Corporation.
|
|
