Oracle教程

Oracle 参数 TABLESPACE_ENCRYPTION_DEFAULT_ALGORITHM 官方解释，作用，如何配置最优化建议

本站中文解释

TABLESPACE_ENCRYPTION_DEFAULT_ALGORITHM 是Oracle的一个参数，用于指定新创建的表空间的默认加密算法。此参数允许设置算法类型和算法参数。目前支持Data Encryption Standard（DES），Triple DES（3DES），AES128，AES192和AES256等。

具体设置方法如下：

1. 通过以下SQL语句更新参数值：

ALTER SYSTEM SET TABLESPACE_ENCRYPTION_DEFAULT_ALGORITHM=’AES192′ SCOPE=SPFILE;

2. 通过重新启动数据库后生效：

SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP;

3. 验证参数设置是否已生效：

SQL> SHOW PARAMETER TABLESPACE

官方英文解释

TABLESPACE_ENCRYPTION_DEFAULT_ALGORITHM specifies the default algorithm the database uses when encrypting a tablespace.

Property Description

Parameter type

String

Syntax

TABLESPACE_ENCRYPTION_DEFAULT_ALGORITHM = { AES128 | AES192 | AES256 | ARIA128 | ARIA192 | ARIA256 | GOST256 | SEED128 | 3DES168 }

Note: 3DES168 must be enclosed in single quotation marks when specified in the ALTER SYSTEM command.

Default value

AES128

Modifiable

ALTER SYSTEM

Modifiable in a PDB

Yes

Basic

No

Oracle RAC

The same value should be specified for all instances.

The value of this initialization parameter determines the algorithm the database uses if an encryption algorithm is not specified when creating an encrypted tablespace or when encrypting an existing tablespace. For example, the value of this parameter takes effect when:

  • You create a tablespace with the CREATE TABLESPACE statement and you specify the ENCRYPTION … ENCRYPT clause, but you do not specify the USING keyword and an algorithm.
  • You create a tablespace with the CREATE TABLESPACE statement and you do not specify the ENCRYPTION … ENCRYPT clause. However, the value of the ENCRYPT_NEW_TABLESPACES initialization parameter instructs the database to encrypt the tablespace.
  • You encrypt an existing tablespace with the ALTER TABLESPACE statement, either by specifying the ENCRYPTION OFFLINE ENCRYPT clause or the ENCRYPTION ONLINE … ENCRYPT clause, and you do not specify the USING keyword and an algorithm.

Note:

This parameter is available starting with Oracle Database 21c.

See Also:

  • “ENCRYPT_NEW_TABLESPACES”

  • Oracle Database SQL
    Language Reference     for more information about the CREATE TABLESPACE statement

  • Oracle Database SQL
    Language Reference     for more information about the ALTER TABLESPACE statement


数据运维技术 » Oracle 参数 TABLESPACE_ENCRYPTION_DEFAULT_ALGORITHM 官方解释，作用，如何配置最优化建议
分享到：

相关推荐