| Not able to connect from client to Oracle Database in Unix [message #572396] |
Tue, 11 December 2012 09:18  |
 |
deekshitha
Messages: 1
Registered: December 2012
|
Junior Member |
|
|
Hi,
I have new virtual unix machine and I installed oralce client on /usr/lib/oracle. Also I have a oracle database and I am able to connect to this database from my desktop sql developer.
So now I am trying to connect from new UNIX machine. Where I created tnsnames.ora file under /usr/lib/oracle/network/admin and before connecting did export the following
export TNS_ADMIN=/usr/lib/oracle/network/admin
export ORACLE_HOME=/usr/lib/oracle/
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$PATH:$HOME/bin:/sbin:$ORACLE_HOME/bin
export ORACLE_SID=VFIODSD1
when I try
# sqlplus
username :xxxxxxx
password : xxxxxxx
ORA-12545: Connect failed because target host or object does not exist. Not sure what I missed here. using same tns file I am able to connect from sql developer on windows.
Can anyone help what I missed in unix configuration?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
