- What's New
- Service Overview
- Getting Started
-
User Guide
- Database Evaluation
- Object Migration
- SQL Statement Conversion
- Conversion Configuration
- SQL Audit
- Data Source Management
- Permissions Management
- Interconnection with CTS
- Best Practices
- Security White Paper
-
API Reference
- Before You Start
- API Types
- Calling APIs
-
API
- API Version Management
- Quota Management
- SQL Statement Conversion
- Evaluation Project
-
Migration Project
- Creating a Migration Project
- Querying Migration Projects
- Querying the Status of a Migration Project
- Checking Target Database Permissions
- Querying Permission Check Results
- Querying Migration Project Details
- Submitting Syntax Conversion of Objects
- Querying Syntax Conversion Progress of Objects
- Submitting Verification
- Querying the Verification Progress
- Downloading a Migration Error Report
- Deleting a Migration Project
- Permissions Policies and Supported Actions
- Appendixes
- SDK Reference
-
FAQs
-
Product Consulting
- Instance Freezing, Release, and Deletion
- Which Schemas in Source Databases Are Ignored for Migration?
- What Are the Differences Between Syntax Conversion and Migration & Verification in a Migration Project?
- What Are the Database Schema Changes After an Oracle Database Is Migrated to the Target Database?
- Why Cannot I Use Some Functions?
- What Is the Function of the dsc_ora_ext Schema Generated After Migration to the Target Database?
- What Should I Do If Data Collection Fails or Is Slow Due to the Small Values of Certain Oracle SGA Parameters?
- What Should I Do If Data Collection Fails and a Message SNAPSHOT TOO OLD Is Displayed?
- What Is the Mapping Between the GaussDB Versions Displayed on the UGO Console and Self-built GaussDB Versions?
- What Are VPCEP Resource Quotas?
-
Database Connections
- What Should I Do If I Cannot Connect to the Source Oracle Database During Database Evaluation Project Creation?
- What Should I Do If I Failed To Connect to the Source Database as User sys?
- How Do I Create GaussDB Databases Compatible with Source Databases?
- What Should I Do If My Database Fails to be Connected?
- SQL Server Connection Test Failed (Error Code=0, SQLState=08S01)
-
Evaluation Project
- How Do I Select a Connection Method?
- How Does UGO Collect Data from Source Databases?
- How Does UGO Check Database Permissions?
- What Are the Possible Causes for an Object Collection Failure?
- In GaussDB, How Do I Configure a Search Path If A Statement Without Schema Name Fails To Be Executed?
- What Is Native Compatibility, Conversion Compatibility, Partial Compatibility, or Incompatibility?
- What Is the Relationship Between Migration Risk (Top 10 risk SQL) and Risky SQL Summary?
- What Are Reconstruction Statistics and How Are Reconstruction Points Measured?
- What Should I Do If An Object Collection Error (Closed Connection) Is Displayed During Evaluation Project Creation?
- What Should I Do If "ErrorCode=4036" Is Displayed During Evaluation Project Creation?
- What Should I Do If "ErrorCode=17002" Is Displayed During Evaluation Project Creation?
- What Do I Do If the Assessment Task Is Connected but the Pre-check Fails?
- What Is the Impact of the Collection on the Source Database?
-
Migration Project
- Why Is There No Available Evaluation Project During Migration Project Creation?
- When Should I Use the Conversion Config Function?
- What Should I Do If SQL Modifications Failed to Be Saved During Object Correction?
- How Do I Solve ERROR: syntax error at or near "@"?
- What Are the Possible Causes for an Object Verification Failure?
- What Are the Impacts of GUC Parameter Settings of GaussDB on Migration?
- How Do I Set GaussDB GUC Parameters?
- Why Is the Number of Indexes Different After Oracle Data is Migrated to GaussDB?
- What Should I Do If There Are ctid, xc_node_id, and tableoid Columns in GaussDB?
- Why Is Data Inconsistent When SELECT Statements Without ORDER BY Are Used for Query in Distributed GaussDB?
-
Product Consulting
- Videos
- General Reference
Copied.
Creating a GaussDB Instance
- If a VPC and a security group are available, skip Creating a VPC and Creating a Security Group.
- For details about how to create a GaussDB instance, see Buying a GaussDB Instance.
Creating a VPC
- Log in to the console.
- Click
in the upper left corner of the console and select the region AP-Singapore.
- Under the service list, choose Networking > Virtual Private Cloud.
The VPC console is displayed.
- Click Create VPC.
- Configure parameters as needed and click Create Now.
- Return to the VPC list and check whether the VPC is created.
If the VPC status becomes available, the VPC has been created.
Creating a Security Group
- Log in to the console.
- Click
in the upper left corner of the console and select the region AP-Singapore.
- Under the service list, choose Networking > Virtual Private Cloud.
The VPC console is displayed.
- In the navigation pane, choose Access Control > Security Groups.
- Click Create Security Group.
- Configure parameters as needed.
- Click OK.
- Return to the security group list and click the security group name.
- Click the Inbound Rules tab, and then click Add Rule.
- Configure an inbound rule, add the IP address of the source database, and click OK.
Creating a GaussDB Instance
- Log in to the console.
- Click
in the upper left corner of the console and select the region AP-Singapore.
- Under the service list, choose Databases > GaussDB.
- In the navigation pane on the left, click Instances.
- Click Buy DB Instance.
- Configure the instance name and basic information.
- Configure instance specifications.
Select small specifications for the test. You are advised to configure specifications based on service requirements in actual use.
- Select a VPC and security group for the instance and configure the database port.
- Configure password and other information.
- Click Next.
- Go to the instance list.
If the instance status becomes available, the instance has been created.
Creating a database in the GaussDB Instance
- Log in to the console.
- Click
in the upper left corner of the console and select the region AP-Singapore.
- Under the service list, choose Databases > Data Admin Service.
- In the navigation pane on the left, click Development Tool to go to the login list page.
- Click Add Login.
- On the displayed page, select the DB engine, source database, and target DB instance, enter the login username, password, and description (optional), and enable Collect Metadata Periodically and Show Executed SQL Statements.
- Click Test Connection.
If a message is displayed indicating connection successful, continue with the operation. If a message is displayed indicating a connection failed and the failure cause is provided, make modifications based on the error message.
- Click OK.
- Locate the added instance, click Log In in the Operation column.
- Choose SQL Operation > SQL Window on the top menu bar.
- Run the following statement to create a database compatible with Oracle:
ugo indicates the database name. Replace it based on the site requirements.
CREATE DATABASE ugo DBCOMPATIBILITY 'ORA';
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot