MISE EN CLUSTER ORACLE

ORACLE_HOME		/opt/oracle/Oracle9i
ORACLE_SID		IPIN
ALERT_LOG_FILE		/opt/oracle/Oracle9i/rdbms/log/alert_IPIN.log
pfile			/opt/oracle/Oracle9i/dbs/initIPIN.ora
CONNECT_STRING		sc_gd_fm/sc_gd_fm


Creation de l'utilisateur sc_gd_fm dedie fault monitoring Oracle

su - oracle

$ sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.1.0 - Production on Tue Dec 3 15:11:37 2002

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.1.0 - Production

SQL> create user sc_gd_fm identified by sc_gd_fm;

User created.

SQL> grant create session, create table to sc_gd_fm;

Grant succeeded.

SQL> grant select on v_$sysstat to sc_gd_fm;

Grant succeeded.

SQL> alter user sc_gd_fm default tablespace ts_other quota 1m on ts_other;

User altered.

SQL> quit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.1.0 - Production


scrgadm -a -t SUNW.oracle_server
scrgadm -a -t SUNW.oracle_listener

scrgadm -a -j ora-svr-rs -g ora-rg  -t SUNW.oracle_server \
	-x oracle_sid=IPIN -x oracle_home=/opt/oracle/Oracle9i \
	-x alert_log_file=/opt/oracle/Oracle9i/rdbms/log/alert_IPIN.log \
	-x parameter_file=/opt/oracle/Oracle9i/dbs/initIPIN.ora \
	-x connect_string=sc_gd_fm/sc_gd_fm
	
	
scrgadm -a -j ora-lsnr-rs -g ora-rg  -t SUNW.oracle_listener \
	-x oracle_home=/opt/oracle/Oracle9i \
	-x listener_name=LISTENER
	

Demarrage du fault monitoring :

scswitch -Z -g ora-rg

Bascule :

scswitch -z -g ora-rg -h 'autre_noeud'
scswitch -z -g ora-rg -h gd1|gd2




Presence des processus serveur :
pgrep -fl smon
pgrep -fl tnslsnr

test de connexion
long (liste une table)
su - oracle -c "echo 'select * from v\$sysstat;'| sqlplus sc_gd_fm/sc_gd_fm"
rapide (renvoie la date)
su - oracle -c "echo 'select sysdate  from dual;'| sqlplus sc_gd_fm/sc_gd_fm"



Arret de la base 
su - oracle -c "echo 'shutdown immediate' | sqlplus '/ as sysdba'"

Les messages ci-dessous apparaissent apres trois arrets de la base. Le RG est bascule vers l'autre noeud.
 
root@gd2 # Dec  3 16:09:07 gd2 last message repeated 2 times
Dec  3 16:10:02 gd2 SC[SUNWscor.oracle_server.monitor]:ora-rg:ora-s



vr-rs: Retry_count exceeded in Retry_interval
Dec  3 16:10:02 gd2 SC[SUNWscor.oracle_server.monitor]:ora-rg:ora-svr-rs: Switching over resource group using scha_control GIVEOVER

Les messages ci-dessous apparaissent lors d'une tentative de basculement vers un noeud qui a eu un probleme dans l'heure prececedente (pingpong_interval=3600):

Dec  3 16:17:09 gd1 Cluster.RGM.rgmd: RGM isn't failing resource group <ora-rg> off of node <1>, because no current or potential master is healthy enough
Dec  3 16:17:09 gd1 Cluster.RGM.rgmd: Resource <ora-svr-rs> of Resource Group <ora-rg> failed pingpong check on node <gd2>.
Dec  3 16:17:09 gd1 SC[SUNWscor.oracle_server.monitor]:ora-rg:ora-svr-rs: scha_control GIVEOVER failed. error sanity checks failed
Dec  3 16:17:09 gd1 SC[SUNWscor.oracle_server.monitor]:ora-rg:ora-svr-rs: Restarting using scha_control RESTART





/opt/oracle/Oracle9i/network/admin/listener.ora :

# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = ora-don)(PORT = 1521))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = ora-serv)(PORT = 1521))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/Oracle9i)
      (PROGRAM = extproc)
    )
  )


/etc/hosts :

#
# Internet host table
#
127.0.0.1       localhost       
10.0.41.17      gd1     dg1.    loghost
10.0.41.18      gd2
10.0.41.19      gdadm
# VLAN Service
192.168.147.11  gd1-serv
192.168.147.12  gd2-serv
192.168.147.13  ipin-serv
192.168.147.14  ora-serv
# VLAN Donnees
192.168.148.11  gd1-don
192.168.148.12  gd2-don
192.168.148.13  ipin-don
192.168.148.14  ora-don


pnmstat -l
group   adapters        status  fo_time act_adp
nafo0   qfe0:qfe4       OK      NEVER   qfe0
nafo1   qfe1:qfe5       OK      NEVER   qfe1
nafo2   qfe2:qfe6       OK      NEVER   qfe2