Oracle Database, Fusion Middleware, Linux


Data Masking with Oracle Enterprise Manager 12c Cloud Control

Data Masking in Oracle Enterprise Manager 12c Cloud Control This tutorial shows you how to identify sensitive data, create Application Data Model, select appropriate mask formats for the sensitive fields, and apply the mask. First of all I would like to mention that I don’t want to reinvent the wheel. We will use Oracle 11g/10g […]

, , , , , , , ,

Installing Oracle Database 11g R2 on Linux with ASM

In this guide we are going to cover Oracle Database 11g R2 installation on Linux with ASM. Automatic Storage Management (ASM) is a feature that has be introduced in Oracle 10g to simplify the storage of Oracle datafiles, controlfiles, logfiles and backups. ASM will be used as the file system and volume manager for Oracle […]

, , , , , , , , , , , , , , ,

Oracle user account in Linux visudo good practice

Main user for most of the oracle products, especially for Oracle Database installations is an oracle user account. Oracle-validated package does create such account automatically with proper group membership configuration and “random” unknown password. In Linux world (following good practice rules) we all have our own, personal and dedicated user accounts which belongs to the particular […]

, , , , , ,

Installing Oracle Database 11g R2 on Linux

In article Installing Oracle Linux in VMware virtual machine we covered installation of Oracle Linux 5U8 including oracle-validated package. Now, our system is ready for Oracle database installation, and no additional configuration tasks is required at this moment. Note: Most of the time we work with OS from remote locations and target servers are located […]

, , , , , , , ,

Installing Oracle Linux in VMware virtual machine

What is Oracle Linux? Oracle Linux is an open source operating system available under the GNU General Public License (GPL) and is available for free download. Oracle Linux includes two kernels: Unbreakable Enterprise Kernel, tracks mainline Linux kernel closely, and offers the latest features and tested performance and stability The Red Hat Compatible Kernel, compiled directly […]

, , , , ,

How To Setup SSH equivalence , password-less SSH authentication

Imagine you have to administer more than one Linux hosts in your network, or clustered environment. You would like to connect to each host in your environment in a secured way, but without providing the password each time. Here’s is a quick guide how to configure your hosts for password less authentications. We have host-1 and host-2 […]

, , , ,

Installing Oracle RAC 11gR2 on Linux 64bit

Yet another way of installing Oracle RAC 11gR2 This tutorial shows how to install Oracle RAC 11gR2 on Linux 64bit with NAS connected via Native Multipathing (Device Mapper-Multipath).   1. Introduction Oracle Real Application Clusters (Oracle RAC) enables an Oracle database to run across a cluster of servers, providing fault tolerance, performance, and scalability with no […]

, ,

How to multiply control files in Oracle DB RAC 11g

This examle shows how to multiply control files in Oracle Database RAC 11g. An example cluster database racdb1 is up and running on two nodes (rac1 and rac2) Two database instances: [racdb11] and [racdb12] 1. SHUTDOWN the database and start an instance [racdb11] only on the first node (rac1) and check the current configuration. Next, shutdown […]

, , , ,

Delete large numbers of instances in Oracle SOA Suite 11g

Purging composites instances in Oracle SOA SUITE 11g There are several ways to purge large amounts of instances in SOA Suite 11g database – dehydration storage; By dropping the SOA Suite repository and next, to recreate it using RCU creation utility providing exactly the same credentials. By executing a set of existing database procedures delivered […]

, , , ,

Identifying locked objects and killing the session in DB

Common error: ORA-00054: resource busy and acquire with NOWAIT specified To identify all locked sessions in an Oracle database: Query 1: SELECT oracle_username || ‘ (‘ || s.osuser || ‘)’ username, s.sid || ‘,’ || s.serial# sess_id, owner || ‘.’ || object_name object, object_type, DECODE (l.block, 0, ‘Not Blocking’, 1, ‘Blocking’, 2, ‘Global’) STATUS, DECODE […]


Previous Posts Next posts

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.