Setup external oracle DB with cwallet

Hi,

 

I am trying to migrate my internal database to oracle autonomous database, and the only connection details I can get is through cwallet files. I have checked out this post, and use the hostname instance combo indicated in this post -> https://teamcity-support.jetbrains.com/hc/en-us/community/posts/206258189-Problem-Migrating-to-Oracle-DB-using-MaintainDB-Utility?input_string=Setup%20external%20oracle%20DB%20with%20cwallet

 

The tnsnames setup I can find is as follows

(description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.us-phoenix-1.oraclecloud.com))(connect_data=(service_name=rhhea6hkgj2saju_teamcitytestdb_medium.atp.oraclecloud.com))(security=(ssl_server_cert_dn="CN=adwc.uscom-east-1.oraclecloud.com,OU=Oracle BMCS US,O=Oracle Corporation,L=Redwood City,ST=California,C=US")))

 

As my teamcity db properties is as follows

driverName=oracle.jdbc.driver.OracleDriver
connectionUrl=jdbc:oracle:thin:@adb.us-phoenix-1.oraclecloud.com:1522:rhhea6hkgj2saju_teamcitytestdb_medium.atp.oraclecloud.com
connectionProperties.user=<username>
connectionProperties.password=<password>

 

And I kept getting the following error while I tried to run the migration:

Using target database
database type: ORACLE
connection string: jdbc:oracle:thin:@adb.us-phoenix-1.oraclecloud.com:1522:rhhea6hkgj2saju_teamcitytestdb_medium.atp.oraclecloud.com
Cannot proceed with 'migrate' command: Could not connect to the target database: Could not connect to Oracle server.
IO Error: Got minus one from a read call: java.sql.SQLRecoverableException: IO Error: Got minus one from a read call. Caused by: oracle.net.ns.NetException: Got minus one from a read call

0

Please sign in to leave a comment.