sqlplus: ORA-01017 logon denied from one host but OK from another
At first make sure the database host is available ping host1.

Then you have to install a client and configure service name.

To install the oracle client correctly and be able to use it you have to:


Choose the "Administrator" type of the oracle client installation, not instant client, it provides you database administrator tools. 
After your client installation run Net Manager (netmgr) to add a new service name. When you start testing the connection (Final step), make sure the "scott" user is available in your database. 
Then run tnsping YOUR_SERVICE_NAMECONNECTION_NAME(Thanks @vapcguy for the correction) - tnsping is a tool that comes in the administration installation). 
Run sqlplus sys/passwd@&lt;YOUR_SERVICE_NAME&gt; as sysdba or sqlplus sys/passwd@host1:PORT/&lt;DATABASE_SERVICE_NAME&gt;