Linux, Office

Installing Ingres….

I was little unwell last week and before, and not being able to do the work i was doing, i was moving around the office, When Balaji asked me to help him to install linux.  Being Me, i asked why you want to install Linux?  He said, he had to test if the enterprise version of our product will work on ingres database.  My First thoughts were (seriously) WTF is ingress(later i found that it was ingres and not ingress)?  And that is how i ended up doing it for him, and that is why i am here writing this.  I wanted to write it here, only after completing the entire exercise.  or atleast after everything was completed.  (Connecting from a machine other than the server(localhost) is not yet working).  But anyway connectivity issues and installation are different.  So without bragging and dragging, let us proceed with how to install Ingres in Linux.
For this exercise i used a RHEL5 machine setup on VirtualBox.  You need to have UI.  I am listing those steps which i had recieved as instructions when i had called up technical support of Ingres.
  1. create a user called ingres.
  2. create a group called ingres.
  3. add the user ingres to the group ingres.
  4. login as root.  yes you read that right, no logging in as normal user and changing into root by issuing switch user command.  the guy gave up on me when i told i did a su to become root and did the install, when we faced the connectivity issue.  So better login as root, if you might be calling the tech support any time.
  5. create two directories ingres_src and ingresII under /opt. (it ain’t case sensitive, you can name it anyway, but the guy said it is his way that he always keeps the names in small case, unless and until mentioned not to)
  6. move the installation gzip file and unzip it into ingres_src folder.
  7. change into that directory and execute ./ingres_install
  8. In the First Screen choose your Configuration Type.  I choose Transactional System.
  9. In the next Screen choose the Installation Mode as ‘Advanced‘.
  10. Instance Name should be IngresII (two capital I)
  11. In the Component Select Screen select Custom.  Uncheck Ingres Replicator and Ingres Star.
  12. Set the Installation Location to the folder which we created next /opt/ingresII.  Leave the rest as such
  13. Set the transaction log file size to half the size of the total RAM available to the system.  If you would be running any other applications in the machine, then calculate the memory with what would be left after satisfying the other applications memory requirements.
  14. Set your locale settings.  Do not change the Character Set.
  15. Do not enable Strict SQL Compliance
  16. Choose the Date Type as ANSI Date
  17. Set the Instance Owner user as ingres and group as ingres
  18. UnCheck Start Ingres with computer, and Check create a demo database.
  19. Well that’s it, Ingres should successfully install and start.
To make sure that the Installer started the server, login as ingres user and issue the command ingstatus.  If you get error saying command not found or something like that, you better logout and then login.  If it still does not work, go the home folder of the user ingres and look for file named .ingIIbash and .ingIItcsh, copy the contents of .ingIIbash to .bash_profile of ingres user and then logout and login again. now it will work.  The output will be something as follows
Now if it hasn’t started issue the command ingstart and wait till the control returns to you.  now in terminal type
sql demodb
and press enter, you will be taken into the screen where you can execute the queries. to come out of it type \q and press enter.  to stop the server use the command ingstop.