Database connection validation results sample

The following sample log output details the information that is retrieved, tested, and validated by the database connection validation utility. This sample output is for a WebSphere Commerce production environment that runs on the Linux operating system with an Oracle database.

The following code is a snippet of a sample wcdDbValidation-instance_name.log file that is generated when the validation utility runs. This sample log file includes database-related information that is used to connect to the database schema.

    ./wcsDbValidation.sh -instanceName demo
   DBValidationDriver version 8.0 (20151015) 
   
   Validate:
   [WcsDbValidation] WcsDbValidation version 8.0 (20151015)
   
   [WcsDbValidation] ***************************************************************
   [WcsDbValidation] Start time = 2015-11-05 11:42:31.821
   
   [WcsDbValidation] >>>>>>>>>> System <<<<<<<<<<
1[WcsDbValidation] OS:
   [WcsDbValidation]   name = Linux
   [WcsDbValidation]   version = 3.10.0-229.11.1.el7.x86_64
   [WcsDbValidation]   architecture = amd64
   [WcsDbValidation]
2[WcsDbValidation] Java:
   [WcsDbValidation]   vendor = IBM Corporation
   [WcsDbValidation]   version = 1.7.0
   [WcsDbValidation]   specification version = 1.7
   [WcsDbValidation]   home = WAS_installdir/java_1.7_64/jre
   [WcsDbValidation]   class version = 51.0
   [WcsDbValidation]
3[WcsDbValidation] User:
   [WcsDbValidation]   name = wasuser
   [WcsDbValidation]   home = /home/wasuser
   [WcsDbValidation]   directory = WC_installdir/bin
   [WcsDbValidation]   language = en
   [WcsDbValidation]   timezone = America/Toronto
   [WcsDbValidation]
4[WcsDbValidation] Heap:
   [WcsDbValidation]   maximum allocation =     128.00 megabytes
   [WcsDbValidation]   current allocation =      21.56 megabytes
   [WcsDbValidation]
5[WcsDbValidation] WebSphere Commerce:
   [WcsDbValidation]   WCUserInstallDir = WC_installdir (project) (readable)
   [WcsDbValidation]   instanceName = demo
   [WcsDbValidation]   instanceName directory = WC_installdir/instances/demo (readable)
   [WcsDbValidation]   loggerconfigfile = WC_installdir/instances/demo/xml/loader/WCALoggerConfig.xml (project) (readable)
   [WcsDbValidation]   errordirectory = WC_installdir/instances/demo/logs (project) (readable)
   [WcsDbValidation] >>>>>>>>>> System <<<<<<<<<<
   
   [WcsDbValidation] >>>>>>>>>> Database <<<<<<<<<<
6[WcsDbValidation] Properties:
   [WcsDbValidation]   dbType = oracle (project)
   [WcsDbValidation]   dbHostname = myhost.mycompany.com (project)
   [WcsDbValidation]   dbName = orcl (project)
   [WcsDbValidation]   portnumber missing.
   [WcsDbValidation]   dbUserName = WCS (project)
   [WcsDbValidation]   dbUserPassword = ***** (project)
   [WcsDbValidation]   dbaName = system (project)
   [WcsDbValidation]   dbaPassword = ***** (project)
   [WcsDbValidation]   schemaName = WCS (project)
   [WcsDbValidation]   jdbcDriver = oracle.jdbc.OracleDriver (project)
   [WcsDbValidation]   jdbcURL = jdbc:oracle:thin:@//myhost.mycompany.com:1521/orcl (project)
   [WcsDbValidation]
   [WcsDbValidation] Checking for minimum-required properties to test database connections: [jdbcURL], [jdbcDriver], [dbUserName], [dbUserPassword] ...
   [WcsDbValidation]   ... found
   [WcsDbValidation]
7[WcsDbValidation] Connection Testing:
   [WcsDbValidation]   Test with supplied jdbcDriver
   [WcsDbValidation]   jdbcDriver = oracle.jdbc.OracleDriver found.
   [WcsDbValidation]     Location = file:/Oracle_installdir/dbhome_1/jdbc/lib/ojdbc6.jar!/oracle/jdbc/OracleDriver.class
   [WcsDbValidation]
   [WcsDbValidation]   Further diagnosing DB type: [oracle]
   [WcsDbValidation]     DB type indicated by JDBC URL: [oracle]
   [WcsDbValidation]     DB type indicated by JDBC Driver: [oracle]
   [WcsDbValidation]     DB type set to: [oracle]
   [WcsDbValidation]
   [WcsDbValidation]   Test connection with supplied jdbcURL using dbUserName and dbUserPassword.
   [WcsDbValidation]   [AllDBConnector]
   [WcsDbValidation]   Connection successful with following parameters:
   [WcsDbValidation]     jdbcURL = jdbc:oracle:thin:@//myhost.mycompany.com:1521/orcl
   [WcsDbValidation]     dbType = oracle; dbUserName = WCS; dbUserPassword = *****
   [WcsDbValidation]       Connection class name = oracle.jdbc.driver.T4CConnection
   [WcsDbValidation]       Database product name = Oracle
   [WcsDbValidation]       Database product version = Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
   [WcsDbValidation] With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
   [WcsDbValidation]       Database major version = 12
   [WcsDbValidation]       Database minor version = 1
   [WcsDbValidation]       Database driver name = Oracle JDBC driver
   [WcsDbValidation]       Database driver version = 12.1.0.2.0
   [WcsDbValidation]       Database driver major version = 12
   [WcsDbValidation]       Database driver minor version = 1
   [WcsDbValidation]     WebSphere Commerce features:
   [WcsDbValidation]       Feature name = BASE. VRMF = 8.0.0.0
   [WcsDbValidation]
   [WcsDbValidation]   [DriverManager]
   [WcsDbValidation]   Connection successful with following parameters:
   [WcsDbValidation]     jdbcURL = jdbc:oracle:thin:@//myhost.mycompany.com:1521/orcl
   [WcsDbValidation]     dbType = oracle; dbUserName = WCS; dbUserPassword = *****
   [WcsDbValidation]       Connection class name = oracle.jdbc.driver.T4CConnection
   [WcsDbValidation]       Database product name = Oracle
   [WcsDbValidation]       Database product version = Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
   [WcsDbValidation] With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
   [WcsDbValidation]       Database major version = 12
   [WcsDbValidation]       Database minor version = 1
   [WcsDbValidation]       Database driver name = Oracle JDBC driver
   [WcsDbValidation]       Database driver version = 12.1.0.2.0
   [WcsDbValidation]       Database driver major version = 12
   [WcsDbValidation]       Database driver minor version = 1
   [WcsDbValidation]
   [WcsDbValidation]   Test connection with supplied jdbcURL using dbaName and dbaPassword.
   [WcsDbValidation]   [AllDBConnector]
   [WcsDbValidation]   Connection successful with following parameters:
   [WcsDbValidation]     jdbcURL = jdbc:oracle:thin:@//myhost.mycompany.com:1521/orcl
   [WcsDbValidation]     dbType = oracle; dbUserName = system; dbUserPassword = *****
   [WcsDbValidation]       Database driver name = Oracle JDBC driver
   [WcsDbValidation]
   [WcsDbValidation]   [DriverManager]
   [WcsDbValidation]   Connection successful with following parameters:
   [WcsDbValidation]     jdbcURL = jdbc:oracle:thin:@//myhost.mycompany.com:1521/orcl
   [WcsDbValidation]     dbType = oracle; dbUserName = system; dbUserPassword = *****
   [WcsDbValidation]       Database driver name = Oracle JDBC driver
   [WcsDbValidation]
8[WcsDbValidation]   Test other possible drivers and connections
   [WcsDbValidation]   Connection failed with: [SQLException] on following parameters:
   [WcsDbValidation]     jdbcURL = jdbc:oracle:oci:@myhost.mycompany.com:1521/orcl
   [WcsDbValidation]     dbType = oracle; dbUserName = WCS; dbUserPassword = *****
   [WcsDbValidation]     ERRORCODE=12154. SQLSTATE=66000
   [WcsDbValidation]
   [WcsDbValidation] >>>>>>>>>> Database <<<<<<<<<<
   
   [WcsDbValidation] End time = 2015-11-05 11:42:34.294
   [WcsDbValidation] ***************************************************************
   
   BUILD SUCCESSFUL
   Total time: 8 seconds
Where
System related information
1 - OS information
Information about the operating system. This information includes the name, version, and architecture of the operating system.
2 - Java information
Information about the Java Runtime Environment. The Java version must be 1.7.0.
3 - User information
Information about the WebSphere Commerce user that is applying the fix pack update.
4 - heap information
The allocated memory. If errors are encountered during a database-related process, ensure that sufficient memory is allocated for the process to complete successfully.
5 - WebSphere Commerce information
Information about the WebSphere Commerce instance, including the instance name, installation directory, and logging configuration file.
Database connection information
6 - Properties
The input parameters for the WebSphere Commerce database that are used to complete the database-related processes that are involved in applying the fix pack update.
7 - Connection testing
Information about the JDBC driver and class are output in this section. If a successful database connection is established, the parameters that were used to establish the connection are included in this section.
8 - Test other possible drivers and connections
Information about alternate JDBC drivers that are tested and validated by the database connection validation utility. In this sample, no alternate JDBC driver and class are found.