8 Replies Latest reply: Jun 5, 2009 12:19 PM by sb92075 RSS

    TNS-12570: TNS:packet reader failure error - please help?

    135995
      Hello,

      I am attempting to log onto an oracle database server that is running locally. I'm using sql*plus to login:

      SQL> connect system@xe
      Enter password:

      Unfortunately, the login prompt hangs, and I'm not able to complete login. Next, I checked the listener and sqlnet log files, and here is the output of the sqlnet log file:


      *****sqlnet.log file details:
      Fatal NI connect error 12570, connecting to:
      +(LOCAL=NO)+

      VERSION INFORMATION:
      +     TNS for 32-bit Windows: Version 10.2.0.1.0 - Production+
      +     Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production+
      +     Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production+
      Time: 05-JUN-2009 09:13:36
      Tracing not turned on.
      Tns error struct:
      ns main err code: 12570
      TNS-12570: TNS:packet reader failure
      ns secondary err code: 12560
      nt main err code: 0
      nt secondary err code: 0
      nt OS err code: 0

      here is the output from the listener log file:

      05-JUN-2009 09:12:45 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=walra04))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
      05-JUN-2009 09:13:34 * service_update * xe * 0
      05-JUN-2009 09:13:36 * (CONNECT_DATA=(SERVICE_NAME=XE)(CID=(PROGRAM=C:\oraclexe\app\oracle\product\10.2.0\server\bin\sqlplus.exe)(HOST=<machine_name>)(USER=<username>))) * (ADDRESS=(PROTOCOL=tcp)(HOST=***.***.***.**)(PORT=2808)) * establish * XE * 0

      ---css.log output
      [  OCRUTL][532]u_set_gbl_comp_error: Parameter was NULL
      [  OCRUTL][532]u_set_gbl_comp_error: Parameter was NULL
      2009-06-05 00:37:15.687: [  OCRRAW][532]proprinit: Could not open raw device
      2009-06-05 00:37:15.687: [ default][532]a_init:7!: Backend init unsuccessful : [33]
      [  OCRUTL][532]u_set_ocr_error: Parameter was NULL
      2009-06-05 00:37:15.687: [ CSSCLNT][532]clsssinit: error(33 ) in OCR initialization


      It is worth mentioning that the PORT=2808 value seems to be applied dynamically, and I'm not sure why. I've specified PORT=1521 in my tnsnames.ora and listener.ora files (see below).

      I've tried searching online for a solution, but have only found possible causes of the issue. I'm an Oracle 10g newbie, and while this problem looks daunting, I'm sure there is a solution for it. Here are my machine/environment specs:

      ---System Specs:

      Oracle Database 10g Express Edition (10.2.0) - installed on Lenovo ThinkPad TSeries
      WindowsXP Professional, Version 2002, Service Pack 2
      Intel Core Duo CPU
      2 GHz, 3GB RAM

      ---tnsnames.ora

      XE=
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = <machine_name>.com)(PORT = 1521))
      )
      (CONNECT_DATA =
      (SERVICE_NAME = XE)
      )
      )

      ---listener.ora
      LISTENER =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = <machine_name>.com)(PORT = 1521))
      )
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      )
      )

      SID_LIST_LISTENER =
      (SID_LIST =
      (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0)
      (PROGRAM = extproc)
      )
      (SID_DESC =
      (GLOBAL_DBNAME = xe)
      (ORACLE_HOME =C:\oraclexe\app\oracle\product\10.2.0)
      (SID_NAME = xe)
      )
      )

      ---sqlnet.ora

      SQLNET.AUTHENTICATION_SERVICES = (NTS)


      If anyone could offer assistance and a viable solution, I would be extremely grateful.

      Kind regards,
      Rachael
        • 1. Re: TNS-12570: TNS:packet reader failure error - please help?
          277993
          If connecting locally just remove the @XE from the connect

          SQL> connect system
          Enter password:

          Use the SQL Comand Prompt from the XE menu
          • 2. Re: TNS-12570: TNS:packet reader failure error - please help?
            sybrand_b
            Oracle errors can be Googled.
            Apparently you are not aware of this. There is also online documentation on http://tahiti.oracle.com
            Please avoid forcing any volunteer to look up the error.
            12570 is about network problems.
            It is a pity you hide a crucial bit of information.
            I don't care about the name, but one does need to know whether this is a DHCP assigned address or a Local Loopback connector.
            If your system is on DHCP, using a Local loopback is mandatory, and you are prompted to set it up during installation.

            Oracle connections always use 2 ports: the first form client to listener on 1521, the second from database to client on a random port number.
            As the listener is a broker only the first connection is closed and all communication is redirected to the second connection.

            ------------------
            Sybrand Bakker
            Senior Oracle DBA

            Experts: those who did read documentation.
            • 3. Re: TNS-12570: TNS:packet reader failure error - please help?
              SanjayRs
              Racheal,

              On local system

              C:\> SET ORACLE_SID=XE

              C:\> SQLPLUS SYSTEM/passwd


              Others - Install Microsoft Loopback Adapter and configure the sqlnet/tnsnames/listener.


              SS
              • 4. Re: TNS-12570: TNS:packet reader failure error - please help?
                135995
                Thank you for your kind response, Sanjay.

                I've uninstalled the database, configured my system (per the Oracle Database Preinstallation Requirements (http://download.oracle.com/docs/cd/B19306_01/install.102/b14316/reqs.htm#BABBDGBI), installed the loopback adapter, configured the C:\WINDOWS\system32\drivers\etc\hosts file, and reinstalled 10g, and, as before, when attempting to work with the database via SQL Developer, the connection to the database times out. Similar behavior encountered while attempting to log in via sql*plus as

                system@xe

                The sqlnet.log file still displays the following:

                Fatal NI connect error 12570, connecting to:
                (LOCAL=NO)

                VERSION INFORMATION:
                     TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
                     Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
                     Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
                Time: 05-JUN-2009 12:40:54
                Tracing not turned on.
                Tns error struct:
                ns main err code: 12570
                TNS-12570: TNS:packet reader failure
                ns secondary err code: 12560
                nt main err code: 0
                nt secondary err code: 0
                nt OS err code: 0
                • 5. Re: TNS-12570: TNS:packet reader failure error - please help?
                  sb92075
                  CUT commands below

                  SET
                  lsnrctl start
                  lsnrctl status
                  lsnrctl service
                  pwd

                  PASTE them into command window

                  CUT from command window the commands & results, then PASTE back here
                  • 6. Re: TNS-12570: TNS:packet reader failure error - please help?
                    135995
                    Hello,

                    As requested here is the output:


                    C:\Documents and Settings\*****>SET
                    ALLUSERSPROFILE=C:\Documents and Settings\All Users
                    APPDATA=C:\Documents and Settings\*****\Application Data
                    ASMROOT=C:\Program Files\CA\Unicenter Software Delivery\SD
                    AVENGINE=C:\PROGRA~1\CA\SHARED~1\SCANEN~1
                    CAI_CAFT=C:\Program Files\CA\SC\CAM
                    CAI_MSQ=C:\Program Files\CA\SC\CAM
                    CAI_MSQ_NOWV=y
                    CASHCOMP=C:\Program Files\CA\SharedComponents\
                    CLASSPATH=.;C:\ruby;C:\Ruby\lib;C:\Ruby\wso2-ws\wsf_c;C:\Ruby\wso2-ws\lib;C:\Ruby\wso2-ws;
                    CommonProgramFiles=C:\Program Files\Common Files
                    COMPUTERNAME=********
                    ComSpec=C:\WINDOWS\system32\cmd.exe
                    FP_NO_HOST_CHECK=NO
                    HOMEDRIVE=C:
                    HOMEPATH=\Documents and Settings\*****
                    IGW_LOC=C:\Program Files\CA\SharedComponents\iTechnology\
                    include=C:\Program Files\Microsoft Visual Studio\VC98\atl\include;C:\Program Files\Microsoft Visual Studio\VC98
                    \mfc\include;C:\Program Files\Microsoft Visual Studio\VC98\include
                    INOCULAN=C:\Program Files\CA\eTrustITM
                    ITMLICENSE=C:\Program Files\CA\SharedComponents\SubscriptionLicense\
                    ITMTHIRDPARTY=C:\Program Files\CA\SharedComponents\ThirdParty\
                    JAVA_HOME=C:\Program Files\Java\jdk1.6.0_06
                    JAVA_PLUGIN_WEBCONTROL_ENABLE=1
                    LH_HOME=C:\LiveHealth
                    lib=C:\Program Files\Microsoft Visual Studio\VC98\mfc\lib;C:\Program Files\Microsoft Visual Studio\VC98\lib
                    LOGONSERVER=\\USILDC01
                    LSHOST=usilap255
                    MSDevDir=C:\Program Files\Microsoft Visual Studio\Common\MSDev98
                    MSJAVA_ENABLE_MONITORS=1
                    NUMBER_OF_PROCESSORS=2
                    OPENSSL_CONF=C:\OpenSSL\bin\openssl.cfg
                    ORACLE_HOSTNAME=********.**.com
                    oracle_sid=xe
                    OS=Windows_NT
                    Path=C:\oraclexe\app\oracle\product\10.2.0\server\bin;C:\Program Files\CA\Dcs\DMScripting\;C:\Program Files\CA\
                    DCS\CAWIN\;C:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib\ojdbc14.jar;C:\Program Files\Microsoft Visual
                    Studio\VC98\Bin\cl.exe;C:\Program Files\Microsoft Visual Studio\VC98\Bin\nmake.exe;C:\Program Files\Microsoft V
                    isual Studio\VC98\Bin\vcvars32.bat;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\CA_APPSW;C:\Progr
                    am Files\Visual Networks\Dial Analysis\;C:\Program Files\CA\SharedComponents\ScanEngine;C:\Program Files\CA\Sha
                    redComponents\CAUpdate\;C:\Program Files\CA\SharedComponents\ThirdParty\;C:\Program Files\CA\SharedComponents\S
                    ubscriptionLicense\;C:\Program Files\CA\eTrustITM;C:\Program Files\Common Files\Roxio Shared\DLLShared\;C:\Prog
                    ram Files\Common Files\Roxio Shared\DLLShared\;C:\Program Files\Common Files\Roxio Shared\9.0\DLLShared\;C:\Pro
                    gram Files\CA\Unicenter Software Delivery\BIN;C:\Program Files\CA\DSM\bin;C:\PROGRA~1\CA\SC\CAM\bin;C:\WINDOWS\
                    system32\WindowsPowerShell\v1.0;C:\Program Files\QuickTime\QTSystem\;C:\Program Files\DisplayLink Core Software
                    \;C:\Program Files\Microsoft Visual Studio\VC98\Bin;.;C:\ruby\bin;C:\Program Files\Microsoft Visual Studio\Comm
                    on\Tools\WinNT;C:\Program Files\Microsoft Visual Studio\VC98\Bin;C:\Program Files\Microsoft Visual Studio\Commo
                    n\Tools;C:\Program Files\Java\jdk1.6.0_06\bin;C:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib\ojdbc14.jar
                    ;C:\Program Files\Java\jre1.6.0_07\bin;C:\ruby\bin;C:\Program Files\Microsoft Visual Studio\VC98\Bin\CL.EXE;C:\
                    Program Files\Microsoft Visual Studio\VC98\Bin\NMAKE.EXE;C:\Program Files\Microsoft Visual Studio\VC98\Bin\VCVA
                    RS32.BAT;C:\oraclexe\app\oracle\product\10.2.0\server\BIN
                    PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.PSC1;.RB;.RBW
                    PROCESSOR_ARCHITECTURE=x86
                    PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 11, GenuineIntel
                    PROCESSOR_LEVEL=6
                    PROCESSOR_REVISION=0f0b
                    ProgramFiles=C:\Program Files
                    PROMPT=$P$G
                    QMAKESPEC=win32-msvc.net
                    QTDIR=C:\Ruby\qt-3.3.x-p8
                    RUBYOPT=-rubygems
                    RUBY_HOME=C:\ruby
                    SDROOT=C:\Program Files\CA\DSM\SD
                    SESSIONNAME=Console
                    SystemDrive=C:
                    SystemRoot=C:\WINDOWS
                    TEMP=C:\DOCUME~1\*****\LOCALS~1\Temp
                    TMP=C:\DOCUME~1\*****\LOCALS~1\Temp
                    TPCCommon=C:\PROGRA~1\THINKV~2\PrdCtr
                    USERDNSDOMAIN=**.COM
                    USERDOMAIN=*****
                    USERNAME=****
                    USERPROFILE=C:\Documents and Settings\*****
                    windir=C:\WINDOWS
                    WSFC_HOME=C:\Ruby\wso2-ws\wsf_c

                    C:\Documents and Settings\*****>lsnrctl start

                    LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 05-JUN-2009 12:49:05

                    Copyright (c) 1991, 2005, Oracle. All rights reserved.

                    TNS-01106: Listener using listener name LISTENER has already been started

                    C:\Documents and Settings\*****>lsnrctl status

                    LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 05-JUN-2009 12:49:05

                    Copyright (c) 1991, 2005, Oracle. All rights reserved.

                    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
                    STATUS of the LISTENER
                    ------------------------
                    Alias LISTENER
                    Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
                    Start Date 05-JUN-2009 12:07:00
                    Uptime 0 days 0 hr. 42 min. 4 sec
                    Trace Level off
                    Security ON: Local OS Authentication
                    SNMP OFF
                    Default Service XE
                    Listener Parameter File C:\oraclexe\app\oracle\product\10.2.0\server\network\admin\listener.ora
                    Listener Log File C:\oraclexe\app\oracle\product\10.2.0\server\network\log\listener.log
                    Listening Endpoints Summary...
                    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
                    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=computername.hostname.com)(PORT=1521)))
                    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8080))(Presentation=HTTP)(Session=RAW))
                    Services Summary...
                    Service "CLRExtProc" has 1 instance(s).
                    Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
                    Service "PLSExtProc" has 1 instance(s).
                    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
                    Service "XEXDB" has 1 instance(s).
                    Instance "xe", status READY, has 1 handler(s) for this service...
                    Service "XE_XPT" has 1 instance(s).
                    Instance "xe", status READY, has 1 handler(s) for this service...
                    Service "xe" has 1 instance(s).
                    Instance "xe", status READY, has 1 handler(s) for this service...
                    The command completed successfully

                    C:\Documents and Settings\*****>lsnrctl service

                    LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 05-JUN-2009 12:49:05

                    Copyright (c) 1991, 2005, Oracle. All rights reserved.

                    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
                    Services Summary...
                    Service "CLRExtProc" has 1 instance(s).
                    Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
                    Handler(s):
                    "DEDICATED" established:0 refused:0
                    LOCAL SERVER
                    Service "PLSExtProc" has 1 instance(s).
                    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
                    Handler(s):
                    "DEDICATED" established:0 refused:0
                    LOCAL SERVER
                    Service "XEXDB" has 1 instance(s).
                    Instance "xe", status READY, has 1 handler(s) for this service...
                    Handler(s):
                    "D000" established:6 refused:0 current:6 max:1002 state:ready
                    DISPATCHER <machine: ********, pid: 1720>
                    (ADDRESS=(PROTOCOL=tcp)(HOST=computername.hostname.com)(PORT=1495))
                    Service "XE_XPT" has 1 instance(s).
                    Instance "xe", status READY, has 1 handler(s) for this service...
                    Handler(s):
                    "DEDICATED" established:13 refused:0 state:ready
                    LOCAL SERVER
                    Service "xe" has 1 instance(s).
                    Instance "xe", status READY, has 1 handler(s) for this service...
                    Handler(s):
                    "DEDICATED" established:13 refused:0 state:ready
                    LOCAL SERVER
                    The command completed successfully

                    C:\Documents and Settings\*****>pwd
                    'pwd' is not recognized as an internal or external command,
                    operable program or batch file.
                    • 7. Re: TNS-12570: TNS:packet reader failure error - please help?
                      sb92075
                      (ADDRESS=(PROTOCOL=tcp)(HOST=computername.hostname.com)(PORT=1495))
                      above is from
                      lsnrctl service
                      port=1495 does not match anything else previously posted?????

                      what happens when you CUT commands below & then paste into command window?

                      sqlplus
                      / as sysdba
                      select * from v$version;
                      exit
                      • 8. Re: TNS-12570: TNS:packet reader failure error - please help?
                        135995
                        Enter user-name: / as sysdba

                        Connected to:
                        Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

                        SQL> select * from v$version;

                        BANNER
                        ----------------------------------------------------------------
                        Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
                        PL/SQL Release 10.2.0.1.0 - Production
                        CORE 10.2.0.1.0 Production
                        TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
                        NLSRTL Version 10.2.0.1.0 - Production

                        SQL> exit
                        Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production