private void HandleOutput(LaunchDbSystemRequest request)
{
var waiterConfig = new WaiterConfiguration
{
MaxAttempts = MaxWaitAttempts,
GetNextDelayInSeconds = (_) => WaitIntervalSeconds
};
switch (ParameterSetName)
{
case StatusParamSet:
response = client.Waiters.ForLaunchDbSystem(request, waiterConfig, WaitForStatus).Execute();
break;
case Default:
response = client.LaunchDbSystem(request).GetAwaiter().GetResult();
break;
}
WriteOutput(response, response.DbSystem);
}
/// <summary>
/// Launches a new DB system in the specified compartment and availability domain.
/// The Oracle Database edition that you specify applies to all the databases on that DB system. The selected edition cannot be changed.
///
/// An initial database is created on the DB system based on the request parameters you provide and some default options.
/// For more information, see Default Options for the Initial Database.
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public LaunchDbSystemResponse LaunchDbSystem(LaunchDbSystemRequest request)
{
var uri = new Uri($"{GetEndPoint(DatabaseServices.DbSystems, this.Region)}");
using (var webResponse = this.RestClient.Post(uri, request.LaunchDbSystemDetails, new HttpRequestHeaderParam()
{
OpcRetryToken = request.OpcRetryToken
}))
using (var stream = webResponse.GetResponseStream())
using (var reader = new StreamReader(stream))
{
var response = reader.ReadToEnd();
return(new LaunchDbSystemResponse()
{
DbSystem = this.JsonSerializer.Deserialize <DbSystemDetails>(response),
OpcRequestId = webResponse.Headers.Get("opc-request-id"),
ETag = webResponse.Headers.Get("ETag")
});
}
}
protected override void ProcessRecord()
{
base.ProcessRecord();
LaunchDbSystemRequest request;
try
{
request = new LaunchDbSystemRequest
{
LaunchDbSystemDetails = LaunchDbSystemDetails,
OpcRetryToken = OpcRetryToken
};
HandleOutput(request);
FinishProcessing(response);
}
catch (Exception ex)
{
TerminatingErrorDuringExecution(ex);
}
}
static async Task MainDatabase(string[] args)
{
string compartmentId = Environment.GetEnvironmentVariable("OCI_COMPARTMENT_ID");
string adminPassword = Environment.GetEnvironmentVariable("PASSWORD");
logger.Info("Starting example");
// Accepts profile name and creates a auth provider based on config file
var provider = new ConfigFileAuthenticationDetailsProvider(OciConfigProfileName);
var identityClient = new IdentityClient(provider);
var virtualNetworkClient = new VirtualNetworkClient(provider);
var databaseClient = new DatabaseClient(provider);
var networkCidrBlock = "10.0.1.0/24";
Vcn vcn = null;
Subnet subnet = null;
string dbSystemId = null;
AvailabilityDomain availablityDomain = await getAvailabilityDomains(identityClient, compartmentId);
logger.Info($"availability domain is {availablityDomain.Name}");
try
{
vcn = await createVcn(virtualNetworkClient, compartmentId, networkCidrBlock);
subnet = await createSubnet(virtualNetworkClient, compartmentId, availablityDomain, networkCidrBlock, vcn);
logger.Info("Launching Database....");
LaunchDbSystemDetails launchDbSystemDetails = new LaunchDbSystemDetails
{
AvailabilityDomain = availablityDomain.Name,
CompartmentId = compartmentId,
CpuCoreCount = 4,
Shape = "BM.DenseIO2.52",
SshPublicKeys = new List <string> {
"ssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAQEAyyA8wePstPC69PeuHFtOwyTecByonsHFAjHbVnZ+h0dpomvLZxUtbknNj3+c7MPYKqKBOx9gUKV/diR/mIDqsb405MlrI1kmNR9zbFGYAAwIH/Gxt0Lv5ffwaqsz7cECHBbMojQGEz3IH3twEvDfF6cu5p00QfP0MSmEi/eB+W+h30NGdqLJCziLDlp409jAfXbQm/4Yx7apLvEmkaYSrb5f/pfvYv1FEV1tS8/J7DgdHUAWo6gyGUUSZJgsyHcuJT7v9Tf0xwiFWOWL9WsWXa9fCKqTeYnYJhHlqfinZRnT/+jkz0OZ7YmXo6j4Hyms3RCOqenIX1W6gnIn+eQIkw== This is the key's comment"
},
SubnetId = subnet.Id,
DatabaseEdition = LaunchDbSystemDetails.DatabaseEditionEnum.EnterpriseEdition,
DisplayName = "OCI DotNet SDK database",
Hostname = "oci-dotnetsdk-host",
Domain = "testdomain",
DbHome = new CreateDbHomeDetails
{
DbVersion = "12.1.0.2",
DisplayName = "Example DB Home",
Database = new CreateDatabaseDetails
{
DbName = "dotnetdb",
AdminPassword = adminPassword
}
}
};
LaunchDbSystemRequest launchDbSystemRequest = new LaunchDbSystemRequest
{
LaunchDbSystemDetails = launchDbSystemDetails
};
LaunchDbSystemResponse launchDbSystemResponse = await databaseClient.LaunchDbSystem(launchDbSystemRequest);
logger.Info($"Database ID: {launchDbSystemResponse.DbSystem.Id} and Database display name: {launchDbSystemResponse.DbSystem.DisplayName}");
logger.Info("Waiting for Database to come to available state....");
GetDbSystemRequest getDbSystemRequest = new GetDbSystemRequest
{
DbSystemId = launchDbSystemResponse.DbSystem.Id
};
WaiterConfiguration waiterConfiguration = new WaiterConfiguration
{
MaxAttempts = 20,
GetNextDelayInSeconds = DelayStrategy.GetExponentialDelayInSeconds
};
GetDbSystemResponse getDbSystemResponse = databaseClient.Waiters.ForDbSystem(
getDbSystemRequest, waiterConfiguration, DbSystem.LifecycleStateEnum.Available).Execute();
logger.Info("Database is available");
logger.Info($"Database ID: {getDbSystemResponse.DbSystem.Id} and Database display name: {getDbSystemResponse.DbSystem.DisplayName}");
dbSystemId = getDbSystemResponse.DbSystem.Id;
}
catch (Exception e)
{
logger.Error($"failed to launch DbSystem: {e}");
}
finally
{
if (dbSystemId != null)
{
await terminateDbSystem(databaseClient, dbSystemId);
}
if (subnet != null)
{
await deleteSubnet(virtualNetworkClient, subnet);
}
if (vcn != null)
{
await deleteVcn(virtualNetworkClient, vcn);
}
identityClient.Dispose();
virtualNetworkClient.Dispose();
databaseClient.Dispose();
logger.Info("End example");
}
}
