This discussion is archived
1 2 Previous Next 26 Replies Latest reply: Apr 5, 2011 12:35 PM by DBA_1976 RSS

ORA-12560: TNS:protocol adapter error on client machine(linux)

user640001 Newbie
Currently Being Moderated
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
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points