Cannot create a connection to the database - to Oracle DB- xMII 12.0

[Former Member]

I am attempting to connect to an Oracle 10.2.0.2 database to do an SQL Query.

I have added the JDBC adapter ojdbc14.jar and deployed it successfully.

I data services I have create a new IDBC Connector Type and I changed the following settings.

Username:

Password:

JDBCDriver: oracle.jdbc.driver.OracleDriver

ServerURL: jdbc:oracle:thin:@hostname:1521:dvlcyt

where the hostname is the name of the server and dvlcyt is the database name.

I check the status and it claims it is running. It also says tere are 0 available connections.

When I goto Workbench and select the data source to be my new oracle connection and select SQL query I get the error message "cannot create a connection to the database"

Can anyone help.

Thanks

Skip Ford

[Former Member · Accepted solution]

A couple of things to check:

1. Netweaver logs for any specific errors

2.Verifying if port 1521 is open for TCP/IP requests

[Former Member · Accepted solution]

How do I find the netweaver logs?

[Former Member · Accepted solution]

http://<server>:port/nwa would take you to the Netweaver Administration page

From there you need to navigate to Monitoring-->Logs and Traces.

I think you can even have a custom view of the logs where in you can filter the logs based on the application (xmii in our case).

You need to have atleast the read - only Netweaver Admin rights to access these pages.

[agentry_src]

Is the database name the same as the SID? I have run into this problem in 11.5, but have not set up an Oracle connector yet in 12.0. Find the SID and try that instead of the database name.

Hope this helps,

Mike