gcloud database-migration connection-profiles create oracle

gcloud database-migration connection-profiles create oracle - create a Database Migration Service connection profile for Oracle

gcloud database-migration connection-profiles create oracle (CONNECTION_PROFILE : --region=REGION) --database-service=DATABASE_SERVICE --host=HOST --port=PORT --username=USERNAME (--password=PASSWORD     | --prompt-for-password) [--no-async] [--ca-certificate=CA_CERTIFICATE] [--display-name=DISPLAY_NAME] [--labels=[KEY=VALUE,…]] [--private-connection=PRIVATE_CONNECTION     | --static-ip-connectivity     | [--forward-ssh-hostname=FORWARD_SSH_HOSTNAME --forward-ssh-username=FORWARD_SSH_USERNAME (--forward-ssh-password=FORWARD_SSH_PASSWORD | --forward-ssh-private-key=FORWARD_SSH_PRIVATE_KEY) : --forward-ssh-port=FORWARD_SSH_PORT; default=22]] [GCLOUD_WIDE_FLAG …]

Connection profile resource - The connection profile to create. The arguments in this group can be used to specify the attributes of this resource. (NOTE) Some attributes are not given arguments in this group but can be set in other ways.

To set the project attribute:

• provide the argument connection_profile on the command line with a fully specified name;
• provide the argument --project on the command line;
• set the property core/project.

This must be specified.

CONNECTION_PROFILE

ID of the connection_profile or fully qualified identifier for the connection_profile.

To set the connection_profile attribute:

• provide the argument connection_profile on the command line.

This positional argument must be specified if any of the other arguments in this group are specified.

--region=REGION

The Cloud region for the connection_profile.

To set the region attribute:

• provide the argument connection_profile on the command line with a fully specified name;
• provide the argument --region on the command line.

--database-service=DATABASE_SERVICE

database service for the oracle connection profile.

--host=HOST

IP or hostname of the database. When --psc-service-attachment is also specified, this field value should be: 1. For Cloud SQL PSC enabled instance - the dns_name field (e.g <uid>.<region>.sql.goog.). 2. For Cloud SQL PSA instance (vpc peering) - the private ip of the instance.

--port=PORT

Network port of the database.

--username=USERNAME

Username that Database Migration Service uses to connect to the database. Database Migration Service encrypts the value when storing it.

Exactly one of these must be specified:

--password=PASSWORD

Password for the user that Database Migration Service uses to connect to the database. Database Migration Service encrypts the value when storing it, and the field is not returned on request.

--prompt-for-password

Prompt for the password used to connect to the database.

--no-async

Waits for the operation in progress to complete before returning.

--ca-certificate=CA_CERTIFICATE

x509 PEM-encoded certificate of the CA that signed the database server's certificate. The value for this flag needs to be the content of the certificate file, not the path to the file. For example, on a Linux machine you can use command substitution: <code>--ca-certificate=$(</path/to/certificate_file.pem)</code>. Database Migration Service will use this certificate to verify it's connecting to the correct host. Database Migration Service encrypts the value when storing it.

--display-name=DISPLAY_NAME

A user-friendly name for the connection profile. The display name can include letters, numbers, spaces, and hyphens, and must start with a letter.

--labels=[KEY=VALUE,…]

List of label KEY=VALUE pairs to add.

Keys must start with a lowercase character and contain only hyphens (-), underscores (_), lowercase characters, and numbers. Values must contain only hyphens (-), underscores (_), lowercase characters, and numbers.

At most one of these can be specified:

Private connection resource - Resource ID of the private connection. This represents a Cloud resource. (NOTE) Some attributes are not given arguments in this group but can be set in other ways.

To set the project attribute:

• provide the argument --private-connection on the command line with a fully specified name;
• provide the argument --project on the command line;
• set the property core/project.

To set the region attribute:

• provide the argument --private-connection on the command line with a fully specified name;
• provide the argument --region on the command line.

--private-connection=PRIVATE_CONNECTION

ID of the private_connection or fully qualified identifier for the private_connection.

To set the private_connection attribute:

• provide the argument --private-connection on the command line.

--static-ip-connectivity

use static ip connectivity

--forward-ssh-hostname=FORWARD_SSH_HOSTNAME

Hostname for the SSH tunnel.

This flag argument must be specified if any of the other arguments in this group are specified.

--forward-ssh-username=FORWARD_SSH_USERNAME

Username for the SSH tunnel.

This flag argument must be specified if any of the other arguments in this group are specified.

--forward-ssh-port=FORWARD_SSH_PORT; default=22

Port for the SSH tunnel, default value is 22.

Exactly one of these must be specified:

--forward-ssh-password=FORWARD_SSH_PASSWORD

SSH password.

--forward-ssh-private-key=FORWARD_SSH_PRIVATE_KEY

SSH private key..

Run $ gcloud help for details.