You are not logged in.
Announcement
Unanswered posts
|
- Index
- » Usage, Operation
- » [resolved] Problem connecting to an ORACLE db
Post a reply
Topic review (newest first)
- gk.kalipurayath
- 2013-03-13 16:24:13
What is the behavior if a database node is taken out of service or added back to the cluster? Will Talend reconnect to database gracefully? I am using the tJDBC_row and tOracleInput components in my jobs
- wintersun1981
- 2012-04-12 12:36:59
Hi, Pavan:
Understand. I've switched to use tOracleOutput component. Thanks!
- tpk
- 2012-04-11 15:20:01
Hi,
Can you tell me for what purpose you are doing this job, if it is for moving data from oracle table to oracle table you can directly use tOracleInput and tOracleOutput. You can define the schema of your oracle DB connection under Meta Data -> DB Connections and you can define the schema of the tables of your DB and use the tables 'n' number of times in your job with out each time creating a connection using tOracleConnection
Thanks and Regards,
Pavan
- wintersun1981
- 2012-04-11 14:37:03
After several trying, I found if first I use ORACLE SERVICE_NAME connection, then switch to RAC connection, then db_schema can be set. So this connection problem is resolved.
But another question is how to build connections between tOracleConnection, tOracleInput and tOracleClose components. If I connect tOracleConnection and tOracleInput, then system always report an error.
Does anyone have some experiences?
- wintersun1981
- 2012-04-11 12:39:42
Hi, all:
I want to build an ORACLE connection with tOracleConnection. I got below tns description from our DBA:
QUANT_TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = host1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = host2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tora10g2)
)
)
I tried ORACLE Service_name connection type, but can't set "SERVER = DEDICATED" parameter.
I tried RAC connection type, but no way to set db_schema parameter.
Can anyone tell me what's the correct connection type and how to configure?
thanks!