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

    • 43,301 hits
  • Visitors

    free counters
  • Vistors Access

  • Calendar

    June 2019
    M T W T F S S
    « Apr    
  • Archives

  • Authors

Posts Tagged ‘security’

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

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 »

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.


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:


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

Database Password File: ORAPWD

Posted by appsinfo on April 2, 2013

Create PASSWORD File

1) SQL> select * from v$pwfile_users;

no rows selected

2) orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=<sys_password> entries=10
3) Now grant sysdba privilege to the users that you need. Check V$PWFILE_USERS about the entry.


 SQL> select * from v$PWFILE_USERS;

USERNAME                       SYSDB SYSOP SYSAS
—————————— —– —– —–
SYS                            TRUE  TRUE  FALSE
SYSTEM                         TRUE  FALSE FALSE
RMANUSER                       TRUE  FALSE FALSE

 SQL> select decode(count(*), 1, ‘spfile’, ‘pfile’ ) from v$spparameter where rownum=1  and isspecified=’TRUE’;


Posted in Security | Tagged: | Leave a Comment »