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.