Error connecting to Data base.

[Former Member]

Hi,

I am working on HTTP-JDBC scenario. Iam getting an error while connecting to Database.

Iam using Oracle DB.

I tried using the Url "oracle.jdbc.OracleDriver" and "oracle.jdbc.driver.OracleDriver" but the result is same.

The error in the JDBC adapter is as follows:-

Error during database connection to the database URL 'jdbc:oracle:thin:@<IPADDRESS>:MCQ' using the JDBC driver 'oracle.jdbc.OracleDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:oracle:thin:@<IPADDRESS>:MCQ': SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093376)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))'

Could some one help me on this?

Regards

Praveen

[bhavesh_kantilal]

:MCQ --> Is this the port?

Normally the Url is,

jdbc:oracle:thin:@<IPADDRESS>:port:DBNAme.

What is the Url provided in the JDBC adapter.

Regards

Bhavesh

[Former Member]

The URL I used is: jdbc:oracle:thin:@<IP Address>:1521:MCQ

Driver :oracle.jdbc.OracleDriver

MCQ is DBname.

Regards

Praveen

[prabhu_s2]

check with the adminstartors if u had given access and check if the port 1521 is open...

[bhavesh_kantilal]

Like pointed looks like a firewall / authorization issue. Check if ports are open and then check if the user id and password has the required authorizations on the database.

Regards

Bhavesh

[prabhu_s2]

check if the port is open that is specified in the connection string

[Former Member]

HI,

Check the DB is ruuning or not and Listner is running or not ,

or

increase the number of retries" in the JDBC adapter configuration.

See the below links

/thread/208634 [original link is broken]

Regards

Chilla