Lab367 - Oracle.doc

Installing Oracle 8i and the VCS Oracle agent consists of the following general steps:1.) Assign a drive letter to the shared disk 2.) Install Oracle and Net8. 3.) Install the database.4.) Stop Oracle services on the system.5.) Preserve the original Oracle installation.6.) Unassign the drive letter. 7.) Install Oracle and Net8 on other cluster systems.8.) Set up the database on other systems 9.) Restore the original Oracle installation 10.) Start database services on other cluster systems.Note It is recommended that you log on as Administrator to install Oracle binaries. This ensures that only the administrator will be able to log on to the database without the internal password.To assign a drive letter to the shared disk1. Start the Disk Administrator. (Start|Programs|AdministrativeTools (Common)|Disk Administrator)2. Select the configured disk.3. Open the Assign Drive Letter window. (Tools|Assign Drive Letter)4. Select the Assign a drive letter option.5. Select a drive letter from the drop-down list.6. Click OK.To Install Oracle and Net8i1. Insert the CD Oracle 8.1.6(8i) Release 2 Enterprise Edition for Windows NT 4.0.2. Run the Setup program.3. Choose to Install Oracle with the Net8 services, and the Database ConfigurationAssistant.4. Follow the wizard instructions, select options as per your configuration, and complete the installation.To install the database1. Verify that the shared drive is mounted on the local system.2. Start the Database Configuration Assistant. This launches the database installer.3. Select Custom Install. Select your configuration options.4. When asked to specify the initialization filename, specify a path on the local disk.5. Select to install the shared data on the shared disk. This includes the control files, redo log files, and data files. If archive log files are created, they too should be on the shared disk.6. Optimize the database on the system by setting the appropriate configurationparameters.7. Select the Create Database Now option. Follow the wizard instructions to complete the installation.8. Go to %ORACLE_HOME%networkadmin and change the hostname to the virtualIP address for this system in both listener.ora and tnsnames.ora files. Thevirtual IP address is derived from the IP resource. For more information on the IPagent, refer to the accompanying Installation and Configuration Guide.9. From the Service Control Manager (Start|Settings|Control Panel|Services), change the startup type of the Oracle and SQLNet services to manual.To stop the Oracle services1. Open the Services control panel. (Start|Settings|Control Panel|Services)2. Select the Oracle service and the listener service.3. Click Stop.4. Click Yes when to asked to confirm whether you want to stop the service.5. Click Close to exit the Services control panel.To preserve the original Oracle installationPreserve the original Oracle installation by renaming the Oracle installation directory.For example, if your data installation directory is Z:Oracle, you could rename it toZ:OracleTemp.To unassign the drive letter1. Start the Disk Administrator. (Start|Programs|AdministrativeTools (Common)|Disk Administrator)2. Select the configured disk.3. Open the Assign Drive Letter window. (Tools|Assign Drive Letter)4. Select the Do not assign a drive letter option.To install Oracle and Net8 on other cluster systemsInstall Oracle and Net8 on each cluster system with the same ORACLE_HOME nameand path. For more information, see To Install Oracle and Net8 on page 5.To set up the database on other cluster systemsTo ensure that all installations are identical, the values you specify while installing and configuring the Oracle database on other systems must match the values specified during the initial database installation.1. Assign a drive letter to the shared disk. See To assign a drive letter to the shared disk on page 5. Verify that the shared disk is mounted from the system.2. Start the Database Configuration Assistant.(Start|Oracle-ORACLE_HOME|Database Administration|Database ConfigurationAssistant). This launches the database installer.3. Select Custom Install. Select your configuration options.4. When asked to specify the initialization filename, specify a path on the local disk.5. Install the shared data on the shared disk. This includes the control files, redo log files,and data files. If archive log files are to be created, they too should be on the shared disk.6. Optimize the database on the system by setting the appropriate configurationparameters.7. Select the Save information to a batch file option, and complete the installation. This creates parameter files and an empty directory structure for datafiles.8. Repeat the process for every additional Oracle installation.To restore the original Oracle installation:1. After you have finished installing Oracle on all cluster systems, delete the lastinstallation directory. For example, if the last Oracle database installation created a directory Z:Oracle on the shared disk, delete this directory.2. Rename the Oracle directory created during the first installation back to its original name. For example, if you had preserved the original installation directory Z:Oracle by renaming it to Z:OracleTemp, rename it to Z:Oracle again.To start database services on other cluster systemsNote The following steps do not apply for the first system on which Oracle and Net8were installed. For example, if the first system is system A, and subsequentinstallations are performed on systems B and C, perform the following steps onlyfrom systems B and C.1. Use ORADIM to create a new manual service for the instance SID where pfileindicates the initialization parameter file. To do this, type the following at thecommand-prompt.set ORACLE_SID=SID%ORACLE_HOME%binoradim -new -sid SID -startmode manual -pfileInitializationFileInitializationFile represents the name of the initialization file for the instance SID. Notethat you must specify the full path of the file, along with its name.2. Verify access to the database by querying the database.3. Go to %ORACLE_HOME%networkadmin and change the hostname to virtual IP address for this system in both listener.ora and tnsnames.ora files. The virtualIP address is derived from the IP resource. For more information on the IP agent, referto the accompanying Installation and Configuration Guide.4. Stop the Oracle services on this system. See To stop the Oracle services on.5. Unassign the drive letter.Installing the Agent SoftwareThe VCS enterprise agent for Oracle is installed using an Installshield wizard. The wizardinstalls the agent on all systems in your cluster, and adds the Oracle and SQLNet resource types to your configuration.Note To install the Oracle agent, the VCS High Availability Engine (HAD) must berunning on all cluster systems1. Insert the VCS Enterprise Agent for Oracle CD.2. From the introduction screen, click Next.3. The next screen displays the list of systems on which the agent will be installed. Verify that all systems in your cluster are listed. Click Next.4. Several messages appear indicating the progress of the installation.5. From the Installation Complete screen, click Finish.Before Configuring the AgentThe VCS enterprise agent for Oracle may be configured in different ways. Beforeconfiguring the agent, review the ORACLE andSQLNet resource types, their attribute definitions, and the sample agent configurations.The Oracle and the SQLNet resource types represent the VCS configuration definition ofthe Oracle agent. The Attribute Definition tables explain the attributes associated with the agent. The agent includes a sample configuration file that you can modify according to your requirements.Oracle Resource Typetype Oracle (static str ArgList = ServiceName, DelayAfterOnline,DelayAfterOffline, DetailMonitor, IndepthMonitorCount, SID,UserName, EncryptedPasswd, SQLFile, AgentDebug NameRule = Oracle_ + resource.ServiceNamestr ServiceNameint DelayAfterOnline = 20int DelayAfterOffline = 20int DetailMonitor = 0int IndepthMonitorCount = 5str SIDstr UserNamestr EncryptedPasswdstr SQLFileint AgentDebug = 0)Attribute DefinitionsRequired Attribute Type andDimensionDefinitionServiceName string-scalar Name of the Oracle service set during the installationof Oracle.Optional Attributes Type andDimensionDefinitionAgentDebug integer-scalar A flag that defines whether the agent logs additionaldebug messages. The value 1 indicates that the agentwill log additional debug messages. The value 0indicates that the agent will not.DelayAfterOffline integer-scalar Number of seconds the agent waits to start themonitoring routine after Oracle is taken offline.Default is 20.DelayAfterOnline integer-scalar Number of seconds the agent waits to start themonitoring routine after Oracle is brought online.Default is 20.DetailMonitor integer-scalar A flag that defines whether the agent monitorsOracle in detail by trying to open and close theservers database file. The value 1 indicates that theagent will monitor Oracle in detail. The value 0indicates that the agent will not monitor Oracle indetail. Default is 0.Note that if the DetailMonitor flag is set to 1, thefollowing attributes must be defined:SIDUserNameSQLFileEncryptedPasswd string-scalar The encrypted password for the database useridentified by UserName. The password must beencrypted with the VCS Encrypt utility, described onpage 2.IndepthMonitorCount integer-scalar An integer that defines the monitor interval betweentwo consecutive detail monitoring cycles. If thisattribute is set to 5, the agent will monitor theapplication in detail every five monitor intervals.Default is 5.SID string-scalar A system identifier that uniquely identifies theOracle database instance to be monitored in detail. Ifno value is specified for this attribute, the agent usesthe ORACLE_SID value from the system registry.SQLFile string-scalar The name of SQL script to be used for detailmonitoring, along with its complete path. Default isVCS_HOMEbinOraclecheck.sql. The agentverifies the existence of this file. A sample filecontents would include:whenever sqlerror exitwhenever oserror exitconnect &1/&2select * from v$database;exit;You must include the connect &1/&2 string whichaccepts the command-line input of user name andpassword, in that order.You must also include the exit command, elseSQLPlus will not terminate, and could potentiallycause a VCS error.UserName string-scalar Valid user name for the database.Sqlnet Resource Typetype SQLNET (static str ArgList = ServiceName, DelayAfterOnline,DelayAfterOffline, AgentDebug NameRule = Sqlnet_ + resource.ServiceNamestr ServiceNameint DelayAfterOnline = 5int DelayAfterOffline = 5int AgentDebug = 0Attribute DefinitionsRequired Attribute Type andDimensionDefinitionServiceName string-scalar Name of the configured listener service.Optional Attributes Type andDimensionDefinitionAgentDebug integer-scalar A flag that defines whether the agent logs additionaldebug messages. The value 1 indicates that the agentwill log additional debug messages. The value 0indicates that the agent will not.DelayAfterOffline integer-scalar Number of seconds the agent waits to start themonitoring routine after Oracle is taken offline.Default is 5.DelayAfterOnline integer-scalar Number of seconds the agent waits to start themonitoring routine after Oracle is brought online.Default is 5.Sample ConfigurationIn the following example, VCS is configured on a two-system cluster (system 1 and system 2). Oracle is installed on both systems, and the data to be used by Oracle is on the shared disks.Sample Configuration on a Two-System clusterIn the following configuration, the shared disk is mounted as drive Z:. The service group IP address for the server is configured using the IP and NIC resource types. The Oracle resource can be started after each of these resources is brought online. The figure below illustrates the configurations dependency graph:Public NetworkVCS Private NetworkSystem 1 System 2Shared DisksOracleSystemFilesOracleDatafilesOracleSystemFilesSample Resource DefinitionOracle ora_thor (ServiceName = OracleServiceTHORDelayAfterOnline = 60DelayAfterOffline = 60DetailMonitor = 1IndepthMonitorCount = 5SID = THORUserName = systemEncryptedPasswd = NECOHACJAIOPACSQLFile = C:Program FilesVeritasClusterServerbinOraclecheck.sqlAgentDebug = 1)SQLNET ora_sqlnet (ServiceName = Oracleora816TNSListenerDelayAfterOnline = 20DelayAfterOffline = 20AgentDebug = 1)Configuring the AgentVCS provides a Cluster Configuration wizard that guides you through the process of configuring the agent. You may choose to configure the agent using the wizard, or the sample configuration templates provided by VCS.Configuring the Agent Using the WizardConfiguring the agent involves the following tasks:Verify the VCS installation and log on to the cluster (page 16).Launch the Cluster Configuration wizard (page 18).Add the Service Group (page 18).Create the service group using a template (page 18).Edit resource attributes according to your configuration (page 19).Bring the service group online (page 19).To Verify the VCS installation and log on to the cluster1. Verify that VCS is running properly on the system. From the command-prompt, type:C:| hasys -display2. Make the VCS configuration writable. From the command-prompt, type:C:| haconf -makerw3. If no user accounts exist, create user accounts:a. From the command-prompt, type:C:| hauser -add user_nameb. Enter a password when prompted.c. Verify your password.d. Create accounts for all users who will use VCS.e. Save the changes to the configuration. At the command-prompt, type:C:| haconf -dump -makeroRetrieve drive and network related information. This information will be requiredwhile editing resource attributes. You may retrieve the information from the followingfiles using Notepad, or any other text editor.C:Program FilesVERITAScommsvcs_nics.txtC:Program FilesVERITAScommsvcs_disks.txt5. Verify that the VCS Cluster Manager is installed.6. Open the Cluster Manager. (Start|Programs|VERITAS Cluster Manager|VCSCluster Manager)7. Log on to the cluster.You may log on to an existing cluster system, or you may create a new cluster.To log on to an existing cluster systemIf the cluster system appears in the Cluster Monitor, follow the instructions below:a. From the Cluster Monitor, click on the cluster system to invoke the login window.b. Enter your user name and password.c. Click OK. The system launches the Cluster Explorer.To create a new clustera. From the Cluster Monitor, create a new cluster. (File|New Cluster)b. From the New Cluster-Connectivity Configuration window, enter the clustername, and the host name.c. Click OK.d. From the login window, enter your user name and password. The systemlaunches the Cluster Explorer.If no service groups exist on the system, the wizard prompts you to launch the ClusterConfiguration wizard.Launch the Cluster Configuration wizard.1. The Cluster Configuration wizard may be launched in two ways:a. Click Yes when prompted to launch the Cluster Configuration wizard.b. Alternately, you may launch the wizard from the Cluster Explorer.(Tools|Configuration Wizard)The Loading Templates Information window appears, and launches the wizard.2. From the wizards Welcome window, click Next.Add the service group1. Enter the service group name.2. From the Available Systems list, select the systems that will cluster the application.3. Click the right arrow to include the selected systems in the service group. The systems added to the service group get listed in Systems for Service Group list.4. If you want to make a system a part of the AutoStartList, click the correspondingStartup checkbox in Systems for Service Group.5. Assign priorities to the cluster systems.6. Click Next.7. From the Would you like the service group to be based on a template? window, clickNext.Create the service group using a template1. Select the OracleGroup template from the list of available templates.2. Click Next.3. If any service group, or resource names clash with existing names, the wizardprompts you with alternate names. You may keep these names, or enter different names.4. Click Next.The wizard informs you that it is ready to create the service group based on theselected template. Click Next. The wizard shows a progress bar indicating servicegroup creation.6. From the Service Group successfully created window, click Next.Edit resource attributes according to your configuration1. Select a resource from the left pane of the window. Its attributes appear in the right pane.2. Select the attribute to be edited.3. Click . in the Edit column.4. From the Edit Attribute window, enter a value for the attribute according to your configuration.5. Click OK.6. Edit attributes for all resources according to your configuration.Bring the service group online1. From the left pane of the window, select the newly-created service group.2. Right-click the service group, and select Enable Resources. This enables all resources in the service group.3. Right-click the service group, and select to enable all systems on which you want to enable the service group. (Right-click|Enable|System_Name orRight-click|Enable|All)4. Save your configuration. (File|Close Configuration)