Secure Oracle EBS Data with Unitask Security Director

2013-09-13T11:36:56.454Z

Automate data scrambling and security in Oracle EBS non-production databases using Unitask Security Director.

Oracle Standby database with Oracle 11G Standard Edittion

2013-08-29T12:06:13.294Z

STEP I- Createing password file for auxiliary server.
Just copy target orapwd file to standby server $ORACLE_HOME/dbs/orapwATLASDEVSB.
STEP II- Configuring network files (listener.ora and tnsnames.ora) to create connectivity between two servers.
Standby database listener
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ATLASDEV)
(ORACLE_HOME = /opt/db/oracle/home/o10oracle/app/oracle/product/11.2.0.2/db_1)
(SID_NAME = ATLASDEVSB)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oratest)(PORT = 1549))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1549))
)
)

STANDBY DATABASE TNSNAMES.ORA
# tnsnames.ora Network Configuration File: /opt/db/oracle/home/o10oracle/app/oracle/product/11.2.0.2/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ATLASDEV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oradev)(PORT = 1525))
)
(CONNECT_DATA =
(SERVICE_NAME = ATLASDEV)
)
)
TARGET DATABASE TNSNAMES.ORA
ATLASDEVSB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oratest)(PORT = 1549))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ATLASDEV)
)
)

STEP III- Creating parameter file for standby instance
*.audit_file_dest='/opt/db/oracle/admin/ATLASDEV/adump'
*.audit_trail='DB'
*.compatible='11.2.0.0.0'
*.control_files='/opt/db/oracle/vol1/ATLASDEV/controlfile/o1_mf_6zn59m4c_.ctl','/opt/db/oracle/vol2/ATLASDEV/controlfile/o1_mf_6zn59m6l_.ctl'
*.db_block_size=8192
*.db_create_file_dest='/opt/db/oracle/vol1/'
*.db_name='ATLASDEV'
*.db_recovery_file_dest='/opt/db/oracle/vol3/fast_recovery_area/'
*.db_recovery_file_dest_size=10G
*.memory_target=1073741824

STEP IV- Creating necessary directories for the standby database files.
Create adump dpdump pfile directories under /opt/db/oracle/admin/ATLASDEV/adump'
Create controlfile datafile onlinelog directories under /opt/db/oracle/vol1/ATLASDEV/.
STEP V- Taking backup of primary database and copy it to the auxiliary server.
Rman>backup current controlfile for standby format ‘/fullpath/standby_control_%U’;
Rman> backup database plus archivelog;
Rman> backup archivelog all;
Sqlplus > select max(sequence#) from v$archived_log;
STEP VI- Startup the auxiliary instance in NOMOUNT mode.
Sqlplus / as sysdba
Sqlplus > Create spfile from pfile=’/fullpath/initATLASDEVSB.ORA’ .
SQLPLUS> STARTUP NOMOUNT;
STEP VII- Running DUPLICATE DATABASE command in the primary database.
Rman target sys/password@atlasdev auxiliary /
Run{
Set until sequence (max seq#);
Duplicate target database for standby dorecover nofilenamecheck;
}
STEP VIII- After successful recovery do following.
Sqlplus / as sysdba
Recover standby database;
AUTO.
ALTER DATABASE OPEN READ ONLY;
If datafile is added on primary database it can be recover using following commands.
• On the standby database, set STANDBY_FILE_MANAGEMENT to AUTO and restart Redo Apply:
SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO;
SQL> RECOVER MANAGED STANDBY DATABASE DISCONNECT;
Ref: http://docs.oracle.com/cd/B28359_01/server.111/b28294/manage_ps.htm

How To Use Oracle JDeveloper To Create Database Connections

2013-08-29T12:05:37.104Z

This tutorial will show you how to create a connection to a database using Oracle JDeveloper. You will learn all the basic steps to establish and view your SQL worksheet and perform all necessary functions. You can watch our collection of Java tutorials here: http://www.fireboxtraining.com/java

Martha Cathy's Videos (OracleConnections) - OracleConnections

Secure Oracle EBS Data with Unitask Security Director

Oracle Standby database with Oracle 11G Standard Edittion

How To Use Oracle JDeveloper To Create Database Connections