Www.ibm.com



IBM/HCL Workload Automation MDM v9.4 FP6 on Oracle 12c (12.2.0.1.0) upgrade to Oracle 19c (19.3.0.0.0) on Microsoft WindowsNOTE: Make sure that the DataSourceProperties for Oracle is set to type4:Execute showDataSourceProperties and redirect output to a txt file = C:\Program Files\IBM\MDM94FP6\wastools>showDataSourceProperties.bat > DataSourceProperties.txtOpen DataSourceProperties.txt = C:\Program Files\IBM\MDM94FP6\wastools>notepad DataSourceProperties.txtEdit DataSourceProperties.txt file. Check the start of the file. The command might have written a message from the application server (WASX7357I) at the beginning of the file. Delete this message.Change line:OracleType2JndiName=jdbc/twsdbtoOracleType2JndiName=jdbc/twsdb_oldChange line:OracleType4JndiName=toOracleType4JndiName=jdbc/twsdbSet:OracleType4URL=jdbc:oracle:thin:@//localhost:1521/<ORCL>Where:localhost must be replaced with the hostname or IP address of the ORACLE server1521 must be replaced with the real port number of the ORACLE listener on the ORACLE server<ORCL> must be replaced with the database instance name (SERVICE_NAME) that is connected to TWS.Example:################################################################Oracle Type2 Resource Properties################################################################OracleType2JndiName=jdbc/twsdb ---> OracleType2JndiName=jdbc/twsdb_oldOracleType2DriverType=OracleType2URL=jdbc:oracle:oci:@ORCLOracleType2DatabaseName=ORCLOracleType2ServerName=OracleType2PortNumber=1521OracleType2OracleLogFileSizeLimit=0OracleType2OracleLogFileCount=1OracleType2OracleLogFileName=OracleType2OracleLogTraceLevel=INFOOracleType2OracleLogFormat=SimpleFormatOracleType2OracleLogPackageName=oracle.jdbc.driverOracleType2TNSEntryName=OracleType2NetworkProtocol=OracleType2DataSourceName=OracleType2LoginTimeout=OracleType2Description=OracleType2EnableMultithreadedAccessDetection=falseOracleType2Reauthentication=falseOracleType2JmsOnePhaseOptimization=falseOracleType2PreTestSQLString=SELECT 1 FROM DUALOracleType2DbFailOverEnabled=OracleType2ConnRetriesDuringDBFailover=OracleType2ConnRetryIntervalDuringDBFailover=################################################################Oracle Type4 Resource Properties################################################################OracleType4JndiName= ---> OracleType4JndiName=jdbc/twsdbOracleType4DriverType=OracleType4URL=jdbc:oracle:thin:@//10.14.36.39:1521/ORCL ---> OracleType4URL=jdbc:oracle:thin:@//10.14.36.39:1521/pdborclOracleType4DatabaseName=ORCLOracleType4ServerName=localhostOracleType4PortNumber=1521OracleType4OracleLogFileSizeLimit=0OracleType4OracleLogFileCount=1OracleType4OracleLogFileName=OracleType4OracleLogTraceLevel=INFOOracleType4OracleLogFormat=SimpleFormatOracleType4OracleLogPackageName=oracle.jdbc.driverOracleType4TNSEntryName=OracleType4NetworkProtocol=OracleType4DataSourceName=OracleType4LoginTimeout=OracleType4Description=OracleType4EnableMultithreadedAccessDetection=falseOracleType4Reauthentication=falseOracleType4JmsOnePhaseOptimization=falseOracleType4PreTestSQLString=SELECT 1 FROM DUALOracleType4DbFailOverEnabled=falseOracleType4ConnRetriesDuringDBFailover=100OracleType4ConnRetryIntervalDuringDBFailover=3000If you do not know how to set the parameters specified above, you can find this information in the file <oracle_home>\network\admin\tnsnames.ora on the machine where the TWS master is installed.You should find a section like this:<hostname> =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxxxxx)(PORT = yyyy)))(CONNECT_DATA =(SERVICE_NAME = zzzz)))Where:xxxxxxxxxx is the hostnameyyyy is the port number (1521 above)zzzz is the DB instance name (ORCL above)Example:# tnsnames.ora Network Configuration File: C:\app\oracle\product\12.1.0\dbhome_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools.ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) )GLOBORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = eu-hws-win37.nonprod.)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )ORCL = ---> SID for type 2 (deprecated) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = eu-hws-win37.nonprod.)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pdborcl) ---> SERVICE_NAME for type 4 ) Stop the WebSphere? Application ServerRun changeDataSourceProperties.bat DataSourceProperties.txt to apply the changes C:\Program Files\IBM\MDM94FP6\wastools>changeDataSourceProperties.bat DataSourceProperties.txtStart the WebSphere? Application ServerVerify that the change has been implemented by executing the command and verifying output C:\Program Files\IBM\MDM94FP6\wastools>showDataSourceProperties.batExample:################################################################Oracle Type2 Resource Properties################################################################OracleType2JndiName=jdbc/twsdb_oldOracleType2DriverType=OracleType2URL=jdbc:oracle:oci:@ORCLOracleType2DatabaseName=ORCLOracleType2ServerName=OracleType2PortNumber=1521OracleType2OracleLogFileSizeLimit=0OracleType2OracleLogFileCount=1OracleType2OracleLogFileName=OracleType2OracleLogTraceLevel=INFOOracleType2OracleLogFormat=SimpleFormatOracleType2OracleLogPackageName=oracle.jdbc.driverOracleType2TNSEntryName=OracleType2NetworkProtocol=OracleType2DataSourceName=OracleType2LoginTimeout=OracleType2Description=OracleType2EnableMultithreadedAccessDetection=falseOracleType2Reauthentication=falseOracleType2JmsOnePhaseOptimization=falseOracleType2PreTestSQLString=SELECT 1 FROM DUALOracleType2DbFailOverEnabled=OracleType2ConnRetriesDuringDBFailover=OracleType2ConnRetryIntervalDuringDBFailover=################################################################Oracle Type4 Resource Properties################################################################OracleType4JndiName=jdbc/twsdbOracleType4DriverType=OracleType4URL=jdbc:oracle:thin:@//10.14.36.39:1521/pdborclOracleType4DatabaseName=ORCLOracleType4ServerName=localhostOracleType4PortNumber=1521OracleType4OracleLogFileSizeLimit=0OracleType4OracleLogFileCount=1OracleType4OracleLogFileName=OracleType4OracleLogTraceLevel=INFOOracleType4OracleLogFormat=SimpleFormatOracleType4OracleLogPackageName=oracle.jdbc.driverOracleType4TNSEntryName=OracleType4NetworkProtocol=OracleType4DataSourceName=OracleType4LoginTimeout=OracleType4Description=OracleType4EnableMultithreadedAccessDetection=falseOracleType4Reauthentication=falseOracleType4JmsOnePhaseOptimization=falseOracleType4PreTestSQLString=SELECT 1 FROM DUALOracleType4DbFailOverEnabled=falseOracleType4ConnRetriesDuringDBFailover=100OracleType4ConnRetryIntervalDuringDBFailover=3000Backup the following files:C:\Program Files\IBM\MDM94FP6\WAS\TWSProfile\bin\setupCmdLine.batC:\Program Files\IBM\MDM94FP6\WAS\TWSProfile\logs\manageSdkEnableAdmin.traceC:\Program Files\IBM\MDM94FP6\TWS\tws_tools\postUpgradeEARs.batC:\Program Files\IBM\MDM94FP6\TWS\tws_tools\createProfile.batC:\Program Files\IBM\MDM94FP6\TWS\dbtools\oracle\scripts\updateSetupCmdLine.batC:\Program Files\IBM\MDM94FP6\TWS\dbtools\oracle\scripts\createdb_root.batC:\Program Files\IBM\MDM94FP6\TWS\dbtools\oracle\scripts\migratedb_root.batC:\Program Files\IBM\MDM94FP6\TWS\dbtools\oracle\scripts\launchdb_root_ora.batC:\Program Files\IBM\MDM94FP6\TWS\dblighttool\launchUpgradeIWSDB.batC:\Program Files\IBM\MDM94FP6\TDWB\dbtools\oracle\scripts\createdb_root.batC:\Program Files\IBM\MDM94FP6\TDWB\dbtools\oracle\scripts\migratedb_root.batC:\Program Files\IBM\MDM94FP6\TDWB\bin\tdwb_env.batC:\Program Files\IBM\MDM94FP6\wastools\InstallOracleDataSource.batINSTALL ORACLE 19cNOTE: Make sure that the current version of Oracle 12c is supported before?upgrading to Oracle version 19cCopy Oracle 19c image in a folder and launch setup.exe = C:\images\ORACLE19c\WINDOWS.X64_193000_db_home\setup.exeAfter installing, go to: C:\images\ORACLE19c\WINDOWS.X64_193000_db_home\bin and launch dbua.bat to upgrade Oracle 12c to 19c:Insert SYSDBA Username and PasswordInsert Oracle Home User and PasswordFixing warningAfter the Upgrade, only if the Oracle home has changed, then change also the Oracle_home that is reported in all the files:C:\Program Files\IBM\MDM94FP6\WAS\TWSProfile\bin\setupCmdLine.batC:\Program Files\IBM\MDM94FP6\WAS\TWSProfile\logs\manageSdkEnableAdmin.traceC:\Program Files\IBM\MDM94FP6\TWS\tws_tools\postUpgradeEARs.batC:\Program Files\IBM\MDM94FP6\TWS\tws_tools\createProfile.batC:\Program Files\IBM\MDM94FP6\TWS\dbtools\oracle\scripts\updateSetupCmdLine.batC:\Program Files\IBM\MDM94FP6\TWS\dbtools\oracle\scripts\createdb_root.batC:\Program Files\IBM\MDM94FP6\TWS\dbtools\oracle\scripts\migratedb_root.batC:\Program Files\IBM\MDM94FP6\TWS\dbtools\oracle\scripts\launchdb_root_ora.batC:\Program Files\IBM\MDM94FP6\TWS\dblighttool\launchUpgradeIWSDB.batC:\Program Files\IBM\MDM94FP6\TDWB\dbtools\oracle\scripts\createdb_root.batC:\Program Files\IBM\MDM94FP6\TDWB\dbtools\oracle\scripts\migratedb_root.batC:\Program Files\IBM\MDM94FP6\TDWB\bin\tdwb_env.batC:\Program Files\IBM\MDM94FP6\wastools\InstallOracleDataSource.batExecute showDataSourceProperties and redirect output to a txt file C:\Program Files\IBM\MDM94FP6\wastools>showDataSourceProperties.bat > myDSPs.txtEdit the file myDSPs.txt changing the Oracle HomeStop the WebSphere? Application Server Run changeDataSourceProperties.bat DataSourceProperties.txt to apply the changes C:\Program Files\IBM\MDM94FP6\wastools>changeDataSourceProperties.bat myDSPs.txtMake sure ojdbc8.jar exists under oracle lib folder = C:\app\oracle\product\12.2.0\dbhome_1\jdbc\lib If it does not exist, download it from the official Oracle website and put it under the oracle lib folder. In the following files change: <ojdbc6.jar> to < ojdbc8.jar>:C:\Program Files\IBM\MDM94FP6\WAS\TWSProfile\config\cells\TWSNodeCell\nodes\TWSNode\servers\server1\resources.xmlC:\Program Files\IBM\MDM94FP6 \TWS\dblighttool\launchUpgradeIWSDB.batC:\Program Files\IBM\MDM94FP6 \TWS\tws_tools\postTWSUpgradeChanges.jaclC:\Program Files\IBM\MDM94FP6 \TWS\tws_tools\postTWSDMInstallationChanges.jaclC:\Program Files\IBM\MDM94FP6 \TWS\tws_tools\postTWSInstallationChanges.jaclC:\Program Files\IBM\MDM94FP6 \TDWB\dblighttool\launchUpgradeIWSDB.batC:\Program Files\IBM\MDM94FP6 \TDWB\bin\tdwb_env.batStart the WebSphere? Application ServerFor more details on this process, refer to the following Technotes: Materials - Property of HCL Limited. ? Copyright IBM Corporation 2016? Copyright HCL Technologies Limited 2020. U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download