1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. ManagedDatabasesChangeDatabaseParameter
Oracle Cloud Infrastructure v1.41.0 published on Wednesday, Jun 19, 2024 by Pulumi

oci.DatabaseManagement.ManagedDatabasesChangeDatabaseParameter

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v1.41.0 published on Wednesday, Jun 19, 2024 by Pulumi

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

    Changes database parameter values. There are two kinds of database parameters:

    • Dynamic parameters: They can be changed for the current Oracle Database instance. The changes take effect immediately.
    • Static parameters: They cannot be changed for the current instance. You must change these parameters and then restart the database before changes take effect.

    Note: If the instance is started using a text initialization parameter file, the parameter changes are applicable only for the current instance. You must update them manually to be passed to a future instance.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
    import * as oci from "@pulumi/oci";
    
    const testManagedDatabasesChangeDatabaseParameter = new oci.databasemanagement.ManagedDatabasesChangeDatabaseParameter("test_managed_databases_change_database_parameter", {
        managedDatabaseId: testManagedDatabase.id,
        parameters: [{
            name: managedDatabasesChangeDatabaseParameterParametersName,
            value: managedDatabasesChangeDatabaseParameterParametersValue,
            updateComment: managedDatabasesChangeDatabaseParameterParametersUpdateComment,
        }],
        scope: managedDatabasesChangeDatabaseParameterScope,
        credentials: {
            password: managedDatabasesChangeDatabaseParameterCredentialsPassword,
            role: managedDatabasesChangeDatabaseParameterCredentialsRole,
            secretId: testSecret.id,
            userName: testUser.name,
        },
        databaseCredential: {
            credentialType: managedDatabasesChangeDatabaseParameterDatabaseCredentialCredentialType,
            namedCredentialId: testNamedCredential.id,
            password: managedDatabasesChangeDatabaseParameterDatabaseCredentialPassword,
            passwordSecretId: testSecret.id,
            role: managedDatabasesChangeDatabaseParameterDatabaseCredentialRole,
            username: managedDatabasesChangeDatabaseParameterDatabaseCredentialUsername,
        },
    });
    
    import pulumi
    import pulumi_oci as oci
    
    test_managed_databases_change_database_parameter = oci.database_management.ManagedDatabasesChangeDatabaseParameter("test_managed_databases_change_database_parameter",
        managed_database_id=test_managed_database["id"],
        parameters=[oci.database_management.ManagedDatabasesChangeDatabaseParameterParameterArgs(
            name=managed_databases_change_database_parameter_parameters_name,
            value=managed_databases_change_database_parameter_parameters_value,
            update_comment=managed_databases_change_database_parameter_parameters_update_comment,
        )],
        scope=managed_databases_change_database_parameter_scope,
        credentials=oci.database_management.ManagedDatabasesChangeDatabaseParameterCredentialsArgs(
            password=managed_databases_change_database_parameter_credentials_password,
            role=managed_databases_change_database_parameter_credentials_role,
            secret_id=test_secret["id"],
            user_name=test_user["name"],
        ),
        database_credential=oci.database_management.ManagedDatabasesChangeDatabaseParameterDatabaseCredentialArgs(
            credential_type=managed_databases_change_database_parameter_database_credential_credential_type,
            named_credential_id=test_named_credential["id"],
            password=managed_databases_change_database_parameter_database_credential_password,
            password_secret_id=test_secret["id"],
            role=managed_databases_change_database_parameter_database_credential_role,
            username=managed_databases_change_database_parameter_database_credential_username,
        ))
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-oci/sdk/go/oci/DatabaseManagement"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := DatabaseManagement.NewManagedDatabasesChangeDatabaseParameter(ctx, "test_managed_databases_change_database_parameter", &DatabaseManagement.ManagedDatabasesChangeDatabaseParameterArgs{
    			ManagedDatabaseId: pulumi.Any(testManagedDatabase.Id),
    			Parameters: databasemanagement.ManagedDatabasesChangeDatabaseParameterParameterArray{
    				&databasemanagement.ManagedDatabasesChangeDatabaseParameterParameterArgs{
    					Name:          pulumi.Any(managedDatabasesChangeDatabaseParameterParametersName),
    					Value:         pulumi.Any(managedDatabasesChangeDatabaseParameterParametersValue),
    					UpdateComment: pulumi.Any(managedDatabasesChangeDatabaseParameterParametersUpdateComment),
    				},
    			},
    			Scope: pulumi.Any(managedDatabasesChangeDatabaseParameterScope),
    			Credentials: &databasemanagement.ManagedDatabasesChangeDatabaseParameterCredentialsArgs{
    				Password: pulumi.Any(managedDatabasesChangeDatabaseParameterCredentialsPassword),
    				Role:     pulumi.Any(managedDatabasesChangeDatabaseParameterCredentialsRole),
    				SecretId: pulumi.Any(testSecret.Id),
    				UserName: pulumi.Any(testUser.Name),
    			},
    			DatabaseCredential: &databasemanagement.ManagedDatabasesChangeDatabaseParameterDatabaseCredentialArgs{
    				CredentialType:    pulumi.Any(managedDatabasesChangeDatabaseParameterDatabaseCredentialCredentialType),
    				NamedCredentialId: pulumi.Any(testNamedCredential.Id),
    				Password:          pulumi.Any(managedDatabasesChangeDatabaseParameterDatabaseCredentialPassword),
    				PasswordSecretId:  pulumi.Any(testSecret.Id),
    				Role:              pulumi.Any(managedDatabasesChangeDatabaseParameterDatabaseCredentialRole),
    				Username:          pulumi.Any(managedDatabasesChangeDatabaseParameterDatabaseCredentialUsername),
    			},
    		})
    		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 testManagedDatabasesChangeDatabaseParameter = new Oci.DatabaseManagement.ManagedDatabasesChangeDatabaseParameter("test_managed_databases_change_database_parameter", new()
        {
            ManagedDatabaseId = testManagedDatabase.Id,
            Parameters = new[]
            {
                new Oci.DatabaseManagement.Inputs.ManagedDatabasesChangeDatabaseParameterParameterArgs
                {
                    Name = managedDatabasesChangeDatabaseParameterParametersName,
                    Value = managedDatabasesChangeDatabaseParameterParametersValue,
                    UpdateComment = managedDatabasesChangeDatabaseParameterParametersUpdateComment,
                },
            },
            Scope = managedDatabasesChangeDatabaseParameterScope,
            Credentials = new Oci.DatabaseManagement.Inputs.ManagedDatabasesChangeDatabaseParameterCredentialsArgs
            {
                Password = managedDatabasesChangeDatabaseParameterCredentialsPassword,
                Role = managedDatabasesChangeDatabaseParameterCredentialsRole,
                SecretId = testSecret.Id,
                UserName = testUser.Name,
            },
            DatabaseCredential = new Oci.DatabaseManagement.Inputs.ManagedDatabasesChangeDatabaseParameterDatabaseCredentialArgs
            {
                CredentialType = managedDatabasesChangeDatabaseParameterDatabaseCredentialCredentialType,
                NamedCredentialId = testNamedCredential.Id,
                Password = managedDatabasesChangeDatabaseParameterDatabaseCredentialPassword,
                PasswordSecretId = testSecret.Id,
                Role = managedDatabasesChangeDatabaseParameterDatabaseCredentialRole,
                Username = managedDatabasesChangeDatabaseParameterDatabaseCredentialUsername,
            },
        });
    
    });
    
    package generated_program;
    
    import com.pulumi.Context;
    import com.pulumi.Pulumi;
    import com.pulumi.core.Output;
    import com.pulumi.oci.DatabaseManagement.ManagedDatabasesChangeDatabaseParameter;
    import com.pulumi.oci.DatabaseManagement.ManagedDatabasesChangeDatabaseParameterArgs;
    import com.pulumi.oci.DatabaseManagement.inputs.ManagedDatabasesChangeDatabaseParameterParameterArgs;
    import com.pulumi.oci.DatabaseManagement.inputs.ManagedDatabasesChangeDatabaseParameterCredentialsArgs;
    import com.pulumi.oci.DatabaseManagement.inputs.ManagedDatabasesChangeDatabaseParameterDatabaseCredentialArgs;
    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 testManagedDatabasesChangeDatabaseParameter = new ManagedDatabasesChangeDatabaseParameter("testManagedDatabasesChangeDatabaseParameter", ManagedDatabasesChangeDatabaseParameterArgs.builder()
                .managedDatabaseId(testManagedDatabase.id())
                .parameters(ManagedDatabasesChangeDatabaseParameterParameterArgs.builder()
                    .name(managedDatabasesChangeDatabaseParameterParametersName)
                    .value(managedDatabasesChangeDatabaseParameterParametersValue)
                    .updateComment(managedDatabasesChangeDatabaseParameterParametersUpdateComment)
                    .build())
                .scope(managedDatabasesChangeDatabaseParameterScope)
                .credentials(ManagedDatabasesChangeDatabaseParameterCredentialsArgs.builder()
                    .password(managedDatabasesChangeDatabaseParameterCredentialsPassword)
                    .role(managedDatabasesChangeDatabaseParameterCredentialsRole)
                    .secretId(testSecret.id())
                    .userName(testUser.name())
                    .build())
                .databaseCredential(ManagedDatabasesChangeDatabaseParameterDatabaseCredentialArgs.builder()
                    .credentialType(managedDatabasesChangeDatabaseParameterDatabaseCredentialCredentialType)
                    .namedCredentialId(testNamedCredential.id())
                    .password(managedDatabasesChangeDatabaseParameterDatabaseCredentialPassword)
                    .passwordSecretId(testSecret.id())
                    .role(managedDatabasesChangeDatabaseParameterDatabaseCredentialRole)
                    .username(managedDatabasesChangeDatabaseParameterDatabaseCredentialUsername)
                    .build())
                .build());
    
        }
    }
    
    resources:
      testManagedDatabasesChangeDatabaseParameter:
        type: oci:DatabaseManagement:ManagedDatabasesChangeDatabaseParameter
        name: test_managed_databases_change_database_parameter
        properties:
          managedDatabaseId: ${testManagedDatabase.id}
          parameters:
            - name: ${managedDatabasesChangeDatabaseParameterParametersName}
              value: ${managedDatabasesChangeDatabaseParameterParametersValue}
              updateComment: ${managedDatabasesChangeDatabaseParameterParametersUpdateComment}
          scope: ${managedDatabasesChangeDatabaseParameterScope}
          credentials:
            password: ${managedDatabasesChangeDatabaseParameterCredentialsPassword}
            role: ${managedDatabasesChangeDatabaseParameterCredentialsRole}
            secretId: ${testSecret.id}
            userName: ${testUser.name}
          databaseCredential:
            credentialType: ${managedDatabasesChangeDatabaseParameterDatabaseCredentialCredentialType}
            namedCredentialId: ${testNamedCredential.id}
            password: ${managedDatabasesChangeDatabaseParameterDatabaseCredentialPassword}
            passwordSecretId: ${testSecret.id}
            role: ${managedDatabasesChangeDatabaseParameterDatabaseCredentialRole}
            username: ${managedDatabasesChangeDatabaseParameterDatabaseCredentialUsername}
    

    Create ManagedDatabasesChangeDatabaseParameter Resource

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

    Constructor syntax

    new ManagedDatabasesChangeDatabaseParameter(name: string, args: ManagedDatabasesChangeDatabaseParameterArgs, opts?: CustomResourceOptions);
    @overload
    def ManagedDatabasesChangeDatabaseParameter(resource_name: str,
                                                args: ManagedDatabasesChangeDatabaseParameterArgs,
                                                opts: Optional[ResourceOptions] = None)
    
    @overload
    def ManagedDatabasesChangeDatabaseParameter(resource_name: str,
                                                opts: Optional[ResourceOptions] = None,
                                                managed_database_id: Optional[str] = None,
                                                parameters: Optional[Sequence[_databasemanagement.ManagedDatabasesChangeDatabaseParameterParameterArgs]] = None,
                                                scope: Optional[str] = None,
                                                credentials: Optional[_databasemanagement.ManagedDatabasesChangeDatabaseParameterCredentialsArgs] = None,
                                                database_credential: Optional[_databasemanagement.ManagedDatabasesChangeDatabaseParameterDatabaseCredentialArgs] = None)
    func NewManagedDatabasesChangeDatabaseParameter(ctx *Context, name string, args ManagedDatabasesChangeDatabaseParameterArgs, opts ...ResourceOption) (*ManagedDatabasesChangeDatabaseParameter, error)
    public ManagedDatabasesChangeDatabaseParameter(string name, ManagedDatabasesChangeDatabaseParameterArgs args, CustomResourceOptions? opts = null)
    public ManagedDatabasesChangeDatabaseParameter(String name, ManagedDatabasesChangeDatabaseParameterArgs args)
    public ManagedDatabasesChangeDatabaseParameter(String name, ManagedDatabasesChangeDatabaseParameterArgs args, CustomResourceOptions options)
    
    type: oci:DatabaseManagement:ManagedDatabasesChangeDatabaseParameter
    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 ManagedDatabasesChangeDatabaseParameterArgs
    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 ManagedDatabasesChangeDatabaseParameterArgs
    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 ManagedDatabasesChangeDatabaseParameterArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args ManagedDatabasesChangeDatabaseParameterArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args ManagedDatabasesChangeDatabaseParameterArgs
    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 managedDatabasesChangeDatabaseParameterResource = new Oci.DatabaseManagement.ManagedDatabasesChangeDatabaseParameter("managedDatabasesChangeDatabaseParameterResource", new()
    {
        ManagedDatabaseId = "string",
        Parameters = new[]
        {
            new Oci.DatabaseManagement.Inputs.ManagedDatabasesChangeDatabaseParameterParameterArgs
            {
                Name = "string",
                Value = "string",
                UpdateComment = "string",
            },
        },
        Scope = "string",
        Credentials = new Oci.DatabaseManagement.Inputs.ManagedDatabasesChangeDatabaseParameterCredentialsArgs
        {
            Password = "string",
            Role = "string",
            SecretId = "string",
            UserName = "string",
        },
        DatabaseCredential = new Oci.DatabaseManagement.Inputs.ManagedDatabasesChangeDatabaseParameterDatabaseCredentialArgs
        {
            CredentialType = "string",
            NamedCredentialId = "string",
            Password = "string",
            PasswordSecretId = "string",
            Role = "string",
            Username = "string",
        },
    });
    
    example, err := DatabaseManagement.NewManagedDatabasesChangeDatabaseParameter(ctx, "managedDatabasesChangeDatabaseParameterResource", &DatabaseManagement.ManagedDatabasesChangeDatabaseParameterArgs{
    	ManagedDatabaseId: pulumi.String("string"),
    	Parameters: databasemanagement.ManagedDatabasesChangeDatabaseParameterParameterArray{
    		&databasemanagement.ManagedDatabasesChangeDatabaseParameterParameterArgs{
    			Name:          pulumi.String("string"),
    			Value:         pulumi.String("string"),
    			UpdateComment: pulumi.String("string"),
    		},
    	},
    	Scope: pulumi.String("string"),
    	Credentials: &databasemanagement.ManagedDatabasesChangeDatabaseParameterCredentialsArgs{
    		Password: pulumi.String("string"),
    		Role:     pulumi.String("string"),
    		SecretId: pulumi.String("string"),
    		UserName: pulumi.String("string"),
    	},
    	DatabaseCredential: &databasemanagement.ManagedDatabasesChangeDatabaseParameterDatabaseCredentialArgs{
    		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 managedDatabasesChangeDatabaseParameterResource = new ManagedDatabasesChangeDatabaseParameter("managedDatabasesChangeDatabaseParameterResource", ManagedDatabasesChangeDatabaseParameterArgs.builder()
        .managedDatabaseId("string")
        .parameters(ManagedDatabasesChangeDatabaseParameterParameterArgs.builder()
            .name("string")
            .value("string")
            .updateComment("string")
            .build())
        .scope("string")
        .credentials(ManagedDatabasesChangeDatabaseParameterCredentialsArgs.builder()
            .password("string")
            .role("string")
            .secretId("string")
            .userName("string")
            .build())
        .databaseCredential(ManagedDatabasesChangeDatabaseParameterDatabaseCredentialArgs.builder()
            .credentialType("string")
            .namedCredentialId("string")
            .password("string")
            .passwordSecretId("string")
            .role("string")
            .username("string")
            .build())
        .build());
    
    managed_databases_change_database_parameter_resource = oci.database_management.ManagedDatabasesChangeDatabaseParameter("managedDatabasesChangeDatabaseParameterResource",
        managed_database_id="string",
        parameters=[oci.database_management.ManagedDatabasesChangeDatabaseParameterParameterArgs(
            name="string",
            value="string",
            update_comment="string",
        )],
        scope="string",
        credentials=oci.database_management.ManagedDatabasesChangeDatabaseParameterCredentialsArgs(
            password="string",
            role="string",
            secret_id="string",
            user_name="string",
        ),
        database_credential=oci.database_management.ManagedDatabasesChangeDatabaseParameterDatabaseCredentialArgs(
            credential_type="string",
            named_credential_id="string",
            password="string",
            password_secret_id="string",
            role="string",
            username="string",
        ))
    
    const managedDatabasesChangeDatabaseParameterResource = new oci.databasemanagement.ManagedDatabasesChangeDatabaseParameter("managedDatabasesChangeDatabaseParameterResource", {
        managedDatabaseId: "string",
        parameters: [{
            name: "string",
            value: "string",
            updateComment: "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:ManagedDatabasesChangeDatabaseParameter
    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:
            - name: string
              updateComment: string
              value: string
        scope: string
    

    ManagedDatabasesChangeDatabaseParameter 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 ManagedDatabasesChangeDatabaseParameter resource accepts the following input properties:

    ManagedDatabaseId string
    The OCID of the Managed Database.
    Parameters List<ManagedDatabasesChangeDatabaseParameterParameter>
    A list of database parameters and their values.
    Scope string

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

    Use MEMORY to make the change in memory and affect it 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 ManagedDatabasesChangeDatabaseParameterCredentials
    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 ManagedDatabasesChangeDatabaseParameterDatabaseCredential
    The credential to connect to the database to perform tablespace administration tasks.
    ManagedDatabaseId string
    The OCID of the Managed Database.
    Parameters []ManagedDatabasesChangeDatabaseParameterParameterArgs
    A list of database parameters and their values.
    Scope string

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

    Use MEMORY to make the change in memory and affect it 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 ManagedDatabasesChangeDatabaseParameterCredentialsArgs
    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 ManagedDatabasesChangeDatabaseParameterDatabaseCredentialArgs
    The credential to connect to the database to perform tablespace administration tasks.
    managedDatabaseId String
    The OCID of the Managed Database.
    parameters List<ManagedDatabasesChangeDatabaseParameterParameter>
    A list of database parameters and their values.
    scope String

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

    Use MEMORY to make the change in memory and affect it 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 ManagedDatabasesChangeDatabaseParameterCredentials
    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 ManagedDatabasesChangeDatabaseParameterDatabaseCredential
    The credential to connect to the database to perform tablespace administration tasks.
    managedDatabaseId string
    The OCID of the Managed Database.
    parameters ManagedDatabasesChangeDatabaseParameterParameter[]
    A list of database parameters and their values.
    scope string

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

    Use MEMORY to make the change in memory and affect it 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 ManagedDatabasesChangeDatabaseParameterCredentials
    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 ManagedDatabasesChangeDatabaseParameterDatabaseCredential
    The credential to connect to the database to perform tablespace administration tasks.
    managed_database_id str
    The OCID of the Managed Database.
    parameters Sequence[databasemanagement.ManagedDatabasesChangeDatabaseParameterParameterArgs]
    A list of database parameters and their values.
    scope str

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

    Use MEMORY to make the change in memory and affect it 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.ManagedDatabasesChangeDatabaseParameterCredentialsArgs
    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.ManagedDatabasesChangeDatabaseParameterDatabaseCredentialArgs
    The credential to connect to the database to perform tablespace administration tasks.
    managedDatabaseId String
    The OCID of the Managed Database.
    parameters List<Property Map>
    A list of database parameters and their values.
    scope String

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

    Use MEMORY to make the change in memory and affect it 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 ManagedDatabasesChangeDatabaseParameter 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 ManagedDatabasesChangeDatabaseParameter Resource

    Get an existing ManagedDatabasesChangeDatabaseParameter 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?: ManagedDatabasesChangeDatabaseParameterState, opts?: CustomResourceOptions): ManagedDatabasesChangeDatabaseParameter
    @staticmethod
    def get(resource_name: str,
            id: str,
            opts: Optional[ResourceOptions] = None,
            credentials: Optional[_databasemanagement.ManagedDatabasesChangeDatabaseParameterCredentialsArgs] = None,
            database_credential: Optional[_databasemanagement.ManagedDatabasesChangeDatabaseParameterDatabaseCredentialArgs] = None,
            managed_database_id: Optional[str] = None,
            parameters: Optional[Sequence[_databasemanagement.ManagedDatabasesChangeDatabaseParameterParameterArgs]] = None,
            scope: Optional[str] = None) -> ManagedDatabasesChangeDatabaseParameter
    func GetManagedDatabasesChangeDatabaseParameter(ctx *Context, name string, id IDInput, state *ManagedDatabasesChangeDatabaseParameterState, opts ...ResourceOption) (*ManagedDatabasesChangeDatabaseParameter, error)
    public static ManagedDatabasesChangeDatabaseParameter Get(string name, Input<string> id, ManagedDatabasesChangeDatabaseParameterState? state, CustomResourceOptions? opts = null)
    public static ManagedDatabasesChangeDatabaseParameter get(String name, Output<String> id, ManagedDatabasesChangeDatabaseParameterState 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 ManagedDatabasesChangeDatabaseParameterCredentials
    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 ManagedDatabasesChangeDatabaseParameterDatabaseCredential
    The credential to connect to the database to perform tablespace administration tasks.
    ManagedDatabaseId string
    The OCID of the Managed Database.
    Parameters List<ManagedDatabasesChangeDatabaseParameterParameter>
    A list of database parameters and their values.
    Scope string

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

    Use MEMORY to make the change in memory and affect it 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 ManagedDatabasesChangeDatabaseParameterCredentialsArgs
    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 ManagedDatabasesChangeDatabaseParameterDatabaseCredentialArgs
    The credential to connect to the database to perform tablespace administration tasks.
    ManagedDatabaseId string
    The OCID of the Managed Database.
    Parameters []ManagedDatabasesChangeDatabaseParameterParameterArgs
    A list of database parameters and their values.
    Scope string

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

    Use MEMORY to make the change in memory and affect it 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 ManagedDatabasesChangeDatabaseParameterCredentials
    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 ManagedDatabasesChangeDatabaseParameterDatabaseCredential
    The credential to connect to the database to perform tablespace administration tasks.
    managedDatabaseId String
    The OCID of the Managed Database.
    parameters List<ManagedDatabasesChangeDatabaseParameterParameter>
    A list of database parameters and their values.
    scope String

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

    Use MEMORY to make the change in memory and affect it 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 ManagedDatabasesChangeDatabaseParameterCredentials
    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 ManagedDatabasesChangeDatabaseParameterDatabaseCredential
    The credential to connect to the database to perform tablespace administration tasks.
    managedDatabaseId string
    The OCID of the Managed Database.
    parameters ManagedDatabasesChangeDatabaseParameterParameter[]
    A list of database parameters and their values.
    scope string

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

    Use MEMORY to make the change in memory and affect it 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.ManagedDatabasesChangeDatabaseParameterCredentialsArgs
    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.ManagedDatabasesChangeDatabaseParameterDatabaseCredentialArgs
    The credential to connect to the database to perform tablespace administration tasks.
    managed_database_id str
    The OCID of the Managed Database.
    parameters Sequence[databasemanagement.ManagedDatabasesChangeDatabaseParameterParameterArgs]
    A list of database parameters and their values.
    scope str

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

    Use MEMORY to make the change in memory and affect it 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<Property Map>
    A list of database parameters and their values.
    scope String

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

    Use MEMORY to make the change in memory and affect it 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

    ManagedDatabasesChangeDatabaseParameterCredentials, ManagedDatabasesChangeDatabaseParameterCredentialsArgs

    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.

    ManagedDatabasesChangeDatabaseParameterDatabaseCredential, ManagedDatabasesChangeDatabaseParameterDatabaseCredentialArgs

    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.

    ManagedDatabasesChangeDatabaseParameterParameter, ManagedDatabasesChangeDatabaseParameterParameterArgs

    Name string
    The parameter name.
    Value string
    The parameter value.
    UpdateComment string
    A comment string to associate with the change in parameter value. It cannot contain control characters or a line break.
    Name string
    The parameter name.
    Value string
    The parameter value.
    UpdateComment string
    A comment string to associate with the change in parameter value. It cannot contain control characters or a line break.
    name String
    The parameter name.
    value String
    The parameter value.
    updateComment String
    A comment string to associate with the change in parameter value. It cannot contain control characters or a line break.
    name string
    The parameter name.
    value string
    The parameter value.
    updateComment string
    A comment string to associate with the change in parameter value. It cannot contain control characters or a line break.
    name str
    The parameter name.
    value str
    The parameter value.
    update_comment str
    A comment string to associate with the change in parameter value. It cannot contain control characters or a line break.
    name String
    The parameter name.
    value String
    The parameter value.
    updateComment String
    A comment string to associate with the change in parameter value. It cannot contain control characters or a line break.

    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 v1.41.0 published on Wednesday, Jun 19, 2024 by Pulumi