ORA-12560: TNS:protocol adapter error on client machine(linux)
Hi,
Oracle10gXE
Linux Fedora14
Getting below error when trying to connect the database from client machine.
Error
====
ORA-12560: TNS:protocol adapter error
Below is the output of 'export' command on client machine showing enviornment variable values:
oracle@work-desktop:/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin$ export
declare -x HISTCONTROL="ignoreboth"
declare -x HOME="/home/oracle"
declare -x LANG="en_US.UTF-8"
declare -x LANGUAGE="en_US:en"
declare -x LD_LIBRARY_PATH="/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib:"
declare -x LESSCLOSE="/usr/bin/lesspipe %s %s"
declare -x LESSOPEN="| /usr/bin/lesspipe %s"
declare -x LOGNAME="oracle"
declare -x MAIL="/var/mail/oracle"
declare -x NLS_LANG="AMERICAN_AMERICA.AL32UTF8"
declare -x OLDPWD="/usr/lib/oracle/xe/app/oracle/product/10.2.0/client"
declare -x ORACLE_HOME="/usr/lib/oracle/xe/app/oracle/product/10.2.0/client"
declare -x PATH="/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin:/usr/local/bin:/usr/bin:/bin:/usr/games:/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin"
declare -x PWD="/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin"
declare -x SHELL="/bin/bash"
declare -x SHLVL="1"
declare -x SQLPATH="/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/sqlplus"
declare -x TERM="xterm"
declare -x TNS_ADMIN="/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/network/admin"
declare -x USER="oracle"
oracle@work-desktop:/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin$
Database connection works fine when connecting from the server itself( i.e. locally on the database server).
Is there anything still missing on the oralce client machine ?
Regards