cancel
Showing results for 
Search instead for 
Did you mean: 

Error database connection in JDBC Adapter

Former Member
0 Kudos

Hi Experts,

I am facing errror database connection problem in production system.

My interface was working fine in production till yesterday but suddenly from today i am facing the error connection problem.

Below is the error message i am getting.

Error during database connection to the database URL 'jdbc:oracle:thin:@<ip>:<port>:"' using the JDBC driver 'oracle.jdbc.driver.OracleDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:oracle:thin:@'jdbc:oracle:thin:@<ip>:<port>:": SQLException: Io exception: The Network Adapter could not establish the connection'

Please advice what would be the problem.

I have checked the IP by pinging, its working fine.

Thanks,

Swetha Reddy

Accepted Solutions (1)

Accepted Solutions (1)

abhay_rajhans2
Contributor
0 Kudos

Hi Swetha,

Ask the database team to confirm on the port number. Check if port number has been changed or whether the particular port is not open with the firewall. The database team can check this with the network team.

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

I think problem in IP Address or Port in conneection parameters.Please check with error the basis team.They will know the exact error.Beacuse basis people will do the monitoring of database.

Thanks

Ravi

Former Member
0 Kudos

Hi All,

Thanks for your suggestions..

I have checked with oracle team and they confirmed that IP address has been changed.

I have given new IP address and its working fine.

Thanks

Swetha Reddy

Former Member
0 Kudos

Try after de-activating & then activating the channel. Also check with BASIS if they have not applied any patched recently.

For safer side also check if firewall settings have not been changed from either side.

Former Member
0 Kudos

Hi Sarvesh,

I have tried with deactivaing and activating channel.. but facing same problem..

Nio firewall settings has been changed either side..

Regarding patch i am not sure what patch should be applied..

i can tell that BASIS has not applied ant patch..

Thanks,

Swetha Reddy

rajasekhar_reddy14
Active Contributor
0 Kudos

Hi Swetha,

Can you create one dummy communication channel with same detilas and test the connection,if it is working fine means then your CC got locked or deactivated.

if it is not working new one too means then some problem with the port details i guess.

Regards,

rAJ