Page 1 of 1

How can i make Oracle connection from UNIX

Posted: Wed Nov 10, 2010 11:02 am
by vemisr
HI expers,

how can i connect to Oracle table from unix, i need to update the DSjob status, run time, source and traget information in a JOB_HISTORY table.


i used connection statement but it didn't connecting.

i need to run this connect statement from UNIX SHELL Script.

Thanks in advance.
vemisr

Posted: Wed Nov 10, 2010 11:10 am
by dougcl
Use sqlplus?

Posted: Wed Nov 10, 2010 11:23 am
by swapnilverma
use sqlplus -s uname/password@instance_name


make sure oracle path is set ...