Not able to connect to Oracle

arsheshadri · Post by **arsheshadri** » Wed Dec 28, 2005 10:50 am

Hi,

I am trying execute a simple job in which I am taking some data from a textfile and loading it to Oracle.

But when I try to run the Job, it says "Oracle_Enterprise_1: connect failed for env: null, user: SHESHA, password: *****" even though I have set all properties.

I am using Oracle Enterprise stage and have set the user name and password properties. I am connecting through a connect string called ETL and I have set this under Additional Connection Option.

The same configuration is working under serverjobs, Is there anything that I have to configure in Datastage Administrator or in Unix?

Thanks & Regards
Sheshadri

arsheshadri · Post by **arsheshadri** » Wed Dec 28, 2005 12:11 pm

Hi,

Thanks for the reply, I checked the database and I have select permission to all dictionary views.

Do I have to do any other things apart from this?

Regards
Sheshadri

lstsaur · Post by **lstsaur** » Wed Dec 28, 2005 1:48 pm

Hi Sheshadri,
Try type in your ID and password directly under Oracle_Enterprise stage's Properties-->Conncetions-->DB Option Mode(Auto-Generate)-->Password and User. It should work if you are pretty sure that you have the access to those dictionary views.
BTW, Oracle_Enterprise stage only works for parallel job. Good luck.

jasper · Post by **jasper** » Thu Dec 29, 2005 1:43 am

hi,
in your error message you see :

connect failed for env: null

Under your connection in the Oracle stage you need to set the remote server property to your database name. For now it has no clue in which DB to look.

arsheshadri · Post by **arsheshadri** » Thu Dec 29, 2005 3:33 am

Thanks everyone, It is working now after setting the Remote Server property.

Regards
Sheshadri