We often need to replace strings in a file or multiple files in a Unix system. This can be done easily using the sed command. we can easily replace the strings in multiples in a very short span of time sed replace a string in a file We can use the below command sed ‘s/<string […]
Password Version in oracle
Password version is a new column in DBA_USERS starting 11g. The PASSWORD_VERSIONS column shows the list of password versions that exist for the account. 10G refers to the earlier case-insensitive Oracle password DES-based version 11G refers to the SHA-1 version, and 12C refers to the SHA-2-based SHA-512 version. It is defined as below in 11G […]
How to login as user without changing the password in Oracle database(alter user identified by values)
In many cases, DBA needs to log in with another user whose credentials/oracle password are not known, also exporting schema and importing the schema, and preserve the same password. Let’s check out how it works out with alter user identified by values Oracle Database 10G Oracle stores the hash of the username and password is […]
How to check encrypted tablespace in the Database
Here is the query that can be used select t.name,e.encryptionalg,e.encyptedts,e.status from v$encrypted_tablespaces e,v$tablespace t where t.ts#=e.ts#(+); We can further check the datafile encryption status of the above tablespaces using the below query select name, encrypted from v$datafile_header where tablespace_name like ‘&1’; We can find the count of the datafiles which are not encrypted in the […]
How To Export -Import TDE Master Encryption Key
We need to export/import the TDE Master Encryption key when we are migrating TDE encrypted NON-CDB to the CDB database or migrating encrypted PDB to another CDB database. How To Export TDE Master Encryption Key When you are migrating PDB from one database to another and the source PDB is encrypted, then you need to […]
How to Configure Auto Login TDE Wallet
When we configure TDE wallet , we need to explicitly open it after each database restart. ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY <wallet password> ; we can verify the status of the wallet as select wallet_type from v$encryption_walletwallet_type————-Password We can configure the auto-login wallet also, In that you don’t need to explicitly open […]