• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General

How to use sed replace string in file

March 10, 2023 by techgoeasy Leave a Comment

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 […]

Filed Under: Unix command and scripts

Password Version in oracle

March 5, 2023 by techgoeasy Leave a Comment

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 […]

Filed Under: Oracle, Oracle Database

How to login as user without changing the password in Oracle database(alter user identified by values)

March 5, 2023 by techgoeasy Leave a Comment

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 […]

Filed Under: Oracle, Oracle Database

How to check encrypted tablespace in the Database

March 4, 2023 by techgoeasy Leave a Comment

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 […]

Filed Under: Oracle, Oracle Database

How To Export -Import TDE Master Encryption Key

March 4, 2023 by techgoeasy Leave a Comment

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 […]

Filed Under: Oracle, Oracle Database

How to Configure Auto Login TDE Wallet

March 4, 2023 by techgoeasy Leave a Comment

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 […]

Filed Under: Oracle, Oracle Database

  • Page 1
  • Page 2
  • Page 3
  • …
  • Page 114
  • Next Page »

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • How to use sed replace string in file
  • Password Version in oracle
  • How to login as user without changing the password in Oracle database(alter user identified by values)
  • How to check encrypted tablespace in the Database
  • How To Export -Import TDE Master Encryption Key

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us