{"id":2328,"date":"2018-10-04T22:00:40","date_gmt":"2018-10-05T03:00:40","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=2328"},"modified":"2026-02-07T15:26:15","modified_gmt":"2026-02-07T21:26:15","slug":"exploring-autonomous-databases-client-credentials","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2018\/2328\/","title":{"rendered":"Exploring Autonomous Databases – Client Credentials"},"content":{"rendered":"\n

You connect to the autonomous database (ATP or ADW) by downloading the Client Credentials Zip file from the Administration console.\u00a0<\/p>\n\n\n\n

\"\"
Service Console -> Administration -> Download Client Credentials<\/figcaption><\/figure>\n\n\n\n

Using SQL Developer, you can connect to the ATP or ADW database by choosing the “Connection Type” as “Cloud PDB” and provide the downloaded zip file name (wallet) as the configuration file name.\u00a0A wallet contains a collection of files, including the key and other information needed to connect to your database service<\/g> in the Autonomous Cloud. All communications between your computer and the database server are encrypted.<\/p>\n\n\n\n

The downloaded zip file includes the connection information for all the ATP and ADW databases you have created under the cloud account, even though the credential zip file name is “wallet_<DBName>.zip”.\u00a0<\/strong><\/p>\n\n\n\n

\"\"
SQL Developer Screen – Cloud PDB Connection entries from the ATP database credentials zip file<\/figcaption><\/figure><\/div>\n\n\n\n

The picture shows connection details for 4 different autonomous databases, though the wallet file name (database name) is DB201810021812.\u00a0<\/p>\n\n\n\n

When you extract the zip file,<\/g> and review the tnsnames<\/g>.ora file, you can find all connection entries (4 services for each ATP database, 3 services for each ADW database). The ADW connection names are <DBNAME>_high,\u00a0 <DBNAME>_medium, and <DBNAME>_low. The ATP connections are the same, plus\u00a0 <DBNAME>_parallel.<\/p>\n\n\n\n

The predefined service names provide different levels of performance and concurrency for\u00a0Autonomous Databases<\/g>. Read about the different service names here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

The wallet zip file from ATP or ADW includes the connection information for all the ATP and ADW databases you have created under the cloud account, even though the credential zip file name is “wallet_.zip”.<\/p>\n","protected":false},"author":1,"featured_media":2317,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[101,55],"class_list":["post-2328","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cloud-autonomous","tag-autonomous-database","tag-oracle-cloud"],"acf":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/10\/oracle-autonomous-db.png?fit=550%2C318&ssl=1","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2328","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/comments?post=2328"}],"version-history":[{"count":1,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2328\/revisions"}],"predecessor-version":[{"id":2331,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2328\/revisions\/2331"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media\/2317"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=2328"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=2328"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=2328"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}