Category Archives: Installations

Install Oracle in silent mode 11G Release 2 (11.2) on OEL6

Posted on by
12

This article presents how to install Oracle 11G Release 2 in silent mode.

Silent mode installation allows to configure necessary Oracle components without using graphical interface nor any interaction with end user. It’s very useful method especially when you want to prepare standard installation using shell scripts.

Read following article how to install Oracle Enterprise Linux 6: Install Oracle Enterprise Linux 6 (for comfort set 4G memory for your virtual machine before proceeding with Oracle software installation).

Installation software is available on OTN version 11.2.0.1 or metalink 11.2.0.4. In this installation I’m presenting installation for 11.2.0.4 but for previous version 11.2.0.X it shouldn’t be different.

Following components will be installed in silent mode:

  • oracle binaries: Oracle Enterprise Edition 11G Release 2
  • network components: listener LISTENER
  • database components: database ORA11G.dbaora.com and database console

Oracle software that was verified

release 11.2.0.4

p13390677_112040_Linux-x86-64_1of7.zip 
p13390677_112040_Linux-x86-64_2of7.zip

Continue reading →

Configure physical standby database Oracle Database 11G release 2 (11.2)

Posted on by
1

This article presents how to configure physical standby database for Oracle Database 11G release 2 (11.2). It’s not focusing on transportation method, duplication method, protection modes nor extra functionality available for physical standbys. All above will be part of future articles :).

This presentation is based on the following article Install Oracle 11G Release 2 (11.2) on Oracle Linux 7 (OEL7).

Architecture

Final standby configuration is very simple:

  • one host: oel7.dbaora.com – already configured with latest binaries Oracle Database 11G
  • primary database: ORA11G
  • listener LISTENER – already installed
  • standby database: SORA11G – this article shows how to configure it
  • standby configuration will work in default mode MAXIMUM PERFORMANCE

standby_physical_11g_01

Continue reading →

Install Oracle 11G Release 2 (11.2) on Fedora 21

Posted on by
Reply

This article presents how to install Oracle 11G on Fedora 21.

Read following article how to install Fedora 21 Linux: Install Fedora 21 (for comfort set 4G memory for your virtual machine before proceeding with Oracle software installation).

Installation software is available on OTN version 11.2.0.1 or metalink 11.2.0.4. In this installation I’m presenting installation for 11.2.0.4 but for previous version 11.2.0.X it shouldn’t be different.

Check article for new release Install Oracle 12C Release 1 (12.1) on Fedora 21

Oracle software that was verified

release 11.2.0.4

p13390677_112040_Linux-x86-64_1of7.zip 
p13390677_112040_Linux-x86-64_2of7.zip

Continue reading →

Install Fedora 21

Posted on by
Reply

This article presents how to install Fedora 21 – Live Workstation version.

I assume you have already downloaded Fedora 21 64 bit Live Workstation(about 1,37 G) and you know how to use VirtualBox 64 bit(100M). Create virtual machine with default settings for Linux Fedora 64 bit. 2GB ram and 64G(includes extra space for Oracle installations) for disk is enough plus increase video memory to 128M. Rest of options you can keep default.

Fedora21_1

Continue reading →

Configure physical standby database Oracle Database 12C release 1 (12.1)

Posted on by
3

This article presents how to configure physical standby database for Oracle Database 12C release 1 (12.1). It’s not focusing on transportation method, duplication method, protection modes nor extra functionality available for physical standbys. All above will be part of future articles :).

This presentation is based on the following article Install Oracle 12C Release 1 (12.1) on Oracle Linux 6 (OEL6).

Architecture

Final standby configuration is very simple:

  • one host: oel6.dbaora.com – already configured with latest binaries Oracle Database 12C
  • primary database: ORA12C – already installed container database has one pluggable database PORA12C1 and SEED template database
  • listener LISTENER – already installed
  • standby database: SORA12C – this article shows how to configure it
  • standby configuration will work in default mode MAXIMUM PERFORMANCE

standby_physical_12c_01

Continue reading →

ORA-00845: MEMORY_TARGET not supported on this system

Posted on by
Reply

During installation of Oracle you can encounter typical error commonly know by DBAs

ORA-00845: MEMORY_TARGET not supported on this system

Oracle is using for automatic memory management Linux shared segments. Usually they are too small but you can modify it on-the-fly.

Just modify entry in “/etc/fstab” to have persistent settings between reboot of your machine. Here shared segments are set to 2500M.

tmpfs   /dev/shm   tmpfs  size=2500M  0 0

remount it

mount -o remount tmpfs

and verify

mount | grep tmpfs
tmpfs on /dev/shm type tmpfs (rw,size=2500M)

to see what is using shared segments run following command

[oracle@oel6 ~]$ ipcs -m

------ Shared Memory Segments --------
key        shmid      owner    perms  bytes  nattch  status      
0x00000000 158433298  oracle   640    4096   0      
0x00000000 158466067  oracle   640    4096   0      
0x00000000 158498836  oracle   640    4096   0      
0x9d984658 158531605  oracle   640    12288  49

Have a fun 🙂
Tomasz

Install Oracle 11G Release 2 (11.2) on Suse Linux 11 (SLES11)

Posted on by
1

This article presents installation of Oracle database 11G Release 2 on Suse Linux Enterprise Server 11.

Read following article how to install Suse Linux Enterprise Server 11: Install Suse Linux Enterprise Server 11 SP3 64 bit(for comfort set 2G memory for your virtual machine).

During installation of Suse LES 11 user oracle and both group dba and oinstall are created. However I drop the user and groups and recreate them.

Software

Software for 11G R2 is available on OTN, edelivery or oracle support

Suse11 requires version Linux x86-64. In this presentation I’m using and always referring to version 11.2.0.4 downloaded from Oracle support page.

Binaries 11.2.0.4

p13390677_112040_Linux-x86-64_1of7.zip - database software  
p13390677_112040_Linux-x86-64_2of7.zip - database software

Requirements

Be sure you fulfill following:

  • SuSE Linux Enterprise Server (SLES) 11, which is Kernel 2.6.27.19-5 or newer.

Continue reading →

Install Ubuntu 14

Posted on by
Reply

This article presents how to install Ubuntu 14.

I assume you have already downloaded Ubuntu 14 64 bit(about 1 G) and you know how to use VirtualBox 64 bit(100M). Create virtual machine with default settings for Linux Ubuntu 64 bit. 2GB ram (I set 4GB for future Oracle database installation) and 64G for disk is enough plus increase video memory to 128M and turn on acceleration 3D. Rest of options you can keep default.

Ubuntu_01

Continue reading →

Install Oracle 12C Release 1 (12.1) on Centos Linux 7

Posted on by
11

This article presents how to install Oracle 12C(12.1.0.1) Release 1 on Centos Linux 7.

Read following article how to install Centos Linux 7: Install Centos Linux 7 (for comfort set 2G memory for your virtual machine before proceeding with Oracle software installation).

Software

Software for 12CR1 is available on OTN or edelivery

Database software

linuxamd64_12c_database_1of2.zip 
linuxamd64_12c_database_2of2.zip

Continue reading →