[resolved] oracle 11g connection

One Star

[resolved] oracle 11g connection

any one can tell me how to create connection for oracle data base . i am connecting using toracle input, i provide every thing but it asking for additional jdbc perameters. can any one tell me what is this additional jdbc perameters.

Accepted Solutions
Moderator

Re: [resolved] oracle 11g connection

Hi.
Generally speaking, SID is instance name in order to identify DB.
You can get it from DB:
In Windows, select instance_name from V$instance (usually, sid is as same as your DB name).
The DB connection should be OK without Additional parameters.
You'd better make a research about DB parameter on website to get a professional answer.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

All Replies
Moderator

Re: [resolved] oracle 11g connection

Hi,
What oracle DB type are you connect to? OCI, RAC, SID or service name? Could you please upload your Database Connection screenshot into forum?(hidden secret message )
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] oracle 11g connection

i am using oracle with SID . could u please tell me what i need to provide for SID and Additional parameters.
here i am attaching my screen shot for db connection.
Moderator

Re: [resolved] oracle 11g connection

Hi.
Generally speaking, SID is instance name in order to identify DB.
You can get it from DB:
In Windows, select instance_name from V$instance (usually, sid is as same as your DB name).
The DB connection should be OK without Additional parameters.
You'd better make a research about DB parameter on website to get a professional answer.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] oracle 11g connection

thankyou sabrina . its working
Moderator

Re: [resolved] oracle 11g connection

Hi,
Thanks for your response, feel free post your issue and difficulty on forum.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] oracle 11g connection

Hi,
I am trying to connect Oracle 11g database from Talend 3.2 version using tOracleConnection Task.
But when i am trying to fetch table through toracleinput task by using the above connection i am getting connection failure.
Please help asap.
Does this version supports to conenct Oracle11g.
Moderator

Re: [resolved] oracle 11g connection

Hi,
Talend 3.2 version

Talend 3.2 version or Talend 5.3.2? If former, it is a quite old version and you'd better take a try in latest one(Talend 5.4.1) to see if it repro?. Is there any connection error info on console?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.