Not able to run expdp [message #689874] |
Sun, 16 June 2024 12:41 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/075298702fbe4101a8f6a8536575eecd?s=64&d=mm&r=g) |
orHooha
Messages: 19 Registered: April 2015
|
Junior Member |
|
|
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0
Export: Release 11.2.0.3.0 - Production
Hi,
We've been having a problem generating an export for a database DOCT1, on a RAC. We get errors about job resource synchronization.
There seems also to be an indication that there's 2 other jobs running, but when we run a DATAPUMP query, it mentions SYS_EXPORT_FULL_01, but says nothing is running.
We tried increasing the STREAMS_POOL_SIZE size, but we receive a common error about memory in another instance.
The other instance - we think - refers to DOCT2, which points to the same database.
These are the errors we're getting, when running a script with expdp, and when trying to set the STREAMS_POOL_SIZE.
This is on an AIX server.
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_FULL_03 for user SYSTEM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 798
ORA-31635: unable to establish job resource synchronization
system@DOCT>SELECT owner_name, job_name, operation, state FROM DBA_DATAPUMP_JOBS;
SYSTEM, SYS_EXPORT_FULL_01, EXPORT, NOT RUNNING
system@DOCT>ALTER SYSTEM SET STREAMS_POOL_SIZE=100m ;
ALTER SYSTEM SET STREAMS_POOL_SIZE=100m
*
ERROR at line 1:
ORA-32018: parameter cannot be modified in memory on another instance
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: Not able to run expdp [message #689886 is a reply to message #689884] |
Tue, 18 June 2024 14:23 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
orHooha wrote on Mon, 17 June 2024 21:46How do I tell if it does? My memory may not be accurate going that far back, but I think this will show you how the service is configured and running:
srvctl config service -d <your database's unique name, probably doct> -s doct
srvctl status service -d <your database's unique name> -s doct However, I think that you are using the default service for the database. You have instances doct1 and doct2, opening a database doct. You should not be using the default service, you should be creating your own service which you start on only one node.
Hope that helps.
|
|
|
Re: Not able to run expdp [message #689889 is a reply to message #689886] |
Thu, 20 June 2024 09:59 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/075298702fbe4101a8f6a8536575eecd?s=64&d=mm&r=g) |
orHooha
Messages: 19 Registered: April 2015
|
Junior Member |
|
|
Thanks, John. I don't understand how to create our own service. Anyway, I'll forward your comment, thanks.
John Watson wrote on Tue, 18 June 2024 15:23orHooha wrote on Mon, 17 June 2024 21:46How do I tell if it does? My memory may not be accurate going that far back, but I think this will show you how the service is configured and running:
srvctl config service -d <your database's unique name, probably doct> -s doct
srvctl status service -d <your database's unique name> -s doct However, I think that you are using the default service for the database. You have instances doct1 and doct2, opening a database doct. You should not be using the default service, you should be creating your own service which you start on only one node.
Hope that helps.
|
|
|
|
|
|
|