OCI - Create object storage buckets

 

Create object storage buckets  in OCI  console 

Welcome to Oracle Cloud Shell.

Your Cloud Shell machine comes with 5GB of storage for your home directory. Your Cloud Shell (machine and home directory) .

Type `help` for more info.

varunyadav@cloudshell:~ (ap-mumbai-1)$ oci os ns get

{

  "data": "bmdsoh48o0kf"

}

varunyadav@cloudshell:~ (ap-mumbai-1)$

• Login OCI Console and select storage >>> Buckets

• Select Create Bucket option.  20GB is the limit on free edition

• Create Bucket  and fill details below.

• Bucket option delete as well below screenshots

• Upload file fill details below.

• File details 

• We try to create bucket using CLI commands but do not have permission on free edition.

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