Error while connection to Oracle Enterprise stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
dsguy
Participant
Posts: 34
Joined: Thu Mar 09, 2006 10:37 am

Error while connection to Oracle Enterprise stage

Post by dsguy »

Hi

I am getting the following error while connecting to Oracle Enterprise stage.
I am able to connect the same using ODBC stage.
Your help is appreciated
>##E TFOP 000481 06:42:57(008) <Oracle_Enterprise_49> Incorrect dboption list; it failed on Expected "," or "}", got: "$", line 1.

Thanks
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

I believe you have special characters in your parameters or maybe even password. Do an exact search on "Incorrect dboption list" and you will find that this has been discussed here before.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
dsguy
Participant
Posts: 34
Joined: Thu Mar 09, 2006 10:37 am

Post by dsguy »

Hi

I am using $ in my password.dou think that might be the problem.
Please help me in resolving this.

Thanks,
Girish
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

That is definately the problem. The error message tells you that
dsguy wrote: >##E TFOP 000481 06:42:57(008) <Oracle_Enterprise_49> Incorrect dboption list; it failed on Expected "," or "}", got: "$", line 1.
Read this post. I think its a bug and there is an ECASE out there for the same.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Post Reply