Login to oracle cloud and provide your account name


Enter your sign in info

You will be taken to home page

From the navigation menu click on autonomous transaction processing

Click on create autonomous database

Enter the required details as mentioned below

Choose workload type and deployment type

 Enter the admin password and make a note of it as it will be required while connecting to this database from sql developer.

Select the option and click create autonomous database

Your database is getting provisioned

It will be available in few seconds. Once available click on DB connection tab

Click on Download Wallet

Provide the admin password

Now open SQL developer and click on + sign to add connection

Enter the connection details as mentioned below with admin user password noted above and test connection. It should be success

Click on connect

Click ok

You are now logged into DIGATP database created on OCI

Let’s create a table in ADMIN schema

Table TEST is now created in ADMIN schema

To connect via putty

Make a directory on your server to store the wallet files downlaoded above. you must have client or ORACLE_HOME of (or higher) version on this server. I am using an old server where i have 12c oracle home already installed.

copy the wallet file in this folder and unzip

[oracle@oel6-node01 wallet]$ mkdir DIGATP
[oracle@oel6-node01 DIGATP]$ pwd
[oracle@oel6-node01 DIGATP]$ ls
[oracle@oel6-node01 DIGATP]$ unzip Wallet_DIGATP.zip
Archive:  Wallet_DIGATP.zip
  inflating: README
  inflating: cwallet.sso
  inflating: tnsnames.ora
  inflating: truststore.jks
  inflating: ojdbc.properties
  inflating: sqlnet.ora
  inflating: ewallet.p12
  inflating: keystore.jks
[oracle@oel6-node01 DIGATP]$ ls
cwallet.sso  ewallet.p12  keystore.jks  ojdbc.properties  README  sqlnet.ora  tnsnames.ora  truststore.jks  Wallet_DIGATP.zip

modify the sqlnet.ora file which is present in this wallet folder. It should now contain the location of the wallet folder like this

[oracle@oel6-node01 DIGATP]$ pwd

[oracle@oel6-node01 DIGATP]$ cat sqlnet.ora

Don’t touch the tnsnames.ora file. This is like this currently. just note the connect identifier you want to use to connect to the cloud database. I will be using digatp_high

[oracle@oel6-node01 DIGATP]$ cat tnsnames.ora
digatp_high = (description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.ap-mumbai-1.oraclecloud.com))(connect_data=(service_name=mrulhtwbetkkcsn_digatp_high.atp.oraclecloud.com))(security=(ssl_server_cert_dn="CN=adb.ap-mumbai-1.oraclecloud.com,OU=Oracle ADB INDIA,O=Oracle Corporation,L=Redwood City,ST=California,C=US")))

digatp_low = (description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.ap-mumbai-1.oraclecloud.com))(connect_data=(service_name=mrulhtwbetkkcsn_digatp_low.atp.oraclecloud.com))(security=(ssl_server_cert_dn="CN=adb.ap-mumbai-1.oraclecloud.com,OU=Oracle ADB INDIA,O=Oracle Corporation,L=Redwood City,ST=California,C=US")))

digatp_medium = (description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.ap-mumbai-1.oraclecloud.com))(connect_data=(service_name=mrulhtwbetkkcsn_digatp_medium.atp.oraclecloud.com))(security=(ssl_server_cert_dn="CN=adb.ap-mumbai-1.oraclecloud.com,OU=Oracle ADB INDIA,O=Oracle Corporation,L=Redwood City,ST=California,C=US")))

digatp_tp = (description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.ap-mumbai-1.oraclecloud.com))(connect_data=(service_name=mrulhtwbetkkcsn_digatp_tp.atp.oraclecloud.com))(security=(ssl_server_cert_dn="CN=adb.ap-mumbai-1.oraclecloud.com,OU=Oracle ADB INDIA,O=Oracle Corporation,L=Redwood City,ST=California,C=US")))

digatp_tpurgent = (description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.ap-mumbai-1.oraclecloud.com))(connect_data=(service_name=mrulhtwbetkkcsn_digatp_tpurgent.atp.oraclecloud.com))(security=(ssl_server_cert_dn="CN=adb.ap-mumbai-1.oraclecloud.com,OU=Oracle ADB INDIA,O=Oracle Corporation,L=Redwood City,ST=California,C=US")))

now set the TNS_ADMIN variable

[oracle@oel6-node01 DIGATP]$ export TNS_ADMIN=/home/oracle/wallet/DIGATP
[oracle@oel6-node01 DIGATP]$ env|grep TNS

TNS_ADMIN environment variable is needed to change the directory path of Oracle Net Services configuration files from the default location of $ORACLE_HOME/network/admin to the location of the secure folder containing the credentials file you saved i.e. /home/oracle/wallet/DIGATP

verify before you try to connect

[oracle@oel6-node01 DIGATP]$ which sqlplus
[oracle@oel6-node01 DIGATP]$ which tnsping

[oracle@oel6-node01 DIGATP]$ tnsping digatp_high

TNS Ping Utility for Linux: Version - Production on 26-MAY-2020 16:26:21

Copyright (c) 1997, 2014, Oracle.  All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.ap-mumbai-1.oraclecloud.com))(connect_data=(service_name=mrulhtwbetkkcsn_digatp_high.atp.oraclecloud.com))(security=(ssl_server_cert_dn=CN=adb.ap-mumbai-1.oraclecloud.com,OU=Oracle ADB INDIA,O=Oracle Corporation,L=Redwood City,ST=California,C=US)))
OK (900 msec)

now try to connect using the admin credentials you created above

[oracle@oel6-node01 DIGATP]$ sqlplus admin/*******@digatp_high

SQL*Plus: Release Production on Tue May 26 16:26:43 2020

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Last Successful login time: Tue May 26 2020 16:23:11 +05:30

Connected to:
Oracle Database 19c Enterprise Edition Release - Production

SQL> select name,open_mode from v$database;

--------- --------------------

we can see the table we created above is visible here.

SQL> sho user

SQL> select * from tab;

------------- ----------

SQL> select * from test;