Oracle 12c Database Installation on Virtual Box

Environment:

Oracle 12c  Database
Virtual Box 4
Oracle Linux 6

unzip /tmp/linuxamd64_12c_database_1of2.zip -d /u01/app/oracle/software
unzip /tmp/linuxamd64_12c_database_2of2.zip -d /u01/app/oracle/software

Restore SQL Server 2012 Database on Windows Server 2012

Restore SQL Server 2012 Database using SQL Server Management Studio.

Installing NetFx3 on Windows Server 2012

Installing SQL Server 2012 on a Windows Server 2012 virtual machine, and the installation was already in progress when we received the following error:

Upgrade Oracle11g Patch Set 11.2.0.3.0

Patch No 10404530         Oracle Database Family: Patchset

                                          11.2.0.3.0 Patch Set For Oracle Database Server

Download from below site.

https://updates.oracle.com/Orion/PatchDetails/process_form?patch_num=10404530&aru=14125322&plat_lang=226P&release=80112030&no_header=1

Unzip the 1of7 & 2of7 files

$./runInstaller

$ ORACLE_HOME=/oracle11/oraupgrade11
$ export ORACLE_HOME
$ ORACLE_SID=oratest
$ export ORACLE_SID

ORA-00845: MEMORY_TARGET not supported on this system

This error comes up because you tried to use the Automatic Memory Management (AMM) feature of Oracle 11g R2. Well done, but it seems that your shared memory filesystem (shmfs) is not big enough. So let’s look at the steps necessary to enlarge your shared memory filesystem to avoid the error below.



[oracle@oracle12c bin]$ ./sqlplus /nolog

SQL*Plus: Release 12.1.0.1.0 Production on Tue Aug 06 12:51:43 2013

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

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system

$ exit

[root@oracle12c ~]# df -h

Filesystem            Size  Used Avail Use% Mounted on

/dev/mapper/vg_oracle12c-lv_root

                          50G   18G   30G  37% /

tmpfs                  1002M  480M  522M  48% /dev/shm

/dev/sda1           485M   48M  412M  11% /boot

/dev/mapper/vg_oracle12c-lv_home

                          39G   36G  1.2G  97% /ora

ora                     173G   15G  159G   9% /media/sf_ora

p1                      293G   84G  210G  29% /media/sf_p1

/dev/sr0              55M   55M     0 100% /media/VBOXADDITIONS_4.2.10_84104

[root@oracle12c ~]# mount -t tmpfs shmfs -o size=1g /dev/shm

[root@oracle12c ~]# df -h

Filesystem            Size  Used Avail Use% Mounted on

/dev/mapper/vg_oracle12c-lv_root

                           50G   18G   30G  37% /

tmpfs                  1.0G     0  1.0G   0% /dev/shm

/dev/sda1           485M   48M  412M  11% /boot

/dev/mapper/vg_oracle12c-lv_home

                          39G   36G  1.2G  97% /ora

ora                     173G   15G  159G   9% /media/sf_ora

p1                      293G   84G  210G  29% /media/sf_p1

/dev/sr0              55M   55M     0 100% /media/VBOXADDITIONS_4.2.10_84104

shmfs                 1.0G     0  1.0G   0% /dev/shm

shmfs                 1.0G     0  1.0G   0% /dev/shm

To make the change presistent edit yout /etc/fstab file to include the option you specified.

[root@oracle12c ~]# cat /etc/fstab
[..]
tmpfs     /dev/shm   tmpfs   size 1g  0 0
[..]

[oracle@oracle12c bin]$ ./sqlplus /nolog

SQL*Plus: Release 12.1.0.1.0 Production on Tue Aug 06 13:01:19 2013

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

SQL> conn / as sysdba

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area  835104768 bytes

Fixed Size    2293880 bytes

Variable Size  562040712 bytes

Database Buffers  268435456 bytes

Redo Buffers    2334720 bytes

Database mounted.

Database opened.

SQL> 

Backup and Recovery of Pluggable Databases

Upgrade Oracle 11g to 12c Database

Environment:
-------------
Oracle VM Box 4.2
Oracle Linux 6.2 64-bit
Oracle 11.2.0.3.0 Database
Oracle 12.1.0.1.0 Database


Two ways to upgrade Oracle Databsae

1. Database Upgrade Assistant (DBUA).
2. Manual

• The  utlu121s.sql script has been replaced with the preupgrd.sql script. The new Pre-Upgrade Information Tool provides fix-up scripts with the ability to fix and address any issues identified by the pre-upgrade check script

• The previous upgrade script catupgrd.sql has been replaced with the new catctl.pl Parallel Upgrade Utility script which provides the ability to run upgrade scripts in parallel taking advantage of spare CPU capacity which can potentially reduce upgrade times

• If Flashback database is enabled, DBUA creates a guaranteed restore point which can be used in case we have a  failure in the upgrade process. We can also restart DBUA to recover from any failures during the upgrade.

• We can now use an existing RMAN backup which DBUA is aware of in case we need to restore the database to the pre-12c upgrade state

• Oracle XML DB is now a mandatory component of the Oracle 12c database and is automatically installed as part of the upgrade process if not found

• If Database Control from earlier release exists, we need to drop the same before upgrading the database. We can do this via DBUA or reduce the upgrade downtime by performing this task in advance by copying a new script emremove.sql from the 12c Oracle Hone and running it against the 11g database.

$ ./dbua