1 2 Previous Next 26 Replies Latest reply: Apr 5, 2011 2:35 PM by DBA_1976 RSS

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

    user640001
      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