aims2oracle

aims2 is supported by Oracle at CERN. Oracle functionality goes come "as standard", so you have to work for it:

yum install --enablerepo=*cern*only* --enablerepo=*cern*extra* oracle-instantclient-basic oracle-instantclient-devel oracle-instantclient-jdbc yum install oracle-instantclient-odbc oracle-instantclient-sqlplus perl-DBI perl-DBD-Oracle -y

More detailed information will follow, but the Oracle set up looks as follows:

[ FIXME: ERD ]

Hosts SQL

REM
REM aims2oracle PXE HOSTS SQL 
REM
  CREATE TABLE "AIMS2"."HOSTS" 
   (   "HOSTNAME" VARCHAR2(4000 BYTE) NOT NULL ENABLE, 
   "HOSTHARDWARE" VARCHAR2(4000 BYTE) NOT NULL ENABLE, 
   "HOSTKICKSTART" CLOB, 
   "HOSTPXE" NUMBER(1,0), 
   "HOSTIMAGE" VARCHAR2(4000 BYTE), 
   "HOSTCREATED" TIMESTAMP (6) NOT NULL ENABLE, 
   "HOSTKOPTS" VARCHAR2(4000 BYTE), 
   "HOSTPXEON" TIMESTAMP (6), 
   "HOSTPXEOFF" TIMESTAMP (6), 
    CONSTRAINT "HOSTS_PK" PRIMARY KEY ("HOSTHARDWARE")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "DATA01"  ENABLE
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "DATA01" 
 LOB ("HOSTKICKSTART") STORE AS (
  TABLESPACE "DATA01" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10
  NOCACHE 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) ;
);

PXEBOOT Image SQL

  CREATE TABLE "AIMS2"."IMAGES" 
   (   "IMAGESUM" VARCHAR2(4000 BYTE) NOT NULL ENABLE, 
   "IMAGECREATED" TIMESTAMP (6), 
   "IMAGEDESCRIPTION" VARCHAR2(4000 BYTE), 
   "IMAGENAME" VARCHAR2(4000 BYTE) NOT NULL ENABLE, 
   "IMAGEFILE" VARCHAR2(4000 BYTE), 
   "KERNEL" VARCHAR2(4000 BYTE), 
   "IMAGEOWNER" VARCHAR2(4000 BYTE), 
   "IMAGEKOPTS" VARCHAR2(4000 BYTE), 
    CONSTRAINT "IMAGES_PK" PRIMARY KEY ("IMAGESUM")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "DATA01"  ENABLE
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "DATA01" ;

LOG Image SQL

  CREATE TABLE "AIMS2"."LOG" 
   (   "LOGTIMESTAMP" TIMESTAMP (6), 
   "LOGMSG" VARCHAR2(4000 BYTE) NOT NULL ENABLE
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "DATA01" ;

CONF Image SQL

  CREATE TABLE "AIMS2"."CONF" 
   (   "CONF_KEY" VARCHAR2(4000 BYTE) NOT NULL ENABLE, 
   "CONF_VALUE" VARCHAR2(4000 BYTE) NOT NULL ENABLE, 
    CONSTRAINT "CONF_PK" PRIMARY KEY ("CONF_KEY")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "DATA01"  ENABLE
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "DATA01" ;