1、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.

2、 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

3、 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. (T

4、ools|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

5、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

6、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.

7、 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

8、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

9、 (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

10、 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, y

11、ou 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 o

12、ption.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

13、, 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

14、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 fi

15、lename, 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 conf

16、igurationparameters.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 yo

17、u 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 i

18、ts 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 inst

19、alled. 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

20、, type the following at thecommand-prompt.set ORACLE_SID=SID%ORACLE_HOME%binoradim -new -sid SID -startmode manual -pfile"InitializationFile"InitializationFile represents the name of the initialization file for the instance SID. Notethat you must specify the full path of the file, along wi

21、th 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 ag

22、ent, 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 wizardinstal

23、ls 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 scr

24、een, 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 Co

25、nfiguring 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 configurati

26、on 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,De

27、layAfterOffline, DetailMonitor, IndepthMonitorCount, SID,UserName, EncryptedPasswd, SQLFile, AgentDebug NameRule = Oracle_ + resource.ServiceNamestr ServiceNameint DelayAfterOnline = 20int DelayAfterOffline = 20int DetailMonitor = 0int IndepthMonitorCount = 5str SIDstr UserNamestr EncryptedPasswdstr

28、 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

29、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.DelayAfterOnlin

30、e 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

31、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

32、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 theapplicat

33、ion 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

34、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;

35、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

36、Resource Typetype SQLNET (static str ArgList = ServiceName, DelayAfterOnline,DelayAfterOffline, AgentDebug NameRule = Sqlnet_ + resource.ServiceNamestr ServiceNameint DelayAfterOnline = 5int DelayAfterOffline = 5int AgentDebug = 0Attribute DefinitionsRequired Attribute Type andDimensionDefinitionSer

37、viceName 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 th

38、at 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 i

39、s 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 di

40、sk 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 Net

41、workSystem 1 System 2Shared DisksOracleSystemFilesOracleDatafilesOracleSystemFilesSample Resource DefinitionOracle ora_thor (ServiceName = OracleServiceTHORDelayAfterOnline = 60DelayAfterOffline = 60DetailMonitor = 1IndepthMonitorCount = 5SID = THORUserName = systemEncryptedPasswd = NECOHACJAIOPACSQ

42、LFile = 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 config

43、uring 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 C

44、onfiguration 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

45、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 whe

46、n 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 m

47、ay 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|VCSClust

48、er 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 inv

49、oke 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 n

50、ame.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

51、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 wind

52、ow, 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

53、 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.Cr

54、eate 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 N

55、ext.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 configurati

56、on1. 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 al

57、l 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 Configurati