Issue in accessing Oracle 10g R2 database

rkdatastage · Post by **rkdatastage** » Thu Dec 27, 2007 12:13 am

Hi
Can somebody guide me to resolve the issue.
I am trying to connect to Oracle 10g R2 using ORAOCI9 Stage and i am getting the following Message like " Unable to initialize plug-in: "
I had tryed to access Oracle 10g R2 with DRS Stage also but i had the same Message " Unable to initialize plug-in: "
Kindly Guide me the workaround.

Data Stage version is 7.5.1.A and is running on windows XP.
Oracle Client is installed in my Machine and i am able to connect to Oracle database.

Thanks in Advance
RK

WoMaWil · Post by **WoMaWil** » Thu Dec 27, 2007 2:00 am

(1) Oracle Client has to be installed on the same Machine as DataStage resides.

(2) Details for to connect ot oracle has to be set in the dsenv file of your DataStage Machine.

(3) Best is to read the manual and do as described there.

ray.wurlod · Post by **ray.wurlod** » Thu Dec 27, 2007 4:02 am

7.5.1.A or 8x ?

Has the ORAOCI9 stage been properly installed and registered?

Can you access Oracle using ODBC from DataStage?

rkdatastage · Post by **rkdatastage** » Thu Dec 27, 2007 4:47 am

Thanks for your response Guys

Datastage version is 7.5.1.A only
i tried to connect through ODBC Stage and i am getting this error.

---
DSR.MetaGeta(GET.TABLES)(SQLConnect('dsn','admin')): BCI Error:
SQLSTATE=IM003,CODE=160,[DataStage][SQL Client][ODBC]Specified driver could not be loaded due to system error 1114 (Oracle in OraClient10g_home1).
----

As i checked the ORAOCI9 Plugin Documentation there it is specified that it will support oracle 9i & 10g Databases.

Do I had to specify any environment variables as Datastage server and Client are both in same Machine and OS is Windows XP.

waiting for your guidance.

Regards
RK

WoMaWil · Post by **WoMaWil** » Thu Dec 27, 2007 8:20 am

Dear RK,

please describe clearly all your machines (operation system)

The machine, where DataStage Server is on
The machine, where Oracle Database is on

On the machine where your DataStage Server is on you have to:

(1) Have at least a Oracle Client on
(2) Have to put manualy several lines concerning Oracle into the file dsenv
and to reboot DataStage
(3) For ODBC and ODBC-access there are addition installations manualy neccessary

DSguru2B · Post by **DSguru2B** » Thu Dec 27, 2007 10:49 am

Did you upgrade the client to 10g as well on your datastage server?

chulett · Post by **chulett** » Thu Dec 27, 2007 10:55 am

rkdatastage wrote:Datastage server and Client are both in same Machine and OS is Windows XP.

One word - unsupported.

rkdatastage · Post by **rkdatastage** » Wed Jan 02, 2008 12:40 am

Hi Guys
Some news from my end
Fortunately i am able to connect to Oracle 10g Database where in i had installed Oracle 10g Client installed on the machine where Datastage server is installed. Thanks for the valuable responses.

I had just restarted my Machine and now i am able to Connect.

If you had any idea on how this has happened kindly Share your Thoughts.

Thanking you all once again for the valuable Support.

Regards
RK

ray.wurlod · Post by **ray.wurlod** » Wed Jan 02, 2008 12:48 am

Possibly an old DLL hanging around in memory.