Oracle configuration in DS for Windows
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 41
- Joined: Tue Jul 08, 2008 5:45 am
- Location: Columbus
Oracle configuration in DS for Windows
Oracle and DS working seperately for me in Windows server edition but couldn't connect Oracle from DataStage. I'm getting TNS couldn't resolved.
Moreover I'm the admin user so no problem in accessibility.
Is there anything i have to do additional setup?
Moreover I'm the admin user so no problem in accessibility.
Is there anything i have to do additional setup?
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 58
- Joined: Tue Nov 17, 2009 3:38 am
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Re: Oracle configuration in DS for Windows
Hence tnsnames.ora must be correct.Sathishkumarins wrote:Oracle and DS working seperately for me in Windows server edition
-
- Participant
- Posts: 58
- Joined: Tue Nov 17, 2009 3:38 am
Re: Oracle configuration in DS for Windows
Ok.Then have you selected the property "Remote Server" under "connection" in your OCI stage ?By default,this property does not appear.And because of this the error "TNS could not resolve" ...appears
please check...
please check...
Nikhil
-
- Premium Member
- Posts: 41
- Joined: Tue Jul 08, 2008 5:45 am
- Location: Columbus
Re: Oracle configuration in DS for Windows
I opened a OCI 8i Stage and searched for Remote server or connections and i couldn't locate any property like tht.....
I have only database name user and password and then column details and finally sql query builder. Could you please tell me exactly where this would be available?
Moreover don't i need to modify any settings in Admin?
I have only database name user and password and then column details and finally sql query builder. Could you please tell me exactly where this would be available?
Moreover don't i need to modify any settings in Admin?
-
- Premium Member
- Posts: 41
- Joined: Tue Jul 08, 2008 5:45 am
- Location: Columbus
Re: Oracle configuration in DS for Windows
Error when i connect using a ODBC stage.
DSR.MetaGeta(GET.DSNINFO)(SQLConnect('ORA_USER','ORA_USER')): BCI Error:
SQLSTATE=08001,CODE=12154,[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle driver][Oracle]ORA-12154: TNS:could not resolve the connect identifier specified
DSR.MetaGeta(GET.DSNINFO)(SQLConnect('ORA_USER','ORA_USER')): BCI Error:
SQLSTATE=08001,CODE=12154,[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle driver][Oracle]ORA-12154: TNS:could not resolve the connect identifier specified
-
- Participant
- Posts: 58
- Joined: Tue Nov 17, 2009 3:38 am
Re: Oracle configuration in DS for Windows
Oh..you are using a server job..i thought it to be parallel job .This option is there in parallel job...Sathishkumarins wrote:I opened a OCI 8i Stage and searched for Remote server or connections and i couldn't locate any property like tht.....
I have only database name user and password and then column details and finally sql query builder. Could you please tell me exactly where this would be available?
Moreover don't i need to modify any settings in Admin?
One more check..
In ther server OCI stage,there is a text box "Database Source Name"
If your tns entry is
testserver.domain.com=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =test@test.com)(PORT = 1521))
(CONNECT_DATA = (SID = WERT))
)
then,the vale of "Database Source Name" should be "testserver.domain.com".
Have you correctly specified this?
I have checked and not seen any setting specific to this in Datastage Administrator...
Last edited by nikhilanshuman on Wed Mar 17, 2010 7:31 pm, edited 1 time in total.
Nikhil
-
- Premium Member
- Posts: 41
- Joined: Tue Jul 08, 2008 5:45 am
- Location: Columbus