I am working in datawarehouse project and use DB2 database . shell scripting is written to connect with DB2 database in my application but i dont know how to connect with oracle databse or other databases.Is there any command in unix to connect any of these datbases?
I used . oraenv on unix prompt but is displaying NO SUCH FILE AND DIRECTORY.
I also tried SqlPlus command eventhough it is saying Command Not Found....
is there anything I am doing wrong .
I am not clear with how to set up the enviornment variable.. Because i used SET command to check these variable but these are not there..
Have you established that Oracle is installed in the first place? (assuming it's not your own server / Linux you're connected to - in which case you should know!).
id oracle
If that's OK, you need to find where the Oracle software is installed. Usually something like