Invalid Session Id

[cherry]

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

[jseclen]

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.

[chulett]

They do or they wouldn't work when rerun individually. Sounds to me like a resource issue, one that I would take to my DBA if it was happening to me and see if any session limits need to be bumped up.

[cherry]

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

[Mike]

Since you are running 3 parallel jobs in parallel, the number of Oracle sessions could be many more than 3. I'd definitely involve your DBA in the monitoring/debugging process.

Mike