Oracle 11g R2 and T4-1 Performance Tunning

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

In alert log, below entries were found:
Deprecated system parameters with specified values:
  log_archive_start

Fix: alter system reset log_archive_start scope=spfile sid='*' ;

======
Performance Tunning with SPFILE


alter system set processes=20000 scope=spfile;
alter system set open_cursors=8000 scope=spfile;

alter system set pga_aggregate_target=13G scope=spfile;
alter system set sga_target=11G scope=spfile;
alter system set sga_max_size=11G scope=spfile;
alter system set memory_target=24G scope=spfile;
alter system set memory_max_target=24G scope=spfile;

alter system set recyclebin=OFF scope=spfile;
alter system set filesystemio_options=setall scope=spfile;


begin
for c in (select sid, serial# from v$session) loop
   dbms_system.set_int_param_in_session(c.sid,c.serial#,'session_cached_cursors', 200);
end loop;
end;
/

Oracle 11g R2: export table

ORA-20446: The owner of the job is not registered
ORA-06512: at “SYSMAN.MGMT_JOBS”, line 168
ORA-06512: at “SYSMAN.MGMT_JOBS”, line 86
ORA-06512: at line 1

Cause:

This is an Oracle bug in 11g, there is a fix available, you can use following workaround:

Fix
$ sqlplus /nolog
SQL> connect sysman/<password>
SQL> execute MGMT_USER.MAKE_EM_USER('USERID');

Oracle Linux 7: Network Bonding

Ref# http://www.unixmen.com/linux-basics-create-network-bonding-centos-6-5/

Create the bond
# nmcli con add type bond con-name bond0 ifname bond0 mode balance-rr
Add each interface to the bond:
# nmcli con add type bond-slave ifname em3 master bond0
# nmcli con add type bond-slave ifname em4 master bond0

Restart the NetworkManager service
# service NetworkManager restart

Types of Network Bonding

According the to the official documentation, here is the types of network bonding modes.

mode=0 (balance-rr)

Round-robin policy: It the default mode. It transmits packets in sequential order from the first available slave through the last. This mode provides load balancing and fault tolerance.

mode=1 (active-backup)

Active-backup policy: In this mode, only one slave in the bond is active. The other one will become active, only when the active slave fails. The bond’s MAC address is externally visible on only one port (network adapter) to avoid confusing the switch. This mode provides fault tolerance.

mode=2 (balance-xor)

XOR policy: Transmit based on [(source MAC address XOR'd with destination MAC address) modulo slave count]. This selects the same slave for each destination MAC address. This mode provides load balancing and fault tolerance.

mode=3 (broadcast)

Broadcast policy: transmits everything on all slave interfaces. This mode provides fault tolerance.

mode=4 (802.3ad)

IEEE 802.3ad Dynamic link aggregation. Creates aggregation groups that share the same speed and duplex settings. Utilizes all slaves in the active aggregator according to the 802.3ad specification.

Prerequisites:

- Ethtool support in the base drivers for retrieving the speed and duplex of each slave.
- A switch that supports IEEE 802.3ad Dynamic link aggregation. Most switches will require some type of configuration to enable 802.3ad mode.

mode=5 (balance-tlb)

Adaptive transmit load balancing: channel bonding that does not require any special switch support. The outgoing traffic is distributed according to the current load (computed relative to the speed) on each slave. Incoming traffic is received by the current slave. If the receiving slave fails, another slave takes over the MAC address of the failed receiving slave.

Prerequisite:

- Ethtool support in the base drivers for retrieving the speed of each slave.

mode=6 (balance-alb)

Adaptive load balancing: includes balance-tlb plus receive load balancing (rlb) for IPV4 traffic, and does not require any special switch support. The receive load balancing is achieved by ARP negotiation. The bonding driver intercepts the ARP Replies sent by the local system on their way out and overwrites the source hardware address with the unique hardware address of one of the slaves in the bond such that different peers use different hardware addresses for the server.