Hi All,
I had an issue in connecting a database.
The ODI Application is unable to connect an oracle DB getting an error message as" login Timeout issue".So firewall is checked.
I tried the credentials using Sql developer ,getting an error message as" Size Data Mismatch unit" and "Connection closed".
We able to connect to the DB after multiple attempts but the connection is getting closed immediately.
I tried the same credentials in someone's sql developer,I am able to connect to the database.
Can you please help me whether the issue is in ODI or Sql developer of mine or Profile corrupted in Database.
Kindly let me know how to resolve this issue.
your help is really appreciated.
ODI Installed Server: Unix,jdk 1.6
Database Server: Linux
jdbc:oracle:thin@<HOST>:<PORT>:<DATABASE_NAME>