How To
Summary
In some situations, you might need to disable and then re-enable Oracle SSL authentication. For example, when you are upgrading to IBM Business Automation Workflow V19.0.0.3 you must disable Oracle SSL authentication before upgrading and then re-enable it after upgrading.
Steps
Disabling Oracle SSL authentication
- Go to <ORACLE_HOME>/network/admin and back up your files by using the sqlnet.ora/listener.ora/tnsnames.ora file.
- Open the <ORACLE_HOME>/network/admin/sqlnet.ora file and remove the TCPS value from the SQLNET.AUTHENTICATION_SERVICES parameter.
- Open the listener.ora file and remove the line with the TCPS protocol from the address list:
(ADDRESS = (PROTOCOL = TCPS)(HOST = <oracle_server_host>)(PORT = <secure_port>))
- Restart the Oracle listener to apply the changes.
Document Location
Worldwide
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS8JB4","label":"IBM Business Automation Workflow"},"ARM Category":[{"code":"a8m50000000Cca0AAC","label":"Upgrade and Migration"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"18.0.0;19.0.0","Line of Business":{"code":"LOB45","label":"Automation"}}]
Was this topic helpful?
Document Information
Modified date:
10 August 2020
UID
ibm16245004