Guenadi N Jilevski's Oracle BLOG

Oracle RAC, DG, EBS, DR and HA DBA BLOG

Pleasant Surprise

Pleasant Surprise

I am pleasantly surprised to see my blog article selected on OTN.

May 27, 2011 Posted by | oracle | 4 Comments

Virtualization using Oracle Linux 6 (OEL6) in Oracle VirtualBox

Virtualization using Oracle Linux 6 (OEL6) in Oracle VirtualBox

In the article you will look at how to install OEL6, VirtualBox Guest additions and configure shared folders and networking.

The following software will be used:

Article in first part covers OEL6 installation. In the second part the OEL6 VM is made user friendly by:

  • Installation of VirtualBox Guest Additions
  • Networking between host OS and Guest OEL6, Internet access form OEL6
  • Configuration of shared folders between Guest OEL6and Host OS
  1. OEL6 installation

Note that OEL6 has a bigger footprint on disk and planning needs to be done to size appropriately the file systems. The following file systems will be carved.

Continue reading

May 12, 2011 Posted by | oracle | 4 Comments

Transferring files between ASM and OS file system in Oracle 10g – 11gR2 (11.2.0.2)

Transferring files between ASM and OS file system in Oracle 10g – 11gR2 (11.2.0.2)

ASM, introduced in Oracle 10G, is Oracle solution for storing database files. In Oracle 11gR2 ASM was further enhanced with a general purpose ASM Cluster File system (ACFS) and ASM Dynamic Volume Manager (ADVM). Since ASM was introduced RMAN remains the only supported way to migrate databases from file systems to ASM and from ASM to file systems. For information and examples about how to use RMAN for migration to ASM click here.

In this article you will look at ways to transfer files between file system and ASM. Files need to be transferred in cases of transportable tablespaces , transportable database or copying backup files to name a few. You will look at the following features:

  • XML DB – enables file transfer since Oracle 10gR1
  • ASMCMD cp command since Oracle 11g
  • DBMS_FILE_TRANSFER package – allowed transfer between ASM/FS since 10gR2

Continue reading

May 12, 2011 Posted by | oracle | 6 Comments

Migration to SecureFiles using Online Table Redefinition in Oracle 11gR2

Migration to SecureFiles using Online Table Redefinition in Oracle 11gR2

Oracle introduced SecureFiles in Oracle 11g to enhance existing LOB types. The new SecureFiles concept and architecture is entirely new engineered LOBs in comparison to the old LOBs existing prior to Oracle 11g that are now referred to as Basic Files. Information about SecureFiles in Oracle 11gR2 can be found here. Information about how to use secure files can be found here. Note that for compatibility reasons Basic Files functionality is supported.

  1. Environment is set by the value of DB_SECUREFILE parameter controlling if LOBS are created as Basicfiles or SecureFiles.

    The db_securefile parameter is set as show below.

    SQL> show parameter db_securefile

    NAME TYPE VALUE

    ———————————— ———– ——————————

    db_securefile string PERMITTED

    SQL>

    Values than db_securefile parameter can take are:

    PERMITTED – Allows the DBA to create SecureFiles

    NEVER – disallow creation in the future ( after the parameter is set to this value)

    ALWAYS – attempts to create all LOBs as SecureFiles LOBs but creates any LOBs not in ASSM tablespaces as BasicFiles LOBs, unless the SECUREFILE parameter is explicitly specified. Any BasicFiles LOB storage options specified are ignored, and the SecureFiles LOB defaults are used for all storage options not specified.

    IGNORE – ignores SecureFiles LOB options and SECUREFILE keyword. LOBS are created as BasicFiles. Continue reading

May 11, 2011 Posted by | oracle | Leave a comment

Virtualization using Oracle VM VirtualBox for building two node Oracle RAC 11gR2 cluster based on Solaris 10 x86-64

Virtualization using Oracle VM VirtualBox for building two node Oracle RAC 11gR2 cluster based on Solaris 10 x86-64

In the article you will have a look at how to use some Oracle VirtualBox features to build two node Oracle 11gR RAC system on Solaris 10 x86-64. An overview to Oracle Virtualization solutions can be seen here. You will configure Solaris VM and install Oracle GI, Oracle RDBMS and will create a database. You will see  how to fix some problems that were encountered.

The following software will be used:

  1. Oracle 11gR2 for Solaris (x86-64). Download from here.
  2. Oracle Solaris (x86-64). Download from here.
  3. Oracle VM VirtualBox 4.0.6. Download from here.

There will be two virtual machines sol1 and sol2, each of them will be configured with

  • 4GB RAM
  • 160GB bootable disk
  • NIC – NAT: for access to Internet
  • NIC – bridged for public interface in RAC with address 192.168.2.21/22 (first IP 192.168.2.21 on sol1 and second IP 192.168.2.22 on node sol2). These are public interface in RAC.
  • NIC – bridged for private interface in RAC with address 10.10.10.21/22 (first IP 10.10.10.21 on sol1 and second IP 10.10.10.22 on node sol2). These are private interface in RAC.
  • NIC – Host Only : for FTP/SSH/telnet/SCP access from the host OS to the guest OS. (first IP 192.168.56.51 on sol1 and second IP 192.168.56.51on node sol2).
  • 5 10GB attached shared disks for the ASM storage.

Note. For access to the Guest OS (Solaris) from the Host (MS Windows Vista 64) via ssh/scp/telnet/ftp.   

                  Continue reading

May 10, 2011 Posted by | oracle | 13 Comments

UDEV rules for device persistency and permissions/ownerships in OEL6/REDHAT 6 for ASM

UDEV rules for device persistency and permissions/ownerships in OEL6/REDHAT 6 for ASM

ASMlib is used to ensure device persistency after a reboot and makes sure that devices retain their access permissions and ownership that are established during ASMib configuration. UDEV is another alternative to ASMlib to achieve device persistency and to set permissions/ownership (OS chown user:group / chmod ) on devices. The article outlines the steps that are required to establish device persistency and setup new device names with desired permissions and ownership in OEL6/REDHAT6 using udev.

Continue reading

May 10, 2011 Posted by | oracle | 16 Comments