Is it possible to see or change the command used by Stat to upload a file for RAC databases??
说明
Failed to upload a file to the server because Stat uses the DB connect string as host:port:sid. For RAC databases should the DB connect string be host:port/service ?
Is it possible to see or change the command used by Stat to upload a file?
解决办法
Depending on what kind of object it is, the Stat oracle agent invokes specific Oracle utilities like FNDLOAD, XDOLoader, sqlplus, etc.
In the case of certain files, it may be possible to check in the Oracle agent log, in debug mode, to see which utility is invoked and its complete command.
If it fails to upload because of the SID instead of SERVICE_NAME for example, you can go to the Oracle Connection information, select the environment and scroll to the right and check the flag 'Use TNS', and fill in the column 'TNS Entry' with the string from the tnsnames.ora (in one line without a space), replacing SID with SERVICE_NAME.
