Home » SQL & PL/SQL » Client Tools » Not able to connect from client to Oracle Database in Unix
Not able to connect from client to Oracle Database in Unix [message #572396] Tue, 11 December 2012 09:18 Go to next message
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?

Re: Not able to connect from client to Oracle Database in Unix [message #572397 is a reply to message #572396] Tue, 11 December 2012 09:26 Go to previous message
BlackSwan
Messages: 22926
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

>Can anyone help what I missed in unix configuration?

I suspect basic OS/Networking mis-configuration which can be tested via 8 different "ping" commands

ping <own_hostname>
ping <own_IP#>
ping <other_hostname>
ping <other_IP#>

now do the same from the "other" system
all 8 must succeed before SQL*Net can succeed


Previous Topic: sqlplus64 gives error
Next Topic: Exporting Result to Text file through Query
Goto Forum:
  


Current Time: Fri Oct 31 04:23:58 CDT 2014

Total time taken to generate the page: 0.23890 seconds