I want to create a connection to remote Oracle server using SQLplus client and tnsnames.ora without installing Oracle 11g server on the Linux client. I used debian and bash script to generate reports from remote Oracle servers. Is this possible?
I tried installing SQLplus client but I can't find the tnsnames.ora files.
If possible, can you please give me an example of configuring SQLplus client to use tnsnames.ora files?
I have installed the "basic instant client" and the "sqlplus addition" package. I can connect normally with
sqlplus user/password@host:port/servicenames. I want to create bash scripts to execute *.sql files on more than 10 instances. So, if I can just connect with
sqlplus user/pw@instance It will look simple. it's is possible?
Update : Solved by copying tnsnames.ora files to /etc.
refer to this page on post #3