Hi
Suddenly in our production, we faced the following problem.
All the database stages, i.e. Oracle stages not working and not connecting to the DB to get data or call procs.
To verify this, i have designed simple job, which pulls one row and writes to a file, even this job is also not working.
Here not working means, the job is not coming out of the 'running' state forever.
Even I did the "View Data" option in the oracle DB stage. dont understand what is the problem. Can you please help me here.
Thanks
Sai
Oracle DB plugins not working in Datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 158
- Joined: Tue Mar 15, 2005 3:16 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 158
- Joined: Tue Mar 15, 2005 3:16 am
Hi Ray..
The import table definition also not working..
But i could connect to oracle from the linux host server where DS installed..
I tried "Rebuild Indexes" from DS Administrator.
And restarted DS Server..
But shockingly after the restart, all my DS jobs in the projects are unvisible,...I could not see any jobs...
Can you please help me out.. looks a serious issue.....
Thanks
Sai
The import table definition also not working..
But i could connect to oracle from the linux host server where DS installed..
I tried "Rebuild Indexes" from DS Administrator.
And restarted DS Server..
But shockingly after the restart, all my DS jobs in the projects are unvisible,...I could not see any jobs...
Can you please help me out.. looks a serious issue.....
Thanks
Sai
Don't "rebuild indexes" unless A) you actually need to and B) you understand how to do it. All of the jobs being "gone" is a result of running it when others are connected. So...
Make sure there are zero other connections - clients, running jobs, defunct connections, nothing - and then rerun it. You'll know you've done it correctly when all your jobs come back to visibility.
![Exclamation :!:](./images/smilies/icon_exclaim.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 158
- Joined: Tue Mar 15, 2005 3:16 am
-
- Participant
- Posts: 158
- Joined: Tue Mar 15, 2005 3:16 am
-
- Participant
- Posts: 158
- Joined: Tue Mar 15, 2005 3:16 am
Silly things like life and my work got in the way.
You need to find out what changed. Obviously something did. Talk to your DBA and see if any Oracle changes were made. You said "even I did the View Data option" but did say what the result was - an error? It works? What? You also said you could connect to Oracle from the DS server - connect how? Do you mean via sqlplus? Something else?
Verify where your $ORACLE_HOME variable points and that your 'dsenv' file still has what it needs there for Oracle connectivity.
You need to find out what changed. Obviously something did. Talk to your DBA and see if any Oracle changes were made. You said "even I did the View Data option" but did say what the result was - an error? It works? What? You also said you could connect to Oracle from the DS server - connect how? Do you mean via sqlplus? Something else?
Verify where your $ORACLE_HOME variable points and that your 'dsenv' file still has what it needs there for Oracle connectivity.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers