Installation of Oracle OCFS and database 9.2.0.4
1.Verify that all nodes can view the shared partition within the disk manager in windows 2000 and that they are numbered the same.(Right click on my computer to computer management and select disk management to see disk configurations). The configuration of shared disk should be same on both nodes.
2. Check the setting of external and internal Network Interface Cards. At command prompt on both nodes fire ipconfig to see the public and private ip settings. Should be correct on both nodes.
3. Ensure that all external/public and internal/private Hostnames are defined in the hosts file on all nodes of the cluster. This file is located in the ex: windows\system32\drivers\etc directory.
Entries like 138.3.136.52 racnode1
Entries like 138.3.136.53 racnode2
Entries like 192.168.1.1 racnode1.san
Entries like 192.168.1.2 racnode2.san
4. Ping both using all ip’s to check proper name resolution.
5. See the setting of TEMP and TMP environment settings and these should be same on both nodes. If this is not done cluster check will fail.
6. The local or domain name and password of the oracle user on both the nodes must be same. Also both the nodes must be in the same domain.
7. If WIN_HOME is on C drive and we have to install the ORACLE_HOME onto the E drive on all nodes, we would run the following commands at command prompt from node1
NET USE \\node2\C$
NET USE \\node2\E$
The successful execution of this command gives the message (The command executed successfully).
8. Within a command prompt window run the clustercheck.exe program located in the disk1\preinstall_rac\clustercheck directory. This tool will create a subdirectory called opsm in the temporary directory specified by the TEMP environment variable settings. We can breathe easy if we see the following line at the end of the log.
ORACLE CLUSTER CHECK WAS SUCCESSFUL
9. Copy the media you have in the following format on node 1:
Oracle 9i Release 2(9.2.0.1) EE
E:\installs\9201\disk1\
E:\installs\9201\disk2\
E:\installs\9201\disk3\
Oracle 9i Patch 9.2.0.4
E:\installs\9204\disk1\
Oracle Clusterware 9.2.0.1
E:\installs\ocfs\
Oracle Clusterware patch 9.2.0.4
E:\installs\ocfs9204\
10. Sometimes there are patch issues with some non-oracle services that ma be running on the cluster node. Typically Microsoft Service distributed transaction coordinator (MSDTCS) can interact with oracle software during install. It is recommended this service is stopped and set to manual. After completing installation it can be set to auto.
11. The minimum partition needed for oracle home 4.5GB and 4.0 for datafiles.
12. Copy the following files from E:\install\ocfs9204\3099262\ocfs (after unzipping the original 3099262-zip ) folder to E:\installs\ocfs\preinstall_rac\cfs
ocfs.sys.2k
ocfs.sys.40
ocfsfindVol.exe
ocfsFormat.exe
OcfsOui.bat
OcfsUtil.exe.
The remaining three files will be copied after database creation else cluster setup will not work correctly now.
13. Rename the E:\installs\ocfs\disk1\preinstall_rac\osd to osd.old and copy the E:\install\ocfs9204\3099262\osd directory in its place.
14. Run the cluster setup wizard E:\install\ocfs\preinstall_rac\clustersetup. Remember to select Use pivate network to inter-connect. Enter cluster name. Enter public hostname the private is automatically selected. Choose CFS for datafiles only. Choose desired drive letter. VIA detection screen appears chose yes or no?
If the error cannot find oraoobjlib.dll comes copy this dll from E:\install\ocfs9204\3099262\srvm\olm to c:\winnt\system32\osd9i\olm on BOTH the nodes. Check the following three services on both nodes on successful installation of the software.
OracleClusterVolumeSevice
Oracle Object Service
OracleCMService9i
15. On both nodes rename the WIN_HOME\system32\osd9i\olm dir to .old and copy the E:\install\ocfs9204\3099262\srvm\olm to above location.
16. If oraoobjlib error occurred and was resolved then manually start the service or restart the service if it is running.
17. Change the CM service priority. Using regedit go to HKEY_LOCAL_MACHINE\Software\Oracle\Osd9i\CM. Right click on the right hand pane, and chose new >DBWORD value. Give the new DBWORD name priority. Double click on the new DBWORD to edit its value. Set the value to 2. Hex or Bin does not matter.
18. Restart the CM service once again as its priority has been changed.
19. Install the OCFS support software. Navigate to E:\installs\ocfs\disk1\install\win32 and run setup.exe. In the file location choose the local NTFS drive on which we have to create the oracle home. Enter the Oracle home as ex C:\oracle\ora920 respectively. After installation cfspatch directory will appear in this directory.
Copy the contents of E:\installs\ocfs9204\3099262\srvm\gsd\*.* and E:\installs\ocfs9204\3099262\srvm\dbca\*.* to ORACLE_HOME\cfspatch directory
20. Set the registry entry HKLM\software\oracle\osd\CM……Hostname to private nodename of this node. Do on both nodes.
21. Installing 9201 RDBMS software. Navigate to the directory E:\installs\disk1\ and run setup.exe.
Select the ORACLE_HOME the same as the one in the OCFS support software installation.
22. The OUI fails because it fails to find crlogdr.exe or other files when installing disk3. These files are located in disk1.
23. Install the 22018 OUI and 9204 RDBMS patches. Navigate to the 9204 patchset stage E:\install\9204\disk1 subfolder and run setup.exe. Enter a new oracle home E:\oracle\oui22018. Invoke the new OUI and install 9204 patch this time.
REBOOT both machines and ensure all services start. And MSDSTCS is not running.
