ORACLE not available

sureshabbisetti · Post by **sureshabbisetti** » Wed Oct 22, 2008 4:49 am

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

ArndW · Post by **ArndW** » Wed Oct 22, 2008 5:18 am

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

chulett · Post by **chulett** » Wed Oct 22, 2008 7:48 am

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.