SQL Agent
Deployment Steps
2min
Deploying SQL Agent involves several key steps:
- Ensure the SQL Agent software is properly uploaded and files are extracted on your database server.
- To extract the file, use the following command: tar -xvf sqlagent-3.5.1.tar.gz
- Navigate to the Agent Management in Kron PAM and get the jwt token for the requested period.
- Update agent_parameters file
Parameter Name | Description | Example Value |
|---|---|---|
krondam_host | The host ip of the target database | 10.20.42.35 |
database_listener_port | The port where the agent should be run | 1265 |
installation_directory | The path where the agent will be installed (Will default to /u01 if left empty) | /u01 |
jwt_token | The registration key that is required for the installation and can be received from Agent Management Screen | 7b91a31a-596a-4797-93fc-7b148b0bfed8 |
ORACLE_HOSTNAME | Oracle hostname | 10.20.42.35 |
ORACLE_UNQNAME | Unique name of Oracle | ORA12CDB |
ORACLE_SID | | |
ORACLE_BASE | | |
ORACLE_HOME | | |
- Execute the installation script (sqlagent-3.5.1.sh)
- To execute the script, use the following command: ./sqlagent-3.5.1.sh
- Start the SQL Agent service.
- Systemctl restart sql-ddm.service