Trouble connecting to Oracle Exadata service

[rpoyner]

Our upstream data source has moved to an Oracle Exadata server and broken the connection with SmartClient. I've chaged the SmartClient settings in server.properties to reflect the new tnsnames.ora, but I'm still getting:

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor.

One change is that the new tnsnames uses SERVICE_NAME=localdbname instead of SID=localdbname.

Current testing this on:
SmartClient_SNAPSHOT_v101d_2015-06-02_Pro

Guidance on getting SmartClient talking to Oracle Exadata is welcome.

Thanks
Russ Poyner

[Isomorphic]

Hi Russel, what we'd suggest is figuring out the correct settings using JDBC directly or any other tool you like. One you know the settings you can just apply the same ones to SmartClient.

[rpoyner]

We have settings that work in the form of a valid tnsnames.ora file.

What I don't have is a clear sense of how to translate that into SmartClient settings. Particularly the change from using SID to identify the database to SERVICE_NAME. Could you suggest a portion of the documentation that would describe the settings found in server.properties?

[Blama]

Perhaps this helps, perhaps it does not. These are my Oracle XE settings:

sql.Oracle.driver: oracle.jdbc.pool.OracleDataSource
sql.Oracle.driver.serverName: localhost
sql.Oracle.driver.portNumber: 1521
sql.Oracle.driver.databaseName: XE
sql.Oracle.driver.user: *****
sql.Oracle.driver.password: *****

sql.Oracle.driver.driverType: thin
sql.Oracle.driver.networkProtocol: tcp
sql.Oracle.driver.context:

My 11r2 settings are the same.

Best regards
Blama

[rpoyner]

I was able to get this working by switching to "DriverManager" and specifying the jdbc url


sql.INFOACCESS.interface.type: driverManager
sql.INFOACCESS.driver.context:
sql.INFOACCESS.driver: oracle.jdbc.driver.OracleDriver
sql.INFOACCESS.driver.networkProtocol: tcp
sql.INFOACCESS.database.type: oracle
sql.INFOACCESS.driver.serverName: localhost
sql.INFOACCESS.driver.portNumber: 1521
sql.INFOACCESS.driver.driverType: thin
sql.INFOACCESS.driver.url: jdbc:oracle:thin:<username>/<password>@//server.name.edu:1900/service.name.edu
sql.INFOACCESS.interface.credentialsInURL: true
sql.INFOACCESS.autoJoinTransactions: true
sql.INFOACCESS.driver.driverName: oracle