Ingres is a mature, high-performance relational database solution. It offers scalability, integration and flexibility to leverage information resources across a wide range of platforms, including Linux. Reliable and cost effective, it supports mission-critical applications in small to medium-size businesses and high-volume deployments in large scale enterprises.
You can convert the RPMs to .debs with ?alien.
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