OCI - Autonomous connection 19c database using 12c oracle client and database

 

Autonomous connection 19c  database using  12c   oracle client and database 

• Example of connecting  autonomous 19c database using oracle database 12.2 and  also oracle client 12.1 form OS window we can do same step in linux OS as well.
• Web Blog URL guidance : download Instance wallet
• Copy existing sqlnet.ora and tnsnames.ora entry from oracle database  and transfer rest files on network /admin location.

• Add entry below in sqlnet.ora file

sqlnet.ora

WALLET_LOCATION = (SOURCE = (METHOD = file) (METHOD_DATA = (DIRECTORY="?/network/admin")))

SSL_SERVER_DN_MATCH=yes

• Add entry below in  tnsnames.ora file.

• Example: Service name below.

• Connect Autonomous database 19c using existing 12.2  window database.

• Apply same step on oracle client12c

Copy instance wallet zip file on /network/admin location

 

OCI - Sql developer connection using instance wallet 19c

 

OCI Cloud -  Sql developer connection using instance wallet 

Download instance wallet

• Open sql Developer. Here we have installed version 20 above.

• Provide credential and select connection type : cloud wallet 

• Select configure file option below:

• Select connections' options below based on priority work

• Execute query after getting connections

OCi - Instance wallet download

OCI Cloud - E wallet download 

• Web blog for reference : oracle oci connection
•  Login oci  and choose DB connection below:

• Select instance wallet 

• Create new password

• Check the wallet zip  files details below