Problem
How can I install Oracle 7.3.2 Workgroup Server on my OpenServer 6.0.0 system?
Solution
What follows are the steps you need to take to install an Oracle 7.3.2 Workgroup Server on SCO OpenServer 6.0.0.
1) Requirements:The requirements to install and Oracle 7.3.2 Workgroup Server on OpenServer 6.0.0 include:
- An installed and configured OpenServer 6.0.0 Server- An SCO OpenServer Release 6.0.0 Development SystemThis is available on your OpenServer 6.0.0 Media Kit CD1 but will require a license to install.
- Oracle 7.3.2 Workgroup Server Media and License- An Oracle 7.3.2 Workgroup Server patch for OpenServer 6.0.0, which is available from SCO Support.
2) Before you install Oracle 7.3.2 Workgroup Server:
Before installing Oracle 7.3.2 Workgroup Server you will need to configure your OpenServer 6 server as follows as the root user:
- Check if using the Software Manager (custom) to see if the SCO OpenServer 6.0.0 Development System is installed. If it is not then obtain a license for the Development System and install the product from the OpenServer 6.0.0 CD1 media.
- Check the value of ULIMIT in:/etc/default/logine.g. Run the command:# cat /etc/default/login | grep ULIMITIf it is not set to 4194303 or unlimited then, using your favourite editor, edit /etc/default/login and set ULIMIT to:
4194303- The SEMMNS kernel parameter need to be set to 200 or above. You can check the value it is currently set to using:
# /etc/conf/bin/idtune -g SEMMNSIf this command returns:200 60 60 2500then this indicates that SEMMNS is set to 200.
If you need to increase the SEMMNS kernel parameter use:
# /etc/conf/bin/idtune -f SEMMNS 200Please Note: The default OpenServer 6.0.0 values for SHMMAX, SHMMIN, SHMMNI, and SEMMNI are acceptable values for use with Oracle.
- If you have increased SEMMNS above then you will need to rebuild the kernel using:
# /etc/conf/bin/idbuild -BAnd then reboot server using:# shutdown -y -g0 -i6- Download the Oracle 7.3.2 Workgroup Server patch from:
ftp://ftpput.sco.com/tmp/support/osr6_ora732wgs_patch.tarinto the root (/) directory on your server.
- As root extract the patch archive using# tar xvf /osr6_ora732wgs_patch.tarThe archive will be extracted into:/OracleYou are now ready to begin installing Oracle Workgroup Server.
3) Installing Oracle Workgroup Server 7.3.2The following section describes how to install the Oracle Workgroup Server 7.3.2.
- Insert the Oracle Workgroup Server 7.3.2 in CD drive
- Login in GUI mode as root and start an xterm(1).
- In the xterm(1) run the commands:
# mkdir /Oracle/cd_link
# CD_LINK=/Oracle/cd_link export CD_LINK- Mount the Oracle Workgroup Server 7.3.2 CD on /mnt using:
# mount /dev/cd0 /mnt- Run the modified Oracle Workgroup Install script provided in the patch you downloaded and extracted in Step 2 above:
# cd /Oracle
# ./wgstart.OSR6This script is interactive and will take some time to complete!
It will do the following:- It will check to see that the Oracle Workgroup CD is mounted and that it is the correct version.
If the script displays:HALT: Oracle CD not mounted; can not locatethis means that it cannot find the Oracle_7_3_2_Workgroup_Server CD or the CD you have mounted is not the correct version of the Oracle Workgroup Server.
- If the correct CD is mounted it will make a linked copy of the Oracle CD and display the following message while doing so:
INFO: .. building CD_LINK - link to the Oracle CD mount
- It will then patch the linked copy of the Oracle CD and then execute the Oracle Workgroup install script wgstart.sh
- The wgstart.sh script will create the "oracle7" user account
**** It will prompt you for a password for the account. ****
**** It will then ask: ****a) where you want to install Oracle 7 b) what Oracle SID to use c) What Language you want to use d) what character set you want to use
Please Note that the default install directory is /usr/oracle7.
On the next Oracle Install screen you will be asked to provide the fully qualified domain name for your server.
The Oracle Installer will then proceed to install the software onto your server.
- Once the Oracle 7 install is complete the installer will attempt to start the webserver and at this point you may see:
Error: Error ( bind failed, errno 102 ) opening advertised port/address Error: Unable to listen on port 8888 Error: Failed to start the server Error: An error occurred when reading the config file /usr/oracle7/ows/admin/sv8888.cfg Error: The server was unable to initialize Information: The server is exiting
You can ignore these error messages.- Finally you should see the message:
wgstart.OSR6 status = 0indicating a successful install. If for some reason the install fails you can check the file
/usr/oracle7/orainst/install.logfor the reasons for the failure.4) Converting the Oracle Workgroup Server libraries to ELF.
Once installed you will need to convert the Oracle Workgroup Server archives from COFF to ELF format so that you can build or recompile your Oracle applications. To do this you should:
- Log into the server as the "oracle7" user - cd /Oracle - Run the "OSR6.ORA-7.3.2.cof2elf.sh" script as follows:
./OSR6.ORA-7.3.2.cof2elf.shto convert the library archives to ELF format. You should see a sequence of messages finishing with:
./otrace/lib/otrcsvr.o Translated
./sqlplus/lib/frms23.o Translated
./sqlplus/lib/frms30.o Translated
./sqlplus/lib/afidrv.o TranslatedYou are now ready to start developing and using Oracle 7.3.2 Workgroup Server on OpenServer 6.0.0
Please Note that the above procedure only works for Oracle 7.3.2 Workgroup Server. If you have a different version of Oracle and you would like to migrate it onto OpenServer 6.0.0 and you need assistance then please send an email to the osr5to6@sco.com alias providing the name and version of Oracle that you are looking migrate.