-
hii,i am try to access the remote procedure,i get a error
but sessions/per user is unlimit.
SQL> EXEC GET_OCS_BALANCE('163162516',:R1,:R2);
BEGIN GET_OCS_BALANCE('163162516',:R1,:R2); END;
*
ERROR at line 1:
ORA-04052: error occurred when looking up remote object
SYSADM.GET_OCS_BALANCE@PPB_LINK.DIGI.COM.MY
ORA-00604: error occurred at recursive SQL level 1
ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
ORA-02063: preceding line from PPB_LINK
thanks
kavitha
kavitha
-
What is the value set for JOB_QUEUE_PROCESSES in the init.ora files of remote and local DBs?
-
You don't have enough sessions defined on your remote box.
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|