Saturday, March 9, 2013

[RDBMS] Enabling and Disabling Database Vault in RAC 11g R2


1. You need to stop all the databases and listeners (if there is more than one) running on the Database Oracle Home. With the next commands you can stop this proccesses:

srvctl stop listener
srvctl stop database -d mydb

2. Enable Database Vault in the Oracle Home (remember that we are using 11g R2 and Database Vault is bundle with the installation, you don't have to install it like older versions)

chopt [ enable | disable] db_option

Values for db_option are described in the following table:

dm                    Oracle Data Mining RDBMS Files
dv                    Oracle Database Vault
lbac                  Oracle Label Security
olap                  Oracle OLAP
partitioning          Oracle Partitioning
rat                   Oracle Real Application Testing
ode_net               Oracle Database Extensions for .NET 1.x
ode_net_2             Oracle Database Extensions for .NET 2.0

You will need to run the following commands in every RAC node:

chopt enable lbac
chopt enable dv

Thursday, March 7, 2013

[E-Business Suite] Error running txkrun.pl deploying a New Forms EAR File


Scenario:

You have a Shared Applications Filesystem  configuration in your E-Business Suite environment like the following:

To have this configuration you need to have your CONTEXT_FILE configured to work that way, how? (well that's will be a topic of other post, but I'll give you a brief).


Tuesday, March 5, 2013

[RDBMS] Transparent Data Encryption 11g R2


This is a procedure to configure Transparent Data Encryption (Basic) on a RAC 11gR2 environment.

First you need to add to the $ORACLE_HOME/netowrk/admin/sqlnet.ora the following lines, or alter them if they already exists, in every RAC node:



ENCRYPTION_WALLET_LOCATION=  
  (SOURCE=(METHOD=FILE)(METHOD_DATA=    
   (DIRECTORY=/u01/oracle/product/11.2.0/dbs/encryption_wallet)))

There is a default path,($ORACLE_HOME/admin/$ORACLE_SID/wallet)but you can change it to the one you want your wallet to be.