To access the Autonomous Database using CloudShell you need to set the following parameters:
export ADBID=ocid1….. –This is the OCID of the Autonomous database.
export WNAME=wallet.zip —This is the wallet file.
export WPWD=password — This is the password of the wallet.
Then we downloa the wallet to our user’s home:
oci db autonomous-database generate-wallet –autonomous-database-id $ADBID \
–file $WNAME –password $WPWD
export TNS_ADMIN=`pwd`
unzip wallet.zip
edit sqlnet.ora to point to wallet folder
sql -cloudconfig $WNAME admin@adb