-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
After enabling the TDE, encryption is still unable to create table space, it's really difficult to use oracle,
Problem Description
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Using the command line mode, create a wallet, or use the EM graphical interface to create wallet, encryption can create table space, is really suit,
Always an error,
SQL> The CREATE in TABLESPACE securespace DATAFILE 'secure01. DBF' SIZE 150 m ENCRYPTION
The DEFAULT STORAGE (ENCRYPT);
Error:
Line 1 error:
ORA - 00439: is not enabled functions: Transparent Data Encryption
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
The first to use IE on em interface,
The use of "encrypted Wallet", "local automatically open Wallet" option, created after the Wallet,
Using the "change encryption security module Settings - changes of encrypted Wallet location will be written to a local $TNS_ADMIN/sqlnet. Ora file,", modify server sqlnet. Ora,
After the success of the change, sqlnet. Ora content for
ENCRYPTION_WALLET_LOCATION=
(SOURCE=
(METHOD=FILE)
(METHOD_DATA=
https://bbs.csdn.net/topics/(DIRECTORY=D: \ \ admin \ apply11 \ oracle wallet)
)
)
SQLNET. AUTHENTICATION_SERVICES=(NTS)
NAMES. DIRECTORY_PATH=(TNSNAMES EZCONNECT)
SSL_CLIENT_AUTHENTICATION=true
SSL_CERT_REVOCATION=NONE
WALLET_LOCATION=
(SOURCE=
(METHOD=FILE)
)
EM display status for
Encryption security module WALLET
Wallet location D: \ \ admin \ apply11 \ oracle Wallet
State OPEN Wallet
Using the em interface and command line Encryption table space, at the same error, ORA - 00439: is not enabled functions: Transparent Data Encryption,
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
According to the method of online
The connect/as sysdba
The alter system set the key identified by "welcome1";
The alter system set wallet open identified by "welcome1";
Many similar articles tutorial, error is not done, can see the Wallet in the em state OPEN, but create encrypted table space, or to the same mistake,
I'm going crazy, oracle in "Settings" level, it's more difficult than MSSQL with several times,,,,,,,,
The Error Codes
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
ORA - 00439
The Problem Category/Subcategory
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
The Database Security, User Management, Auditing, the Vault, Grants, ASO, EUS, VPD, OLS, TDE, Data Redaction)/Transparent Data Encryption (TDE)
Uploaded Files
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
CodePudding user response:
Restart the service?CodePudding user response:
Must restart, is generated after the wallet, containing the certificate, to export the certificate application, to submit application for "certificate authority" to the certification? I am trying, there is no certificate authentication step,Any other questions, I really don't know how make,
And oracle database 11 EM, though with a web page, but the oracle of the main program is divided, listen port to the default 5972, EM cannot use immediately,
Reoccupy emca - deconfig dbcontrol db and emca - config dbcontrol db reconstruction (process middle chose new port), still no,
-- -- -- -- -- -- -- -- -- --
Will modify a default port, you have to learn a lot of oracle command, see a pile of oracle technical term, probably make uncertain,
Will modify a default port, you must put the DBA this knowledge into the door, and may also make uncertain,
Is the oracle;