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 12.1.0.2 (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
/home/oracle/wallet/DIGATP
[oracle@oel6-node01 DIGATP]$ ls
Wallet_DIGATP.zip
[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
/home/oracle/wallet/DIGATP
[oracle@oel6-node01 DIGATP]$ cat sqlnet.ora
WALLET_LOCATION = (SOURCE = (METHOD = file) (METHOD_DATA = (DIRECTORY="/home/oracle/wallet/DIGATP")))
SSL_SERVER_DN_MATCH=yes
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=/home/oracle/wallet/DIGATP
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/adminto 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
/u01/app/oracle/product/12.1.0.2/db_1/bin/sqlplus
[oracle@oel6-node01 DIGATP]$ which tnsping
/u01/app/oracle/product/12.1.0.2/db_1/bin/tnsping
[oracle@oel6-node01 DIGATP]$ tnsping digatp_high
TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 26-MAY-2020 16:26:21
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
/home/oracle/wallet/DIGATP/sqlnet.ora
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 12.1.0.2.0 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 19.0.0.0.0 - Production
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
FEVQ1POD READ WRITE
we can see the table we created above is visible here.
SQL> sho user
USER is "ADMIN"
SQL> select * from tab;
TNAME
--------------------------------------------------------------------------------
TABTYPE CLUSTERID
------------- ----------
TEST
TABLE
SQL> select * from test;
ID
----------
1
2
DBATracker 