How to Script in PuTTY to Connect to an Oracle Database
PuTTY provides a way to access remote computers over Secure Shell, or SSH, connections. When you do this, you are given a command terminal to that computer, and complete access to its commands as if you were sitting there. While not a scripting program, PuTTY does allow you to access remote programs on computers, and execute them on that computer. For example, connecting through PuTTY to a server with an Oracle database allows you to use that database over the remote connection.
Other People Are Reading
Instructions
-
-
1
Download and follow the installation instructions for PuTTY, found at chiark.greenend.org.uk.
-
2
Start Putty by double-clicking the created PuTTY icon.
-
-
3
Enter the server name in the Name box, either by domain name or IP address.
-
4
Select the "SSH" radion button, click the "Open" button and enter your login credentials for the database's server.
-
5
Enter commands to the database with the SQL language. You are now connected to the database server's operating system and can access the database itself. If using Oracle SQL plus, for example, enter "sqlplus" into the command line, followed by your database login credentials.
-
1
