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
ORACLE not available
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 21
- Joined: Thu Oct 04, 2007 4:34 am
- Location: India
- Contact:
Most likely the database connectivity values are parameters, and they are not being passed correctly from the sequence.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers