OraOCI9 stage : accessing Oracle
Posted: Tue Dec 23, 2003 2:15 am
Hi Kenneth,
Before posting a topic on Oraoci9, I searched the topic for OraOci9 connectivity. I found the following topic
viewtopic.php?t=85123&highlight=oraoci9
In which, you have mentioned that we have to settings in dsenv file, what kind of settings do we need to do to access Oracle 9 from this stage.
I have the desired tnsentry in my tnsnames.ora file, that is, I can connect to Oracle by logging on the unix server (where my datastage resides). But can not access Oracle from OCI stage. getting an error ORA-12154.
Please guide.
Thanks
Girish Oak
Before posting a topic on Oraoci9, I searched the topic for OraOci9 connectivity. I found the following topic
viewtopic.php?t=85123&highlight=oraoci9
In which, you have mentioned that we have to settings in dsenv file, what kind of settings do we need to do to access Oracle 9 from this stage.
I have the desired tnsentry in my tnsnames.ora file, that is, I can connect to Oracle by logging on the unix server (where my datastage resides). But can not access Oracle from OCI stage. getting an error ORA-12154.
Please guide.
Thanks
Girish Oak