PRIMECLUSTER Wizard for Oracle 導入運用手引書 4.1

Transcription

1 PRIMECLUSTER Wizard for Oracle PRIMECLUSTER Wizard for Oracle 4.1 Solaris Operating System

2 PRIMECLUSTER Wizard for Oracle PRIMECLUSTER Wizard for Oracle PRIMECLUSTER PRIMECLUSTER Oracle ACUI SunSun MicrosystemsSun Solaris Solaris Sun Microsystems, Inc. Oracle Oracle Corporation All Rights Reserved, Copyright(C) FUJITSU LIMITED

3 PRIMECLUSTER Wizard for Oracle PRIMECLUSTER / Oracle /...11 userapplication userapplication userapplication / Oracle / Oracle userapplication userapplication Oracle RAC 10g PRIMECLUSTER / Oracle / userapplication Oracle userapplication Oracle Oracle RAC 10g Oracle / Oracle Oracle Oracle system Oracle ASM Automatic Storage Management hvoradisable hvoraenable clorapass cloracpy - Oracle clgetoralog Oracle clorabr clorainfo

4 PRIMECLUSTER Wizard for Oracle A CUI A.1 userapplication A.1.1 Application-Create A.1.2 A.1.3 ( ) A.1.4 Configuration-Generate and Configuration-Activate A.1.5 userapplication A.2 Oracle / A.2.1 Application-Edit A.2.2 Configuration-Generate and Configuration-Activate A.2.3 userapplication

5 PRIMECLUSTER Wizard for Oracle

6 PRIMECLUSTER Wizard for Oracle PRIMECLUSTER Wizard for Oracle PRIMECLUSTER Oracle PRIMECLUSTER Oracle Real Application Clusters ( RAC Oracle9i RAC Oracle RAC 10g ) Oracle ( ) PRIMECLUSTER Oracle Wizard Detector Scripts PRIMECLUSTER Oracle Oracle Oracle / PRIMECLUSTER RMS userapplication ORACLE Wizard Oracle Oracle Oracle Oracle system Oracle SQL ( system ) Oracle SQL Oracle ORA-XXXXX Oracle Oracle SQL Oracle Oracle tnsping Oracle Oracle userapplication Oracle Oracle Oracle Oracle end backup Oracle Oracle immediate abort Oracle

7 PRIMECLUSTER Wizard for Oracle Oracle Oracle IP IP

8 PRIMECLUSTER Wizard for Oracle

9 PRIMECLUSTER Wizard for Oracle RAC Oracle9i RAC 1 PRIMECLUSTER / PRIMECLUSTER / 2 PRIMECLUSTER Wizard for Oracle PRIMECLUSTER Wizard for Oracle Oracle 3 Oracle / 4 userapplication 5 / 6 7 Oracle / 2.2 RAC:Oracle RAC 10g 1 PRIMECLUSTER / PRIMECLUSTER / 2 PRIMECLUSTER Wizard for Oracle PRIMECLUSTER Wizard for Oracle Oracle 3 Oracle / 4 5 userapplication 2.7 Oracle RAC 10g 1 PRIMECLUSTER / PRIMECLUSTER / 2 PRIMECLUSTER Wizard for Oracle PRIMECLUSTER Wizard for Oracle 3 Oracle / Oracle / 4 userapplication 5 / 6 7 Oracle / 2.2

10 PRIMECLUSTER Wizard for Oracle PRIMECLUSTER / 2.6 Oracle9i RAC Oracle 10g RAC 2.7 Oracle RAC 10g PRIMECLUSTER Oracle PRIMECLUSTER PRIMECLUSTER Enterprise Edition PRIMECLUSTER Enterprise Edition PRIMECLUSTER HA Server PRIMECLUSTER Clustering Base PRIMECLUSTER Wizard for Oracle PRIMECLUSTER Wizard for Oracle PRIMECLUSTER

11 PRIMECLUSTER Wizard for Oracle Oracle / Oracle /etc/system PRIMECLUSTER Oracle Oracle Oracle Oracle /etc/system Oracle9i set shmsys:shminfo_shmmax= set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=100 set shmsys:shminfo_shmseg=10 set semsys:seminfo_semmni=100 set semsys:seminfo_semmsl=200 set semsys:seminfo_semmns=400 set semsys:seminfo_semopm=100 set semsys:seminfo_semvmx=32767 /etc/services Oracle listener 1521/tcp oracle Oracle Oracle DBA(Database Administrator) ID ID # groupadd g < ID> dba # useradd u < ID> g dba d /export/home/oracle s /bin/sh m oracle # passwd oracle dba Oracle

12 PRIMECLUSTER Wizard for Oracle (.profile) ORACLE_BASE=/opt/oracle; export ORACLE_BASE ORACLE_HOME=/opt/oracle/product/9.0.1; export ORACLE_HOME ORACLE_TERM=sun-cmd; export ORACLE_TERM ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data; export ORA_NLS33 LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH PATH=$ORACLE_HOME/bin:/usr/bin:/usr/ccs/bin:/usr/ucb; export PATH PATH /usr/ucb /usr/ccs/bin PRIMECLUSTER Wizard for Oracle Oracle Oracle DBA Oracle DBA PATH $ORACLE_HOME/bin root su(1m) Oracle # su - <Oracle > Oracle Oracle Oracle Oracle Oracle

13 PRIMECLUSTER Wizard for Oracle userapplication userapplication ( ) userapplication<app3> userapplication userapplication Oracle userapplication userapplication Oracle userapplication 2.6 Oracle /

14 PRIMECLUSTER Wizard for Oracle Controller userapplication userapplication userapplication Configuration Wizard userapplication Configuration Wizard userapplication Configuration Wizard PRIMECLUSTER 6 Oracle userapplication ( ) Oracle userapplication Oracle userapplication

15 PRIMECLUSTER Wizard for Oracle GDS Oracle Disk Class Disk Class Oracle Disk Class MONITORONLY NO Disk Class MONITORONLY YES Oracle MONITORONLY YES Disk Class Oracle OFFLINE PRIMECLUSTER 6 userapplication Configuration Wizard userapplication userapplication userapplication userapplication =Standby AutoStartup=No PersistentFault = 1 =Gds =Standby AutoSwitchOver = HostFailure ResourceFailure ShutDown PersistentFault = 1 HaltFlag=Yes =Gds Fsystem userapplication userapplication userapplication Oracle IP IP

16 PRIMECLUSTER Wizard for Oracle / REDO ( ) Oracle $ORACLE_HOME/dbs $ORACLE_BASE/admin/$ORACLE_SID /opt/fjsvclora/sbin/cloracpy tar "4.4 cloracpy Oracle ( )"

17 PRIMECLUSTER Wizard for Oracle / N:1 N:1 1:1 2:1 LOCAL_LISTENER listener.ora tnsnames.ora Oracle Oracle Oracle ($ORACLE_HOME/dbs/init<ORACLE_SID>.ora) spfile = /mnt2/o9idb/parameter/spfile.ora

18 PRIMECLUSTER Wizard for Oracle Oracle 10g DBCA(Database Configuration Assistant) 2.4 userapplication userapplication # mv $ORACLE_HOME/dbs/spfile<SID>.ora < >/spfile<sid>.ora $ORACLE_HOME/dbs/init<SID>.ora spfile=< >/spfile<sid>.ora cloracpy Oracle $ORACLE_HOME/network/admin/listener.ora, tnsnames.ora listener.ora IP Oracle Oracle IP IP LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = < IP >)(PORT = 1521)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ora9i) (ORACLE_HOME = /opt/oracle/product/9.0.1) (SID_NAME = ora9i) ) ) tnsnames.ora Oracle tnsping Oracle tnsnames.ora tnsnames.ora PRIMECLUSTER Wizard for Oracle Oracle tnsnames.ora ORACLE_SID ( IP ) Oracle

19 PRIMECLUSTER Wizard for Oracle = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = < IP >)(PORT = 1521)) ) (CONNECT_DATA = (SID = ora9i)) system PRIMECLUSTER Wizard for Oracle Oracle system Oracle Oracle system PRIMECLUSTER Wizard for Oracle system "4.3 clorapass - " Oracle Oracle Oracle /

20 PRIMECLUSTER Wizard for Oracle Oracle / "2.4 userapplication " userapplication Oracle PRIMECLUSTER Oracle / Oracle Oracle / Oracle / Oracle Oracle RMS userapplication Configuration Wizard Oracle Resource Resource Oracle

21 PRIMECLUSTER Wizard for Oracle Oracle Oracle Oracle ( ) clorainfo c (SubApplicationName) (SubApplicationName) RMS Oracle ASM ORACLE_<SubApplicationName>_<OracleSID> Oracle LISTENER_<SubApplicationName>_<ListenerName> 39 "ORACLE_" "LISTENER_"

22 PRIMECLUSTER Wizard for Oracle Oracle (ResourceName) Oracle Oracle (ResourceName) Oracle Oracle RAC 10g (ResourceName) Oracle RAC 10g Oracle RAC 10g (ResourceName) Oracle RAC 10g (StartPriority) Oracle Oracle Same Oracle (MTS) Oracle Oracle Oracle ( ) clorainfo c OracleSID (OracleSID) ORACLE_SID Oracle (OracleUser) Oracle (StartTimeout) Oracle 600s (300s s) (StopTimeout) Oracle 180s (60s s) (AbortTimeout) Oracle 60s (60s s)

23 PRIMECLUSTER Wizard for Oracle Oracle () (StopModeStop) Oracle immediate (abort, immediate, transactional) Oracle () (StopModeFail) Oracle abort (abort, immediate) (Interval) Oracle 30s (5s s) (WatchTimeout) Oracle 300s (30s s) Oracle Oracle ( ) clorainfo c ListenerName (ListenerName) Oracle Oracle (OracleUser) Oracle (StartTimeout) Oracle 180s (120s s) (StopTimeout) Oracle 60s (60s s) (Interval) Oracle 30s (5s s) (WatchTimeout) Oracle Oracle 300s (30s s)

24 PRIMECLUSTER Wizard for Oracle TNSName Oracle /Oracle ( ) clorainfo c TNSName (TNSName) Oracle TNSName Oracle tnsping tnsnames.ora TNSName Oracle ( ) PreOnlineScript (PreOnlineScript) PostOnlineScript (PostOnlineScript) PreOfflineScript (PreOfflineScript) PostOfflineScript (PostOfflineScript) FaultScript (FaultScript) Fault (Flags) NULLDETECTOR Oracle : Oracle : AUTORECOVER RMS Oracle : Oracle : MONITORONLY Oracle : Oracle :

25 PRIMECLUSTER Wizard for Oracle PRIMECLUSTER RMS 9 Oracle Oracle ORACLE_SID GUI/CUI userapplication clorainfo c 4.7 clorainfo - userapplication PRIMECLUSTER Oracle userapplication ( ) PRIMECLUSTER userapplication

26 PRIMECLUSTER Wizard for Oracle ( ) userapplication userapplication Oracle userapplication Oracle

27 PRIMECLUSTER Wizard for Oracle userapplication userapplication userapplication IP IP Oracle Oracle Oracle

28 PRIMECLUSTER Wizard for Oracle Oracle RAC 10g PRIMECLUSTER Oracle PRIMECLUSTER Enterprise Edition PRIMECLUSTER Enterprise Edition PRIMECLUSTER Wizard for Oracle PRIMECLUSTER Wizard for Oracle PRIMECLUSTER Oracle RAC 10g OS Cluster Ready Services CRS CRS PRIMECLUSTER GDS Oracle PRIMECLUSTER GDS PRIMECLUSTER RMS OS NAS NFS PRIMECLUSTER RMS OS Oracle Cluster Registry Voting Disk Oracle RAC IP Oracle DBA(Database Administrator) ID ID DBA PATH $ORACLE_HOME/bin $ORACLE_CRS_HOME/bin

29 PRIMECLUSTER Wizard for Oracle PATH=/opt/oracle/product/10.1.0/bin:/opt/oracle/product/10.1.0/crs/bin; export PATH CRS Oracle CRS Oracle 10g Oracle Oracle 10g RAC PRIMECLUSTER Wizard for Oracle Oracle Oracle DBA Oracle DBA Path $ORACLE_HOME/bin $ORACLE_CRS_HOME/bin / Oracle Oracle Oracle Oracle DBA crs_stat

30 PRIMECLUSTER Wizard for Oracle userapplication Oracle RAC 10g Oracle Oracle PRIMECLUSTER RMS RAC userapplication userapplication Oracle userapplication<app_0> userapplication<app_1> Oracle userapplication =Standby AutoStartup=No PersistentFault = 1 userapplication<app_2> userapplication<app_3> GLS IP userapplication =Standby AutoSwitchOver = HostFailure ResourceFailure ShutDown PersistentFault = 1 HaltFlag=Yes

31 PRIMECLUSTER Wizard for Oracle userapplication<app_4> userapplication<app_0> userapplication<app_1> userapplication userapplication Oracle userapplication userapplication userapplication Configuration Wizard userapplication Configuration Wizard userapplication Configuration Wizard PRIMECLUSTER 6

32 PRIMECLUSTER Wizard for Oracle userapplication Configuration Wizard Oracle Oracle Oracle Oracle Oracle 10g RAC Oracle RAC 10g crs_stat ora.*.inst ora.*.lsnr Oracle Oralce node1 ora.01.inst ora.e1.lsnr node2 ora.02.inst ora.e2.lsnr Resource

33 PRIMECLUSTER Wizard for Oracle Resource Oracle OracleRAC10g

34 PRIMECLUSTER Wizard for Oracle (SubApplicationName) RMS Oracle <SubApplicationName>_<inst_name>.i Oracle <SubApplicationName>_<lsnr_name>.l Oracle RAC 10g crs_stat Oracle "ora.<db_unique_name>"oracle ora.<node_name> "<SubApplicationName>_".lsner.inst 39 <SubApplicationName> Oracle DBA

35 PRIMECLUSTER Wizard for Oracle Oracle

36 PRIMECLUSTER Wizard for Oracle Oracle Oracle Oracle

37 PRIMECLUSTER Wizard for Oracle

38 PRIMECLUSTER Wizard for Oracle (clorainfo c ) Oracle (OracleUser) ScriptTimeout (ScriptTimeout) Oracle UNIX Oracle DBA 900 s 300s 86400s OracleRAC10g (WFTime) 900 s PersistentWarning PersistentWarning( Warning ) ImmediateFault( Faulted ) 60s 86400s

39 PRIMECLUSTER Wizard for Oracle PreOnlineScript (PreOnlineScript) PostOnlineScript (PostOnlineScript) PreOfflineScript (PreOfflineScript) PostOfflineScrpt (PostOfflineScript) FaultScript (FaultScript) Fault (Flags) o NULLDETECTOR PRIMECLUSTER Wizard for Oracle CRS PreOnlineScript /opt/fjsvclora/sbin/cloracrs <OracleUser> # /etc/init.d/init.crs disable CRS 113 userapplication Configuration Wizard

40 PRIMECLUSTER Wizard for Oracle userapplication Configuration Wizard userapplication

41 PRIMECLUSTER Wizard for Oracle

42 PRIMECLUSTER Wizard for Oracle Oracle Oracle9i RAC PRIMECLUSTER Wizard for Oracle Oracle Oracle Oracle su - <Oracle > sqlplus /nolog connect / as sysdba startup nomount startup mount alter database mount (4 startup nomount ) alter database open / PRIMECLUSTER Wizard for Oracle Oracle $ORACLE_HOME/dbs/init$ORACLE_SID.ora 2.5 PRIMECLUSTER Wizard for Oracle Oracle Oracle V$BACKUP ACTIVE V$RECOVER_FILE Oracle9i RAC Oracle Oracle su - <Oracle > sqlplus /nolog connect / as sysdba shutdown <immediate/abort> Oracle shutdown abort Oracle PRIMECLUSTER Wizard for Oracle Oracle immediate abort Immediate abort

43 PRIMECLUSTER Wizard for Oracle Oracle Oracle su - <Oracle > Oracle system Oracle Oracle OPEN system insert, update, delete, select system PRIMECLUSTER Wizard for Oracle Oracle system 2.5 system PRIMECLUSTER Wizard for Oracle PRIMECLUSTER Wizard for Oracle system Warning Warning Fault system Oracle max session max process Oracle SQL insert,update Oracle OPEN

44 PRIMECLUSTER Wizard for Oracle Oracle RAC 10g Oracle RAC 10g Oracle Cluster Ready Service CRS Oracle Oracle Oracle CRS PRIMECLUSTER Wizard for Oracle Warning RMS CRS CRS Faulted RMS Oracle Oracle srvctl start instance d $DB_NAME i $ORACLE_SID srvctl stop instance d $DB_NAME i $ORACLE_SID Oracle CRS Oracle vip gsd ons Oracle / / RMS userapplication (hvswitch, hvutil) CRS srvctl Oracle shutdown PRIMECLUSTER userapplication

45 PRIMECLUSTER Wizard for Oracle userapplication userapplication Oracle userapplication userapplication userapp_3 userapplication userapplication userapplication userapplication userapplication userapplication PRIMECLUSTER userapplication userapplication

46 PRIMECLUSTER Wizard for Oracle Oracle / PRIMECLUSTER PRIMECLUSTER Wizard for Oracle Oracle Oracle Oracle PreOnlineScript Online PostOnlineScript Online PreOfflineScript Offline PostOfflineScript Offline FaultScript Fault root exit 0 0 ScriptTimeout RMS PRIMECLUSTER RMS 2.6.3

47 PRIMECLUSTER Wizard for Oracle Oracle Oracle Oracle Oracle Oracle / userapplication Oracle Oracle Oracle userapplication Oracle Oracle PRIMECLUSTER Oracle Oracle Oracle userapplication Oracle userapplication userapplication hvoradisable Oracle Oracle Oracle Oracle Oracle userapplication hvoradisable RMS hvdisable Oracle Oracle Oracle Oracle Oracle Oracle Oracle Oracle Oracle Oracle OPEN Oracle Oracle userapplication hvoradisable RMS hvenable userapplication hvoraenable Oracle

48 PRIMECLUSTER Wizard for Oracle userapplication Oracle PRIMECLUSTER PRIMECLUSTER Wizard for Oracle userapplication Oracle Oracle Oracle Oracle RAC 10g Oracle RAC 10g srvctl shutdown RMS userapplication PRIMECLUSTER userapplication userapplication userapplication PRIMECLUSTER RMS Maintenance ( ) Oracle Oracle "4.1 hvoradisable - ", "4.2 hvoraenable - " Oracle Oracle Oracle Oracle userapplication hvoradisable Oracle Oracle Oracle hvoradisable Warning Oracle Oracle Oracle

49 PRIMECLUSTER Wizard for Oracle Oracle Oracle Oracle Oracle # hvutil m on <userapplication> # hvoradisable a <userapplication> Oracle # su - <Oracle > $ sqlplus /nolog SQL> connect / as sysdba SQL> shutdown immediate Oracle Oracle # su - <Oracle > $ sqlplus /nolog SQL> connect / as sysdba SQL> startup # hvutil m off <userapplication> # hvoraenable a <userapplication> Oracle Oracle Oracle Oracle Oracle Oracle Oracle PSR(Patch Set Release) Oracle RMS userapplication # hvutil m on <userapplication> # hvoradisable a <userapplication>

50 PRIMECLUSTER Wizard for Oracle Oracle # su - <Oracle > $ sqlplus /nolog SQL> connect / as sysdba SQL> shutdown immediate Oracle Oracle 2 # su - <Oracle > $ sqlplus /nolog SQL> connect / as sysdba SQL> startup # hvutil m off <userapplication> # hvoraenable a <userapplication> Oracle Oracle Oracle SAP R/3 Oracle # hvutil m on <userapplication> # hvoradisable a <userapplication> Oracle # su - <Oracle > $ sqlplus /nolog SQL> connect / as sysdba SQL> shutdown immediate Oracle # su - <Oracle > $ sqlplus /nolog SQL> connect / as sysdba SQL> startup

51 PRIMECLUSTER Wizard for Oracle # hvutil m off <userapplication> # hvoraenable a <userapplication> Oracle Oracle Oracle Oracle Oracle Oracle Oracle # hvutil m on <userapplication> # hvoradisable a <userapplication> Oracle # hvutil m off <userapplication> # hvoraenable a <userapplication> Oracle Oracle Oracle Oracle SYSTEM UNDO SYSTEM UNDO Oracle Oracle Oracle Oracle SAP R/3 Oracle

52 PRIMECLUSTER Wizard for Oracle userapplication # hvutil f <userapplication> # hvoradisable a <userapplication> userapplication # hvswitch <userapplication> Oracle # su - <Oracle > $ sqlplus /nolog SQL> connect / as sysdba SQL> startup # hvoraenable a <userapplication> Oracle Oracle # hvutil m on <userapplication> # hvoradisable a <userapplication> Oracle # hvutil m off <userapplication> # hvoraenable a <userapplication>

53 PRIMECLUSTER Wizard for Oracle Oracle system Oracle system Oracle hvoradisable Oracle hvoradisable 4.1 hvoradisable - syslog [Info] [0101] Fault Watching is disable Oracle system Oracle system Oracle Wizard for Oracle Oracle system clorapass Wizard for Oracle Oracle system clorapass 4.3 clorapass - Oracle hvoraenable Oracle hvoraenable 4.2 hvoraenable - syslog [Info] [0102] Fault Watching is enable Oracle system Oracle system Oracle clorapass Oracle system

54 PRIMECLUSTER Wizard for Oracle PRIMECLUSTER Wizard for Oracle Oracle Detector Oracle Oracle /opt/fjsvclora/etc/fjsvclorafm.actionlist errno/status/action/message 18 Cn Wa "maximum number of sessions exceeded" 20 Cn Wa "maximum number of processes (%s) exceeded" 470 All Of "LGWR process terminated with error" 471 All Of "DBWR process terminated with error" 472 All Of "PMON process terminated with error" 942 Ol Np "table or view does not exist" 1012 All Rs "not logged on" 1034 All Of "ORACLE not available" errno Oracle (ORA-xxxxx) Status Detector Cn Oracle Ol Oracle Dc Oracle All Action Np Of Offline Wa Warning Rs Detector Fa Faulted NOP Np SQL Rs Message

55 PRIMECLUSTER Wizard for Oracle

56 PRIMECLUSTER Wizard for Oracle Oracle PRIMECLUSTER Oracle Oracle Oracle PRIMECLUSTER Wizard for Oracle PRIMECLUSTER Wizard for Oracle /var/opt/reliant/log/fjsvclora_<oraclesid>_*.log /var/opt/reliant/log/fjsvclora_<listenername>_*.log / /ID/ 2002/04/25 15:18:40 [Info] [1101] Starting Oracle detector 2002/04/25 15:18:40 [Info] [1102] Connected to Oracle 2002/04/25 15:18:40 [Error] [1299] ORA Oracle not avairable. YYYY/MM/DD HH:MM:SS InformationErrorWarning ID RMS PRIMECLUSTER Wizard for Oracle /var/opt/fjsvclora/fjsvclora_<oraclesid>_*.trclog /var/opt/fjsvclora/fjsvclora_<listenername>_*.trclog

57 PRIMECLUSTER Wizard for Oracle Oracle ($ORACLE_HOME/network/admin/*.ora) $ORACLE_HOME/dbs/*.ora $ORACLE_BASE/admin/$ORACLE_SID/pfile/*.ora $ORACLE_HOME/rdbms/log/alert_$ORACLE_SID.log ($ORACLE_BASE/admin/$ORACLE_SID/bdump/alert_$ORACLE_SID.log) $ORACLE_HOME/network/log/<ListenerName>.log $ORACLE_CRS_HOME/crs/log/<nodename>.log (Oracle RAC 10g ) PRIMECLUSTER PRIMECLUSTER " C " PRIMECLUSTER Wizard for Oracle /opt/fjsvclora/etc/* /usr/opt/reliant/etc/hvgdconfig /usr/opt/reliant/build/< >.usfiles/* /var/opt/reliant/log/* /var/opt/fjsvclora/* Oracle PRIMECLUSTER Wizard for Oracle PRIMECLUSTER fjsnap fjsnap FJSVsnap PRIMECLUSTER PRIMECLUSTER Wizard for Oracle Oracle PRIMECLUSTER Wizard for Oracle 4.5 clgetoralog Oracle

58 PRIMECLUSTER Wizard for Oracle Oracle PRIMECLUSTER Wizard for Oracle Oracle prestartup Oracle Oracle V$INSTANCE STATUS /opt/fjsvclora/usr "prestartup" nomount Oracle Oracle V$INSTANCE STATUS "STARTED" /opt/fjsvclora/usr "nomount" mount Oracle Oracle V$INSTANCE STATUS "MOUNTED" /opt/fjsvclora/usr "mount" /opt/fjsvclora/usr 0 0 Oracle root $1:$ORACLE_HOME $2:$ORACLE_SID $3:Oracle "2.6.1 Oracle " 4

59 PRIMECLUSTER Wizard for Oracle ASM Automatic Storage Management Oracle 10g ASM (1:1 ) ASM N:1 ASM ASM ASM Oracle userapplication Oracle RAC 10g ASM ASM ASM CRS ASM / ASM ASM + ( +ASM ) ASM Oracle ASM $ORACLE_HOME/dbs $ORACLE_BASE/admin/$ORACLE_SID $ORACLE_BASE/admin/[ASM ]

60 PRIMECLUSTER Wizard for Oracle /opt/fjsvclora/sbin/cloracpy tar ASM tar $ORACLE_BASE/admin/[ASM ] ASM ASM ASM_DISKGROUPS Oracle ASM Oracle userapplication userapplication Oracle ASM 1 userapplication ASM Oracle ASM NULLDETECTOR ASM (mount/dismount) ASM ORA-15032: not all alterations performed ORA-15017: diskgroup " " cannot be mounted ORA-15030: diskgroup name " " is in use by another diskgroup

61 PRIMECLUSTER Wizard for Oracle

62 PRIMECLUSTER Wizard for Oracle hvoradisable - /opt/fjsvclora/sbin/hvoradisable application_name resource_name /opt/fjsvclora/sbin/hvoradisable -a [ application_name ] Oracle Oracle Oracle Oracle Oracle userapplication / userapplication userapplication Oracle Oracle Warning userapplication Warning Oracle Oracle Warning userapplication Warning Oracle Oracle userapplication ASM ASM "3.11 ASM(Automatic Storage Management) " application_name userapplication resource_name Oracle Oracle application_name resource_name -a [application_name ] application_name userapplication Oracle Oracle application_name Oracle Oracle 0 : 1 : 2 : -a

63 PRIMECLUSTER Wizard for Oracle userapplication

64 PRIMECLUSTER Wizard for Oracle hvoraenable - /opt/fjsvclora/sbin/hvoraenable application_name resource_name /opt/fjsvclora/sbin/hvoraenable -a [ application_name ] hvoradisable Oracle Oracle userapplication / userapplication hvoradisable userapplication Oracle Oracle Warning Online ASM ASM "3.11 ASM(Automatic Storage Management) " application_name resource_name application_name userapplication resource_name Oracle Oracle application_name resource_name -a [ application_name ] application_name userapplication Oracle Oracle userapplication Oracle Oracle 0 : 1 : 2 : -a

65 PRIMECLUSTER Wizard for Oracle userapplication

66 PRIMECLUSTER Wizard for Oracle clorapass - /opt/fjsvclora/sbin/clorapass clorapass PRIMECLUSTER Wizard for Oracle Oracle system Oracle system system system manager 1 Oracle Oracle Oracle system 0 : 0 : Oracle system 3.6 Oracle system

67 PRIMECLUSTER Wizard for Oracle cloracpy - Oracle Oracle DBA /opt/fjsvclora/sbin/cloracpy /opt/fjsvclora/sbin/cloracpy Oracle tar cloracpy $ORACLE_HOME,$ORACLE_BASE 1:1 Oracle Oracle Oracle $ORACLE_BASE $ORACLE_HOME $ORACLE_SID cloracpy tar $ORACLE_HOME/dbs/ $ORACLE_BASE/admin/$ORACLE_SID/ $ORACLE_HOME/network/admin/*.ora /tmp/oracle.$oracle_sid.tar tar xvf /tmp/oracle.$oracle_sid.tar tar $ORACLE_BASE $ORACLE_HOME N:1 0 : 0 :

68 PRIMECLUSTER Wizard for Oracle clgetoralog Oracle /opt/fjsvclora/bin/clgetoralog [ -n RMSconfiguration ] [ -d output_directory ] [ -a ] Oracle PRIMECLUSTER Oracle <hostname>_< >_clgetoralog.tar $ORACLE_HOME/dbs/*.ora $ORACLE_BASE/admin/$ORACLE_SID/pfile/*.ora background_dump_dest/*.log $ORACLE_BASE/admin/$ORACLE_SID/bdump/*.log $ORACLE_HOME/rdbms/log/*.log $ORACLE_HOME/dbs/*.log listener.ora tnsnames.ora $ORACLE_HOME/network/admin/*.ora $ORACLE_HOME/network/log/*.log CRS $ORACLE_CRS_HOME/crs/admin/* $ORACLE_CRS_HOME/crs/log/* Wizard for Oracle V/L RMS V/L switchlog PRIMECLUSTER V/L uname -a uptime psrinfo -v (CPU ) /usr/platform/`arch -k`/sbin/prtdiag cat /etc/release Solaris cat /var/sadm/ptf/newprev/rcontents PTF pkgparam -v FJSVbse ESF sysdef -i ipcs swap -l ptree -a, ps -ef ntpq -p NTP /var/adm/messages

69 PRIMECLUSTER Wizard for Oracle fjsnap [ -n RMSconfiguration ] RMSconfiguration RMS RMS [ ] RMS GUI userapplication Configuration Wizard RMS "config" RMS RMS # /opt/smaw/bin/hvdisp -a grep Configuration Configuration: /opt/smaw/smawrrms/build/config.us [ ] [ -d output_directory ] <hostname>_< >_clgetoralog.tar <hostname>_< >_clgetoralog.tar /var/tmp/ [ -a ] [ ] RMS -n RMS RMS /var/opt/reliant/log/* RMS /usr/opt/reliant/bin/hvenv.local /var/adm/messages* /etc/hosts, /etc/inet/hosts /etc/passwd /etc/services, /etc/inet/services /etc/system /etc/vfstab showrev -p [ ] 0 : 0 :

70 PRIMECLUSTER Wizard for Oracle clgetoralog $ORACLE_HOME/dbs/init<SID>.ora background_dump_dest $ORACLE_BASE/admin/<SID>/bdump/*.log Oracle background_dump_dest Oracle /opt/fjsvclora/etc/clgetoralog.conf /opt/fjsvclora/etc/clgetoralog.conf COLLECTOBJ=/oracle/admin/orclsid/bdump/alert_orclsid.log COLLECTOBJ=/oracle/admin/orclsid/bdump/*.trc init<sid>.ora spfile<sid>.ora background_dump_dest COLLECTOBJ= = * COLLECTOBJ=/oracle/admin/orclsid/bdump/*.trc [OK] COLLECTOBJ=/oracle/admin/*/bdump/*.trc [NG]

71 PRIMECLUSTER Wizard for Oracle clorabr - /opt/fjsvclora/bin/clorabr { backup restore } [ -d backup_directory ] PRIMECLUSTER Wizard for Oracle PRIMECLUSTER cfbackup/cfrestore PRIMECLUSTER Wizard for Oracle PRIMECLUSTER PRIMECLUSTER 11PRIMECLUSTER /opt/fjsvclora/etc/fjsvclora.pwd /opt/fjsvclora/etc/fjsvclorafm.actionlist /opt/fjsvclora/usr/_mount10endbackup.sh /opt/fjsvclora/usr/ mount10endbackup.sh /opt/fjsvclora/usr/_mount20mediarecover.sh /opt/fjsvclora/usr/ mount20mediarecover.sh /opt/fjsvclora/usr/mount05endbackup_mediarecover.sh backup PRIMECLUSTER Wizard for Oracle FJSVclora /var/tmp /var/tmp/fjsvclora restore PRIMECLUSTER Wizard for Oracle FJSVclora /var/tmp/fjsvclora /var/tmp [ -d backup_directory ] FJSVclora FJSVclora

72 PRIMECLUSTER Wizard for Oracle 0 : 0 :

73 PRIMECLUSTER Wizard for Oracle clorainfo - /opt/fjsvclora/bin/clorainfo { -c [ RMSconfiguration ] -e -m [ ResourceName ] -v } Wizard for Oracle -c [ RMSconfiguration ] RMS Wizard for Oracle RMSconfiguration RMS RMSconfiguration RMS Wizard for Oracle -e Oracle -m [ ResourceName ] Wizard for Oracle enable disable ResourceName 0 RMS 2 RMS 10 RMS 12 RMS ResourceName Wizard for Oracle ResourceName Wizard for Oracle -v Wizard for Oracle 0 : RMS "-m ResourceName" 2 : RMS "-m ResourceName" 10 : RMS "-m ResourceName" 12 : RMS "-m ResourceName" :

74 PRIMECLUSTER Wizard for Oracle PRIMECLUSTER Wizard for Oracle Oracle Oracle Oracle Oracle ID ORACLE_HOME Oracle system system Oracle REDO Oracle immediate DBA Oracle Online Backup abort abort Oracle Oracle Oracle Oracle Oracle Oracle Oracle Oracle 10 3 RMS hvshut hvshut RMS userapplication PreOnlineScript exit code Oracle /opt/fjsvclora/usr _mount10endbackup.sh -> mount10endbackup.sh _mount20mediarecover.sh -> mount20mediarecover.sh mount05endbackup_mediarecover.sh -> _mount05endbackup_mediarecover.sh 3.10 Oracle Resource Wizard ( : Oracle ) SAP R/3 Wizard (ForUseWithR3) SAP R/3 Wizard

75 PRIMECLUSTER Wizard for Oracle Oracle system 3.6 Oracle system Oracle RAC 10g CRS srvctl Oracle shutdown RMS RMS Oracle RAC 10g Oracle RAC 10g Oracle <SubApplicationName>_<inst_name>.i Oracle <SubApplicationName>_<lsnr_name>.l Oracle RAC 10g crs_stat Oracle "ora.<db_unique_name>"oracle ora.<node_name> "<SubApplicationName>_".lsner.inst 39 <SubApplicationName>

76 PRIMECLUSTER Wizard for Oracle PRIMECLUSTER Wizard for Oracle syslog daemon.err Oracle ERROR: 1202: Cannot map shared memory or get semaphore ( ) ERROR: 1203: Cannot open actionlist ERROR: 1204: Corrupted actionlist: Invalid errno, line=%d "errno" line=%d errno ERROR: 1205: Corrupted actionlist: Invalid status, line=%d "status" line=%d status ERROR: 1206: Corrupted actionlist: Invalid action, line=%d "action" line=%d action ERROR: 1208: <Oracle process> process error Oracle Oracle Oracle ERROR: 1213: Action error detected: Offline

77 PRIMECLUSTER Wizard for Oracle Offline Oracle Oracle ERROR: 1214: Action error detected: Faulted Faulted Oracle Oracle ERROR: 1215: Action error detected: Restart Oracle Oracle ERROR: 1219: Cannot read hvgdconfig RMS (hvgdconfig ) RMS ERROR: 1220: Not Found xx setting in hvgdconfig RMS (hvgdconfig ) "%s" RMS ERROR: 1223: Not found AttributeName in hvgdconfig RMS (hvgdconfig ) AttributeName RMS ERROR: 1224: Receiving of monitoring instruction failed (detail) ( ) ERROR: 1225: Reporting of monitoring result failed : status ( ) ERROR: 1226: Checking existence of Detector process failed ( )

78 PRIMECLUSTER Wizard for Oracle ERROR: 1227: Invalid setting in hvgdconfig : AttributeName RMS hvgdconfig AttributeName RMS ERROR: 1299: ORA-xxxxx Oracle "ORA-xxxxx" Oracle Oracle WARN: 1302: Action error detected: Warning Warning Oracle Oracle ERROR: 3402: clorainstance detected Oracle error! (ORA-xxxxx: ) svrmgrl Oracle Oracle Oracle Oracle ERROR: 3403: clorainstance detected Oracle error! (ORA-xxxxx: ) sqlplus Oracle Oracle Oracle Oracle Oracle ERROR: 2202: Cannot map shared memory or get semaphore ( ) ERROR: 2203: Cannot get ORACLE_HOME ORACLE_HOME Oracle ORACLE_HOME ERROR: 2204: Cannot read hvgdconfig RMS (hvgdconfig ) RMS ERROR: 2205: Not Found xx setting in hvgdconfig

79 PRIMECLUSTER Wizard for Oracle RMS (hvgdconfig ) "%s" RMS ERROR: 2206: Not Found AttributeName in hvgdconfig RMS (hvgdconfig ) AttributeName RMS ERROR: 2210: Tnsping detected the error (xx) tnsping Listener Listener Listener ERROR: 2211: The listener name is invalid Listener listener.ora, tnsnames.ora Listener ERROR: 2214: The process of the listener does not exist Listener userapplication userapplication Online Listener Listener ERROR: 2215: Process ID of the listener is not found Listener ID Listener Listener ERROR: 2219: Reporting of monitoring result failed : status ( ) ERROR: 2220: System error occurred(detail) ERROR: 2221: Receiving of monitoring instruction failed (detail) ( )

80 PRIMECLUSTER Wizard for Oracle ERROR: 2222: Checking existence of Detector process failed ( ) INFO: 0101: Fault Watching is disable hvoradisable hvoraenable INFO: 0102: Fault Watching is enable hvoraenable ERROR: 0207: Cannot allocate memory for hvgdconfig : AttributeName ( ) ERROR: 0208: Data init error ( ) ERROR: 0209: Fork error ( ) ERROR: 0211: User xx not found. Oracle Oracle ERROR: 0212: Cannot create log xx

81 PRIMECLUSTER Wizard for Oracle ERROR: 0213: Library init error ( ) ERROR: 0219: Detector aborted Detector ERROR: 0220: Not found <AttributeName> in hvgdconfig. RMS hvgdconfig AttributeName RMS ERROR: 0221: Invalied setting in hvgdconfig : AttributeName RMS hvgdconfig AttributeName RMS ERROR: 0222: Checking permission of resource monitoring failed ( ) ERROR: 0223: Checking existence of fault monitor process failed ( ) ERROR: 0224: Sending monitoring instruction failed (detail) ( ) ERROR: 0225: Receiving of monitoring result failed (detail) ( ) ERROR: 0226: Watch Timeout error occurred (count)

82 PRIMECLUSTER Wizard for Oracle Oracle Listener Oracle Listener Oracle Listener ERROR: 0227: Receiving of Script notice failed ERROR: 0228: Starting fault monitor failed ERROR: 0229: Pipe error ( ) PRIMECLUSTER Wizard for Oracle Oracle Oracle clgetoralog clgetoralog [ERROR] Creation of temporary directory failed! (directory_name) /tmp clgetoralog [ERROR] Invalid RMS Configuration name! (RMS_configuration) RMS RMS_configuration RMS clgetoralog [ERROR] No space in path_name (details)! path_name path_name clgetoralog [ERROR] Creation of directory failed! (directory_name)

83 PRIMECLUSTER Wizard for Oracle clgetoralog [ERROR] "file_name" already exists! clgetoralog [ERROR] Creation of "file_name" failed!" clgetoralog [WARN] Obtaining local SysNode Name failed! SysNode clgetoralog [WARN] Execution of hvw failed! RMS hvw(1m) clgetoralog [WARN] Result of hvw is invalid! RMS hvw(1m) clgetoralog [WARN] Wizard for Oracle resources not found in hvgdconfig! hvgdconfig Wizard for Oracle clgetoralog [WARN] Obtaining RMS Configuration name from CONFIG.rms failed! RMS clgetoralog [WARN] Invalid RMS Configuration name! (RMS_configuration) CONFIG.rms RMS

84 PRIMECLUSTER Wizard for Oracle clorainfo clorainfo: ERROR: Obtaining local SysNode Name failed! SysNode CF (Cluster Foundation) clorainfo: ERROR: Checking RMS running status failed! (details) RMS RMS userapplication clorainfo: ERROR: Obtaining RMS configuration name failed! (details) RMS userapplication clorainfo: ERROR: CONFIG.rms does not exist! (details) CONFIG.rms userapplication clorainfo: ERROR: Wizard for Oracle resources not found userapplication Wizard for Oracle userapplication userapplication Oracle clorainfo: ERROR: The specified resource does not exist on this SysNode(SysNode_name), or does not belong to Wizard for Oracle! - resource_name resource_name SysNode_name resource_name Wizard for Oracle clorainfo: ERROR: Resource does not belong to Wizard for Oracle - resource_name resource_name Wizard for Oracle

85 PRIMECLUSTER Wizard for Oracle clorainfo: ERROR: Invalid RMS Configuration. RMS userapplication clorainfo: ERROR: RMS_configuration does not exist. RMS RMS_configuration RMS hvoradisable/hvoraenable command: ERROR: Internal error! (details) command: ERROR: Failed to disable/enable resource monitoring - resource_name resource_name command: ERROR: hvgdconfig does not exist! hvgdconfig userapplication command: ERROR: Obtaining local SysNode Name failed! SysNode CF (Cluster Foundation) command: ERROR: Obtaining RMS configuration Name failed! RMS userapplication command: ERROR: Execution of hvw failed! RMS hvw(1m) userapplication command: ERROR: Result of hvw is invalid!

86 PRIMECLUSTER Wizard for Oracle RMS hvw(1m) userapplication command: ERROR: Failed to disable/enable resource monitoring! (details) RMS userapplication command: ERROR: No Wizard for Oracle resources belong to specified userapplication! - userapplication_name userapplication userapplication_name Wizard for Oracle userapplication command: ERROR: No Wizard for Oracle resources are in the current RMS configuration! RMS Wizard for Oracle userapplication userapplication Oracle command: ERROR: No Wizard for Oracle resources exist on this node! - SysNode_name SysNode_name Wizard for Oracle userapplication userapplication Oracle command: ERROR: Invalid userapplication or Resource! userapplication userapplication command: ERROR: The specified resource does not exist on SysNode_name! - resource_name SysNode_name command: WARNING: RMS is not running, but the monitoring of resource_name is

87 PRIMECLUSTER Wizard for Oracle disabled/enabled. RMS RMS

88 PRIMECLUSTER Wizard for Oracle CUI CUI GUI <> ( ) CUI GUI 1. Oracle userapplication app1 app2 A.1.2 ( ) Controller userapplication app3 A.1.2 ( ) Generate Activate A.1.4 Configuration-Generate and Configuration-Activate 4. Oracle DB 2.5 / 5. Oracle A.2.1 Application-Edit Generate Activate A.2.2 Configuration-Generate and Configuration-Activate

89 PRIMECLUSTER Wizard for Oracle CUI 1. Oracle userapplication A Generate Activate A.1.4 Configuration-Generate and Configuration-Activate 3. Oracle DB 2.5 / 4. Oracle A.2.1 Application-Edit Generate Activate A.2.2 Configuration-Generate and Configuration-Activate userapplication Oracle Oracle userapplication RMS Configuration Wizard RMS Configuration Wizard # hvw n < > RMS Configuration Wizard RMS Configuration Wizard ( ) 1. Application-Create 2. Configuration-Generate 3. Configuration-Activate userapplication userapplication userapplication Application type selection menu userapplication turnkey wizard (:ORACLE) turnkey wizard

90 PRIMECLUSTER Wizard for Oracle PRIMECLUSTER Oracle ( ) Oracle userapplication Oracle userapplication Main RMS management menu Application-Create userapplication

91 PRIMECLUSTER Wizard for Oracle Application type selection menu ORACLE ( ) Settings of turnkey wizard ORACLE ApplicationName userapplication Machines+Basics Oracle userapplication userapplication HELP PRIMECLUSTER RMS 9 - AutoStartup = no AutoSwitchOver = no

92 PRIMECLUSTER Wizard for Oracle PersistentFault = 1 AutoStartUp no SAVE+EXIT Setting of turnkey wizard ORACLE SAVE+EXIT Main RMS management menu (Oracle ) 1 userapplication 1 6 userapplication userapplication app3 Main configuration menuapplication Create Application type selection menu GENERIC Machines+Basics

93 PRIMECLUSTER Wizard for Oracle SAVE+EXIT Settings of turnkey wizard "GENERIC"Controllers AdditionalAppToControl userapplication app1 app2 ControlPolicy FOLLOW SCALABLE SAVE+EXIT Settings of application type "Controller"

94 PRIMECLUSTER Wizard for Oracle SAVE+EXIT Settings of turnkey wizard "GENERIC" Main configuration menu Main RMS management menu Application-Create userapplication Application type selection menu ORACLE ( )

95 PRIMECLUSTER Wizard for Oracle Settings of turnkey wizard ORACLE ApplicationName userapplication Machines+Basics Machines Machines[0] Machines[1] AdditionalMachines HELP PRIMECLUSTER RMS 9 - AutoSwitchOver = HostFailure ResourceFailure ShutDown PersistentFault = 1 HaltFlag=yes SAVE+EXIT

96 PRIMECLUSTER Wizard for Oracle Setting of turnkey wizard ORACLE (:GDS LocalFileSystemsGls SAVE+EXIT Main RMS management menu (Oracle )

97 PRIMECLUSTER Wizard for Oracle Configuration-Generate Configuration-Activate Main RMS management menu RMS hvcm userapplication userapplication IP IP RMS PRIMECLUSTER RMS 11

98 PRIMECLUSTER Wizard for Oracle "A.1 userapplication " userapplication Oracle # hvw n< > RMS Configuration Wizard ( ) 1. Application-Edit 2. Configuration-Generate 3. Configuration-Activate userapplication userapplication userapplication PRIMECLUSTER Oracle Main RMS management menu Application-Edit Application selection menu "A.1 userapplication " userapplication userapplication app3 app1 app2

99 PRIMECLUSTER Wizard for Oracle Settings of turnkey wizard "ORACLE" Oracle Oracle Oracle Oracle AdditionalInstance AdditionalListener StartPriority Oracle Oracle Oracle Oracle Oracle (MTS) Oracle Oracle Oracle 4. Oracle 6. Oracle Oracle 5. Oracle 6. SAVE+EXIT userapplication Configuration-Generate Configuration-Activate Main RMS management menu

100 PRIMECLUSTER Wizard for Oracle userapplication userapplication

101 PRIMECLUSTER Wizard for Oracle RMS hvcm userapplication userapplication IP IP Oracle IP Oracle RMS PRIMECLUSTER RMS 11