Oracle DB plugins not working in Datastage

saikrishna · Post by **saikrishna** » Mon Jun 01, 2009 4:04 am

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

ray.wurlod · Post by **ray.wurlod** » Mon Jun 01, 2009 5:51 am

Can you import a table definition from Oracle? If not, get your DBA to check your connectivity from the DataStage server.

saikrishna · Post by **saikrishna** » Mon Jun 01, 2009 6:20 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

chulett · Post by **chulett** » Mon Jun 01, 2009 6:24 am

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.

saikrishna · Post by **saikrishna** » Mon Jun 01, 2009 6:29 am

Hey chullet

I made it wrong...
What could be the solution now.. As it is production.

saikrishna · Post by **saikrishna** » Mon Jun 01, 2009 6:45 am

Thanks Chullet.. I got it.. It is working fine ..when I rebuild it... Thank you.. I didnt follow your note correctly..

Coming back to the main thread issue, whats the reason behind "not able to connect to db from datastage"

Thank you and Thanks a lot
Sai

saikrishna · Post by **saikrishna** » Tue Jun 02, 2009 12:04 am

Hi

Can you please help me in resolving DB connectivity problem from DataStage..

Thanks
Sai

chulett · Post by **chulett** » Tue Jun 02, 2009 7:18 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.