Issue in accessing Oracle 10g R2 database
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 107
- Joined: Wed Sep 29, 2004 10:15 am
Issue in accessing Oracle 10g R2 database
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 107
- Joined: Wed Sep 29, 2004 10:15 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
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
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
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
Wolfgang Hürter
Amsterdam
Amsterdam
-
- Participant
- Posts: 107
- Joined: Wed Sep 29, 2004 10:15 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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: