Oracle Database Restore From Backup & Apply To Last Archive Logs

################################
## RESTORE CONTROLFILE & SPFILE
##
################################

RMAN > connect target /
RMAN > set dbid 53241354
RMAN > startup nomount
RMAN > set controlfile autobackup format for device type disk to '/data/RESTORE/ORCL/COPIED_BACKUP/%F';
RMAN > restore spfile
        to pfile '/oracle/db_home/dbs/initORCL.ora'
        from autobackup;
## Edit PFILE (host directories )
vi initORCL.ora
%s/u01/oracle/g

RMAN> shutdown immediate;
RMAN> startup nomount pfile='/oracle/db_home/dbs/initORCL.ora';
RMAN> set controlfile autobackup format for device type disk to '/data/RESTORE/ORCL/COPIED_BACKUP/%F';
RMAN> restore controlfile from autobackup;
RMAN> alter database mount;
RMAN> show all;

RMAN > catalog start with '/data/RESTORE/ORCL/COPIED_BACKUP';

####################################################################
##--NEW NAMES FOR DATAFILE AND REDOLOGS WHICH GENARATES AUTO SCRIPTS
##--select 'set NEWNAME for datafile ' || file# || ' to '  || '''' || '/data/oradata/ORCL/' || REGEXP_SUBSTR(name,'[^/]+',3,4)  || '''' || ';' from v$datafile;
##--select 'SQL "ALTER DATABASE RENAME FILE ' || '''' || '''' || member || '''' || '''' || ' TO ' || '''' || '''' || '/oradata1/oradata/ORCL/' || REGEXP_SUBSTR(member,'[[:alnum:]]+[^[:digit:]]+$') || '''' || '''' || ' ";'  from v$logfile order by member asc;
##!/bin/bash
####################################################################


####################################################################
## RECOVER DATABASE TO LAST BACKUP ARCHIVELOG
## RMAN> list backup of archivelog all;
#   List of Archived Logs in backup set 26950
#  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
#  ---- ------- ---------- --------- ---------- ---------
#
#
#  List of Archived Logs in backup set 26981
#  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
#  ---- ------- ---------- --------- ---------- ---------
#  1    43158   11085301507511 27-AUG-14 11085301553660 27-AUG-14
#  1    43159   11085301553660 27-AUG-14 11085301596363 27-AUG-14
##
##
####################################################################

export ORACLE_HOME=/oracle/db_home
export ORACLE_SID=ORCL

/oracle/db_home/bin/rman target= / << EOF
run {
allocate channel c1 type disk;
allocate channel c2 type disk;

set NEWNAME for datafile 1 to '/data/oradata/ORCL/system01.dbf';
set NEWNAME for datafile 2 to '/data/oradata/ORCL/undotbs01.dbf';
set NEWNAME for datafile 3 to '/data/oradata/ORCL/sysaux01.dbf';
set NEWNAME for datafile 4 to '/data/oradata/ORCL/users01.dbf';
set NEWNAME for datafile 5 to '/data/oradata/ORCL/DATAFILE01.DBF';
set NEWNAME for datafile 6 to '/data/oradata/ORCL/DATAFILE02.DBF';
set NEWNAME for datafile 7 to '/data/oradata/ORCL/DATAFILE03.DBF';
set NEWNAME for datafile 8 to '/data/oradata/ORCL/DATAFILE04.DBF';


SQL "ALTER DATABASE RENAME FILE ''/data2/ORCL/redolog/redo_file11.log'' TO ''/data/oradata/ORCL/redo_file11.log'' ";
SQL "ALTER DATABASE RENAME FILE ''/data2/ORCL/redolog/redo_file12.log'' TO ''/data/oradata/ORCL/redo_file12.log'' ";
SQL "ALTER DATABASE RENAME FILE ''/data2/ORCL/redolog/redo_file13.log'' TO ''/data/oradata/ORCL/redo_file13.log'' ";
SQL "ALTER DATABASE RENAME FILE ''/data2/ORCL/redolog/redo_file14.log'' TO ''/data/oradata/ORCL/redo_file14.log'' ";


SET UNTIL SCN 11085301596363;
restore database;
switch datafile all;
recover database;

release channel c1;
release channel c2;

## --Commented For Archive Log apply
## --alter database open resetlogs;

}
EXIT;
EOF


##################################
### COPY MISSING ARCHIVE LOGFILES
###################################

select REGEXP_SUBSTR(name,'[^/]+',2,3)
    from v$archived_log
    where archived = 'YES' and NEXT_CHANGE# >11085301596363
# vi filelist.txt
arc_1_790985659_43161.dbf
arc_1_790985659_43162.dbf
arc_1_790985659_43163.dbf
arc_1_790985659_43164.dbf
arc_1_790985659_43160.dbf
arc_1_790985659_43165.dbf
arc_1_790985659_43166.dbf
arc_1_790985659_43167.dbf
arc_1_790985659_43168.dbf
arc_1_790985659_43169.dbf
arc_1_790985659_43170.dbf
arc_1_790985659_43171.dbf
arc_1_790985659_43172.dbf
arc_1_790985659_43173.dbf
arc_1_790985659_43174.dbf
arc_1_790985659_43175.dbf
arc_1_790985659_43176.dbf
arc_1_790985659_43177.dbf

## Write it & Quit

#tar cvf arch_files.tar --files-from filelist.txt

#scp arch_files.tar oracle@xxx.xx.xx.xxx:/data/RESTORE/ORCL/ARCH

#tar xvf arch_files.tar

##########################
## ARCHIVED LOGS RECOVERY
##########################

select name,sequence#
    from v$archived_log
    where archived = 'YES' and NEXT_CHANGE# > 11085301596363;

SQL > recover database using backup controlfile until cancel;


/data/RESTORE/ORCL/ARCH/arc_1_790985659_43160.dbf 43160
/data/RESTORE/ORCL/ARCH/arc_1_790985659_43161.dbf 43161
/data/RESTORE/ORCL/ARCH/arc_1_790985659_43162.dbf 43162
/data/RESTORE/ORCL/ARCH/arc_1_790985659_43163.dbf 43163
/data/RESTORE/ORCL/ARCH/arc_1_790985659_43164.dbf 43164
/data/RESTORE/ORCL/ARCH/arc_1_790985659_43165.dbf 43165
/data/RESTORE/ORCL/ARCH/arc_1_790985659_43166.dbf 43166
/data/RESTORE/ORCL/ARCH/arc_1_790985659_43167.dbf 43167
/data/RESTORE/ORCL/ARCH/arc_1_790985659_43168.dbf 43168
/data/RESTORE/ORCL/ARCH/arc_1_790985659_43169.dbf 43169
/data/RESTORE/ORCL/ARCH/arc_1_790985659_43170.dbf 43170
/data/RESTORE/ORCL/ARCH/arc_1_790985659_43171.dbf 43171
/data/RESTORE/ORCL/ARCH/arc_1_790985659_43172.dbf 43172
/data/RESTORE/ORCL/ARCH/arc_1_790985659_43173.dbf 43173
/data/RESTORE/ORCL/ARCH/arc_1_790985659_43174.dbf 43174
/data/RESTORE/ORCL/ARCH/arc_1_790985659_43175.dbf 43175
/data/RESTORE/ORCL/ARCH/arc_1_790985659_43176.dbf 43176
/data/RESTORE/ORCL/ARCH/arc_1_790985659_43177.dbf 43177   27.08.2014 12:25:18

######################
## QUICK CHECK !!!
## How to quickly check that Database is consistent after incomplete recovery (Point in Time Recovery) before OPEN RESETLOGS (Doc ID 1354256.1)
################################
SQL > select file#, substr(name, 1, 50), substr(tablespace_name, 1, 15) from v$datafile_header where fuzzy='YES' ;


SQL > alter database open resetlogs;

##############################################
###
###   RECOVERY COMPLETED
###
##############################################


####################
## -- TEMP FILE ADD
## -- select 'ALTER TABLESPACE ' || TABLESPACE_NAME ||  ' ADD TEMPFILE '   || '''' || '/oradata1/oradata/ORCL/' || REGEXP_SUBSTR(FILE_NAME,'[^/]+',3,4) || '''' || ' size 1G reuse autoextend on next 100M maxsize 5G;' from DBA_TEMP_FILES order by FILE_NAME asc;
####################

SQL> alter tablespace temp drop tempfile '/data2/ORCL/datafile/temp01.dbf';
SQL> alter tablespace temp drop tempfile '/data2/ORCL/datafile/temp02.dbf';
SQL> alter tablespace temp drop tempfile '/data2/ORCL/datafile/temp03.dbf';
SQL> ALTER TABLESPACE TEMP ADD TEMPFILE '/data/oradata/ORCL/temp01.dbf' size 1G reuse autoextend on next 100M maxsize 5G;
SQL> ALTER TABLESPACE TEMP ADD TEMPFILE '/data/oradata/ORCL/temp02.dbf' size 1G reuse autoextend on next 100M maxsize 5G;
SQL> ALTER TABLESPACE TEMP ADD TEMPFILE '/data/oradata/ORCL/temp03.dbf' size 1G reuse autoextend on next 100M maxsize 5G;



SQL > select dbid from v$database;
SQL > select host_name from v$instance;

FTP File Copy Between Windows & Linux Machines

You can copy all files in a directory from Windows  to Linux  Server via below script.

/usr/bin/ftp -v -n 10.10.0.1 << EOF > /u01/Copy.log
user username password
cd copy_directory
bin
prompt
mget *
quit
EOF

Linux Bash Script Find Percentage Your Job (Copy , Restore ... )

If you got bored entering "du -sh" command when how much percantage done copying or restoring your database just copy below script your command prompt in that directory . And also don't forget to change Estimated_Total parameter which is your total size's of files.


 for i in {1..200} ;
do
 set -- `(du -h| sed 's/\([0-9]*\)\(.*\)/\1/')`;
 size=$1;
 Estimated_Total=375;
 echo "Estimated Percent %" $(((100 * $1)/Estimated_Total)) " Restored Size $1G";
 sleep 10;
done

Output ;

Estimated Percent % 77  Restored Size 289G
Estimated Percent % 77  Restored Size 289G
Estimated Percent % 77  Restored Size 290G

Find Specific Word in View Source Code

You can search a specific word in all views source code . And also you can configure this simple code  for package,procedure ... etc .

DECLARE
 CURSOR C1 IS  select VIEW_NAME,OWNER from dba_views where owner not in ('SYS','SYSTEM','DBSNMP','WMSYS','EXFSYS','CTXSYS','XDB','ORDSYS','ORDDATA','MDSYS','OLAPSYS','SYSMAN','RMAN','APEX_030200');
v_output CLOB :=NULL;
BEGIN
FOR C1_REC in C1 LOOP
 select (select * from ( select DBMS_METADATA.GET_DDL('VIEW' ,  C1_REC.VIEW_NAME, C1_REC.OWNER ) AS "TT"   from DUAL) where TT  like ('%@YOUR_WORD%') )   INTO v_output from DUAL ;
IF v_output is not null then
DBMS_OUTPUT.PUT_LINE(C1_REC.OWNER ||'.' || C1_REC.VIEW_NAME);
   v_output :=NULL;
END IF;  
END LOOP;
END;
/

12C Grid Control Manual Target Agent Delete

When deleting agent in 12C grid Console an error appering like that "Unknown error. java.sql.SQLException: ORA-20242: Target myhost.mydomain.com:3875:oracle_emd is monitoring other targets. It cannot be deleted

ORA-06512: at "SYSMAN.MGMT_ADMIN", line 484

ORA-06512: at "SYSMAN.MGMT_ADMIN", line 876

ORA-06512: at line 1"


You need clean manually target host from 12C Enterprise Manager.


cd $OMS_HOME/bin


[oracle@myhost bin]$ ./emcli login -username=sysman -password=<sysman password >


[oracle@myhost bin]$ ./emcli get_targets

[oracle@myhost bin]$ ./emcli sync

[oracle@myhost bin]$ ./emcli delete_target -name=<Target IP> -type="host"

Target "xx.xx.xx.xx:host" deleted successfully


[oracle@myhost bin]$ ./emcli delete_target -name=<Target IP>:3875 -type="oracle_emd"


Target "<Target IP>:3875:oracle_emd" deleted successfully


After deleting target host , you can configure this agent again ..

Oracle EM 12c Cloud Control Mail Configuration

For mail server configuration , you should set up  smtp server configuration.

Setup - > Notifications - > Notification Methods

Enter your smtp server ip and also enter user/pass if  it is authenticated by username/password your smtp server. 

I will show up alert configuration in my next blog ...

Oracle Enterprise Manager 12c Notes

Oracle Enterprise Manager 12c Cloud Control comes with up great features for database management. I decided to share my notes about EM 12c management , installation and configuration ...

Using the blkid Command getting UUID information disks

When failure of "scsi_id" command during ASM installation with udev rules, you can use "blkid" command to get UUID information of disks.

~]# blkid
/dev/vda1: UUID="7fa9c421-0054-4555-b0ca-b470a97a3d84" TYPE="ext4"
/dev/vda2: UUID="7IvYzk-TnnK-oPjf-ipdD-cofz-DXaJ-gPdgBW" TYPE="LVM2_member"
/dev/mapper/vg_kvm-lv_root: UUID="a07b967c-71a0-4925-ab02-aebcad2ae824" TYPE="ext4"
/dev/mapper/vg_kvm-lv_swap: UUID="d7ef54ca-9c41-4de4-ac1b-4193b0c1ddb6" TYPE="swap"

For instance, to display information about /dev/vda1, type:

~]# blkid /dev/vda1
/dev/vda1: UUID="7fa9c421-0054-4555-b0ca-b470a97a3d84" TYPE="ext4"

You can also use the above command with the -p and -o udev command line options to obtain more detailed information. Note that root privileges are required to run this command:

blkid -po udev device_name

For example:

~]# blkid -po udev /dev/vda1
ID_FS_UUID=7fa9c421-0054-4555-b0ca-b470a97a3d84
ID_FS_UUID_ENC=7fa9c421-0054-4555-b0ca-b470a97a3d84
ID_FS_VERSION=1.0
ID_FS_TYPE=ext4
ID_FS_USAGE=filesystem

Can SCAN IP be used for ftp of files ?

SCAN IP's can be used for ftp ,sftp and also ssh connection during rac cluster service already running . Because when cluster services are running scan ip's nic bonding to public network interface for example ;

In RAC Node1

oracle@testdbrac1:/oracle:>ifconfig -a

eth0      Link encap:Ethernet  HWaddr 00:50:56:B8:40:B0 

          inet addr:PUBLIC IP  Bcast:xxx.x.x.xxx  Mask:255.255.255.0

          inet6 addr: fe80::250:56ff:feb8:40b0/64 Scope:Link

          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

          RX packets:1006522 errors:0 dropped:0 overruns:0 frame:0

          TX packets:92530 errors:0 dropped:0 overruns:0 carrier:0

          collisions:0 txqueuelen:1000

          RX bytes:99913091 (95.2 MiB)  TX bytes:32001574 (30.5 MiB)

eth0:2    Link encap:Ethernet  HWaddr 00:50:56:B8:40:B0 

          inet addr:SCAN IP_1  Bcast:xxx.x.x.xxx  Mask:255.255.255.0

          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

In RAC Node 2

oracle@testdbrac2:/oracle:>ifconfig -a

eth0      Link encap:Ethernet  HWaddr 00:50:56:B8:40:B1 

          inet addr:PUBLIC IP  Bcast:xxx.x.x.xxx  Mask:255.255.255.0

          inet6 addr: fe80::250:56ff:feb8:40b1/64 Scope:Link

          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

          RX packets:1004162 errors:0 dropped:0 overruns:0 frame:0

          TX packets:69260 errors:0 dropped:0 overruns:0 carrier:0

          collisions:0 txqueuelen:1000

          RX bytes:100817580 (96.1 MiB)  TX bytes:15328431 (14.6 MiB)

eth0:2    Link encap:Ethernet  HWaddr 00:50:56:B8:40:B1 

          inet addr:SCAN IP_2  Bcast:xxx.x.x.xxx  Mask:255.255.255.0

          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

eth0:3    Link encap:Ethernet  HWaddr 00:50:56:B8:40:B1 

          inet addr:SCAN IP_3  Bcast: xxx.x.x.xxx  Mask:255.255.255.0

          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

You can also check output command "ifconfig -a"  when rac services are not running. If you are planning for failover scenarios , it is reasonably.

Calculating optimal ulimit with RDA - Health Check

That's params from installation docs :

Open file descriptors	nofile	at least 1024	at least 65536
Number of processes available to a single user	nproc	at least 2047	at least 16384
Size of the stack segment of the process	stack	at least 10240 KB	at least 10240 KB, and at most 32768 KB

 We can confirm these parameters with RDA - Health Check utility. RDA - Health Check / Validation Engine Guide (Doc ID 250262.1)

ASM - Disk Operations

DROP DISKGROUP

SQL> column HEADER_STATUS format a20
SQL> set pages 100
SQL> col PATH format a25
SQL> SELECT name, header_status, path FROM V$ASM_DISK ;

NAME                           HEADER_STATUS        PATH
------------------------------ -------------------- -------------------------
                               CANDIDATE            /dev/asm-disk8
                               CANDIDATE            /dev/asm-disk6
                               CANDIDATE            /dev/asm-disk7
DATA_0000                      MEMBER               /dev/asm-disk1
DATA2_0000                     MEMBER               /dev/asm-disk4
DATA_0002                      MEMBER               /dev/asm-disk3
DATA2_0001                     MEMBER               /dev/asm-disk5
DATA_0001                      MEMBER               /dev/asm-disk2

DROP DISKGROUP DATA2 INCLUDING CONTENTS;
drop diskgroup DATA2 force including contents;

Rac-Node2

oracle@testdbrac2:/oracle:>grid_env
oracle@testdbrac2:/oracle:>sqlplus "/as sysasm"

SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 28 10:49:18 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL>  select GROUP_NUMBER, NAME, state from v$asm_diskgroup;

GROUP_NUMBER NAME                           STATE
------------ ------------------------------ -----------
           1 DATA                           MOUNTED
           2 DATA2                          MOUNTED

SQL> alter diskgroup DATA2 dismount;

Diskgroup altered.

SQL> select GROUP_NUMBER, NAME, state from v$asm_diskgroup;

GROUP_NUMBER NAME                           STATE
------------ ------------------------------ -----------
           1 DATA                           MOUNTED
           0 DATA2                          DISMOUNTED

Oracle 11g Grid Uninstall

You can uninstall oracle grid infrastructure via two way ;

Run the following commands with root user

Rac Node1
cd /oracle/app/11.2.0/grid/crs/install
 perl rootcrs.pl -deconfig -force

Rac Node2
cd /oracle/app/11.2.0/grid/crs/install
perl rootcrs.pl -deconfig -force -lastnode

Or (again need root user ) ;

Compressing Export Dump File On The Fly

If you don't have enough storage to keep export dump file on server , you can compress your dump file when export is running.

mkfifo pipe.dmp
gzip  < pipe.dmp > expdat.dmp.z &
exp user/passwd full=y file=pipe.dmp

Redolog File Block Corruption Database Recovery Without Any Backup

First Error with oracle database -

UDE-01034: operation generated ORACLE error 1034
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Solaris-AMD64 Error: 2: No such file or directory
UDE-00003: all allowable logon attempts failed

Related memory error in alert.log file
-------------------------------------

Starting ORACLE instance (normal)
WARNING: The system does not seem to be configured
optimally. Creating a segment of size 0x000000004c000000
failed. Please change the shm parameters so that
a segment can be created for this size. While this is
not a fatal issue, creating one segment may improve
performance


We check the memory because of kernel parameters not configured properly.

oracle@xxxx:/data/oracle:>prtconf | grep Mem
Memory size: 4096 Megabytes

oracle@xxxx:/data/oracle:>id -p
uid=610(oracle) gid=610(dba) projid=100(user.oracle)

Determine Endian Format When Migration Oracle Database Across OS Platform

When migrating Oracle Database to different platform , first of all you should check your endian format for both platforms (old and new ). You can determine via sqlplus with below command.


SQL> COLUMN PLATFORM_NAME FORMAT A32
SQL> SELECT * FROM V$TRANSPORTABLE_PLATFORM;

PLATFORM_ID PLATFORM_NAME                    ENDIAN_FORMAT
----------- -------------------------------- --------------
          1 Solaris[tm] OE (32-bit)          Big
          2 Solaris[tm] OE (64-bit)          Big
          7 Microsoft Windows IA (32-bit)    Little
         10 Linux IA (32-bit)                Little
          6 AIX-Based Systems (64-bit)       Big
          3 HP-UX (64-bit)                   Big
          5 HP Tru64 UNIX                    Little
          4 HP-UX IA (64-bit)                Big
         11 Linux IA (64-bit)                Little
         15 HP Open VMS                      Little
          8 Microsoft Windows IA (64-bit)    Little
          9 IBM zSeries Based Linux          Big
         13 Linux 64-bit for AMD             Little
         16 Apple Mac OS                     Big
         12 Microsoft Windows 64-bit for AMD Little
         17 Solaris Operating System (x86)   Little

If you are not sure ;
You can use this command on unix shell

echo I | tr -d [:space:] | od -to2 | head -n1 | awk '{print $2}' | cut -c6

IF return 0  ->  Big Endian
IF return 1  ->  Little Endian

After determination endian format , you can choose your methodology for migration operation.Check Oracle Support Note:Migration Of An Oracle Database Across OS Platforms (Generic Platform) (Doc ID 733205.1)

Oracle 10gR1 on Linux installation error

Due to  certified Oracle RDBMS 10gR1  on Linux 4 , installation process failed when trying to starting runInstaller.

Online Datafile Move : 12c Database New Feature

-rw-r-----. 1 oracle oinstall  52429312 Jul 16 09:49 redo03.log
-rw-r-----. 1 oracle oinstall  52429312 Jul 16 10:19 redo01.log
-rw-r-----. 1 oracle oinstall   5251072 Jul 16 10:24 users01.dbf
-rw-r-----. 1 oracle oinstall  92282880 Jul 16 10:45 temp01.dbf
-rw-r-----. 1 oracle oinstall 277880832 Jul 16 10:50 undotbs01.dbf
-rw-r-----. 1 oracle oinstall 828383232 Jul 16 10:51 system01.dbf
-rw-r-----. 1 oracle oinstall 859840512 Jul 16 10:51 sysaux01.dbf
-rw-r-----. 1 oracle oinstall  52429312 Jul 16 10:51 redo02.log
-rw-r-----. 1 oracle oinstall  17973248 Jul 16 10:52 control01.ctl
-rw-r-----. 1 oracle oinstall 828383232 Jul 16 10:52 system02.dbf

[oracle@cdb12c ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 12.1.0.1.0 Production on Tue Jul 16 10:51:53 2013

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> alter database move datafile '/u01/app/oracle/oradata/test12c/system01.dbf' to '/u01/app/oracle/oradata/test12c/system02.dbf';

Database altered.

Linux display Error while running firefox

While opening firefox " Xlib: extension "RANDR" missing on display message appeared  and failed to open display on my machine. I installed the gtk2-engines and passed this interesting error.

[root@mytest ~]# firefox
Xlib:  extension "RANDR" missing on display "xx.xx.xx.xx:0.0".
Error: cannot open display: xx.xx.xx.xx:0.0

Xlib:  extension "RANDR" missing on display ":0"

Oracle Database 12c Installation Step by Step on Oracle Linux 6.4

Newly announced Oracle Database 12c (12.1.0.1) comes with new features ; especially pluggable database , changings behaviour of CBO etc ... 

I downloaded latest Oracle Linux from http://edelivery.oracle.com and installed into Oracle Virtualbox .

Unzip files 

unzip linuxamd64_12c_database_1of2.zip
unzip linuxamd64_12c_database_2of2.zip 

  

Configure your /etc/hosts file

127.0.0.1   localhost localhost.localdomain 

xx.xxx.xx.xx cdb12c cdb12c.mytest

You can configure parameters for now or later. I skipped this step because of when installer checking prerequsite step it generates a bash script for correcting these parameters. 

Add or amend the following lines in the "/etc/sysctl.conf" file.

After installation VirtualBox 4.2.14 for Windows hosts from https://www.virtualbox.org/wiki/Downloads an error message appeared like below

Failed to create the VirtualBox COM object.
The application will now terminate.

Callee RC:

CO_E_SERVER_EXEC_FAILURE (0x80080005)

A bit digging in Virtualbox logs (Document and Settings\.Virtualbox ,


VirtualBox COM Server 4.2.14 r86644 win.x86 (Jun 21 2013 16:12:11) release log
00:00:00.000000 main     Log opened 2013-06-26T09:55:00.622000300Z
00:00:00.000000 main     OS Product: Windows 7
00:00:00.000000 main     OS Release: 6.1.7601
00:00:00.000000 main     OS Service Pack: 1
00:00:00.015000 main     DMI Product Name: HP Compaq Pro 6300 SFF
00:00:00.031000 main     DMI Product Version: 
00:00:00.031000 main     Host RAM: 3476MB total, 1787MB available
00:00:00.031000 main     Executable: C:\Program Files\Oracle\VirtualBox\VBoxSVC.exe
00:00:00.031000 main     Process ID: 5960
00:00:00.031000 main     Package type: WINDOWS_32BITS_GENERIC
00:00:00.764000          VDInit finished

00:00:05.881000 Watcher  ERROR [COM]: aRC=E_ACCESSDENIED (0x80070005) aIID={3b2f08eb-b810-4715-bee0-bb06b9880ad2} aComponent={VirtualBox} aText={The object is not ready}, preserve=false

Just run program as administrator and problem solved.