Page 1 of 1
Issue in accessing Oracle 10g R2 database
Posted: Thu Dec 27, 2007 12:13 am
by rkdatastage
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
Posted: Thu Dec 27, 2007 2:00 am
by WoMaWil
(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.
Posted: Thu Dec 27, 2007 4:02 am
by ray.wurlod
7.5.1.A or 8x ?
Has the ORAOCI9 stage been properly installed and registered?
Can you access Oracle using ODBC from DataStage?
Posted: Thu Dec 27, 2007 4:47 am
by rkdatastage
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
Posted: Thu Dec 27, 2007 8:20 am
by WoMaWil
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
Posted: Thu Dec 27, 2007 10:49 am
by DSguru2B
Did you upgrade the client to 10g as well on your datastage server?
Posted: Thu Dec 27, 2007 10:55 am
by chulett
rkdatastage wrote:Datastage server and Client are both in same Machine and OS is Windows XP.
One word - unsupported.
Posted: Wed Jan 02, 2008 12:40 am
by rkdatastage
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
Posted: Wed Jan 02, 2008 12:48 am
by ray.wurlod
Possibly an old DLL hanging around in memory.