31 August 2013

SQL*Loader-704: Internal error: ulmtsyn and ORA-01480

load.ctl  parameter file content :

LOAD DATA
INFILE dummy_table.txt
BADFILE dummy_table.bad
DISCARDFILE dummy_table.dsc
TRUNCATE 
INTO TABLE dummy_table_length_is_more_than_30
FIELDS TERMINATED BY ";" OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS(  msisdn )


Execution

D:mp>sqlldr mennan/mennan@ora11gr2 control=load.ctl

SQL*Loader: Release 11.2.0.2.0 - Production on Fri Aug 2 11:52:37 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

SQL*Loader-704: Internal error: ulmtsyn: OCIStmtExecute(tabhp) [1480]
ORA-01480:  trailing null missing from STR bind value

D:mp>



The error is because of table name(dummy_table_length_is_more_than_30) length is 34 which is not allowed in oracle(the internal error that is thrown, is not meaningful in my opinion). Please note that, every object shall have name  is less than 30 chars. ( I do not know why this restriction exists in Oracle in 21st centry :). I hope, Oracle will remove this restriction in object names).



Code Instrumentation

A few days ago, I have given a presentation about code instrumentation to my colleagues. Instrumentation is something that shall not be an optional issue; shall be a quality concern.

A slide  from the presentation:

How to Instrument

Use database tables for logging, tracing and performance counters. Archive these log information, when it is not frequently analyzed. If not necessary, erase these table data, otherwise DBAs will complain.
It can also be used file system(utl_file package) for logging. But note that, database tables are very easy to analyze and query.
Use Oracle’s built-in tools for performance monitoring and profiling. (Statspack, AWR reports, PL/SQL Hierarchical Profiler etc)
Only log, necessary information. These log records are read by human eyes. Tons of log information are very difficult to read and analyze.
Please analyze the log and trace information. Be proactive. Take actions before something goes wrong. 
Instrumentation shall be a quality issue and shall not be skipped. It is a code discipline.
In Code Review process, reviewer shall mark un-instrumented code.






01 April 2013

"TT0802: Data store space exhausted" and "TT0778: Log write failed because filesystem is full" errors


A few days ago, we have encounter a timesten error:

[TimesTen][TimesTen 11.2.1.4.0 ODBC Driver][TimesTen]TT0802: Data store space exhausted -- file "blk.c", lineno 3260, procedure "sbBlkAlloc"
*** ODBC Error/Warning = S1000, TimesTen Error/Warning = 802
[TimesTen][TimesTen 11.2.1.4.0 ODBC Driver][TimesTen]TT6220: Permanent data partition free space insufficient to allocate 5640 bytes of memory -- file "blk.c", lineno 3260, procedure "sbBlkAlloc"
*** ODBC Error/Warning = S1000, TimesTen Error/Warning = 6220

When we analyze, we see that the PermSize parameter is insufficient for loading database into the memory.  We update the PermSize in the sys.odbc.ini file and restart timesten daemon.(you can read this post for restarting timesten daemon)

sys.odbc.ini
[tt01]
PermSize=51200
….


After fixing this error, we got another error:

[TimesTen][TimesTen 11.2.1.4.0 ODBC Driver][TimesTen]TT0778: Log write failed because filesystem is full -- file "logmgr.c", lineno
6065, procedure "sbLogRecInsert"
*** ODBC Error/Warning = S1000, TimesTen Error/Warning = 778

This error is because of DataStore path have not enough space as the parameter PermSize.

$ df -k .
/timesten         (/dev/lvtimesten) :  5205785 total allocated Kb
                                                 558788 free allocated Kb
                                                 4646997 used allocated Kb
                                                    90 % allocation used

sys.odbc.ini
[tt01]
..
DataStore=/timesten/TimesTen/tt1121/DataStore/ttds
PermSize=51200

After giving enough disk space to the filesytem, error is gone.
/dev/lvtimesten
                   58490880 4660048 50466552    8% /timesten




30 March 2013

TimesTen In Memory Database - Data Source Name(DSN)


Timesten In memory database has a configuration file which named as sys.odbc.ini. In this file, DSN(Data Source Name)s  are defined and some configurations are setup( DataStore and PermSize parameters are defined and can be configured with requirements.). A sample of this file is shown below. DSN name is tt01 and PermSize is 10000 Mb and DataStore is saved in the /timesten/TimesTen/tt1121/DataStore/ttds directory, and so on…
[tt01]
Driver=/timesten/TimesTen/tt1121/lib/libtten.so
DataStore=/timesten/TimesTen/tt1121/DataStore/ttds
DatabaseCharacterSet=US7ASCII
AutoCreate=1
Logging=1
DurableCommits=0
LockLevel=0
Temporary=0
PermSize=10000
LogBufMB=64
PrivateCommands=1
CkptFrequency=0
CkptLogVolume=0
Isolation=1
Connections=64
TypeMode=1

When you connect timesten database with ttisql, the information is printed out.

$ ttisql tt01

Copyright (c) 1996-2009, Oracle.  All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.



connect "DSN=tt01";


Connection successful: DSN=tt01;UID=g112adm;DataStore=/timesten/TimesTen/tt1121/DataStore/ttds;DatabaseCharacterSet=US7ASCII;ConnectionCharacterSet=US7ASCII;DRIVER=/timesten/TimesTen/tt1121/lib/libtten.so;Isolation=1;PermSize=10000;Connections=64;CkptFrequency=0;CkptLogVolume=0;PrivateCommands=1;TypeMode=1;LogBufMB=64;
(Default setting AutoCommit=1)


If you change PermSize parameter of this file, during connection, an info message is printed and points out that the new parameter has not been taken into consideration. Suppose that you have changed PermSize as 5000 in the sys.odbc.ini file.
[tt01]
PermSize=5000
….


$ ttisql tt01

Copyright (c) 1996-2009, Oracle.  All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.



connect "DSN=tt01";

Warning  6226: Ignoring value requested for first connection attribute 'PermSize' -- value currently in use: 10000, requested value: 5000

Connection successful: DSN=tt01;UID=g112adm;DataStore=/timesten/TimesTen/tt1121/DataStore/ttds;DatabaseCharacterSet=US7ASCII;ConnectionCharacterSet=US7ASCII;DRIVER=/timesten/TimesTen/tt1121/lib/libtten.so;Isolation=1;PermSize=51200;Connections=64;CkptFrequency=0;CkptLogVolume=0;PrivateCommands=1;TypeMode=1;LogBufMB=64;
(Default setting AutoCommit=1)

You should stop&start timesten daemon in order to take affect the changed parameter:

$ ttDaemonAdmin -stop
TimesTen Daemon stopped.

Daemon is stopped. If you want to connect timesten db, you will get an error:


$ ttisql tt01

Copyright (c) 1996-2009, Oracle.  All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.



connect "DSN=tt01";
  799: Unable to connect to daemon; check daemon status
The command failed.
Done.

After starting daemon, you can connect.
$ ttDaemonAdmin -start
TimesTen Daemon startup OK.

It is also possible to check daemon status:
$ ttStatus
TimesTen status report as of Wed Mar 27 18:51:04 2013

Daemon pid 16195 port 59000 instance tt1121
TimesTen server pid 16200 started on port 59001
------------------------------------------------------------------------
Data store /timesten/TimesTen/tt1121/DataStore/ttds
DATA STORE IN PROCESS OF BEING LOADED INTO RAM

There are no connections to the data store
Obsolete or not yet active connection(s):
Process 16196 context 0x60000000000a7d40 name Manager connid 0, nascent connection, shmKey 0xE8C11AD PLSQL shmKey 0xF8C11AD
RAM residence policy: Always
Replication policy  : Manual
Cache Agent policy  : Manual
PL/SQL enabled.
------------------------------------------------------------------------
Accessible by group g112
End of report

Please note that, if it is configured, the database is flushed into the memory. You will see the message(DATA STORE IN PROCESS OF BEING LOADED INTO RAM). It means that, please wait the flush operation , it is in-progress now.




26 March 2013

Oracle - Drop Table If Exists

Oracle does not have a drop table statement to drop a table if exists, like some other RDBMSes does. If you do not want get error messages for a non-existent table drop operation, you can follow workarounds as I showed below. It may be useful, during setup processes, especially you don't want to generate error message to the user,  if the table that you are dropping does not exist.



--CREATE TABLE MENNAN.TABLE_EXAMPLE AS SELECT * FROM DUAL;
---SIMPLE WAY, if execute immediate fails, because table not exists, transaction will be committed
BEGIN
  EXECUTE IMMEDIATE 'DROP TABLE MENNAN.TABLE_EXAMPLE';
EXCEPTION
  WHEN OTHERS THEN
    IF SQLCODE <> -942 THEN
      RAISE;
    END IF;
END;
/

---- NAMED EXCEPTION, the same as SIMPLE WAY
DECLARE
  ve_TableNotExists EXCEPTION;
  PRAGMA EXCEPTION_INIT(ve_TableNotExists, -942);

  vs_DynamicDropTableSQL VARCHAR2(1024);
  vs_TableName           VARCHAR2(64);
BEGIN
  vs_TableName           := 'MENNAN.TABLE_EXAMPLE';
  vs_DynamicDropTableSQL := 'DROP TABLE ' || vs_TableName;

  EXECUTE IMMEDIATE vs_DynamicDropTableSQL;
EXCEPTION
  WHEN ve_TableNotExists THEN
    dbms_output.put_line(vs_TableName || ' not exist, skipping....');
  WHEN OTHERS THEN
    dbms_output.put_line(SQLERRM);
    RAISE;
END;
/


---- NAMED EXCEPTION, the same as SIMPLE WAY but more general one
DECLARE
  ve_TableNotExists EXCEPTION;
  PRAGMA EXCEPTION_INIT(ve_TableNotExists, -942);


  PROCEDURE DropTable(pis_TableName IN VARCHAR2) IS
    vs_DynamicDropTableSQL VARCHAR2(1024);
  BEGIN
 
    vs_DynamicDropTableSQL := 'DROP TABLE ' || pis_TableName; 
    EXECUTE IMMEDIATE vs_DynamicDropTableSQL;
   
  EXCEPTION
    WHEN ve_TableNotExists THEN
      dbms_output.put_line(pis_TableName || ' not exist, skipping....');
    WHEN OTHERS THEN
      dbms_output.put_line(SQLERRM);
      RAISE;
  END DropTable;
 
 
BEGIN
  DropTable('MENNAN.TABLE_EXAMPLE');
END;
/

---Yet another way, first check from dictionary, if exists drop the table. Checking from dictionary may take time but avoids unnecessary transactions
DECLARE
  vs_TableName VARCHAR2(64);
  vn_Count     PLS_INTEGER;
BEGIN
  vs_TableName := 'MENNAN.TABLE_EXAMPLE';
 
  SELECT COUNT(*)
    INTO vn_Count
    FROM ALL_TABLES
   WHERE OWNER || '.' || TABLE_NAME = vs_TableName;

  IF vn_Count > 0 THEN
    EXECUTE IMMEDIATE 'DROP TABLE ' || vs_TableName;
  END IF;
END;
/





24 March 2013

Notes on Oracle 11G R2 Installation on Oracle Enterprise Linux




A few days ago, I have installed on Oracle Database 11.2 on Oracle Linux. Installation can be done via InstallationGuide. I will give some tricks/notes on installation process.

·         First of all, update/upgrade Linux kernel.(yum upgrade)
·         Then install X Windows system, if not exists(for dbca, netca etc). (yum groupinstall "X Window System" "GNOME Desktop Environment")
·         Pre install rpms.(yum install oracle-rdbms-server-11gR2-preinstall)
·         Oracle user/group/directory creations(user:oracle groups:oinstall,dba,oper,asmadmin Optimal Flexible Architecture (OFA):/u01 etc).
·         Kernel parameters(/etc/security/limits.conf , /etc/pam.d/login , /etc/selinux/config , /etc/sysctl.conf  )
·         Install additional packages(I have copied all packages below, I hope I did not forget anything)
yum install libaio libaio-devel
yum install gcc-c++ glibc glibc-devel libgcc
yum install compat-libcap1 compat-libstdc++ compat-libstdc++
yum install libstdc++ libstdc++-devel
yum install elfutils-libelf-devel
yum install unixODBC-devel unixODBC
yum install bitmap-fonts desktop-backgrounds-basic xorg-x11-drivers xorg-x11-fonts-100dpi xorg-x11-fonts-75dpi  xorg-x11-fonts-ISO8859-1-100dpi  xorg-x11-fonts-ISO8859-1-75dpi xorg-x11-fonts-Type1 xorg-x11-fonts-misc xorg-x11-fonts-truetype xorg-x11-server-Xorg xorg-x11-xauth xorg-x11-xfs xorg-x11-xinit
yum install control-center  gnome-applets gnome-panel gnome-session gnome-terminal  metacity nautilus yelp

Please note that, validations can fail, although x86_64 version of a package is installed. You can ignore these errors.

For instance UnixODBC exists in the system(i686 and x86_64) but in the logs, verification failed.
[root@jupiter ~]# rpm -q unixODBC
unixODBC-2.2.14-12.el6_3.x86_64
unixODBC-2.2.14-12.el6_3.i686

Logs:
INFO: INFO: Package: unixODBC-2.2.11: This is a prerequisite condition to test whether the package "unixODBC-2.2.11" is available on the system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:VERIFICATION_FAILED
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:unixODBC-2.2.11 (i386)
INFO: INFO: Actual Value:missing
INFO: INFO: Error Message:PRVF-7532 : Package "unixODBC-2.2.11 (i386)" is missing on node "jupiter"
INFO: INFO: Cause: A required package is either not installed or, if the package is a kernel module, is not loaded on the specified node.
INFO: INFO: Action: Ensure that the required package is installed and available.
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Package: unixODBC-2.2.11: This is a prerequisite condition to test whether the package "unixODBC-2.2.11" is available on the system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:unixODBC-2.2.11 (x86_64)
INFO: INFO: Actual Value:unixODBC-2.2.14-12.el6_3 (x86_64)
INFO: INFO: -----------------------------------------------



I have copied part of installation logs for validation checks :

INFO: INFO: Physical Memory: This is a prerequisite condition to test whether the system has at least 1GB (1048576.0KB) of total physical memory.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:1GB (1048576.0KB)
INFO: INFO: Actual Value:3.85GB (4040484.0KB)
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Available Physical Memory: This is a prerequisite condition to test whether the system has at least 50MB (51200.0KB) of available physical memory.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:50MB (51200.0KB)
INFO: INFO: Actual Value:3.29GB (3452444.0KB)
INFO: INFO: -----------------------------------------------
INFO: INFO: Expected value not found.
INFO: INFO: Actual value not found.
INFO: INFO: Expected value not found.
INFO: INFO: Actual value not found.
INFO: INFO: Expected value not found.
INFO: INFO: Actual value not found.
INFO: INFO: *********************************************
INFO: INFO: Swap Size: This is a prerequisite condition to test whether sufficient total swap space is available on the system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:3.85GB (4040484.0KB)
INFO: INFO: Actual Value:3.86GB (4046844.0KB)
INFO: INFO: -----------------------------------------------
INFO: INFO: Expected value not found.
INFO: INFO: Actual value not found.
INFO: INFO: Expected value not found.
INFO: INFO: Actual value not found.
INFO: INFO: Expected value not found.
INFO: INFO: Actual value not found.
INFO: INFO: Expected value not found.
INFO: INFO: Actual value not found.
INFO: INFO: Expected value not found.
INFO: INFO: Actual value not found.
INFO: INFO: Expected value not found.
INFO: INFO: Actual value not found.
INFO: INFO: Expected value not found.
INFO: INFO: Actual value not found.
INFO: INFO: *********************************************
INFO: INFO: Free Space: jupiter:/tmp: This is a prerequisite condition to test whether sufficient free space is available in the file system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:1GB
INFO: INFO: Actual Value:35.5GB
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: User Existence: oracle: This is a prerequisite condition to test whether user "oracle" exists on the system.
INFO: INFO: Severity:CRITICAL
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: WARNING: Result values are not available for this verification task
INFO: INFO: *********************************************
INFO: INFO: Group Existence: oinstall: This is a prerequisite condition to test whether group "oinstall" exists on the system.
INFO: INFO: Severity:CRITICAL
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: WARNING: Result values are not available for this verification task
INFO: INFO: Expected value not found.
INFO: INFO: Actual value not found.
INFO: INFO: Expected value not found.
INFO: INFO: Actual value not found.
INFO: INFO: *********************************************
INFO: INFO: Group Existence: dba: This is a prerequisite condition to test whether group "dba" exists on the system.
INFO: INFO: Severity:CRITICAL
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: WARNING: Result values are not available for this verification task
INFO: INFO: *********************************************
INFO: INFO: Group Membership: oinstall: This is a prerequisite condition to test whether user "oracle" is a member of the group "oinstall".
INFO: INFO: Severity:CRITICAL
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: WARNING: Result values are not available for this verification task
INFO: INFO: *********************************************
INFO: INFO: Group Membership: dba: This is a prerequisite condition to test whether user "oracle" is a member of the group "dba".
INFO: INFO: Severity:CRITICAL
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: WARNING: Result values are not available for this verification task
INFO: INFO: *********************************************
INFO: INFO: Run Level: This is a prerequisite condition to test whether the system is running with proper run level.
INFO: INFO: Severity:CRITICAL
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:3,5
INFO: INFO: Actual Value:3
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Hard Limit: maximum open file descriptors: This is a prerequisite condition to test whether the hard limit for "maximum open file descriptors" is set to at least 65536.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:65536
INFO: INFO: Actual Value:65536
INFO: INFO: -----------------------------------------------
INFO: INFO: Expected value not found.
INFO: INFO: Actual value not found.
INFO: INFO: Expected value not found.
INFO: INFO: Actual value not found.
INFO: INFO: *********************************************
INFO: INFO: Soft Limit: maximum open file descriptors: This is a prerequisite condition to test whether the soft limit for "maximum open file descriptors" is set to at least 1024.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:1024
INFO: INFO: Actual Value:4096
INFO: INFO: -----------------------------------------------
INFO: INFO: Expected value not found.
INFO: INFO: Actual value not found.
INFO: INFO: Expected value not found.
INFO: INFO: Actual value not found.
INFO: INFO: *********************************************
INFO: INFO: Hard Limit: maximum user processes: This is a prerequisite condition to test whether the hard limit for "maximum user processes" is set to at least 16384.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:16384
INFO: INFO: Actual Value:16384
INFO: INFO: -----------------------------------------------
INFO: INFO: Expected value not found.
INFO: INFO: Actual value not found.
INFO: INFO: Expected value not found.
INFO: INFO: Actual value not found.
INFO: INFO: *********************************************
INFO: INFO: Soft Limit: maximum user processes: This is a prerequisite condition to test whether the soft limit for "maximum user processes" is set to at least 2047.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:2047
INFO: INFO: Actual Value:2047
INFO: INFO: -----------------------------------------------
INFO: INFO: Expected value not found.
INFO: INFO: Actual value not found.
INFO: INFO: Expected value not found.
INFO: INFO: Actual value not found.
INFO: INFO: Expected value not found.
INFO: INFO: Actual value not found.
INFO: INFO: *********************************************
INFO: INFO: Architecture: This is a prerequisite condition to test whether the system has a certified architecture.
INFO: INFO: Severity:CRITICAL
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:x86_64
INFO: INFO: Actual Value:x86_64
INFO: INFO: -----------------------------------------------
INFO: INFO: Expected value not found.
INFO: INFO: Actual value not found.
INFO: INFO: *********************************************
INFO: INFO: OS Kernel Version: This is a prerequisite condition to test whether the system kernel version is at least "2.6.9".
INFO: INFO: Severity:CRITICAL
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:2.6.9
INFO: INFO: Actual Value:2.6.39-400.17.2.el6uek.x86_64
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: OS Kernel Parameter: semmsl: This is a prerequisite condition to test whether the OS kernel parameter "semmsl" is properly set.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:250
INFO: INFO: Actual Value:250
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: OS Kernel Parameter: semmns: This is a prerequisite condition to test whether the OS kernel parameter "semmns" is properly set.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:32000
INFO: INFO: Actual Value:32000
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: OS Kernel Parameter: semopm: This is a prerequisite condition to test whether the OS kernel parameter "semopm" is properly set.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:100
INFO: INFO: Actual Value:100
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: OS Kernel Parameter: semmni: This is a prerequisite condition to test whether the OS kernel parameter "semmni" is properly set.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:128
INFO: INFO: Actual Value:128
INFO: INFO: -----------------------------------------------
INFO: INFO: Expected value not found.
INFO: INFO: Actual value not found.
INFO: INFO: Expected value not found.
INFO: INFO: Actual value not found.
INFO: INFO: *********************************************
INFO: INFO: OS Kernel Parameter: shmmax: This is a prerequisite condition to test whether the OS kernel parameter "shmmax" is properly set.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:536870912
INFO: INFO: Actual Value:68719476736
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: OS Kernel Parameter: shmmni: This is a prerequisite condition to test whether the OS kernel parameter "shmmni" is properly set.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:4096
INFO: INFO: Actual Value:4096
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: OS Kernel Parameter: shmall: This is a prerequisite condition to test whether the OS kernel parameter "shmall" is properly set.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:2097152
INFO: INFO: Actual Value:4294967296
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: OS Kernel Parameter: file-max: This is a prerequisite condition to test whether the OS kernel parameter "file-max" is properly set.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:6815744
INFO: INFO: Actual Value:6815744
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: OS Kernel Parameter: ip_local_port_range: This is a prerequisite condition to test whether the OS kernel parameter "ip_local_port_range" is properly set.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:between 9000 & 65500
INFO: INFO: Actual Value:between 9000 & 65500
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: OS Kernel Parameter: rmem_default: This is a prerequisite condition to test whether the OS kernel parameter "rmem_default" is properly set.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:262144
INFO: INFO: Actual Value:4194304
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: OS Kernel Parameter: rmem_max: This is a prerequisite condition to test whether the OS kernel parameter "rmem_max" is properly set.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:4194304
INFO: INFO: Actual Value:4194304
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: OS Kernel Parameter: wmem_default: This is a prerequisite condition to test whether the OS kernel parameter "wmem_default" is properly set.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:262144
INFO: INFO: Actual Value:262144
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: OS Kernel Parameter: wmem_max: This is a prerequisite condition to test whether the OS kernel parameter "wmem_max" is properly set.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:1048576
INFO: INFO: Actual Value:1048586
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: OS Kernel Parameter: aio-max-nr: This is a prerequisite condition to test whether the OS kernel parameter "aio-max-nr" is properly set.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:1048576
INFO: INFO: Actual Value:1048576
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Package: make-3.80: This is a prerequisite condition to test whether the package "make-3.80" is available on the system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:make-3.80
INFO: INFO: Actual Value:make-3.81-20.el6
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Package: binutils-2.15.92.0.2: This is a prerequisite condition to test whether the package "binutils-2.15.92.0.2" is available on the system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:binutils-2.15.92.0.2
INFO: INFO: Actual Value:binutils-2.20.51.0.2-5.36.el6
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Package: gcc-3.4.6: This is a prerequisite condition to test whether the package "gcc-3.4.6" is available on the system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:gcc-3.4.6
INFO: INFO: Actual Value:gcc-4.4.7-3.el6
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Package: libaio-0.3.105: This is a prerequisite condition to test whether the package "libaio-0.3.105" is available on the system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:VERIFICATION_FAILED
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:libaio-0.3.105 (i386)
INFO: INFO: Actual Value:missing
INFO: INFO: Error Message:PRVF-7532 : Package "libaio-0.3.105 (i386)" is missing on node "jupiter"
INFO: INFO: Cause: A required package is either not installed or, if the package is a kernel module, is not loaded on the specified node.
INFO: INFO: Action: Ensure that the required package is installed and available.
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Package: libaio-0.3.105: This is a prerequisite condition to test whether the package "libaio-0.3.105" is available on the system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:libaio-0.3.105 (x86_64)
INFO: INFO: Actual Value:libaio-0.3.107-10.el6 (x86_64)
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Package: glibc-2.3.4-2.41: This is a prerequisite condition to test whether the package "glibc-2.3.4-2.41" is available on the system.
INFO: INFO: Severity:CRITICAL
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:glibc-2.3.4-2.41 (i686)
INFO: INFO: Actual Value:glibc-2.12-1.107.el6 (i686)
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Package: glibc-2.3.4-2.41: This is a prerequisite condition to test whether the package "glibc-2.3.4-2.41" is available on the system.
INFO: INFO: Severity:CRITICAL
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:glibc-2.3.4-2.41 (x86_64)
INFO: INFO: Actual Value:glibc-2.12-1.107.el6 (x86_64)
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Package: compat-libstdc++-33-3.2.3: This is a prerequisite condition to test whether the package "compat-libstdc++-33-3.2.3" is available on the system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:VERIFICATION_FAILED
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:compat-libstdc++-33-3.2.3 (i386)
INFO: INFO: Actual Value:missing
INFO: INFO: Error Message:PRVF-7532 : Package "compat-libstdc++-33-3.2.3 (i386)" is missing on node "jupiter"
INFO: INFO: Cause: A required package is either not installed or, if the package is a kernel module, is not loaded on the specified node.
INFO: INFO: Action: Ensure that the required package is installed and available.
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Package: compat-libstdc++-33-3.2.3: This is a prerequisite condition to test whether the package "compat-libstdc++-33-3.2.3" is available on the system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:compat-libstdc++-33-3.2.3 (x86_64)
INFO: INFO: Actual Value:compat-libstdc++-33-3.2.3-69.el6 (x86_64)
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Package: elfutils-libelf-0.97: This is a prerequisite condition to test whether the package "elfutils-libelf-0.97" is available on the system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:elfutils-libelf-0.97 (x86_64)
INFO: INFO: Actual Value:elfutils-libelf-0.152-1.el6 (x86_64)
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Package: elfutils-libelf-devel-0.97: This is a prerequisite condition to test whether the package "elfutils-libelf-devel-0.97" is available on the system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:elfutils-libelf-devel-0.97
INFO: INFO: Actual Value:elfutils-libelf-devel-0.152-1.el6
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Package: glibc-common-2.3.4: This is a prerequisite condition to test whether the package "glibc-common-2.3.4" is available on the system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:glibc-common-2.3.4
INFO: INFO: Actual Value:glibc-common-2.12-1.107.el6
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Package: glibc-devel-2.3.4: This is a prerequisite condition to test whether the package "glibc-devel-2.3.4" is available on the system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:glibc-devel-2.3.4 (x86_64)
INFO: INFO: Actual Value:glibc-devel-2.12-1.107.el6 (x86_64)
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Package: glibc-headers-2.3.4: This is a prerequisite condition to test whether the package "glibc-headers-2.3.4" is available on the system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:glibc-headers-2.3.4
INFO: INFO: Actual Value:glibc-headers-2.12-1.107.el6
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Package: gcc-c++-3.4.6: This is a prerequisite condition to test whether the package "gcc-c++-3.4.6" is available on the system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:gcc-c++-3.4.6
INFO: INFO: Actual Value:gcc-c++-4.4.7-3.el6
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Package: libaio-devel-0.3.105: This is a prerequisite condition to test whether the package "libaio-devel-0.3.105" is available on the system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:VERIFICATION_FAILED
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:libaio-devel-0.3.105 (i386)
INFO: INFO: Actual Value:missing
INFO: INFO: Error Message:PRVF-7532 : Package "libaio-devel-0.3.105 (i386)" is missing on node "jupiter"
INFO: INFO: Cause: A required package is either not installed or, if the package is a kernel module, is not loaded on the specified node.
INFO: INFO: Action: Ensure that the required package is installed and available.
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Package: libaio-devel-0.3.105: This is a prerequisite condition to test whether the package "libaio-devel-0.3.105" is available on the system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:libaio-devel-0.3.105 (x86_64)
INFO: INFO: Actual Value:libaio-devel-0.3.107-10.el6 (x86_64)
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Package: libgcc-3.4.6: This is a prerequisite condition to test whether the package "libgcc-3.4.6" is available on the system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:VERIFICATION_FAILED
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:libgcc-3.4.6 (i386)
INFO: INFO: Actual Value:missing
INFO: INFO: Error Message:PRVF-7532 : Package "libgcc-3.4.6 (i386)" is missing on node "jupiter"
INFO: INFO: Cause: A required package is either not installed or, if the package is a kernel module, is not loaded on the specified node.
INFO: INFO: Action: Ensure that the required package is installed and available.
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Package: libgcc-3.4.6: This is a prerequisite condition to test whether the package "libgcc-3.4.6" is available on the system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:libgcc-3.4.6 (x86_64)
INFO: INFO: Actual Value:libgcc-4.4.7-3.el6 (x86_64)
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Package: libstdc++-3.4.6: This is a prerequisite condition to test whether the package "libstdc++-3.4.6" is available on the system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:VERIFICATION_FAILED
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:libstdc++-3.4.6 (i386)
INFO: INFO: Actual Value:missing
INFO: INFO: Error Message:PRVF-7532 : Package "libstdc++-3.4.6 (i386)" is missing on node "jupiter"
INFO: INFO: Cause: A required package is either not installed or, if the package is a kernel module, is not loaded on the specified node.
INFO: INFO: Action: Ensure that the required package is installed and available.
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Package: libstdc++-3.4.6: This is a prerequisite condition to test whether the package "libstdc++-3.4.6" is available on the system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:libstdc++-3.4.6 (x86_64)
INFO: INFO: Actual Value:libstdc++-4.4.7-3.el6 (x86_64)
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Package: libstdc++-devel-3.4.6: This is a prerequisite condition to test whether the package "libstdc++-devel-3.4.6" is available on the system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:libstdc++-devel-3.4.6 (x86_64)
INFO: INFO: Actual Value:libstdc++-devel-4.4.7-3.el6 (x86_64)
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Package: sysstat-5.0.5: This is a prerequisite condition to test whether the package "sysstat-5.0.5" is available on the system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:sysstat-5.0.5
INFO: INFO: Actual Value:sysstat-9.0.4-20.el6
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Package: unixODBC-2.2.11: This is a prerequisite condition to test whether the package "unixODBC-2.2.11" is available on the system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:VERIFICATION_FAILED
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:unixODBC-2.2.11 (i386)
INFO: INFO: Actual Value:missing
INFO: INFO: Error Message:PRVF-7532 : Package "unixODBC-2.2.11 (i386)" is missing on node "jupiter"
INFO: INFO: Cause: A required package is either not installed or, if the package is a kernel module, is not loaded on the specified node.
INFO: INFO: Action: Ensure that the required package is installed and available.
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Package: unixODBC-2.2.11: This is a prerequisite condition to test whether the package "unixODBC-2.2.11" is available on the system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:unixODBC-2.2.11 (x86_64)
INFO: INFO: Actual Value:unixODBC-2.2.14-12.el6_3 (x86_64)
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Package: unixODBC-devel-2.2.11: This is a prerequisite condition to test whether the package "unixODBC-devel-2.2.11" is available on the system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:VERIFICATION_FAILED
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:unixODBC-devel-2.2.11 (i386)
INFO: INFO: Actual Value:missing
INFO: INFO: Error Message:PRVF-7532 : Package "unixODBC-devel-2.2.11 (i386)" is missing on node "jupiter"
INFO: INFO: Cause: A required package is either not installed or, if the package is a kernel module, is not loaded on the specified node.
INFO: INFO: Action: Ensure that the required package is installed and available.
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Package: unixODBC-devel-2.2.11: This is a prerequisite condition to test whether the package "unixODBC-devel-2.2.11" is available on the system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:unixODBC-devel-2.2.11 (x86_64)
INFO: INFO: Actual Value:unixODBC-devel-2.2.14-12.el6_3 (x86_64)
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Package: pdksh-5.2.14: This is a prerequisite condition to test whether the package "pdksh-5.2.14" is available on the system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:VERIFICATION_FAILED
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:pdksh-5.2.14
INFO: INFO: Actual Value:missing
INFO: INFO: Error Message:PRVF-7532 : Package "pdksh-5.2.14" is missing on node "jupiter"
INFO: INFO: Cause: A required package is either not installed or, if the package is a kernel module, is not loaded on the specified node.
INFO: INFO: Action: Ensure that the required package is installed and available.
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Package: expat-1.95.7: This is a prerequisite condition to test whether the package "expat-1.95.7" is available on the system.
INFO: INFO: Severity:IGNORABLE
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: INFO: Expected Value:expat-1.95.7 (x86_64)
INFO: INFO: Actual Value:expat-2.0.1-11.el6_2 (x86_64)
INFO: INFO: -----------------------------------------------
INFO: INFO: *********************************************
INFO: INFO: Users With Same UID: This test checks that multiple users do not exist with user id as "0".
INFO: INFO: Severity:CRITICAL
INFO: INFO: OverallStatus:SUCCESSFUL
INFO: INFO: -----------------------------------------------
INFO: INFO: Verification Result for Node:jupiter
INFO: WARNING: Result values are not available for this verification task
INFO: INFO: Waiting for completion of background operations
INFO: INFO: Completed background operations
INFO: INFO: Validating view at state <performChecks>
INFO: INFO: Completed validating view at state <performChecks>
INFO: INFO: Validating state <performChecks>
INFO: INFO: Using default Validator configured in the Action class oracle.install.ivw.db.action.PrereqAction
INFO: INFO: Completed validating state <performChecks>
INFO: INFO: Verifying route success
INFO: INFO: Get view named [SummaryUI]
INFO: INFO: View for [SummaryUI] is oracle.install.commons.base.interview.common.view.SummaryGUI@17eca1a
INFO: INFO: Initializing view <SummaryUI> at state <showSummary>
INFO: INFO: Completed initializing view <SummaryUI> at state <showSummary>
INFO: INFO: Displaying view <SummaryUI> at state <showSummary>
INFO: INFO: Completed displaying view <SummaryUI> at state <showSummary>
INFO: INFO: Loading view <SummaryUI> at state <showSummary>
INFO: INFO: Completed loading view <SummaryUI> at state <showSummary>
INFO: INFO: Localizing view <SummaryUI> at state <showSummary>
INFO: INFO: Completed localizing view <SummaryUI> at state <showSummary>
INFO: INFO: Waiting for completion of background operations
INFO: INFO: Completed background operations
INFO: INFO: Executing action at state showSummary
INFO: INFO: size estimation for EEinstall is 4397.013998031616