Hi All,
I have a sequence that triggers 3 jobs in parallel.
All the 3 jobs uses the same lookup tables.
When I ran the job, iam getting a fatal error Fatal Error: Fatal: ORA-00022: invalid session ID; access denied
But When I run them individually they are running fine.
Could someone help to resolve this issue.
Best Regards
Invalid Session Id
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 133
- Joined: Wed Mar 05, 2003 4:19 pm
- Location: Lima - Peru. Sudamerica
- Contact:
Re: Invalid Session Id
Hi cherry
Did you search the error code ??' i did, this is the explanation
# oerr ora 00022
00022, 00000, "invalid session ID; access denied"
// *Cause: Either the session specified does not exist or the caller
// does not have the privilege to access it.
// *Action: Specify a valid session ID that you have privilege to access,
// that is either you own it or you have the CHANGE_USER privilege.
you must to verify if the oracle user has the role defined to conect to oracle from DataStage (please check you manual to install datastage and conect to oracle)
i hope this help.
Did you search the error code ??' i did, this is the explanation
# oerr ora 00022
00022, 00000, "invalid session ID; access denied"
// *Cause: Either the session specified does not exist or the caller
// does not have the privilege to access it.
// *Action: Specify a valid session ID that you have privilege to access,
// that is either you own it or you have the CHANGE_USER privilege.
you must to verify if the oracle user has the role defined to conect to oracle from DataStage (please check you manual to install datastage and conect to oracle)
i hope this help.
Saludos,
Miguel Seclén
Lima - Peru
Miguel Seclén
Lima - Peru
There are enough session limits.I guess when I run the 3 jobs in a parallel mode, 3 session should get created. But in my case the first job is taking the second job's session id. Please correct me if iam wrong. Is there any way where I can change my job design to run in parallel mode.
Regards
Cherry
Regards
Cherry