Return
-
Title
Run PM to execute sqlplus script on remote Unix Env server does't work. -
Description
Run PM to execute sqlplus script on remote Unix Env server like a fileserver does't work. -
Cause
Some application like ‘sqlplus’ requires right environment like ORACLE_HOME, TNS_ADMIN, PATH, etc… when called to execute on the remote server. So, the question is How to call/execute a sqlplus command on a remote Unix server. -
Resolution
Solution:
1. Go to Maintenance | General | Object Type | File Server tab.
2. Include the command (./.ssh/rc) in the ‘Post Login Cmd ‘ column in the File Server Tab for the object type
3. Log in on the Env on the File Server machine and modify or create the .ssh/rc file exporting the Oracle Envs needed by sqlplus, likeExport ORACLE_HOME=/…/…/Export TNS_ADMIN=$ORACLE_HOME/network/adminExport PATH=$ORACLE_HOME/bin:$PATH4. Apply these changes for the object type, and perform a new migration.