Autonomous Data Warehouse Cloud
In this we are going to see article creating a new Autonomous Data Warehouse (ADW) service on the Oracle Cloud.
- You have an Oracle Cloud account to build (ADW), if not request a free trial.
Here: https://cloud.oracle.com/tryit - Step by step to create Free Oracle Cloud account here
Creating step by step Oracle Autonomous Data Warehouse Cloud Service
Step1:-Log into Oracle Cloud and click the Create Instance link.
Step2:-Click on the Autonomous Data Warehouse Create menu option.
Step3:-Click on the Autonomous Data Warehouse
Provisioning a Database information
Step4:-Enter the details of DB Name,CPU & Storage information (default sizes are 1 CPU core and 1TB of storage)
Step4:-Enter the details of Credentials of admin user
Step5: Select the appropriate your licensing model and Click the Create Autonomous Data Warehouse button .
Step5: Autonomous Data Warehouse Database creation in progress .
New service created in <30 seconds
Step6: Autonomous Data Warehouse Database Ready for use.
Step7: Autonomous Data Warehouse Database Details.
Connecting to the Database
- Securely connect using credential wallets via SQL*Net,JDBC,ODBC
- Wallet can be downloaded from the service console or using REST APIs
Step8:- Downloading the credential wallet (Click db connection menu option)
Step9:Type credential wallet password and click download
Step10:-Zipfile downloaded in the local machine
Step9:-Connecting to the database using the wallet in SQL Developer
Location of the wallet zip file
admin password
Database Service name
Step10:-We have successfully created your first Autonomous Data Warehouse Database Cloud Service.
Reference:-
Catch Me On:- Hariprasath Rajaram Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/ Facebook:https://www.facebook.com/HariPrasathdba FB Group:https://www.facebook.com/groups/894402327369506/ FB Page: https://www.facebook.com/dbahariprasath/? Twitter: https://twitter.com/hariprasathdba