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

RMAN backup restore large files Oracle Database 12C release 1 (12.1)

Posted on by
1

There are two important improvements in making big datafile backups and restores in Oracle 12C release 1

  • multisection backup of image copies
  • multisection backup of incremental backups for level higher than 0

Multisection option was introduced in 11G and possible only for:

  • multisection backup of backup sets
  • multisection backup of full backup
  • multisection backup of incremental backups for level 0

Requirements and restrictions

  • COMPATIBLE must be set to 12.0 or higher
  • Not for control files or spfiles

Continue reading →

Session sequence Oracle Database 12C release 1 (12.1)

Posted on by
Reply

In Oracle Database 12C new keywords SESSION, GLOBAL are available that can be specified during a sequence creation 

CREATE SEQUENCE session_seq START WITH 1 INCREMENT BY 1 SESSION;
CREATE SEQUENCE global_seq START WITH 1 INCREMENT BY 1 GLOBAL;

GLOBAL – creates standard sequence well known in previous release. This is the default.

SESSION – creates new type session sequence, which is a special type of sequence that is specifically designed to be used with global temporary tables that have session visibility.  Session sequence returns a unique range of sequence numbers only within a session, but not across sessions. Another difference is that session sequences are not persistent. If a session goes away, so does the state of the session sequences that were accessed during the session.

Session sequences must be created by a read-write database but can be accessed on any read-write or read-only databases (either a regular database temporarily open read-only or a standby database).

CACHE, NOCACHE,NOORDER are ignored when specified with SESSION calues

Continue reading →