Oracle 4.1 Webcam User Manual
Contents
1. 40 bostl Main EWS management menu current configuration oraclel 13 HELP 2 QUIT 3 Application Create 4 Application Edit bi Application Remove B Application Clone 7 Gonfiguration Genera te 8 Configuration dctiva te 2 Select ORACLE all caps in the Application type selection menu page Creation Application type selection menu 13 HELP 2 QUIT 3 RETURN 4 OPTIONS 5 GENERIC B ORACLE Application Type B 3 Specify the userApplication name of ApplicationName in the Settings of turnkey wizard ORACLE page settings af turnkey wizard ORACLE 13 HELP 2 M SAVETEARIT 3 SAVETERIT 4 REMOVE EXIT 5 ApplicationMame 4FF 1 B MachinestBasical Choose the setting to process 5 4 Select Machines Basics to set up a node and following menu items Create the same number of userApplication as that of Oracle instances Set up a node for each userApplication For other settings refer to HELP or PRIMECLUSTER RMS Configuration and Administration Information Recommended setting AutoSwitchOver no PersistentFault 1 Select SAVE EXIT to save the above setup 41 42 MachineztBasics appl iconsistent 1 HELP fflineDoneScript 2 FaultScript 3 SAVETEXIT Auto tartlp no 4 REMOVE EXIT Autoswi teh ver Mo 5 AdditionalMachine Preservestate no B AdditionalConzole PersistentFaul t 1 7 Machines 0 hozt1EMG ShutdownPriority DI PreCheckScrip2. E PRIME CLUSTER lt PRIMECLUSTER Wizard for Oracle Configuration and Administration Guide 4 1 for Solaris Operating Environment Edition April 2003 Preface Purpose The purpose of the document is to outline functions of PRIMECLUSTER Wizard for Oracle Further it describes the procedures from installation to operation management Readers The document is intended for system engineers and system administrators to design configure and manage a PRIMECLUSTER system The reader should have expertise in the PRIMECLUSTER and Oracle system Outline The document consists of the following 6 chapters and 1 appendix Chapter 1 Feature Chapter 2 Environment setup Chapter 3 Operation Chapter 4 Command Chapter 5 Notice Chapter 6 Message Appendix A Notational convention The document conforms to the following notational conventions ote Describes points to be taken notice of Information Describes information a user can refer to Example Describes by using an example Trademarks Solaris NFS Sun Microsystems are trademarks or registered trademarks of Sun Microsystems Inc in the United States and other countries Sun s logo mark and Solaris are registered trademarks of Sun Microsystems Inc ORACLE and Oracle Applications are trademarks or registered trademarks of Oracle Corporation Requests No part of this document may be reproduced or copied without permission of FUJITSU LIMITED The contents
3. If this process is omitted or failed the operational and standby nodes do not work properly Example You can set the initialized parameter file as follows SORACLE HOME dbs init ORACLE SID ora spfile mnt2 o9idb parameter spfile ora Network setup Set up the Oracle network ORACLE HOME network admin listener ora tnsnames ora listener ora Set up a logical IP address for a listener IP address to switch listeners Example LISTENER DESCRIPTION ADDRESS PROTOCOL TCP HOST lt logical address gt PORT 1521 SID LIST LISTENER SID LIST SID DESC GLOBAL DBNAME oragi ORACLE HOME opt oracle product 9 0 1 SID NAME oraQi tnsnames ora Set up the tnsnames ora file to monitor listener operation by executing the tnsping command Also set up a network service name in the tnsnames ora file and in the Oracle listener environment of Oracle Wizard The ORACLE SID a host logical IP address and a port number which are all set up in this file should be the same as those of the listener of the listener ora file Example Network service name DESCRIPTION ADDRESS PROTOCOL TCP HOST logical IP address gt PORT 1521 CONNECT DATA SID oraQi Check Oracle operation Check if Oracle is properly running by starting and stopping manually 2 6 Create and set up Oracle resource This section explains how to register the Or
4. 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 Q etc services Set up a port number for the Oracle listener Example listener 1521 tcp oracle Oracle User Create DBA database administrator user to allow a user to install Oracle and operate The user ID and the group ID should be identical on all nodes Example groupadd g group ID dba useradd u user ID g dba d export home oracle s bin sh m oracle passwd oracle Normally the group name should be dba Set up environment variables of Oracle user m Example profile ORACLE BASE opt oracle export ORACLE BASE ORACLE HOMEd opt oracle product 8 1 7 export ORACLE HOME ORACLE TERM zsun 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 When usr ucb is contained in PATH it needs to be set up after usr ccs bin Information For further details refer to the Oracle manual Installation Oracle Install Oracle using Oracle user Install a program on each node s local disk The database needs to be created on the shared disk when a cluster system is configured not when Oracle is install
5. watching phase Cannot get the watching message Contact your system administrator Error 2218 Cannot get detector status Cannot receive the detector status Contact your system administrator Common messages Info 0101 Fault Watching is disable Monitoring resource was discontinued To restart monitoring execute hvoraenable Info 0102 Fault Watching is enable Monitoring resource was restarted Error 0202 hvgdconfig Interval Error There is an incorrect setup Interval in the hvgdconfig Check this file Error 0203 hvgdconfig lt Timeout gt Error 37 38 There is an incorrect setup Timeout in the hvgdconfig Check this file Error 0207 Cannot allocate memory hvgdconfig The system error occurred in the mapping memory There are probably insufficient system resources Check the system environment Error 0208 Data init error The system error occurred in the getting semaphore There are probably insufficient system resources Check the system environment Error 0209 Fork error The system error occurred in the process generation There are probably insufficient system resources Check the system environment Error 0210 Watcher exec error The system error occurred in the starting process up There are probably insufficient system resources Check the system environment Error 0211 User xx not found There is an incorrect setup of Oracle user Check it Error 0212 Cannot c
6. 3 Set up standby opero ME 42 A 1 4 Configuration Generate and Configuration Activate sss 44 A 1 5 CHECK USErADPIICAN ON NER TR 45 AZ Greate and sebup Oracle resoun usse oct ense aive drin a Ee 45 A 2 1 ADDICION E EE 45 A 2 2 Configuration Generate and Confouraton Achvate 46 A 2 3 Check userADplication operatoare neon decd e deed caue cacdoavciadsaaieetelaxciweiecceaendeadcacas 48 Chapter 1 Feature Feature outline PRIMECLUSTER Wizard for Oracle is a software product that facilitates cluster operation management for Oracle operating on a PRIMECLUSTER system This is required for scalable operation and standby operation for a cold standby Oracle instance The scalable operation requires Oracle9i Real Application Clusters Oracle9i RAC The standby operation does not require Oracle9i RAC but requires Oracle cold standby instead Module structure For Oracle operation on PRIMECLUSTER the module consists of the followings Environment setup Wizard Environment setup tool to enable Oracle operation on PRIMECLUSTER Control Oracle startup and stop Setup operation command Commands used to set up and operate Environment setup The environment setup tool provides ORACLE Wizard that creates userApplication in the environment configuration of PRIMECLUSTER RMS Monitoring A detector monitors Oracle instances and Oracle listeners The detector is connected to Oracle using system user to monitor the Oracle instance Then it per
7. Failed to acquire shared memory or semaphoe Check the system environment Error 2203 Cannot get ORACLE HOME Failed to acquire ORACLE HOME Check ORACLE HOME environment variable Error 2204 Cannot read hvgdconfig Cannot read the hvgdconfig file Check this file Error 2205 Not Found xx setting in hvgdconfig There is an incorrect setup of resource xx in hvgdconfig file Check this file Error 2206 Not Found Listener in hvgdconfig The listener setup failed in the hvgdconfig file Check this file Error 2207 Cannot send Listener status Online Online notification failed Contact your system administrator Error 2208 Cannot send Listener status Offline Offline notification failed Contact your system administrator Error 2209 The system error occurred fork error The system error occurred in the process generation Check the system environment Error 2210 Tnsping detected the error xx There was an error in tnsping Error 2211 The listener name is invalid The Oracle listener name is incorrect Error 2212 The system error occurred process open error The system error occurred in the process open Check the system environment Error 2214 The process of the listener does not exist An Oracle listener process failure was detected Error 2216 Cannot receive watch message Cannot receive the monitored message Contact your system administrator Error 2217 Cannot get
8. abase and then userApplication using RMS Configuration Wizard This RMS Configuration Wizard adopts the format that allows a user to refer to and select information in the menu The following command is executed on an arbitrary node hvw n Definition name The method of setting the environment is outlined below Select a number from the following menu to create an environment using RMS Configuration Wizard The environment settings using ORACLE wizard are described below 1 Application Create 2 Configuration Generate 3 Configuration Activate The menu written in capitals is a turnkey wizard that facilitates creation of userApplication Information For further details refer to the PRIMECLUSTER manuals A 1 1 Application Create The examples of Oracle environment setup are provided as follows Scalable operation Oracle9i RAC In scalable operation userApplication is configured as shown in the illustration Sy shode Sy shode x pode 1 lt node gt useraoplication user amp pplicatian xappi xappz Q Standby operation In standby operation userApplication is configured as shown in the illustration Syshlode Syshode lt podel lt pade gt user pplication x appi andop andop znadel znadez andoOp TpAddresses LocalFileSy stems A 1 2 Set up scalable operation Oracle 9i RAC 1 Select Application Create in the Main RMS management menu page to create userApplication
9. acle related resource in userApplication 2 6 1 Create Oracle resource This section explains how to create the Oracle resource using userApplication Configuration Wizard 1 Select Create ResourceResource in the userApplication Configuration menu A marp ation Coanftiguratiori Wizard ipaonfig i userApplication Cenfiguration menu ve Jus otaggs pi 3 amp shirmraFiMS Selec a meru b be amp amp up E Create Resource Eat upeepplication or resource Ramzwe usar amp oanticadon or Pasouree Edit global settings in Configuration Create Resource gr sirota RMS Gelec 3 Fhesourte hoe b be created Resource type Oracle ki Hesournce name Cancel Hack Reeg Heli des Applet Window 3 Add the Oracle instance and Oracle listener in the Set up Resource menu Sekec meu lo be l up C Application amecceaciel n Additionsilnstance D AdditicnsiLisTenar gt BlarlPriaritezEamn Te Pa Pau au Pau PPP Pu a PPP Pau I Ls I E ee Tet to dor azrzrign mt least an rsclelnzsztance Wage of an rscleLizstens r Jetbtirngre GE BpnlirmsEi n type Uraecis nob yee rconsiastent CNN d V NNN taut tau DN EE EE EE yee Serer reer err ner AE e ee rE ee ree POPE LR al NENNEN ApplilcationName Change the application name Additionallnstance Add the Oracle instance resource AdditionalListener Add the Oracle listener resource StartPriority Set up a s
10. an user amp pplication zappl zapp2z and p and p zxnadei znadez andop andop Oracle Oracle Oracle Oracle Instancel Liste nerl Instance Liste ner In standby operation userApplication is configured as follows Syshode SysMode xnadei lt node gt user amp pplicatian xappi Oracle Oracle Instance Listener LocalFilesSy stems IpA ddresses GDS 2 6 3 Check userApplication Execute the hvcm command of RMS to start up userApplication and check if it is normally running on all nodes Information See PRIMECLUSTER RMS Configuration and Administration for the RMS command 22 Chapter 3 Operation Set up Oracle related script Script files on a PRIMECLUSTER system control each resource startup and stop Script files in PRIMECLUSTER Wizard also start and stop of the Oracle instance and Oracle listener Along with this Oracle startup and stop the scripts can execute user programs and batch process PreOnlineScript Executed before Online processing PostOnlineScript Executed after Online processing PreOfflineScript Executed before Offline processing PostOfflineScript Executed after Offline processing FaultScript Executed when a fault occurs Notice System administrator access privileges are used for execution The exit code 0 indicates normal termination The value other than 0 indicates abnormal termination or switching process failure The script is abnormally te
11. and the standby nodes Database should be created and set up on the operational node The command should be executed using Oracle user SORACLE BASE ORACLE HOME and ORACLE SID should be set in the Oracle user environment variables The following backup files are stored in the tar file by executing the cloracpy command All resources under ORACLE HOME dbs All resources under ORACLE BASE admin ORACLE SID e ORACLE HOME network admin ora These files should be contained in the tmp oracle ORACLE SID tar file Copy this file to the standby nodes Then the files in the operational node are deployed on the standby nodes by executing the tar xvf tmp oracle ORACLE SID tar command This command stores the files in the tar file and deploys by full path The command should not be executed if the SORACLE BASE or ORACLE HOME setup differs between the operational node and the standby nodes Also if the operational method is different between the operational node and the standby nodes this command is not enabled The file that has a name same as other file will be overridden None 0 Normal termination Other than O Abnormal termination 33 4 9 34 clgetoralog Collect Oracle information for User Format Function Parameter Exit status troubleshooting Super user opt FJSVclora bin clgetoralog n configure name d output directory It is a feature to collect Oracle information f
12. andby operation Oracle Client In standby operation a cluster system consists of an operational node and standby nodes On the operational node Oracle applications a logical IP address and shared disks are active On the standby nodes these resources are inactive In the event of a failure business operation is switched to one of the standby nodes and the resources in this standby node are activated Then the client can be connected to the running node using the logical IP address without modifying any settings Chapter 2 Environment setup Set up environment This section explains a general setup procedure of Oracle operating on a PRIMECLUSTER system Scalable operation Oracle9i RAC K Outline O One arbitrary node Other nodes Install and set up PRIMECLUSTER Install and set up PRIMECLUSTER 9 Install PRIMECLUSTER Wizard for Install PRIMECLUSTER Wizard for Oracle Oracle 3 Install and set up Oracle software Install and set up Oracle software 4 create userappicaton OOO S Create and set up an Oracle database OOOO rs L an Oracle database 7 Greate and setup Oracioresouces fT Standby operation No Operational node Standby nodes 1 Install and set up PRIMECLUSTER Install and set up PRIMECLUSTER 2 Install PRIMECLUSTER Wizard for Install PRIMECLUSTER Wizard for Oracle Oracle 4 Create userApplicaion 1 5 Create and set up an Oracle database 6 Set up an Oracle da
13. e the setting to process 3 4 Add the Oracle instance and Oracle listener in the Oracle setup page Additionallnstance Add the Oracle instance resource AdditionalListener Add the Oracle listener resource StartPriority Set up a startup order of the Oracle instance and Oracle listener Example If you use the Oracle multi threaded server MTS the Oracle listener needs to be started first 5 Setup the Oracle instance See 4 of 2 6 1 Create Oracle resource for details Set up the Oracle listener See 5 and 6 of 2 6 1 Create Oracle resource for details 6 Select SAVE EXIT to save When using Oracle9i RAC follow the setup procedure from 1 to 6 for the number of other userApplication A 2 2 Configuration Generate and Configuration Activate Select Configuration Generate to set up userApplication Then select Configuration Activate to enable the userApplication setup Main RMS management menu hosti Main EMS management menu current configuration 13 HELP 2 QUIT 21 Application Create 4 Application Edit 5 Application Remove B Application Clone 7 Configuration Genera te 9 Configuration Activate In scalable operation userApplication is configured as follows Sy sMode Syshode znadei lt node gt oracle userApplication user amp pplicatian zappiz zapp2 and p andop zx nadei znadez Oracle Oracle Oracle Instancel Liste neri Instance In standby operation userApplication
14. ed The details will be described later in this document Oracle9i RAC Install Oracle9i RAC using root user Refer to the Oracle9i RAC manual Information For further details refer to the Oracle manual 2 4 Create userApplication This section explains how to set up userApplication creation and Non Oracle resource setup Set up the Oracle resource after configuring the database Then set up userApplication using userApplication Configuration Wizard This userApplication Configuration Wizard follows the Wizard format in which you can select the item from the menu and click a Next button Information See Chapter 6 Cluster application configuration of PRIMECLUSTER Installation Administration Guide for the userApplication Configuration Wizard setup 2 4 1 Application Create The Oracle environment setup is described with the following illustrations Scalable operation Oracle9i RAC userApplication is configured as shown in the illustration Sy shlode Sy shlode znadei lt node gt user amp pplication user amp pplication xappi xappz andop and op lt noded gt lt node gt Standby operation userApplication is configured as shown in the illustration Syshode Syshode znadei lt node gt userdpplication appl gt k LocalFileSy stems IpAddresses GDS setup GDS should be set up as shared disk for concurrent access for scalable operation and
15. hared disk ex GDS LocalFileSystems and IpAddress in the Settings of turnkey wizard ORACLE page Settings of turnkey wizard ORACLE 1 HELP 2 a SAVETEXIT 4 5 ApplicationMame APPi B MachineztBaziosiarppl 7 CommandLinesi 8 Contrallersi j 4 RACLE Choose the setting to process 16 10 LocalFileSystemsi 11 RemoteFileSystemat 12 IpAddreszesi 13 RawDisksi 14 RC VolumeHManazementi 15 VERITAS VolumeManagementt 18 Gds Globa 1 Disk Services 17 Gle Global Link Servicest 6 Return to the Main RMS management menu by selecting SAVE EXIT Any settings related to Oracle should not be done here A 1 4 Configuration Generate and Configuration Activate Select Configuration Generate to set up userApplication Select Configuration Activate to enable the userApplication setup Main RMS management menu hosti Main RMS manazement menu current configuration oraclel 1 HELP 2 QUIT 21 Application Create 4 Application Edit bi Application Remove B Application Clone 7 Confizuration Generate 8 Configuralion Aclivale A 1 5 Check userApplication Execute the hvcm command of RMS to start up userApplication and check if it is normally running on all nodes Shared disk Check access to the shared disk on an operational node Logical IP address Check access to an operational node Information See PRIMECLUSTER RMS Configuration and Admin
16. ication type selection menu page Creation Application type selection menu 13 HELP 2 QUIT 3 RETURN 4 OPTIONS 5 GENERIC B ORACLE Application Type B 3 Specify the userApplication name of ApplicationName in the Settings of turnkey wizard ORACLE page settings af turnkey wizard ORACLE 13 HELP 2 M SAVETEARIT 3 SAVETERIT 4 REMOVE EXIT 5 ApplicationMame 4FF 1 B MachinestBasical Choose the setting to process 5 4 Select Machines Basics to set up nodes and following menu items Set an operational node to Machines 0 and standby nodes to Machines n Select AdditionalMachines to add a node For other settings refer to HELP or PRIMECLUSTER RMS Configuration and Administration Information Recommended setting AutoSwitchOver HostFailure ResourceFailure ShutDown PersistentFault 1 Select SAVE EXIT to save the above setup 43 44 MachineztBasics appl consiztent 13 HELP rid a SAVETEXIT 4 REMOVE EXIT 5 Addi tiona lMachine B AdditionalConzole T Machines 0 bost1 BS 0 PreCheckscript 9 Pre nlineSeript 10 Post nlineS3oript 11 PreOfflineSeript Choose the setting to process 7 Offlinelonescript FaultScript Autostar Hlp mo Autoswi teh ver Mo Preservestate no PersistentFaul t 1 ShutdownPriori Luz OnlinePriority StandbyTranzitions LicenseToKill nn Autobreak yes 5 Set up a resource required for the s
17. iodically creates updates and deletes dummy table which is created in the system user s default tablespace by executing the SQL command This enables the detector to detect a logical failure as well as the process state of the Oracle instance When the Oracle instance hangs and if the SQL command is not returned within a specified time the detector times out to notify a user of the failure The two types of monitoring of the Oracle listener are process detection and the tnsping command Startup and stop control Along with the state transition of a cluster system scripts automatically start or stop Oracle instances or Oracle listeners These scripts first check and then start up the Oracle instance If damage has occurred the scripts automatically recover the Oracle instance For example if the Oracle instance fails during online backup the scripts automatically execute end backup to start up the Oracle instance When the AutoRecover is set to Yes When stopping the Oracle instance the scripts stop it in the immediate mode default If this does not occur properly the scripts stop the instance in the abort mode This means operational node switchover can be performed at high speed 1 2 Operating Environment Scalable operation Oracle Client DU In scalable operation with Oracle9i RAC Oracle is operated on all nodes Regardless of which node a client is connected to the client is able to use the database St
18. is configured as follows Oracle Liste ner 4 48 A 2 3 SysMode Syshlode lt node gt lt node gt user amp pplication xappi andop and Op lt nodel gt lt nodez gt Oracle Oracle Instance Liste ner Tp4ddresses LocalFileSy stems Check userApplication operation Execute the hvcm command of RMS to start up userApplication and check if it is normally running on all nodes Information See PRIMECLUSTER RMS Configuration and Administration for the RMS command
19. istration for the RMS command A 2 Create and set up Oracle resource The Oracle related resource is registered in userApplication that is created in Chapter 2 4 Execute the following command on an arbitrary node hvw n Definition name For further details refer to PRIMECLUSTER RMS Configuration and Administration A 2 1 Application Edit The examples of Oracle environment setup are provided as follows 1 Select Application Edit in the Main RMS management menu page to edit userApplication bostl Main EWS management menu current configuration oraclel 13 HELP 2 QUIT 3 Application Create 4 Application Edit 5 Application Remove B Application Clone 7 Gonfiguration Genera te Di CGonfiguration detiva te 2 Select userApplication created in the Application selection menu page of Chapter 2 4 45 Edit Application selection menu restricted 1 HELP 2 QUIT a RETURN 4 OPTIONS 5 APPI B APP Application Mame 5 3 Select ORACLE in the Settings of turnkey wizard ORACLE page settings af turnkey wizard ORACLE 13 HELP 10 LocalFileSyzstemsi 2 11 RemateFileSyztemzt 3 SAVEFEXIT 12 Ip ddressest 4 13 Rawlizkzi bi pplicationMame APP 14 RG VolumeManazement B MachinestBasics appl 15 VERITAS VolumeManagementi j TI CommandLinezi 16 BGdz Global Disk Servicezihds sc 8 Contrallersi j 17 Gle Global Link Servicest 9 RAGCLE Choos
20. llocated as follows Server parameterfile Share SS Create database Scalable operation with Oracle9i RAC Create a database on an arbitrary node This database should be accessible from other nodes Information Refer to the Oracle9i RAC manual Create database Standby operation Operational node Create a database on an operational node Standby nodes have to access this database Information Refer to the Oracle manual Standby node Set up directory generation file copy and link The configuration should be the same as that of the operational node where the database is generated Under 0RACLE_HOME dbs Under 0RACLE_BASE admin ORACLE_ SID The access privilege to the generated directory and file should be the same as that of the operational node Set up an output location on the standby nodes if you use archive log operation Information The required files in the operational node can be backed up in a tar format by executing the cloracpy command Refer to Chapter 4 4 Mutual standby N 1 Standby operation Create a database on an operational node On the standby nodes the database on the shared disk created from the operational node should be enabled This is the same as other operation methods Example Mutual standby mi Al Oraclez Example 2 1 Standby OracleS9i Allocate a server parameter file on the shared disk when using the Oracle9i server parameter file
21. na rrn rnnr nren 17 2 6 2 Set up userApplication E 21 2 6 3 Check userApplication c T e eeaees 22 tz onc EMEN T m 23 3 1 Setup Oracle related SCIiIPt cece cceccceeecceeeeceeeeseeeeeeeeeeseeeeseeeseaeessaeessaeeeseeeseaeessaeessaeeeessaeeesaneesens 24 3 2 Oracle stop during cluster operaton 25 3 39 Action defmition file s erasa bereet 26 3 4 Solution at the time Of awitchover nennen nnne nnne n nsna nsns nnns sn a sss na sre ans 27 3 5 Collect information for troubleshooting cccccecseeeeeeeeeeeeceeeeeaeeeeeaeeeeesaeeeesseeeeesseeeeeseaeeeeseneeesaeaaeeeesaaes 28 Saone MEE ein lr Te WEE 29 4 1 hvoradisable Discontinue monitoring resource eene nnne nnne ener nnn nnns 30 4 2 X hvoraenable Restart monitoring resource nennen nnne nnne nnne nnne nnns 31 4 3 clorapass Set up password for monitoring seesssessssssssssssseeeeeeeeneneene nennen nennen nnns 32 4 4 cloracpy Oracle environment setup tool for standby node sssesseeeeeeeeneeer 33 4 5 clgetoralog Collect Oracle information for Iroubleshootng 34 CAD ets om eie TREE mE 35 Chapter lt 0 Message ar eas esee ttes ie eife o etu uatycensanemiuc eit cause Ur cese toS utenc operi ce Di dde LE Mnt 36 Appendix A Setup method BEILER EE 39 Al GrEgtesUSemADOlCALON TEES 39 A 1 1 elei Ter ere Ee 39 A 1 2 Set up scalable operation Oracle 9i RA 40 A 1
22. o enable this feature RMS attempts to recover the failed resources to prevent userApplication from switching to other host PreOnlineScript Executed before Online processing No default PostOnlineScript Executed after Online processing No default PreOfflineScript Executed before Offline processing No default PostOfflineScript Executed after Offline processing No default FaultScript Executed when a fault occurs No default Save by selecting SAVE EXIT LU ef m Heaton Longue ton Yard eoni l Set up Resource Resource type Oracle ve le otaggs gr shirmtaFiMS Selec marni to be amp amp up A SAVE EXIT pplicalipnHamez oracle Aandilionslnslantie Lo AdditionalListenar L euari narit Earmeg gt Or amp tieinetsciceNameli arsr nd 1 OratleLiser eH ame 0 LISTENER settings of application type Grecis consistent Zelect tse SAVEHEXIID ani to cre te Set and click Regixtrstaion When using Oracle9i RAC follow the setup procedure from 1 to 6 for the number of other userApplication Set up userApplication This section explains how to create the userApplication and Oracle resource referring to 8 1 1 Modify cluster application configuration of PRIMECLUSTER Installation Administration Guide In scalable operation userApplication is configured as follows Syshode Syshode lt node gt podez gt t user amp pplicati
23. of this document may be revised without prior notice All Rights Reserved Copyright C FUJITSU LIMITED 2003 Contents Configuration and Administration Guide cccccccccceseeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeseeeeeeseeseesseeeeeseeeeesseeeesaeeeeeseeeeeas 1 jars eng M ND GE 4 1 1 Calle QUEING tei a Seth ona cede tave ccta e ea a bae e e cts aad obedscen de Set ak water ete aar see aaen Fated 5 1 2 Operating Environment 6 Chapter 2 Environment setup ccccccccceccccccceeeeceeeeaeceeeeaeececeeeuesceeeeeaesceeeeeueeceeeaueceeeeeueeeeseeaugeeeeaenseeeeeeeaeess 7 2 1 Setup epnvironment cece ecc cc eeccceecec ee ecceeeeceeeseaceseeeeeaeeeeseeeceaeessaeeeseeeeseasessaeessaeesseeeeseaeeeseusesseeesseeeeas 8 2 2 Install and set up PRIMECLUSTER software 9 2 3 Install and set up Oracle software 10 2 4 Create userApplication cccccccceccccseccceeeeeceeeceeeseeeeeseeeeseeeseaeeeseeeeseaeeseaeessaeeeseeeeseaeessaeessueeessaeeesaeeeseas 12 2 4 1 Application Gr ate EE 12 2 4 2 Check userApplication cccccccecccceececeeeeceeececeeeeceaeeeeeeeeeeeseeeesseeeeseeeeseaeessaeeeseeeeseueessaeesseeeetseeeess 13 2 5 Create and set up Oracle database cccccccccecccceccceeeeeceececeeeeeseeceseeceseceseecesseeeseesesseeesseeeeseeeessaneeesaes 14 2 6 Create and set up Oraceresource 17 2 6 1 Create Oracle resource n nunanunnnnsninsninsnirrnirrnrrsrrrerrrenirrnrrtrirenrrenrerr rrr trrrurrn errari nrn
24. or troubleshooting The clgetoralog command collects Oracle information and log files on a PRIMECLUSTER system The clgetoralog command collects SORACLE HOME dbs log SORACLE HOME rdbms log SORACLE HOMEJ admin SORACLE SID pfile ora SORACLE HOMEJ admin ORACLE SID bdump log e ORACLE HOME network admin ora e SORACLE HOME network log log If n option is specified the clgetoralog command collects configuration information of PRIMECLUSTER Wizard for Oracle and log files n configure name It specifies the RMS definition name including the PRIMECLUSTER Wizard for Oracle information that you need in addition to Oracle information Without this option the clgetoralog command collects Oracle information using current active RMS definition name d output directory It specifies the directory where collected Oracle information is stored Without this option collected Oracle information is stored in the following directory opt FJSVclora bin snap 0 Normal termination Other than O Abnormal termination Chapter 5 Notice This section explains the points you need to pay close attention to The Oracle database needs to be allocated to the shared disk PRIMECLUSTER operated with Oracle products of different versions is not supported For the supported Oracle products refer to the installation guide or handbook A user name user ID group name and group ID should be identical on all node
25. ource that is discontinued monitoring resource name It specifies the resource name of the Oracle instance or listener that is restarted monitoring 0 Normal termination Other than 0 Abnormal termination 31 4 3 clorapass Set up password for monitoring 32 User Format Function Parameter Exit status Super user opt FJSVclora sbin clorapass It is a feature to specify a password of Oracle system user in PRIMECLUSTER Wizard for Oracle by executing the clorapass command The detector monitoring the Oracle instance is connected to Oracle using system user For that purpose this detector requires the password of Oracle system user If the password is not set up in this Wizard for Oracle the detector uses manager as a system user password None 0 Normal termination Other than O Abnormal termination 4 4 cloracpy Oracle environment setup tool for User Format Function Parameter Exit status standby node Oracle DBA user opt FJSVclora sbin cloracpy The required files in the operational node can be backed up in a tar format by executing the cloracpy command By deploying this backup data on the standby nodes the file copy and link settings are enabled Execute the cloracpy command SORACLE_HOME and ORACLE_BASE should be identical between the operational node and the standby nodes Oracle configuration should be the same between the operational node
26. plication during maintenance When the hvoradisable command properly stops monitoring the resource this brings the resource Warning on Web Based Admin View 25 3 3 Action definition file 26 The instance monitoring detector of Oracle Wizard determines what corrective action should be taken from an error code The action definition file consists of Oracle error numbers corrective actions and error messages e Action definition file name and path letc opt F JSVclora F JSVclorafm actionlist o File format errno Status Action Message 18 20 470 471 472 942 1012 1034 Cn Wa maximum number of sessions exceeded Cn Wa maximum number of processes s exceeded All Of LGWR process terminated with error All Of DBWR process terminated with error All Of PMON process terminated with error OI Np table or view does not exist All Rs not logged on All Of ORACLE not available errno Indicates an Oracle error number ORA xxxxx Status Indicates the detector state Cn When connecting to the Oracle instance Ol Under connection to the Oracle instance Dc When disconnecting to the Oracle instance All Any status of above Action Indicates detector s operation Np Ignores any detected errors Of Notifies Offline Wa Notifies Warning Rs Restarts detector Fa Notifies Faulted When an error is detected by executing the UPDATE command of SQL and if NP is shown as a correcti
27. raka Walch Tinmepute 300 Selecr the SAVE EETURM menu rco save the setup aed click Hexr E E E 4 E d E E E E ListenerName Listener name OracleUser Oracle installation user StartTimeout Timeout duration of Oracle startup Default 180s 120s 86400s StopTimeout Timeout duration of Oracle stop Default 60s 60s 86400s Interval Monitoring interval of Oracle instance Default 30s 5s 86400s WatchTimeout No response time during monitoring Oracle Default 300s 30s 3600s 6 Advanced setup 20 T abuser Application Configuration Wizard om omm Ee Sat up Resource Resource type Oracle amp j shirmar Eeleci a menu to be set up ONS Marne Baim BopTImeoute GO nera Wake Timeout 300 gt Aub Pec eer yee 12 PracnilinpEcriptz Posttinlinesicrig e O iPreOffineSrript Post0MineScrip o Fautleipt Select the ZATESPETUPM mem to save the setup smi click Herc TNSName Network service name used to monitor the Oracle listener Note The tnsping command is used to monitor the Oracle listener if TNSName is set This TNSName is set in tnsnames ora When TNSName is omitted the feature to monitor only the listener process is enabled arbitrary AutoRecover Feature to recover resources Note Select yes t
28. reate log xx Cannot create log files There are probably insufficient system resources disk space Check the system environment Error 0213 Library init error The system error occurred in the initialization There are probably insufficient system resources Check the system environment Error 0214 Cannot get watching status Cannot get watching status Contact your system administrator Error 0215 Cannot get monitor status Cannot get monitor status Contact your system administrator Error 0216 Send watch message error Cannot send watch message Contact your system administrator Error 0217 Receive result error Cannot receive watch result Contact your system administrator Error 0218 Timeout occurred There is no response from Oracle or Listener Check Oracle Alertlog files or Listner log files to confirm if Oracle or Listener is normal Error 0219 Detector aborted The system error occurred and detector terminated There are probably insufficient system resources Check the system environment Appendix A Setup method using CUI This appendix explains how to create the environment configuration using CUI A 1 Create userApplication following the procedure of Chapter 2 4 A 2 Create the Oracle resource following the procedure of Chapter 2 6 A 1 Create userApplication This section explains userApplication generation and non Oracle resource setup Set up the Oracle resource after configuring the dat
29. recovery is required the file names in the opt FJSVclora usr directory should be replaced as follows mount1OEndBackup sh lt gt mount1OEndBackup sh mount20MediaRecover sh lt gt _mount20MediaRecover sh 35 Chapter 6 Message 36 This section lists console messages that are output while PRIMECLUSTER Wizard for Oracle is running The messages are indicated in the syslog 3C format Oracle instance detector messages Error 1202 Cannot map shared memory or get semaphore Cannot map shared memory or get Semaphore Check the system environment Error 1203 Cannot open actionlist Cannot open the action definition file Check this file Error 1204 Corrupted actionlist Invalid errno line xx There is an incorrect setup in the action definition file Check errno of the message line number xx Error 1205 Corrupted actionlist Invalid status line xx There is an incorrect setup in the action definition file Check status of the message line number xx Error 1206 Corrupted actionlist Invalid action line xx There is an incorrect setup in the action definition file Check action of the message line number xx Error 1207 Cannot receive watched status Cannot receive the monitored status Contact your system administrator Error 1208 lt Oracle process gt process error An Oracle process error was detected Error 1209 Cannot send Oracle status Online Online notification failed Contac
30. rminated when the execution time exceeds the given timeout This also causes a failure during switchover process X Each script has the environment variable defined in RMS Information See PRIMECLUSTER RMS Configuration and Administration for further details 24 Oracle stop during cluster operation PRIMECLUSTER Wizard for Oracle monitors an Oracle system while PRIMECLUSTER is running If the Oracle system is stopped this PRIMECLUSTER Wizard considers it as a failure Then the Oracle system is restarted or switched over to a standby node If maintenance work such as Oracle cold backup is required discontinue to monitor Oracle executing the following command When discontinuing opt FJSVclora sbin hvoradisable application name resource name When restarting opt FJSVclora sbin hvoraenable application name resource name These commands are executed for the Oracle instance and listener resource on the node where maintenance work is required Information See Chapter 4 Command Mote Restart monitoring When the Oracle instance and or listener is stopped and monitoring is discontinued restart the Oracle instance and or listener before monitoring is restarted State transition during maintenance When the Oracle system is not monitored the state transition does not occur even in the event of an Oracle failure However the state transition might occur because of other glitches like disk failures userAp
31. s to install Oracle Q A different user name should be assigned respectively to create multiple ORACLE HOME in one server Q To monitor the Oracle instance the detector is connected to the database by using system user The detector also checks Oracle operation by using the system user s default tablespace Q The Oracle instance fails to stop in the immediate mode in the following situations 1 DBA user is connected to the Oracle instance or 2 The Oracle instance backup is in progress Ifthe Oracle instance is stopped in the abort mode automatic recovery runs when the Oracle instance is restarted next time Q The Oracle resource needs to be allocated to the shared disk as prerequisite The Oracle archive log files might be stored on the local disks In such a case if recovery is required the files from all nodes should be put together on the node where Oracle is recovered Q Startup and stop time of the Oracle instance varies depending on the database size The default timeout duration of the Oracle instance startup is 10 minutes The default timeout duration of the Oracle instance stop is 5 minutes Q Be aware of the exit code and timeout duration when the following scripts are set up PreOnlineScript PostOnlineScript PreOfflineScript PostOfflineScript FaultScript When a database failure is detected during Oracle instance startup recovery operation is automatically run This is not applicable to OracleQiIRAC If
32. switching disk for standby operation We recommend that you prepare the disk class for Oracle system table space and other Oracle resources respectively The MONITORONLY attribute should be set up to NO for the Oracle system table space and YES for the other Oracle resources userApplication setup 2 4 2 Create userApplication using userApplication Configuration Wizard See Chapter 6 Cluster application configuration of PRIMECLUSTER Installation Administration Guide In scalable operation userApplication should be created for each node In standby operation one userApplication should be created for all operational nodes The recommended values are as follows Scalable operation Oracle9i RAC Operation Standby AutoSwitchOver no PersistentFault 1 HaltFlag Yes Additional resources Gds resource Standby operation Operation Standby AutoSwitchOver HostFailure ResourceFailure ShutDown PersistentFault 1 HaltFlag Yes Additional resources Gds resource Fsystem resource Network resource Check userApplication Execute the hvcm command of RMS to start up userApplication and check if it is normally running on all nodes Shared disk Check access to the shared disk on an operational node Logical IP address Check access to an operational node 2 9 Create and set up Oracle database Allocate database Create a database on the shared disk The shared disk should be active Each file is a
33. t nlinePriority 9 Pre nlineSoript StandbyTranszitions 10 iPost nlineScript LicenseToKill no 11 iPre fflineScripi AutoBreak yes Choose the setting to process 7 5 Set up a resource required for the shared disk ex GDS in the Setting of turnkey wizard ORACLE page settings af turnkey wizard ORACLE 11 HELP 10 LaocalFileSystemzi 2 11 RemateFileSvztemz 3 SAVEFEXIT 12 Ip ddressest 4 13 Rawlisksi bi pplicationMame APPi 14 RC VolumeHanagement B MachinestBasicsiappl 15 VERITAS VolumeManazementi 7 CommandLinest 16 Gds Global Disk Services 8J Controllersi 17 Glz Global Link Servicesi 8 DRACLEL Choose the setting to process 16 6 Return to the Main RMS management menu by executing SAVE EXIT Any settings related to Oracle should not be done here 7 With the procedure from 1 to 6 the node setup is done For scalable operation create the same number of userApplication as that of all nodes This setup procedure should be done on all nodes A 1 3 Set up standby operation 1 Select Application Create in the Main RMS manage menu page to create userApplication hoti Main EWS management menu current configuration oraclel 13 HELP 2 QUIT 3 Application Create 4 Application Edit bi Application Remove B Application Clone 7 Gonfiguration Genera te 8 Configuration detiva te 2 Select ORACLE in capitals in the Appl
34. t delete or edit these files 21 3 9 Collect information for troubleshooting The following information is helpful in the event of a failure Oracle information Setup file ORACLE HOME network admin ora SORACLE_HOME dbs ora ORACLE BASE admin ORACLE SID pfile ora Logging file ORACLE HOME rdbms log alert ORACLE SID log ORACLE BASE admin SORACLE SID bdump alert ORACLE_SID log ORACLE HOME network log ListenerName log PRIMECLUSTER information You can collect information by executing the collecting information for troubleshooting command of PRIMECLUSTER Refer to PRIMECLUSTER Configuration and Administration Guide PRIMECLUSTER Wizard for Oracle information Setup file lopt FJSVclora etc usr opt reliant etc hvgdconfig usr opt reliant build wizard d lt configuration name gt usfiles Log file var opt reliant log var opt FJSVclora 28 Chapter 4 Command 4 1 30 hvoradisable Discontinue monitoring resource User Format Function Parameter Exit status Super user opt FJSVclora sbin hvoradisable application name resource name It is a feature to discontinue monitoring the specified Oracle instance or Oracle listener resource This function is used to stop the Oracle instance or Oracle listener for maintenance t is disenabled while userApplication is stopped Itis enabled when userApplication is activated next time Then the resource goes into the Warning state
35. t your system administrator Error 1210 Cannot send Oracle status Offline Offline notification failed Contact your system administrator Error 1211 Cannot send Oracle status Warning Warning notification failed Contact your system administrator Error 1212 Cannot send Oracle status Faulted Fault notification failed Contact your system administrator Error 1213 Action error detected Offline Offline was detected Error 1214 Action error detected Faulted Faulted was detected Error 1215 Action error detected Restart Restarts the detector Error 1216 Cannot get watching phase Cannot receive the monitoring state Contact your system administrator Error 1217 Cannot get detector status Cannot receive the detector status Contact your system administrator Error 1219 Cannot read hvgdconfig Cannot read the hvgdconfig file Check this file Error 1220 Not Found xx setting in hvgdconfig There is an incorrect setup of resource xx in hvgdconfig file Check this file Error 1223 Not found ORACLE SID in hvgdconfig ORACLE SID is not found in the hvgdconfig file Check this file Error 1299 ORA xxxxx An Oracle error was detected Check Oracle and Oracle Alertlog files Warn 1302 Action error detected Warning Warning was detected Check Oracle and Oracle Alertlog files Oracle listener detector messages Error 2202 Cannot map shared memory or get semaphore
36. tabase 7 Greate and setup Orace resources OOOO Further details of each step are described below 2 2 Install and set up PRIMECLUSTER software This section explains how to install and set up PRIMECLUSTER Set up hardware Set up hardware required for PRIMECLUSTER The shared disk is also required to create the Oracle database Install software Install PRIMECLUSTER first referring to PRIMECLUSTER Installation Guide Then install Oracle Wizard following the instructions of PRIMECLUSTER Wizard for Oracle Installation Guide Scalable operation requires PRIMECLUSTER Enterprise Edition Standby operation requires PRIMECLUSTER Enterprise Edition or PRIMECLUSTER HA Server Set up cluster system Set up a cluster system including network systems and shared disk units according to the PRIMECLUSTER manual 2 3 Install and set up Oracle software This section explains how to install and set up Oracle Initial setup etc system Set up values in the etc system file for Oracle in addition to the values for PRIMECLUSTER The kernel parameter values vary depending on the implemented Oracle versions Refer to the Oracle installation guide The parameter values should be identical on all nodes Note Before installing Oracle you need to change the etc system file and reboot the node Example The setup examples are shown below set shmsys shminfo_shmmax 4294967295 set shmsys shminfo shmmin 1
37. tartup order of the Oracle instance and Oracle listener Example If you use the Oracle multi threaded server MTS the Oracle listener needs to be started first 4 Setup the Oracle instance as follows ES uses Application Configuration Wizard E Set up Resource Resource type Oracia Soke a meri m be sed up O SAVE RETJRH L OracleUsermoracle L Bisetfrnppnuk DD O Step Timeout 180 2 AbarfTimecutz en D StooMndestopsimmediate StoppdeF aliai _ merae 30 Witch Tieneoutz 300 OracleSID ORACLE SID OracleUser Oracle Installation user StartTimeout Timeout duration of Oracle startup Default 600s 300s 86400s 18 StopTimeout Timeout duration of Oracle stop Default 180s 60s 86400s AbortTimeout Timeout duration of forced termination in the event of an Oracle stop error Default 60s 60s 86400s StopModeStop Oracle stop mode in normal time Default Immediate mode abort immediate transactional StopModeFail Oracle stop mode in the event of a failure Default Abort mode abort immediate Interval Monitoring interval of Oracle instance Default 30s 5s 86400s WatchTimeout No response time during monitoring Oracle Default 300s 30s 3600s 5 Setup the Oracle listener as follows EX user Application Configuration Wizard ee o 5 H m EDU EE AlBi xi e shar nahe Beil a menu to be s t up e GAVE RETURA C OracieUseroracle D BlapTimecut B0 L2 me
38. ve action the subsequent process has to be discontinued Take the Rs process Message Indicates text of an error code 3 4 Solution at the time of switchover Oracle logging When switchover or degeneration occurs solve the problem referring to Oracle alert logging or trace logging in the same way as the solution in single Oracle operation PRIMECLUSTER Wizard for Oracle logging PRIMECLUSTER Wizard for Oracle provides information what kind of failure is detected and what corrective action is taken in the following log files lvar opt reliant log FJSVclora OracleSID log var opt reliant log FJSVclora_ lt ListenerName gt _ log The log file formats are as follows Date type ID text 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 01034 Oracle not available Date Output in the format of YYYY MM DD HH MM SS Type Indicates classification Information Error Warning ID Indicates a message number Text Indicates message content Note There is no restriction of space or memory for log files RMS manages the log files Information The following trace logs are output as information for troubleshooting var opt FJSVclora FJSVclora_ lt OracleSID gt _ trclog var opt FJSVclora FJSVclora_ lt ListenerName gt _ trclog Note The log files and the trace files are important for troubleshooting Do no
39. without starting the Oracle instance or Oracle listener If the opt FJSVclora sbin hvoradisable command is executed while userApplication is running this disenables the feature to monitor the Oracle system immediately and the resource state goes into the Warning state You need to confirm if the resource state is Warning and then stop the Oracle instance or Oracle listener Even though the Oracle instance or Oracle listener is stopped the resource remains Warning Along with userApplication stop this feature is automatically cancelled application name It specifies the userApplication name including the resource that is discontinued monitoring resource name It specifies the resource name of the Oracle instance or listener resource that is discontinued monitoring 0 Normal termination Other than 0 Abnormal termination 4 2 hvoraenable Restart monitoring resource User Format Function Parameter Exit status Super user lopt F JSVclora sbin hvoraenable application name resource name It is a feature to restart monitoring the Oracle instance or Oracle resource This function is disenabled while userApplication is stopped Itis enabled when userApplication is activated next time Execute the hvoraenable command while the Oracle instance or Oracle listener is running Confirm if the resource state is changed from Warning to Online application name It specifies the userApplication name including the res
Download Pdf Manuals
Related Search