pat98's always & forever

*  Oracle 환경변수 (for 11g RAC)
umask 022
export ORACLE_OWNER=oracle
export ORACLE_BASE=/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0
export GRID_HOME=/oragrid/product/11.2.0
export ORACLE_SID=RAC1
export ORACLE_TERM=vt100
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS10=$ORACLE_HOME/nls/data
export NLS_LANG=American_America.KO16KSC5601
export PATH=$ORACLE_HOME/bin:/bin:/sbin:.:$PATH:$ORACLE_HOME/OPatch
export SHLIB_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/usr/lib:/lib:$ORACLE_HOME/rdbms/lib
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/usr/lib:/lib
export PS1=[`whoami`:'$PWD']#
export AIXTHREAD_SCOPE=S
alias ss='sqlplus "/as sysdba"'
stty erase ^H

-----------------------------------------

*  Oracle 환경변수 (HP-UX)
umask 022
export ORACLE_OWNER=oracle
export ORACLE_BASE=/oracle
export ORACLE_HOME=$ORACLE_BASE/ora10
export ORACLE_SID=ORA10
export ORACLE_TERM=vt100
#export TMPDIR=$ORACLE_BASE/tmp
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export NLS_LANG=American_America.KO16KSC5601
export PATH=$ORACLE_HOME/bin:/bin:/sbin:.:$PATH:$ORACLE_HOME/OPatch/bin
export SHLIB_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/usr/lib:/lib:$ORACLE_HOME/rdbms/lib
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/usr/lib:/lib
export PS1=[`whoami`:'$PWD']#
alias ss='sqlplus "/as sysdba"'
stty erase ^H

-----------------------------------------
*  Oracle 환경변수 (Linux)
umask 022
export ORACLE_OWNER=oracle
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/db
export GRID_HOME=/oragrid/app/grid
export ORACLE_SID=TEST1
export ORACLE_TERM=vt100
#export TMPDIR=$ORACLE_BASE/tmp
export TNS_ADMIN=$ORACLE_HOME/network/admin
#export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export NLS_LANG=American_America.UTF8
export PATH=$ORACLE_HOME/bin:/bin:/sbin:.:$PATH:$ORACLE_HOME/OPatch
export SHLIB_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/usr/lib:/lib:$ORACLE_HOME/rdbms/lib
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/usr/lib:/lib
export PS1=[`whoami`:'$PWD']#
export LANG=C
#export LD_ASSUME_KERNEL=2.4.1
alias sp='sqlplus "/as sysdba"'
stty erase ^H

-----------------------------------------

*  Oracle 환경변수 (AIX)
umask 022
export ORACLE_OWNER=oracle
export ORACLE_BASE=/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0
export ORACLE_SID=ILMOA
export ORACLE_TERM=vt100
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export NLS_LANG=AMERICAN_AMERICA.UTF8
export PATH=$ORACLE_HOME/bin:/bin:/sbin:.:$PATH:$ORACLE_HOME/OPatch
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/usr/lib:/lib
export PS1="`whoami`@`hostname`:[\${PWD}]#>"
export LIBPATH=$ORACLE_HOME/lib:/usr/lib 
export AIXTHREAD_SCOPE=S
export LANG=en_US
stty erase ^H
alias ss='sqlplus "/as sysdba"'

Veritas Clusterware
# /opt/VRTSvcs/bin/hastatus -summary

-- SYSTEM STATE
-- System State Frozen

A node01 RUNNING 0
A node02 RUNNING 0

-- GROUP STATE
-- Group System Probed AutoDisabled State

B ClusterService node01 Y N ONLINE
B ClusterService node02 Y N ONLINE
B cvm node01 Y N ONLINE
B cvm node02 Y N ONLINE
B oradatacfs node01 Y N ONLINE
B oradatacfs node02 Y N ONLINE
B oraraw_vols node01 Y N ONLINE
B oraraw_vols node02 Y N ONLINE

AIX HACMP Clusterware
# /usr/sbin/cluster/clstat -a
clstat - HACMP Cluster Status Monitor
-------------------------------------

Cluster: aixclu34 (1214048368)
Thu Mar 26 22:05:42 GMT 2009
State: UP Nodes: 2
SubState: STABLE

Node: aixclu3 State: UP
Interface: aixclu3 (0) Address: 132.22.11.80
State: UP
Interface: aixclu3-prv (1) Address: 132.22.5.55
State: UP
Resource Group: ora_clu34 State: On line

Node: aixclu4 State: UP
Interface: aixclu4 (0) Address: 132.22.11.82
State: UP
Interface: aixclu4-prv (1) Address: 132.22.5.56
State: UP
Resource Group: ora_clu34 State: On line

HP MC Service Guard Clusterware
Utility cmviewcl will provide cluster status but the location of this may
vary. You will first need to check the location of the variable 'SGSBIN'
in /etc/cmcluster.conf.
The /usr/local/cmcluster/bin directory is the default location of the
cmviewcl command. However this might be different so do check /etc/cmcluster.conf

$ /usr/sbin/cmviewcl

CLUSTER STATUS
hpclu02 up

NODE STATUS STATE
hpclu6 up running

PACKAGE STATUS STATE AUTO_RUN NODE
11gnode1 up running enabled hpclu6

NODE STATUS STATE
hpclu7 up running

PACKAGE STATUS STATE AUTO_RUN NODE
11gnode2 up running enabled hpclu7

NODE STATUS STATE
hpclu8 up running

PACKAGE STATUS STATE AUTO_RUN NODE
11gnode3 up running enabled hpclu8

UNOWNED_PACKAGES

Sun Clusterware For SPARC

chipset implementations we will need to install the Oracle UDLM
package. Oracle provides a UDLM patch that you must install onto each node in
the cluster from the /udlm directory on the clusterware directory before
installing and configuring RAC.
For x86 64-bit systems, the skgxn libraries are included as part of the
SUNWscucm x86 package, UDLM is not required.

In earlier versions prior to Sun Cluster 3.2 please use
'/usr/cluster/bin/clnode -show'

# /usr/cluster/bin/cluster status

=== Cluster Nodes ===

--- Node Status ---

Node Name Status
--------- ------
solclu2 Online
solclu1 Online

=== Cluster Transport Paths ===

Endpoint1 Endpoint2 Status
--------- --------- ------
solclu2:rge1 solclu1:rge1 Path online
solclu2:rge0 solclu1:rge0 faulted

=== Cluster Quorum ===

--- Quorum Votes Summary ---

Needed Present Possible
------ ------- --------
3 5 5

--- Quorum Votes by Node ---

Node Name Present Possible Status
--------- ------- -------- ------
solclu2 1 1 Online
solclu1 1 1 Online

--- Quorum Votes by Device ---

Device Name Present Possible Status
----------- ------- -------- ------
d11 1 1 Online
d12 1 1 Online
d13 1 1 Online
=== Cluster Resources ===

Resource Name Node Name State Status Message
------------- --------- ----- --------------
rac_framework        solclu2 Online Online
                                  solclu1 Online Online
crs_framework-rs     solclu2 Online Online
                                  solclu1 Online Online