this may be a simple questions but I am not a DBA administrator but rather a penetration tester. I have installed an Express edition of Oracle 11 database on one host (Windows 7) and want to access to from another host (Backtrack Linux based on Debian) from SQL*PLUS Instant client.
While I managed to resolve multiple issues with shared libraries, I am still not able to run the sqlplus command as Oracle. I get the following errors:
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
I followed the installation manual by Oracle and also created Oracle user with 2 env. variables set to:
Note that I only installed SQPLUS client on Linux and there is no DB running. The version of sqlplus is 18.104.22.168.0
On different forums people advised to set other variables according to the DB installed but I have none.
All I want is to run sqlplus with the IP address, SID, port and username.
Is it feasible to have only SQL*PLUS client installed or am I still missing something else?
Thanks for any hints.