1. Login to a remote host through ssh ( I have alreay setup the public-private keys and it is working fine)
2. Fire a SQL query to get count of rows in a table, return that to a variable

This does not appear to work.

The problem is..it does not appear to run the commands within the backtick in the ssh session. This is because the error reported is about the path of sqlplus : "No such file or directory" (Oracle home is different in the local host and remote hosts) . Need help from shell scripting experts.

We all know how boring and exhausting it is to transfer huge web projects developed locally to a webserver simply via FTP.
The File Transfer Protocol is a really nice solution if you need to transfer small amounts of files, but if you're plannin…

When it comes to security, there are always trade-offs between security and convenience/ease of administration. This article examines some of the main pros and cons of using key authentication vs password authentication for hosting an SFTP server.

This video shows how to copy a database user from one database to another user DBMS_METADATA. It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.