1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. ManagedDatabasesResetDatabaseParameter
Oracle Cloud Infrastructure v2.3.0 published on Wednesday, Jul 17, 2024 by Pulumi

oci.DatabaseManagement.ManagedDatabasesResetDatabaseParameter

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v2.3.0 published on Wednesday, Jul 17, 2024 by Pulumi

    This resource provides the Managed Databases Reset Database Parameter resource in Oracle Cloud Infrastructure Database Management service.

    Resets database parameter values to their default or startup values.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
    import * as oci from "@pulumi/oci";
    
    const testManagedDatabasesResetDatabaseParameter = new oci.databasemanagement.ManagedDatabasesResetDatabaseParameter("test_managed_databases_reset_database_parameter", {
        managedDatabaseId: testManagedDatabase.id,
        parameters: managedDatabasesResetDatabaseParameterParameters,
        scope: managedDatabasesResetDatabaseParameterScope,
        credentials: {
            password: managedDatabasesResetDatabaseParameterCredentialsPassword,
            role: managedDatabasesResetDatabaseParameterCredentialsRole,
            secretId: testSecret.id,
            userName: testUser.name,
        },
        databaseCredential: {
            credentialType: managedDatabasesResetDatabaseParameterDatabaseCredentialCredentialType,
            namedCredentialId: testNamedCredential.id,
            password: managedDatabasesResetDatabaseParameterDatabaseCredentialPassword,
            passwordSecretId: testSecret.id,
            role: managedDatabasesResetDatabaseParameterDatabaseCredentialRole,
            username: managedDatabasesResetDatabaseParameterDatabaseCredentialUsername,
        },
    });
    
    import pulumi
    import pulumi_oci as oci
    
    test_managed_databases_reset_database_parameter = oci.database_management.ManagedDatabasesResetDatabaseParameter("test_managed_databases_reset_database_parameter",
        managed_database_id=test_managed_database["id"],
        parameters=managed_databases_reset_database_parameter_parameters,
        scope=managed_databases_reset_database_parameter_scope,
        credentials=oci.database_management.ManagedDatabasesResetDatabaseParameterCredentialsArgs(
            password=managed_databases_reset_database_parameter_credentials_password,
            role=managed_databases_reset_database_parameter_credentials_role,
            secret_id=test_secret["id"],
            user_name=test_user["name"],
        ),
        database_credential=oci.database_management.ManagedDatabasesResetDatabaseParameterDatabaseCredentialArgs(
            credential_type=managed_databases_reset_database_parameter_database_credential_credential_type,
            named_credential_id=test_named_credential["id"],
            password=managed_databases_reset_database_parameter_database_credential_password,
            password_secret_id=test_secret["id"],
            role=managed_databases_reset_database_parameter_database_credential_role,
            username=managed_databases_reset_database_parameter_database_credential_username,
        ))
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-oci/sdk/v2/go/oci/DatabaseManagement"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := DatabaseManagement.NewManagedDatabasesResetDatabaseParameter(ctx, "test_managed_databases_reset_database_parameter", &DatabaseManagement.ManagedDatabasesResetDatabaseParameterArgs{
    			ManagedDatabaseId: pulumi.Any(testManagedDatabase.Id),
    			Parameters:        pulumi.Any(managedDatabasesResetDatabaseParameterParameters),
    			Scope:             pulumi.Any(managedDatabasesResetDatabaseParameterScope),
    			Credentials: &databasemanagement.ManagedDatabasesResetDatabaseParameterCredentialsArgs{
    				Password: pulumi.Any(managedDatabasesResetDatabaseParameterCredentialsPassword),
    				Role:     pulumi.Any(managedDatabasesResetDatabaseParameterCredentialsRole),
    				SecretId: pulumi.Any(testSecret.Id),
    				UserName: pulumi.Any(testUser.Name),
    			},
    			DatabaseCredential: &databasemanagement.ManagedDatabasesResetDatabaseParameterDatabaseCredentialArgs{
    				CredentialType:    pulumi.Any(managedDatabasesResetDatabaseParameterDatabaseCredentialCredentialType),
    				NamedCredentialId: pulumi.Any(testNamedCredential.Id),
    				Password:          pulumi.Any(managedDatabasesResetDatabaseParameterDatabaseCredentialPassword),
    				PasswordSecretId:  pulumi.Any(testSecret.Id),
    				Role:              pulumi.Any(managedDatabasesResetDatabaseParameterDatabaseCredentialRole),
    				Username:          pulumi.Any(managedDatabasesResetDatabaseParameterDatabaseCredentialUsername),
    			},
    		})
    		if err != nil {
    			return err
    		}
    		return nil
    	})
    }
    
    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using Oci = Pulumi.Oci;
    
    return await Deployment.RunAsync(() => 
    {
        var testManagedDatabasesResetDatabaseParameter = new Oci.DatabaseManagement.ManagedDatabasesResetDatabaseParameter("test_managed_databases_reset_database_parameter", new()
        {
            ManagedDatabaseId = testManagedDatabase.Id,
            Parameters = managedDatabasesResetDatabaseParameterParameters,
            Scope = managedDatabasesResetDatabaseParameterScope,
            Credentials = new Oci.DatabaseManagement.Inputs.ManagedDatabasesResetDatabaseParameterCredentialsArgs
            {
                Password = managedDatabasesResetDatabaseParameterCredentialsPassword,
                Role = managedDatabasesResetDatabaseParameterCredentialsRole,
                SecretId = testSecret.Id,
                UserName = testUser.Name,
            },
            DatabaseCredential = new Oci.DatabaseManagement.Inputs.ManagedDatabasesResetDatabaseParameterDatabaseCredentialArgs
            {
                CredentialType = managedDatabasesResetDatabaseParameterDatabaseCredentialCredentialType,
                NamedCredentialId = testNamedCredential.Id,
                Password = managedDatabasesResetDatabaseParameterDatabaseCredentialPassword,
                PasswordSecretId = testSecret.Id,
                Role = managedDatabasesResetDatabaseParameterDatabaseCredentialRole,
                Username = managedDatabasesResetDatabaseParameterDatabaseCredentialUsername,
            },
        });
    
    });
    
    package generated_program;
    
    import com.pulumi.Context;
    import com.pulumi.Pulumi;
    import com.pulumi.core.Output;
    import com.pulumi.oci.DatabaseManagement.ManagedDatabasesResetDatabaseParameter;
    import com.pulumi.oci.DatabaseManagement.ManagedDatabasesResetDatabaseParameterArgs;
    import com.pulumi.oci.DatabaseManagement.inputs.ManagedDatabasesResetDatabaseParameterCredentialsArgs;
    import com.pulumi.oci.DatabaseManagement.inputs.ManagedDatabasesResetDatabaseParameterDatabaseCredentialArgs;
    import java.util.List;
    import java.util.ArrayList;
    import java.util.Map;
    import java.io.File;
    import java.nio.file.Files;
    import java.nio.file.Paths;
    
    public class App {
        public static void main(String[] args) {
            Pulumi.run(App::stack);
        }
    
        public static void stack(Context ctx) {
            var testManagedDatabasesResetDatabaseParameter = new ManagedDatabasesResetDatabaseParameter("testManagedDatabasesResetDatabaseParameter", ManagedDatabasesResetDatabaseParameterArgs.builder()
                .managedDatabaseId(testManagedDatabase.id())
                .parameters(managedDatabasesResetDatabaseParameterParameters)
                .scope(managedDatabasesResetDatabaseParameterScope)
                .credentials(ManagedDatabasesResetDatabaseParameterCredentialsArgs.builder()
                    .password(managedDatabasesResetDatabaseParameterCredentialsPassword)
                    .role(managedDatabasesResetDatabaseParameterCredentialsRole)
                    .secretId(testSecret.id())
                    .userName(testUser.name())
                    .build())
                .databaseCredential(ManagedDatabasesResetDatabaseParameterDatabaseCredentialArgs.builder()
                    .credentialType(managedDatabasesResetDatabaseParameterDatabaseCredentialCredentialType)
                    .namedCredentialId(testNamedCredential.id())
                    .password(managedDatabasesResetDatabaseParameterDatabaseCredentialPassword)
                    .passwordSecretId(testSecret.id())
                    .role(managedDatabasesResetDatabaseParameterDatabaseCredentialRole)
                    .username(managedDatabasesResetDatabaseParameterDatabaseCredentialUsername)
                    .build())
                .build());
    
        }
    }
    
    resources:
      testManagedDatabasesResetDatabaseParameter:
        type: oci:DatabaseManagement:ManagedDatabasesResetDatabaseParameter
        name: test_managed_databases_reset_database_parameter
        properties:
          managedDatabaseId: ${testManagedDatabase.id}
          parameters: ${managedDatabasesResetDatabaseParameterParameters}
          scope: ${managedDatabasesResetDatabaseParameterScope}
          credentials:
            password: ${managedDatabasesResetDatabaseParameterCredentialsPassword}
            role: ${managedDatabasesResetDatabaseParameterCredentialsRole}
            secretId: ${testSecret.id}
            userName: ${testUser.name}
          databaseCredential:
            credentialType: ${managedDatabasesResetDatabaseParameterDatabaseCredentialCredentialType}
            namedCredentialId: ${testNamedCredential.id}
            password: ${managedDatabasesResetDatabaseParameterDatabaseCredentialPassword}
            passwordSecretId: ${testSecret.id}
            role: ${managedDatabasesResetDatabaseParameterDatabaseCredentialRole}
            username: ${managedDatabasesResetDatabaseParameterDatabaseCredentialUsername}
    

    Create ManagedDatabasesResetDatabaseParameter Resource

    Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

    Constructor syntax

    new ManagedDatabasesResetDatabaseParameter(name: string, args: ManagedDatabasesResetDatabaseParameterArgs, opts?: CustomResourceOptions);
    @overload
    def ManagedDatabasesResetDatabaseParameter(resource_name: str,
                                               args: ManagedDatabasesResetDatabaseParameterArgs,
                                               opts: Optional[ResourceOptions] = None)
    
    @overload
    def ManagedDatabasesResetDatabaseParameter(resource_name: str,
                                               opts: Optional[ResourceOptions] = None,
                                               managed_database_id: Optional[str] = None,
                                               parameters: Optional[Sequence[str]] = None,
                                               scope: Optional[str] = None,
                                               credentials: Optional[_databasemanagement.ManagedDatabasesResetDatabaseParameterCredentialsArgs] = None,
                                               database_credential: Optional[_databasemanagement.ManagedDatabasesResetDatabaseParameterDatabaseCredentialArgs] = None)
    func NewManagedDatabasesResetDatabaseParameter(ctx *Context, name string, args ManagedDatabasesResetDatabaseParameterArgs, opts ...ResourceOption) (*ManagedDatabasesResetDatabaseParameter, error)
    public ManagedDatabasesResetDatabaseParameter(string name, ManagedDatabasesResetDatabaseParameterArgs args, CustomResourceOptions? opts = null)
    public ManagedDatabasesResetDatabaseParameter(String name, ManagedDatabasesResetDatabaseParameterArgs args)
    public ManagedDatabasesResetDatabaseParameter(String name, ManagedDatabasesResetDatabaseParameterArgs args, CustomResourceOptions options)
    
    type: oci:DatabaseManagement:ManagedDatabasesResetDatabaseParameter
    properties: # The arguments to resource properties.
    options: # Bag of options to control resource's behavior.
    
    

    Parameters

    name string
    The unique name of the resource.
    args ManagedDatabasesResetDatabaseParameterArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    resource_name str
    The unique name of the resource.
    args ManagedDatabasesResetDatabaseParameterArgs
    The arguments to resource properties.
    opts ResourceOptions
    Bag of options to control resource's behavior.
    ctx Context
    Context object for the current deployment.
    name string
    The unique name of the resource.
    args ManagedDatabasesResetDatabaseParameterArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args ManagedDatabasesResetDatabaseParameterArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args ManagedDatabasesResetDatabaseParameterArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    Constructor example

    The following reference example uses placeholder values for all input properties.

    var managedDatabasesResetDatabaseParameterResource = new Oci.DatabaseManagement.ManagedDatabasesResetDatabaseParameter("managedDatabasesResetDatabaseParameterResource", new()
    {
        ManagedDatabaseId = "string",
        Parameters = new[]
        {
            "string",
        },
        Scope = "string",
        Credentials = new Oci.DatabaseManagement.Inputs.ManagedDatabasesResetDatabaseParameterCredentialsArgs
        {
            Password = "string",
            Role = "string",
            SecretId = "string",
            UserName = "string",
        },
        DatabaseCredential = new Oci.DatabaseManagement.Inputs.ManagedDatabasesResetDatabaseParameterDatabaseCredentialArgs
        {
            CredentialType = "string",
            NamedCredentialId = "string",
            Password = "string",
            PasswordSecretId = "string",
            Role = "string",
            Username = "string",
        },
    });
    
    example, err := DatabaseManagement.NewManagedDatabasesResetDatabaseParameter(ctx, "managedDatabasesResetDatabaseParameterResource", &DatabaseManagement.ManagedDatabasesResetDatabaseParameterArgs{
    	ManagedDatabaseId: pulumi.String("string"),
    	Parameters: pulumi.StringArray{
    		pulumi.String("string"),
    	},
    	Scope: pulumi.String("string"),
    	Credentials: &databasemanagement.ManagedDatabasesResetDatabaseParameterCredentialsArgs{
    		Password: pulumi.String("string"),
    		Role:     pulumi.String("string"),
    		SecretId: pulumi.String("string"),
    		UserName: pulumi.String("string"),
    	},
    	DatabaseCredential: &databasemanagement.ManagedDatabasesResetDatabaseParameterDatabaseCredentialArgs{
    		CredentialType:    pulumi.String("string"),
    		NamedCredentialId: pulumi.String("string"),
    		Password:          pulumi.String("string"),
    		PasswordSecretId:  pulumi.String("string"),
    		Role:              pulumi.String("string"),
    		Username:          pulumi.String("string"),
    	},
    })
    
    var managedDatabasesResetDatabaseParameterResource = new ManagedDatabasesResetDatabaseParameter("managedDatabasesResetDatabaseParameterResource", ManagedDatabasesResetDatabaseParameterArgs.builder()
        .managedDatabaseId("string")
        .parameters("string")
        .scope("string")
        .credentials(ManagedDatabasesResetDatabaseParameterCredentialsArgs.builder()
            .password("string")
            .role("string")
            .secretId("string")
            .userName("string")
            .build())
        .databaseCredential(ManagedDatabasesResetDatabaseParameterDatabaseCredentialArgs.builder()
            .credentialType("string")
            .namedCredentialId("string")
            .password("string")
            .passwordSecretId("string")
            .role("string")
            .username("string")
            .build())
        .build());
    
    managed_databases_reset_database_parameter_resource = oci.database_management.ManagedDatabasesResetDatabaseParameter("managedDatabasesResetDatabaseParameterResource",
        managed_database_id="string",
        parameters=["string"],
        scope="string",
        credentials=oci.database_management.ManagedDatabasesResetDatabaseParameterCredentialsArgs(
            password="string",
            role="string",
            secret_id="string",
            user_name="string",
        ),
        database_credential=oci.database_management.ManagedDatabasesResetDatabaseParameterDatabaseCredentialArgs(
            credential_type="string",
            named_credential_id="string",
            password="string",
            password_secret_id="string",
            role="string",
            username="string",
        ))
    
    const managedDatabasesResetDatabaseParameterResource = new oci.databasemanagement.ManagedDatabasesResetDatabaseParameter("managedDatabasesResetDatabaseParameterResource", {
        managedDatabaseId: "string",
        parameters: ["string"],
        scope: "string",
        credentials: {
            password: "string",
            role: "string",
            secretId: "string",
            userName: "string",
        },
        databaseCredential: {
            credentialType: "string",
            namedCredentialId: "string",
            password: "string",
            passwordSecretId: "string",
            role: "string",
            username: "string",
        },
    });
    
    type: oci:DatabaseManagement:ManagedDatabasesResetDatabaseParameter
    properties:
        credentials:
            password: string
            role: string
            secretId: string
            userName: string
        databaseCredential:
            credentialType: string
            namedCredentialId: string
            password: string
            passwordSecretId: string
            role: string
            username: string
        managedDatabaseId: string
        parameters:
            - string
        scope: string
    

    ManagedDatabasesResetDatabaseParameter Resource Properties

    To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

    Inputs

    The ManagedDatabasesResetDatabaseParameter resource accepts the following input properties:

    ManagedDatabaseId string
    The OCID of the Managed Database.
    Parameters List<string>
    A list of database parameter names.
    Scope string

    The clause used to specify when the parameter change takes effect.

    Use MEMORY to make the change in memory and ensure that it takes effect immediately. Use SPFILE to make the change in the server parameter file. The change takes effect when the database is next shut down and started up again. Use BOTH to make the change in memory and in the server parameter file. The change takes effect immediately and persists after the database is shut down and started up again.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    Credentials ManagedDatabasesResetDatabaseParameterCredentials
    The database credentials used to perform management activity. Provide one of the following attribute set. (userName, password, role) OR (userName, secretId, role) OR (namedCredentialId)
    DatabaseCredential ManagedDatabasesResetDatabaseParameterDatabaseCredential
    The credential to connect to the database to perform tablespace administration tasks.
    ManagedDatabaseId string
    The OCID of the Managed Database.
    Parameters []string
    A list of database parameter names.
    Scope string

    The clause used to specify when the parameter change takes effect.

    Use MEMORY to make the change in memory and ensure that it takes effect immediately. Use SPFILE to make the change in the server parameter file. The change takes effect when the database is next shut down and started up again. Use BOTH to make the change in memory and in the server parameter file. The change takes effect immediately and persists after the database is shut down and started up again.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    Credentials ManagedDatabasesResetDatabaseParameterCredentialsArgs
    The database credentials used to perform management activity. Provide one of the following attribute set. (userName, password, role) OR (userName, secretId, role) OR (namedCredentialId)
    DatabaseCredential ManagedDatabasesResetDatabaseParameterDatabaseCredentialArgs
    The credential to connect to the database to perform tablespace administration tasks.
    managedDatabaseId String
    The OCID of the Managed Database.
    parameters List<String>
    A list of database parameter names.
    scope String

    The clause used to specify when the parameter change takes effect.

    Use MEMORY to make the change in memory and ensure that it takes effect immediately. Use SPFILE to make the change in the server parameter file. The change takes effect when the database is next shut down and started up again. Use BOTH to make the change in memory and in the server parameter file. The change takes effect immediately and persists after the database is shut down and started up again.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    credentials ManagedDatabasesResetDatabaseParameterCredentials
    The database credentials used to perform management activity. Provide one of the following attribute set. (userName, password, role) OR (userName, secretId, role) OR (namedCredentialId)
    databaseCredential ManagedDatabasesResetDatabaseParameterDatabaseCredential
    The credential to connect to the database to perform tablespace administration tasks.
    managedDatabaseId string
    The OCID of the Managed Database.
    parameters string[]
    A list of database parameter names.
    scope string

    The clause used to specify when the parameter change takes effect.

    Use MEMORY to make the change in memory and ensure that it takes effect immediately. Use SPFILE to make the change in the server parameter file. The change takes effect when the database is next shut down and started up again. Use BOTH to make the change in memory and in the server parameter file. The change takes effect immediately and persists after the database is shut down and started up again.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    credentials ManagedDatabasesResetDatabaseParameterCredentials
    The database credentials used to perform management activity. Provide one of the following attribute set. (userName, password, role) OR (userName, secretId, role) OR (namedCredentialId)
    databaseCredential ManagedDatabasesResetDatabaseParameterDatabaseCredential
    The credential to connect to the database to perform tablespace administration tasks.
    managed_database_id str
    The OCID of the Managed Database.
    parameters Sequence[str]
    A list of database parameter names.
    scope str

    The clause used to specify when the parameter change takes effect.

    Use MEMORY to make the change in memory and ensure that it takes effect immediately. Use SPFILE to make the change in the server parameter file. The change takes effect when the database is next shut down and started up again. Use BOTH to make the change in memory and in the server parameter file. The change takes effect immediately and persists after the database is shut down and started up again.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    credentials databasemanagement.ManagedDatabasesResetDatabaseParameterCredentialsArgs
    The database credentials used to perform management activity. Provide one of the following attribute set. (userName, password, role) OR (userName, secretId, role) OR (namedCredentialId)
    database_credential databasemanagement.ManagedDatabasesResetDatabaseParameterDatabaseCredentialArgs
    The credential to connect to the database to perform tablespace administration tasks.
    managedDatabaseId String
    The OCID of the Managed Database.
    parameters List<String>
    A list of database parameter names.
    scope String

    The clause used to specify when the parameter change takes effect.

    Use MEMORY to make the change in memory and ensure that it takes effect immediately. Use SPFILE to make the change in the server parameter file. The change takes effect when the database is next shut down and started up again. Use BOTH to make the change in memory and in the server parameter file. The change takes effect immediately and persists after the database is shut down and started up again.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    credentials Property Map
    The database credentials used to perform management activity. Provide one of the following attribute set. (userName, password, role) OR (userName, secretId, role) OR (namedCredentialId)
    databaseCredential Property Map
    The credential to connect to the database to perform tablespace administration tasks.

    Outputs

    All input properties are implicitly available as output properties. Additionally, the ManagedDatabasesResetDatabaseParameter resource produces the following output properties:

    Id string
    The provider-assigned unique ID for this managed resource.
    Id string
    The provider-assigned unique ID for this managed resource.
    id String
    The provider-assigned unique ID for this managed resource.
    id string
    The provider-assigned unique ID for this managed resource.
    id str
    The provider-assigned unique ID for this managed resource.
    id String
    The provider-assigned unique ID for this managed resource.

    Look up Existing ManagedDatabasesResetDatabaseParameter Resource

    Get an existing ManagedDatabasesResetDatabaseParameter resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

    public static get(name: string, id: Input<ID>, state?: ManagedDatabasesResetDatabaseParameterState, opts?: CustomResourceOptions): ManagedDatabasesResetDatabaseParameter
    @staticmethod
    def get(resource_name: str,
            id: str,
            opts: Optional[ResourceOptions] = None,
            credentials: Optional[_databasemanagement.ManagedDatabasesResetDatabaseParameterCredentialsArgs] = None,
            database_credential: Optional[_databasemanagement.ManagedDatabasesResetDatabaseParameterDatabaseCredentialArgs] = None,
            managed_database_id: Optional[str] = None,
            parameters: Optional[Sequence[str]] = None,
            scope: Optional[str] = None) -> ManagedDatabasesResetDatabaseParameter
    func GetManagedDatabasesResetDatabaseParameter(ctx *Context, name string, id IDInput, state *ManagedDatabasesResetDatabaseParameterState, opts ...ResourceOption) (*ManagedDatabasesResetDatabaseParameter, error)
    public static ManagedDatabasesResetDatabaseParameter Get(string name, Input<string> id, ManagedDatabasesResetDatabaseParameterState? state, CustomResourceOptions? opts = null)
    public static ManagedDatabasesResetDatabaseParameter get(String name, Output<String> id, ManagedDatabasesResetDatabaseParameterState state, CustomResourceOptions options)
    Resource lookup is not supported in YAML
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    resource_name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    The following state arguments are supported:
    Credentials ManagedDatabasesResetDatabaseParameterCredentials
    The database credentials used to perform management activity. Provide one of the following attribute set. (userName, password, role) OR (userName, secretId, role) OR (namedCredentialId)
    DatabaseCredential ManagedDatabasesResetDatabaseParameterDatabaseCredential
    The credential to connect to the database to perform tablespace administration tasks.
    ManagedDatabaseId string
    The OCID of the Managed Database.
    Parameters List<string>
    A list of database parameter names.
    Scope string

    The clause used to specify when the parameter change takes effect.

    Use MEMORY to make the change in memory and ensure that it takes effect immediately. Use SPFILE to make the change in the server parameter file. The change takes effect when the database is next shut down and started up again. Use BOTH to make the change in memory and in the server parameter file. The change takes effect immediately and persists after the database is shut down and started up again.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    Credentials ManagedDatabasesResetDatabaseParameterCredentialsArgs
    The database credentials used to perform management activity. Provide one of the following attribute set. (userName, password, role) OR (userName, secretId, role) OR (namedCredentialId)
    DatabaseCredential ManagedDatabasesResetDatabaseParameterDatabaseCredentialArgs
    The credential to connect to the database to perform tablespace administration tasks.
    ManagedDatabaseId string
    The OCID of the Managed Database.
    Parameters []string
    A list of database parameter names.
    Scope string

    The clause used to specify when the parameter change takes effect.

    Use MEMORY to make the change in memory and ensure that it takes effect immediately. Use SPFILE to make the change in the server parameter file. The change takes effect when the database is next shut down and started up again. Use BOTH to make the change in memory and in the server parameter file. The change takes effect immediately and persists after the database is shut down and started up again.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    credentials ManagedDatabasesResetDatabaseParameterCredentials
    The database credentials used to perform management activity. Provide one of the following attribute set. (userName, password, role) OR (userName, secretId, role) OR (namedCredentialId)
    databaseCredential ManagedDatabasesResetDatabaseParameterDatabaseCredential
    The credential to connect to the database to perform tablespace administration tasks.
    managedDatabaseId String
    The OCID of the Managed Database.
    parameters List<String>
    A list of database parameter names.
    scope String

    The clause used to specify when the parameter change takes effect.

    Use MEMORY to make the change in memory and ensure that it takes effect immediately. Use SPFILE to make the change in the server parameter file. The change takes effect when the database is next shut down and started up again. Use BOTH to make the change in memory and in the server parameter file. The change takes effect immediately and persists after the database is shut down and started up again.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    credentials ManagedDatabasesResetDatabaseParameterCredentials
    The database credentials used to perform management activity. Provide one of the following attribute set. (userName, password, role) OR (userName, secretId, role) OR (namedCredentialId)
    databaseCredential ManagedDatabasesResetDatabaseParameterDatabaseCredential
    The credential to connect to the database to perform tablespace administration tasks.
    managedDatabaseId string
    The OCID of the Managed Database.
    parameters string[]
    A list of database parameter names.
    scope string

    The clause used to specify when the parameter change takes effect.

    Use MEMORY to make the change in memory and ensure that it takes effect immediately. Use SPFILE to make the change in the server parameter file. The change takes effect when the database is next shut down and started up again. Use BOTH to make the change in memory and in the server parameter file. The change takes effect immediately and persists after the database is shut down and started up again.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    credentials databasemanagement.ManagedDatabasesResetDatabaseParameterCredentialsArgs
    The database credentials used to perform management activity. Provide one of the following attribute set. (userName, password, role) OR (userName, secretId, role) OR (namedCredentialId)
    database_credential databasemanagement.ManagedDatabasesResetDatabaseParameterDatabaseCredentialArgs
    The credential to connect to the database to perform tablespace administration tasks.
    managed_database_id str
    The OCID of the Managed Database.
    parameters Sequence[str]
    A list of database parameter names.
    scope str

    The clause used to specify when the parameter change takes effect.

    Use MEMORY to make the change in memory and ensure that it takes effect immediately. Use SPFILE to make the change in the server parameter file. The change takes effect when the database is next shut down and started up again. Use BOTH to make the change in memory and in the server parameter file. The change takes effect immediately and persists after the database is shut down and started up again.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    credentials Property Map
    The database credentials used to perform management activity. Provide one of the following attribute set. (userName, password, role) OR (userName, secretId, role) OR (namedCredentialId)
    databaseCredential Property Map
    The credential to connect to the database to perform tablespace administration tasks.
    managedDatabaseId String
    The OCID of the Managed Database.
    parameters List<String>
    A list of database parameter names.
    scope String

    The clause used to specify when the parameter change takes effect.

    Use MEMORY to make the change in memory and ensure that it takes effect immediately. Use SPFILE to make the change in the server parameter file. The change takes effect when the database is next shut down and started up again. Use BOTH to make the change in memory and in the server parameter file. The change takes effect immediately and persists after the database is shut down and started up again.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    Supporting Types

    ManagedDatabasesResetDatabaseParameterCredentials, ManagedDatabasesResetDatabaseParameterCredentialsArgs

    Password string
    The password for the database user name.
    Role string
    The role of the database user. Indicates whether the database user is a normal user or sysdba.
    SecretId string
    The OCID of the secret containing the user password.
    UserName string
    The database user name used to perform management activity.
    Password string
    The password for the database user name.
    Role string
    The role of the database user. Indicates whether the database user is a normal user or sysdba.
    SecretId string
    The OCID of the secret containing the user password.
    UserName string
    The database user name used to perform management activity.
    password String
    The password for the database user name.
    role String
    The role of the database user. Indicates whether the database user is a normal user or sysdba.
    secretId String
    The OCID of the secret containing the user password.
    userName String
    The database user name used to perform management activity.
    password string
    The password for the database user name.
    role string
    The role of the database user. Indicates whether the database user is a normal user or sysdba.
    secretId string
    The OCID of the secret containing the user password.
    userName string
    The database user name used to perform management activity.
    password str
    The password for the database user name.
    role str
    The role of the database user. Indicates whether the database user is a normal user or sysdba.
    secret_id str
    The OCID of the secret containing the user password.
    user_name str
    The database user name used to perform management activity.
    password String
    The password for the database user name.
    role String
    The role of the database user. Indicates whether the database user is a normal user or sysdba.
    secretId String
    The OCID of the secret containing the user password.
    userName String
    The database user name used to perform management activity.

    ManagedDatabasesResetDatabaseParameterDatabaseCredential, ManagedDatabasesResetDatabaseParameterDatabaseCredentialArgs

    CredentialType string
    The type of the credential for tablespace administration tasks.
    NamedCredentialId string
    The OCID of the named credential where the database password metadata is stored.
    Password string
    The database user's password encoded using BASE64 scheme.
    PasswordSecretId string
    The OCID of the Secret where the database password is stored.
    Role string
    The role of the database user.
    Username string
    The user to connect to the database.
    CredentialType string
    The type of the credential for tablespace administration tasks.
    NamedCredentialId string
    The OCID of the named credential where the database password metadata is stored.
    Password string
    The database user's password encoded using BASE64 scheme.
    PasswordSecretId string
    The OCID of the Secret where the database password is stored.
    Role string
    The role of the database user.
    Username string
    The user to connect to the database.
    credentialType String
    The type of the credential for tablespace administration tasks.
    namedCredentialId String
    The OCID of the named credential where the database password metadata is stored.
    password String
    The database user's password encoded using BASE64 scheme.
    passwordSecretId String
    The OCID of the Secret where the database password is stored.
    role String
    The role of the database user.
    username String
    The user to connect to the database.
    credentialType string
    The type of the credential for tablespace administration tasks.
    namedCredentialId string
    The OCID of the named credential where the database password metadata is stored.
    password string
    The database user's password encoded using BASE64 scheme.
    passwordSecretId string
    The OCID of the Secret where the database password is stored.
    role string
    The role of the database user.
    username string
    The user to connect to the database.
    credential_type str
    The type of the credential for tablespace administration tasks.
    named_credential_id str
    The OCID of the named credential where the database password metadata is stored.
    password str
    The database user's password encoded using BASE64 scheme.
    password_secret_id str
    The OCID of the Secret where the database password is stored.
    role str
    The role of the database user.
    username str
    The user to connect to the database.
    credentialType String
    The type of the credential for tablespace administration tasks.
    namedCredentialId String
    The OCID of the named credential where the database password metadata is stored.
    password String
    The database user's password encoded using BASE64 scheme.
    passwordSecretId String
    The OCID of the Secret where the database password is stored.
    role String
    The role of the database user.
    username String
    The user to connect to the database.

    Import

    Import is not supported for this resource.

    To learn more about importing existing cloud resources, see Importing resources.

    Package Details

    Repository
    oci pulumi/pulumi-oci
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the oci Terraform Provider.
    oci logo
    Oracle Cloud Infrastructure v2.3.0 published on Wednesday, Jul 17, 2024 by Pulumi