Oracle

Description

The Oracle plugin lets you manage users and tablespaces on your Oracle database instance. It supports creating and deleting users, resetting passwords, unlocking accounts, and creating and extending tablespaces. The plugin connects using a JDBC connection string with hostname, port, SID, username, and password. Use this plugin when your workflows need to automate Oracle database administration tasks like user provisioning, password management, or storage maintenance.

Prerequisites

1. Oracle 12c environment on Windows.
2. Sufficient privileges for operation to be done (preferably sysbda privileges/Dba user).
3. The pluggable database (PDB) should be open before performing any action on PDB.
4. ojdbc6.jar must be present in lib folder of Process Studio as well as AE agent.
5. For connecting to the Oracle Server, OracleOraDB12homeTNSListener & OracleServiceSID should be started.