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
Please sign in to leave a comment.