| Running a Script on Database from Remote Machine [message #53966] |
Tue, 22 October 2002 08:26  |
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
|
Senior Member |
|
|
I have 2 machines A and B
B Machine has got oracle database installed in it.
In A machine i dont have any Oracle Components installed...
I have a Script file in machine A , which i want to Execute on machine B ...But i have to execute the script only from Machine A..
Please help me with the procedure..
Thanks and regards
SAI
|
|
|
|
|
|
| Re: Running a Script on Database from Remote Machine [message #53977 is a reply to message #53966] |
Tue, 22 October 2002 17:27  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Hope you have UNIX based machines. Then install ssh on both of them (if you still doesn't have it). Create authorized_keys file in both users ~/.ssh directory so you can login through SSH w/o password from machine to machine.
Then simple run from the machine A :
scp script_to_run username@machineB:/tmp
ssh username@machineB:/oracle_home/bin/sqlplus username/password @/tmp/script_to_run
You can do the same with rcp and rsh if security is not a concern.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
