Cluster/HA2012. 11. 2. 09:56


Quick guide: how to manage Redhat Cluster in RHEL 5

Check cluster status


[root@ncs-db-1 ~]# clustat
Cluster Status for ncs_dbcluster @ Wed Sep 1 15:22:08 2009
Member Status: Quorate

Member Name ID Status
------ ---- ---- ------
ncs-db-n1 1 Online, Local, rgmanager
ncs-db-n2 2 Online, rgmanager

Service Name Owner (Last) State
------- ---- ----- ------ -----
service:clusvc ncs-db-n1 started


Disable cluster status
After disable, resource group shutdown and will not affect by server reboot and/or failover.


[root@ncs-db-1 ~]# clusvcadm -d clusvc
Local machine disabling service:clusvc...Success



Enable cluster status


[root@ncs-db-1 ~]# clusvcadm -e clusvc
Local machine trying to enable service:clusvc...Success
service:clusvc is now running on ncs-db-n1


Freeze cluster resource group
After freeze resource group, it will not being monitored by the cluster manager. But current resource group state will not be affected by this command.


[root@ncs-db-1 ~]# clusvcadm -Z clusvc
Local machine freezing service:clusvc...Success


Unfreeze cluster resource group


[root@ncs-db-1 ~]# clusvcadm -U clusvc
Local machine unfreezing service:clusvc...Success



Stop cluster resource group
Resource group can failover if current node due to fencing.


[root@ncs-db-1 ~]# clusvcadm -s clusvc
Local machine stopping service:clusvc...Success



Restart cluster resource group
Resource group can failover if current node due to fencing.


[root@ncs-db-1 ~]# clusvcadm -s clusvc
Local machine stopping service:clusvc...Success


Relocate resource to another member in the failover domain


[root@ncs-db-1 ~]# clusvcadm -r clusvc -m ncs-db-n2
Trying to relocate service:clusvc to ncs-db-n2...Success
service:clusvc is now running on ncs-db-n2


Other useful commands


[root@ncs-db-1 ~]# ccs_tool lsnode

Cluster name: ncs_dbcluster, config_version: 21

Nodename Votes Nodeid Fencetype
ncs-db-n1 1 1 ncs-db-1-ilo1
ncs-db-n2 1 2 ncs-db-2-ilo2



[root@ncs-db-1 ~]# cman_tool status
Version: 6.1.0
Config Version: 21
Cluster Name: ncs_cluster
Cluster Id: 27444
Cluster Member: Yes
Cluster Generation: 1796
Membership state: Cluster-Member
Nodes: 2
Expected votes: 1
Total votes: 2
Quorum: 1
Active subsystems: 9
Flags: 2node Dirty
Ports Bound: 0 11 177
Node name: ncs-db-n1
Node ID: 1
Multicast addresses: xxx.xxx.xxx.xxx
Node addresses: xxx.xxx.xxx.xxx

http://www.dbaglobe.com/search/label/Redhat

Posted by [TheWon]
Information2012. 8. 7. 10:19

 

AIXParameter ‘stack’ (KB) in file /etc/security/limits
LinuxParameter ‘stack’ (KB) in file /etc/security/limits.conf
Tru64Parameter ‘max_per_proc_stack_size’ in file /etc/sysconfigtab
HP-UX 64 bitParameter ‘maxssiz_64bit’ in file /stand/system default 256MB
HP-UX 32 bitParameter ‘maxssiz’ in file /stand/system default 8MB
SUN Solaris pre 9No file derived parameter use ulimit –s command
SUN Solaris 9 & 10Parameter ‘process.max-stack-size’ in file /etc/project

http://www.actian.com/kb/article/415757


Posted by [TheWon]
Information2012. 7. 27. 15:56

TPC http://www.tpc.org
SPEC http://www.spec.org
LINPACK http://www.netlib.org/benchmark/performance.pdf
Pro/E http://www.proe.com
GPC http://www.spec.org/gpc
VolanoMark http://www.volano.com
STREAM http://www.cs.virginia.edu/stream/
SAP http://www.sap.com/benchmark/
Oracle, Siebel, PeopleSoft http://www.oracle.com/us/solutions/benchmark/apps-benchmark/
Baan http://www.ssaglobal.com
Fluent http://www.fluent.com/software/fluent/index.htm
TOP500 Supercomputers http://www.top500.org/
Ideas International http://www.ideasinternational.com/benchmark/bench.html
Storage Performance Council http://www.storageperformance.org/results

Posted by [TheWon]
HW/OS2012. 4. 30. 16:51

http://msdn.microsoft.com/en-us/library/windows/desktop/aa366778(v=vs.85).aspx


Posted by [TheWon]
DBMS/Oracle2012. 4. 4. 15:58

11.2 
  AiX 버전과 최소 Level: 
    5.3
    6.1 
    7.1 - requires 11.2.0.3

  See Database Installation Guide 11g Release 2 (11.2) for IBM AIX on Power Systems for the Minimum Operating System Requirements. 
    All 11.2 AIX Installation Guides 
  ACFS:
    Requires a minimum OS level of AIX 6.1 TL4 SP2 and Grid Infrastructure 11.2.0.2 or later
    For AIX 7.1 requires minimum Grid Infrastructure version 11.2.0.2.4 or 11.2.0.3.0
  Oracle Database products are tested and certified on the AIX 5, AIX 6, and AIX 7 operating systems. The customers must install the follow APARs (IBM OS Patches) on AIX7.1:

    IZ87216
    IZ87564
  Exceptions: 
    AIX 7.1

      Customers must install the follow APARs (IBM OS Patches) on AIX7.1:

        IZ87216 
        IZ87564


11.1
  AiX 버전과 최소 Level:

    5.3
    6.1 TL00 SP4 and higher
  See Database Installation Guide 11g Release 1 (11.1) for IBM AIX on Power for the Minimum Operating System Requirements. 
    All 11.1 AIX Installation Guides


10.2
  AiX 버전과 최소 Level: 

    5.2
    5.3
    6.1
  See Database Installation Guide for AIX 5L Based Systems (64-Bit) for the Minimum Operating System Requirements. All 10.2 Installation Guides


10.1
  10.1 is in Extended Support as of February 1, 2009. See Oracle Lifetime 
  Support Policy - Technology for more details.
  AiX 버전과 최소 Level: 

    5.1
    5.2 Maintenance level 1 or higher. The following APARS are required: 
      IY43980
      IY44810 
      IY45462 
      IY45707 
      IY46214 
      IY46605 
      IY51801
      The following filesets must be installed and committed: 
      bos.adt.base 
      bos.adt.lib 
      bos.adt.libm 
      bos.perf.libperfstat 
      bos.perf.perfstat 
      bos.perf.proctools \
    5.3


9.2
  All support for 9.2 ended as of July 31, 2010.  See Oracle Lifetime Support Policy - Technology for more details. 
  AiX 버전과 최소 Level:   

    5.1
    5.2
    5.3

 

Posted by [TheWon]