16.5 Use the OCI Console to Run Commands in the Data Transforms Instance

When the Oracle Data Transforms repository provisioning process completes, certain commands are available for use in the compute instance Run command feature.

You can use these commands as templates to create new commands that you can run without having to login into the instance.

Name	Command	Description
restartCommand	sudo systemctl restart jettyserver.service	Restarts the jetty server.
archiveCommand	cp -R /u01/oracle/transforms_home/logs /tmp	Archives the log files to the local temporary folder.
listLogs	ls /u01/oracle/transforms_home/logs	Lists the log files.
displayStartupLog	cat /u01/oracle/transforms_home/logs/transformsStartup.log	Displays the configuration logs. This information is useful for troubleshooting any configuration issues.

To use the run command feature, you have to setup the following policy:

Allow dynamic-group odi_group  to  manage instance-family  in compartment odi
Allow dynamic-group odi_group  to use instance-agent-command-family in compartment odi
Allow dynamic-group odi_group to use instance-agent-command-execution-family in compartment odi where request.instance.id=target.instance.id

To use the pre-installed scripts to create commands to run on an instance:

1. On the OCI console, open the navigation menu present on the top left corner and click Compute.
2. Under Compute, click Instances.
3. Click the instance that you want to run the command on.
4. Under Resources, click Run command. The Run command screen lists the commands that you can use as a template to create and execute commands.
5. Find the command in the list, click the Actions menu, and then click View command details.
6. On the Command details page, copy the command from the Command Content section and close the page.
7. Click Create command.
8. Enter a name for the command.
9. In the Add script section, select Paste script and paste the copied command in the box.
10. In the Output type section, select the location to save the output of the command.
11. Click Create command.
12. Wait for the completion of the command. See the Execution Status column to monitor whether the command has run successfully.

If the command output was saved to an Object Storage location, either download the response object from the bucket where it was saved or navigate to the Object Storage pre-authenticated request URL. If the command output was saved as a plain text file, find the command in the list, click the Actions menu, and then click View command details to view the output.