How can i make Oracle connection from UNIX

vemisr · Post by **vemisr** » Wed Nov 10, 2010 11:02 am

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

dougcl · Post by **dougcl** » Wed Nov 10, 2010 11:10 am

Use sqlplus?

swapnilverma · Post by **swapnilverma** » Wed Nov 10, 2010 11:23 am

use sqlplus -s uname/password@instance_name

make sure oracle path is set ...