orachk upload into collection manager
I am using Redhat servers and trying to create a script to upload the Orachk reports into the collection manager in APEX. I can upload them manually but I'm trying to upload them after it is run and I get this error:
orachk was not able to make successfull connection to database to upload result.
Here is my script:
#!/bin/sh
export RAT_UPLOAD_CONNECT_STRING="(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=apexd.dev)(PORT=1521))(LOAD_BALANCE=yes)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DVAPEX)))"
export RAT_UPLOAD_TABLE=AUDITCHECK_RESULT
export RAT_PATCH_UPLOAD_TABLE=AUDITCHECK_PATCH_RESULT
export RAT_UPLOAD_USER=ORACHK_ADMIN