Twitter Updates

    follow me on Twitter

    G-AVLN in front of her home

    G-AVLN in front of her home

    Mostly Unix and Linux topics. But flying might get a mention too.

    Friday, October 21, 2005

    Ingres 3 - part 1

    A customer of ours is planning an upgrade to Ingres3, whilst changing from Dynix to Linux at the same time. So I thought that I'd refresh my acquaintance with Ingres, since I haven't seen this version yet. I have had some experience of looking after a Linux system running Ingres, but this is the first time I'll be installing r3 myself.

    At this stage I'm not even sure that what I'm doing will work. This is going to be what I call a dry run - I'm going to play it by ear, following the installation steps intuitively, rather than following any particular set of instructions - so, the following steps should be taken more as a log of events, rather than a tutorial. I had a look at www.tldp.net , which does have an ingres HOWTO, but it is a really old one, and although most of the document might be OK, I decided not to risk it ;-). At least this way I will have to use some brain cells.

    You've been warned! To emphasize the point, here is a quote from the "Ingres r3 Getting Started" document (part of the downloaded documentation package):

    "Note: Make sure you thoroughly understand the issues regarding system resources, storage locations, and other configuration parameters before installing Ingres. If you are not sure, have someone more knowledgeable in these areas perform the following tasks."

    I have not even checked or tested that system requirements are good enough - here is the briefest of specs:
    I'm using Compaq nc6120, with 2G RAM, inside a VMWare virtual machine with Fedora Core 4.

    So, to the installation.

    Step 1 ================================================================
    Download the following files from CA site: http://opensource.ca.com/projects/ingres/

    ingres-3.0.2-105-pc-linux-i386.tgz
    ingresr3documentation.tar.gz

    You will need to register with CA first.

    Step 2 ================================================================
    Prepare for the installation: create 'infrastructure' and unpack the tarballs.

    # mkdir -p ingres/documentation

    Unpack the documentation. I chose to separate the documentation (PDF files) from the installation software.
    # cp ./ingresr3documentation.tar.gz ingres/documentation
    # (cd ingres/documentation; tar xzvf ingresr3documentation.tar.gz)

    Unpack the Ingres 3 software
    # cd ingres;
    # tar xzvf ingres-3.0.2-105-pc-linux-i386.tgz
    # cd ingres-3.0.2-105-pc-linux-i386

    Step 3 ================================================================
    Perform the installation

    Need to run the Licence scripts first, to accept the conditions. The main database installation script won't work until you do this one first. Trust me, I know this from experience ;-)

    # ./ingres-CATOSL

    Can now run the main Ingres 3 installation script.

    # ./*install
    INSTALL OUTPUT: Invoking RPM...
    INSTALL OUTPUT: Preparing... ################################ [100%]
    INSTALL OUTPUT: System user ingres has been created but no password has been set.
    INSTALL OUTPUT: Please set the password to enable login for this user.
    INSTALL OUTPUT: 1:ca-ingres ################################ [ 6%]
    INSTALL OUTPUT: II_INSTALLATION configured as II.
    INSTALL OUTPUT: 2:ca-ingres-dbms ################################ [ 12%]
    INSTALL OUTPUT: Setting up Ingres Intelligent DBMS, this may take some time...
    INSTALL OUTPUT: See /opt/CA/IngresII/ingres/files/install.log for more info.
    INSTALL OUTPUT: 3:ca-ingres-net ################################ [ 18%]
    INSTALL OUTPUT: Building the password validation program 'ingvalidpw'.
    INSTALL OUTPUT: Could not compile ingvalidpw: Using executable from the distribution instead.
    INSTALL OUTPUT: Executable successfully installed.
    INSTALL OUTPUT: 4:ca-ingres-qr_run ################################ [ 24%]
    INSTALL OUTPUT: 5:ca-ingres-abf ################################ [ 29%]
    INSTALL OUTPUT: 6:ca-ingres-c2audit ################################ [ 35%]
    INSTALL OUTPUT: 7:ca-ingres-das ################################ [ 41%]
    INSTALL OUTPUT: 8:ca-ingres-esql ################################ [ 47%]
    INSTALL OUTPUT: 9:ca-ingres-ice ################################ [ 53%]
    INSTALL OUTPUT: Setting up Ingres Web Deployment Option, this may take some time..
    INSTALL OUTPUT: See /opt/CA/IngresII/ingres/files/install.log for more info
    INSTALL OUTPUT: ngres release 3 has installed successfully.
    INSTALL OUTPUT: The instance will now be started...
    INSTALL OUTPUT:
    INSTALL OUTPUT: Starting Ingres, instance

    So, the following Ingres packages have been installed:

    # rpm -qa | grep ingres
    ca-ingres-net-3.0.2-105
    ca-ingres-das-3.0.2-105
    ca-ingres-odbc-3.0.2-105
    ca-ingres-tuxedo-3.0.2-105
    ca-ingres-CATOSL-3.0.2-105
    ca-ingres-dbms-3.0.2-105
    ca-ingres-qr_run-3.0.2-105
    ca-ingres-c2audit-3.0.2-105
    ca-ingres-esql-3.0.2-105
    ca-ingres-jdbc-3.0.2-105
    ca-ingres-ome-3.0.2-105
    ca-ingres-star-3.0.2-105
    ca-ingres-vision-3.0.2-105
    ca-ingres-3.0.2-105
    ca-ingres-abf-3.0.2-105
    ca-ingres-ice-3.0.2-105
    ca-ingres-rep-3.0.2-105
    ca-ingres-documentation-3.0.2-105


    Service 'rc' file has been installed:

    # ls -l /etc/init.d/ingres*
    -rwxr-xr-x 1 root root 7187 Oct 20 19:27 /etc/init.d/ingresII

    Indeed: the service list in the runlevel 5 lists the following:

    Ingres II name server (iigcn) - running
    Ingres II recovery server (dmfrcp) - running
    Ingres II DBMS server (iidbms) - 1 running
    Ingres II Star server (iistar) - 1 running
    Ingres II Net server (iigcc) - 1 running
    Ingres II Data Access server (iigcd) - 1 running
    Ingres II JDBC server (iijdbc) - not active
    Ingres II RMCMD process (rmcmd) - running
    Ingres II archiver process (dmfacp) - running

    And, sure enough, loads of Ingres processes are running:

    # ps -ef | grep ingres
    ingres 25691 1 0 19:34 pts/1 00:00:00 /opt/CA/IngresII/ingres/bin/iigcn II
    ingres 25805 1 0 19:34 pts/1 00:00:02 /opt/CA/IngresII/ingres/bin/iidbms recovery (dmfrcp) II
    ingres 25925 1 0 19:34 pts/1 00:00:01 /opt/CA/IngresII/ingres/bin/dmfacp II
    ingres 25935 1 0 19:34 pts/1 00:00:19 /opt/CA/IngresII/ingres/bin/iidbms dbms (default) II
    ingres 26079 1 0 19:34 pts/1 00:00:00 /opt/CA/IngresII/ingres/bin/iigcc II gcc
    ingres 26135 1 0 19:34 pts/1 00:00:00 /opt/CA/IngresII/ingres/bin/iigcd II gcd
    ingres 26189 1 0 19:34 pts/1 00:00:02 /opt/CA/IngresII/ingres/bin/iistar star (default) II
    ingres 26270 1 0 19:34 pts/1 00:00:02 /opt/CA/IngresII/ingres/bin/rmcmd II

    That's all for this posting - next time, I'll see if my common sense approach worked. Chances are that many settings, variables, locations (possibly even additional libraries, etc) will have to be tweaked, adjusted, added...

    Why am I so pessimistic? Well, it's just that it's been going too well so far! ;-)

    2 comments:

    Gordon said...

    Hello, your blog is informative. I have a linux server related website, please visit and hope that it is helpful to you

    joel said...

    Link to my site and enjoy untethered information relaiting to Date Loss on computers.
    Linl to this site: #keyword##
    http://www.firstdata-recovery.info

    Blog Archive