DSXchange

Hi,

I am executing Job sequence, which loads the data from one staging area to another staging area. Both Source and Target are Oracle tables.
The sequence aborted and I am getting the following errors
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does no.
I have run the same job individually , that time it was executed successfully,
Any one please help me what could be the error?

Thanks in advance
Suresh

Most likely the database connectivity values are parameters, and they are not being passed correctly from the sequence.

Those errors mean the Oracle instance you attempted to connect to was down. So either it was available earlier but not now or, as Arnd mentions, you connected to a different (and still unavailable) instance.

Check the Server job's log, the first record will show the parameter values it used. Or double-click on the job from the Status view in the Director, you'll see the parameter values from the most recent run.