The command "pw dbconfig set" is failing and giving an error "The Network Adapter could not establish the connection, SQLState:08006"  for TrueSight Infrastructure Management (TSIM). The command "pw dbconfig test" also fails and shows the same error.
 

pw dbconfig set -database oracle -host <Oracle Hostname>:<Port> -sid <sid> -username proact -password password -repusername proactru -reppassword password BMC TrueSight Infrastructure Management Command Line Interface 2019 version 11.3.02 Copyright 1997-2019 BMC Software, Inc. as an unpublished work.  All rights reserved. Error: Validating connection parameters failed ... Message: [For MainUser : IO Error: The Network Adapter could not establish the connection, SQLState:08006]

If it is successful, the output of the command "pw dbconfig test" will be as below:



 

1. Verify if the configuration is correct and accurate at pw/custom/pronet.conf. For example:

pronet.api.database.oracle.rac=false
pronet.api.database.database=oracle
pronet.api.database.statsdata.BatchSize=100
pronet.api.database.enableReconnect=true
pronet.api.database.sid=<SID>
pronet.api.database.hostname=<DB FQDN>
pronet.api.database.oracle.toscreen_users=
pronet.api.database.statsdata.MaxBatchCommitWaitTime=120
pronet.api.database.oracle.minimum_supported_version=11
pronet.api.database.useBatch=true
pronet.api.database.portnum=2002

If it is correct then the problem is a match on product defect DRTMD-124 whereby 'pw dbconfig set' is falsely returning a failure.

2. Test ping/tracert to the Oracle host from TSIM

3. If it is failing like below - You would need to work with your Network and Unix team to correct the configuration

Working scenario: Successful.



Non Working Scenario : Failed



4. Once network issue is resolved, set the new Oracle host using the command "pw dbconfig set" command

5. Verify using ./runjava api.database.DbUpCheck OR command "pw dbconfig test"

6. Once Oracle showing as connected, Restart the TSIM using "pw sys start" - all the services should be now up and running.