잡학문구

Download the Credentials Zip File

Once you have created the database, download the credentials zip file for client access to that database. You will use this file in the next step, and in the next tutorial to connect SQL Developer to your Autonomous Transaction Processing database.

1. In the console, in the details page of your new Autonomous Transaction Processing database, select DB Connection.
   

   

   Description of the illustration open_service_console
2. The Database Connection dialog opens for downloading client credentials. For wallet type, select Instance Wallet.
   Note: Oracle recommends you download the database-specific wallet type, Instance Wallet, to provide to your end users and for application use whenever possible. The other wallet type, Regional wallet, should only be used for administrative purposes that require potential access to all Autonomous Databases within a region.
   Click Download Wallet.
   

   

   Description of the illustration database_connection_dialog
3. In the Download Wallet dialog, enter an encryption password for the wallet, confirm the password, and then click Download.
   

   

   Description of the illustration download_wallet
4. Click Save File, and then click OK.
5. Store the zip file and make note of the password. You will use the zip file in the next step to define a SQL Developer connection to your Autonomous Transaction Processing database.

Define a SQL Developer Connection

Define a SQL Developer connection to the database in your Autonomous Transaction Processing service.

1. Open SQL Developer on your local computer. In the Connections panel, right-click Connections and select New Connection.
   Note:
   Depending on your version of SQL Developer, do not right-click Cloud Connection or Database Schema Service Connections. That menu selection is for connecting to a different Oracle cloud service, the Oracle Database Schema Service.
   

   

   Description of the illustration select_new_connection
2. The New/Select Database Connection dialog appears. Enter the following information:
• Connection Name - Enter the name for this cloud connection.
• Username - Enter the database username. Use the default administrator database account (admin) that is provided as part of the service.
• Password - Enter the admin user's password that you or your Autonomous Transaction Processing administrator specified when creating the service instance.
• Connection Type - Select Cloud Wallet.
• Configuration File - Click Browse, and select the Client Credentials zip file, downloaded from the Autonomous Transaction Processing service console by you, or given to you by your Autonomous Transaction Processing administrator.
• Service - In the drop-down menu, service selections are prepended with database names. Select the tpurgent, tp, high, medium, or low menu item for your database. These service levels map to the TPURGENT, TP, HIGH, MEDIUM and LOW consumer groups, which provide different levels of priority for your session.
  Note: Earlier versions of SQL Developer may not support this feature.  

Description of the illustration new_select_database_connection_dialog

1. Click Test.
   Status: Success displays at the left-most bottom of the New/Select Database Connection dialog.
2. Click Connect.
   An entry for the new connection appears under Connections.

Create a User in your Autonomous Transaction Processing Database

Once you have connected SQL Developer to your Autonomous Transaction Processing database, use a SQL Developer worksheet to define a create user statement to create the user atpc_user. In the next tutorial, you will create sales history tables in the atpc_user schema and load data into these tables from an object store.

1. Open a SQL Developer worksheet and run the following SQL statements to create the user atpc_user, swapping in a password with the guidelines provided in the following Note section.
   create user atpc_user identified by "<password>";
   grant dwrole to atpc_user;

2. 

    

   Description of the illustration sql_developer_commands_create_atpc_userNote: Autonomous Transaction Processing requires strong passwords. The password you specify must meet the default password complexity rules. This database checks for the following requirements when you create or modify passwords:
   
   • The password must be between 12 and 30 characters long and must include at least one uppercase letter, one lowercase letter, and one numeric character.
   • The password cannot contain the username.
   • The password cannot be one of the last four passwords used for the same username.
   • The password cannot contain the double quote (") character
   
   Note: Autonomous Transaction Processing databases come with a pre-defined database role named DWROLE.
   This role provides the common privileges for a database user: CREATE ANALYTIC VIEW, CREATE ATTRIBUTE DIMENSION, ALTER SESSION, CREATE HIERARCHY, CREATE JOB, CREATE MINING MODEL, CREATE PROCEDURE, CREATE SEQUENCE, CREATE SESSION, CREATE SYNONYM, CREATE TABLE, CREATE TRIGGER, CREATE TYPE, CREATE VIEW, READ,WRITE ON directory DATA_PUMP_DIR, EXECUTE privilege on the PL/SQL package DBMS_CLOUD  
   
   
3. In the next tutorial, "Connecting SQL Developer to Autonomous Transaction Processing", you will connect SQL Developer to your Autonomous Transaction Processing database as user atpc_user, and define SH tables(sales history tables from an Oracle sample schema) for that user. Later, you will load data into those tables from an Object Store.

Next Tutorial

Connecting SQL Developer to Autonomous Transaction Processing