import * as pulumi from "@pulumi/pulumi"; import * as inputs from "../types/input"; import * as outputs from "../types/output"; /** * This resource provides the Managed Databases Change Database Parameter resource in Oracle Cloud Infrastructure Database Management service. * Api doc link for the resource: https://docs.oracle.com/iaas/api/#/en/database-management/latest/ManagedDatabasesChangeDatabaseParameter * * Example terraform configs related to the resource : https://github.com/oracle/terraform-provider-oci/tree/master/examples/databasemanagement * * 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 * * ```typescript * 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 * * Import is not supported for this resource. */ export declare class ManagedDatabasesChangeDatabaseParameter extends pulumi.CustomResource { /** * Get an existing ManagedDatabasesChangeDatabaseParameter resource's state with the given name, ID, and optional extra * properties used to qualify the lookup. * * @param name The _unique_ name of the resulting resource. * @param id The _unique_ provider ID of the resource to lookup. * @param state Any extra arguments used during the lookup. * @param opts Optional settings to control the behavior of the CustomResource. */ static get(name: string, id: pulumi.Input, state?: ManagedDatabasesChangeDatabaseParameterState, opts?: pulumi.CustomResourceOptions): ManagedDatabasesChangeDatabaseParameter; /** * Returns true if the given object is an instance of ManagedDatabasesChangeDatabaseParameter. This is designed to work even * when multiple copies of the Pulumi SDK have been loaded into the same process. */ static isInstance(obj: any): obj is ManagedDatabasesChangeDatabaseParameter; /** * The database credentials used to perform management activity. Provide one of the following attribute set. (userName, password, role) OR (userName, secretId, role) OR (namedCredentialId) */ readonly credentials: pulumi.Output; /** * The credential to connect to the database to perform tablespace administration tasks. */ readonly databaseCredential: pulumi.Output; /** * The [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm) of the Managed Database. */ readonly managedDatabaseId: pulumi.Output; /** * A list of database parameters and their values. */ readonly parameters: pulumi.Output; /** * 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 */ readonly scope: pulumi.Output; /** * Create a ManagedDatabasesChangeDatabaseParameter resource with the given unique name, arguments, and options. * * @param name The _unique_ name of the resource. * @param args The arguments to use to populate this resource's properties. * @param opts A bag of options that control this resource's behavior. */ constructor(name: string, args: ManagedDatabasesChangeDatabaseParameterArgs, opts?: pulumi.CustomResourceOptions); } /** * Input properties used for looking up and filtering ManagedDatabasesChangeDatabaseParameter resources. */ export interface ManagedDatabasesChangeDatabaseParameterState { /** * The database credentials used to perform management activity. Provide one of the following attribute set. (userName, password, role) OR (userName, secretId, role) OR (namedCredentialId) */ credentials?: pulumi.Input; /** * The credential to connect to the database to perform tablespace administration tasks. */ databaseCredential?: pulumi.Input; /** * The [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm) of the Managed Database. */ managedDatabaseId?: pulumi.Input; /** * A list of database parameters and their values. */ parameters?: pulumi.Input[] | undefined>; /** * 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 */ scope?: pulumi.Input; } /** * The set of arguments for constructing a ManagedDatabasesChangeDatabaseParameter resource. */ export interface ManagedDatabasesChangeDatabaseParameterArgs { /** * The database credentials used to perform management activity. Provide one of the following attribute set. (userName, password, role) OR (userName, secretId, role) OR (namedCredentialId) */ credentials?: pulumi.Input; /** * The credential to connect to the database to perform tablespace administration tasks. */ databaseCredential?: pulumi.Input; /** * The [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm) of the Managed Database. */ managedDatabaseId: pulumi.Input; /** * A list of database parameters and their values. */ parameters: pulumi.Input[]>; /** * 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 */ scope: pulumi.Input; } //# sourceMappingURL=managedDatabasesChangeDatabaseParameter.d.ts.map