Infrastructure Technology Group – APPSINFODB

Finding solutions for DBA's to smile…….!!!!!!! DBA its just not Administration, its core of customer’s Data Integrity

  • Blog Stats

    • 39,804 hits
  • Visitors

    free counters
  • Vistors Access

  • Calendar

    April 2018
    M T W T F S S
    « Dec    
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    30  
  • Archives

  • Authors

Posts Tagged ‘Oracle E-Business Suite’

How to Implement TDE

Posted by appsinfo on April 3, 2018

Now that we have got the documentation to implement TDE. At high level we can follow below steps and mark these as check list during deployment or cut-over to production. Below steps are performed on EBS R12.2 on Solaris operating system.

Folks make sure you take full backup before importing the database including the binaries. A snapshot of entire stack is best option.

  1. Perform Pre TDE steps as per the Doc ID: 1926686.1
  2. Export complete database using data pump
  3. Create new empty database
  4. ENCRYPT the application tablespace
  5. Create and open the wallet
  6. Import the complete database using data pump to the encrypted tablespace
  7. Perform post TDE steps
Advertisements

Posted in Backup and Recovery, Cloud, E-Business Suite R12, Infrastructure, Leadership, Oracle Database, Oracle ExaData & ExaLogic, Patches, Security | Tagged: , , , , | Leave a Comment »

TDE- Transparent Data Encryption

Posted by appsinfo on April 3, 2018

TDE is designed to provide customers the ability to transparently apply encryption within the database without impacting existing applications. Transparent data encryption helps protect data stored on media in the event that the storage media or data file gets stolen, because it stores the encryption keys in a security module (that is, a keystore) external to the database. Protecting data from this type of theft is required for most compliance regulations. The benefit to using transparent data encryption is that it requires little coding and is quick and easy to implement.

More Details

Posted in E-Business Suite R12, Oracle Database, Oracle EBS 12.2, Security | Tagged: , , , , | Leave a Comment »

Starting with Exadata

Posted by appsinfo on October 29, 2014

Starting with Exadata

It comes in a rack with the components that make up a database infrastructure: disks, servers, networking gear, and so on. Three configuration types are available: (1) full rack, (2) half rack, or (3) quarter rack. The architecture is identical across all three types but the number of components differs. Read the rest of this entry »

Posted in Engineered Systems, Infrastructure, Oracle EBS 12.2, Oracle ExaData & ExaLogic | Tagged: , , | Leave a Comment »

Implementing Row–LOV

Posted by appsinfo on September 18, 2014

Implementing Row–LOV

To implement a Row–LOV, create an LOV that selects the primary key of the row the user wants into a form parameter, and then copy that value into the primary key field in the results block right before executing a query. Read the rest of this entry »

Posted in System Administration | Tagged: | Leave a Comment »

Oracle Advanced Support Gateway Security – OASG

Posted by appsinfo on August 27, 2014

Oracle Advanced Support Gateway Security – OASG

As part of any implementation project and using oracle engineered systems as part of infrastructure, we should nail down the firewall ports as part of security. This requires extensive pre-planning, architecture, instance strategy based on scope of project.

Overview

The Oracle Advanced Support Gateway is an important part of the Oracle delivery architecture for Oracle Connected Services and its placement must be carefully considered in order for Oracle to deliver Oracle Connected Services.

More information can be found on: http://docs.oracle.com/cd/E41177_01/html/E40643/makehtml-id-0.html#scrolltoc

 

Posted in Infrastructure, Oracle ExaData & ExaLogic | Tagged: , | Leave a Comment »