use the oracle cloud infrastructure console to create an autonomous database instance and create a user you can start from the cloud.oracle.com home page on this page enter the cloud account name that you receive from your welcome email or your cloud administrator click next on the sign in page select the arrow next to oracle cloud infrastructure direct sign in enter your cloud account credentials click sign in select the navigation menu in the top left corner of this page click oracle database and then click autonomous data warehouse this video shows the steps to create an autonomous database
for an autonomous data warehouse workload the same steps apply to creating an autonomous database for an autonomous transaction processing workload the console for autonomous database appears you can use the list scope drop-down menu to select a compartment click create autonomous database in the create autonomous database dialog select a compartment for the database from the drop-down list enter a database display name for display purposes and then enter the database name choose the workload type autonomous data warehouse is automatically selected you can alternatively choose transaction processing json or apex as workload types choose a deployment type the
shared infrastructure deployment type runs the autonomous database without provisioning a dedicated infrastructure otherwise you can choose the dedicated infrastructure deployment type to run the autonomous database on a dedicated exadata infrastructure you can optionally create an always free database always free databases are provided free of charge and are suitable for small scale applications or for learning about and exploring oracle cloud infrastructure choose the database version to use specify the number of cpus for your service select your storage capacity in terabytes if you select the auto scaling option because your workload requires additional cpu and io resources
the database automatically uses the resources without any manual intervention required create an administrator password for the admin user of the service instance by default secure connections are allowed from all ip addresses you can control and restrict access to your autonomous database by setting network access control lists you can also choose to have mutual tls enabled this option is selected by default for license type select whether you are using an included license or bringing your own license you have the option to enter your email to receive operational notifications and announcements click create autonomous database the create
autonomous database dialog closes on the console the state field indicates that the database is provisioning when creation is completed the state field changes from provisioning to available this is the autonomous database details page click database actions this will open a new tab in your browser where you can perform a variety of actions concerning your database click sql to go to the sql worksheet use the sql worksheet to define a database user autonomous databases come with a predefined database role named dw role this role provides the common privileges for a database user for detailed steps on
performing the example shown in this video go to the autonomous database 15-minute quick start live lab learn more at oracle.com autonomous database
