TNS:packet writer failure
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: TNS:packet writer failure

  1. #1
    Join Date
    Nov 2001
    Location
    Chicago
    Posts
    5
    TNSacket writer failure

    Hello!
    I got very strange problem. My Db and SID has name RTCCS and when I tried to start SVRMGRL I got error message
    $ export ORACLE_SID=RTCCS
    $ svrmgrl

    Oracle Server Manager Release 3.1.6.0.0 - Production

    Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

    ORA-12571: TNSacket writer failure
    SVRMGR> exit

    In trace file I found message too

    nsdo: transport write error
    nserror: entry
    nserror: nsres: id=0, op=67, ns=12571, ns2=12560; nt[0]=530, nt[1]=3, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
    nsdo: nsctxrnk=0
    nsdo: error exit
    nioqsm: send-break: failed to send OOB break...
    nioqper: error from send-marker
    nioqper: nr err code: 0
    nioqper: ns main err code: 12571
    nioqper: ns (2) err code: 12560
    nioqper: nt main err code: 530
    nioqper: nt (2) err code: 3
    nioqper: nt OS err code: 0

    But I can start my Db with different SID, for example rtccs, without any problem
    $ export ORACLE_SID=rtccs
    $ svrmgrl

    Oracle Server Manager Release 3.1.6.0.0 - Production

    Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

    Oracle8i Enterprise Edition Release 8.1.6.3.0 - Production
    With the Partitioning option
    JServer Release 8.1.6.3.0 - Production

    SVRMGR> connect internal
    Connected.
    SVRMGR> select * from v$database;
    DBID NAME CREATED RESETLOGS_ RESETLOGS PRIOR_RESE PRIOR_RES LOG_MODE CHECKPOINT ARCHIVE_CH CONTROL CONTROLFI CONTROLFIL CONTROLFIL CONTROLFI OPEN_RESETL VERSION_T OPEN_MODE
    ---------- --------- --------- ---------- --------- ---------- --------- ------------ ---------- ---------- ------- --------- ---------- ---------- --------- ----------- --------- ----------
    609588797 RTCCS 04-MAY-01 45159261 24-OCT-01 1 04-MAY-01 ARCHIVELOG 46180744 45979033 CURRENT 04-MAY-01 211246 46262364 31-OCT-01 NOT ALLOWED 24-OCT-01 READ WRITE
    1 row selected.
    SVRMGR>
    Any idea ? I did not have any problem before with this Db.

  2. #2
    Join Date
    Dec 1999
    Location
    Cincinnati, Ohio USA
    Posts
    99
    Can you post your listener.ora and tnsnames.ora?
    Doug

  3. #3
    Join Date
    Nov 2001
    Location
    Chicago
    Posts
    5
    Listener

    RTCCS =
    (ADDRESS_LIST =
    (ADDRESS= (PROTOCOL= IPC)(KEY= EXTPROCRTCCS))
    (ADDRESS= (PROTOCOL= TCP)(Host= nyunix-test01)(Port= 1526))
    )

    SID_LIST_RTCCS =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME= RTCCS)
    (ORACLE_HOME= /u02/software/oracle/ora816)
    (SID_NAME = rtccs)
    )
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /u02/software/oracle/ora816)
    (PROGRAM = extproc)
    )
    )

    STARTUP_WAIT_TIME_RTCCS = 0
    CONNECT_TIMEOUT_RTCCS = 10
    TRACE_LEVEL_RTCCS = OFF

    LOG_DIRECTORY_RTCCS = /u02/software/oracle/ora816/network/admin
    LOG_FILE_RTCCS = RTCCS
    TRACE_DIRECTORY_RTCCS = /u02/software/oracle/ora816/network/admin
    TRACE_FILE_RTCCS = RTCCS

    I've used port 1521 before. same problem


    TNSNAMES

    rtccspr =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = nyunix-test01)(PORT = 1526))
    )
    (CONNECT_DATA =
    (SID=rtccs)
    )
    )

    But, to connect to oracle from SVRMGRL oracle uses default connection entry.

    This from trace file.
    niotns: niotns: setting up interrupt handler...
    niotns: Not trying to enable dead connection detection.
    niotns: Calling address: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/u02/software/oracle/ora816/bin/oracle)(ARGV0=oraclert
    ccs)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRA M=)(HOST=nyunix-test01)(
    USER=oracle))))
    nscall: entry

    I've done rename RTCCS.lsr and tnsnames.ora files and I started my DB with differen SID withou any problem.

    SVRMGR> connect internal
    Connected.
    SVRMGR> startup pfile=initRTCCS.ora
    ORACLE instance started.
    Total System Global Area 449658560 bytes
    Fixed Size 69312 bytes
    Variable Size 325644288 bytes
    Database Buffers 122880000 bytes
    Redo Buffers 1064960 bytes
    Database mounted.
    Database opened.
    SVRMGR> exit
    Server Manager complete.



  4. #4
    Join Date
    Jun 2000
    Location
    Chennai/India
    Posts
    90
    Hi,
    I anticipate the problem is because of your tnsnames.ora contains rtccs in lower caps instead of caps, may be because of that.
    A Winner never Quits, A Quitter never Wins
    Ganesh .R

  5. #5
    Join Date
    Nov 2001
    Location
    Chicago
    Posts
    5
    No. Problem is that I CAN NOT start SVRMGRL. It dos not use LISTENER.ora and TNSNAMES.ora at all. It uses internal protocol BSQ and @ORACLE_HOME/bin/oracle programm.

  6. #6
    Join Date
    Jun 2000
    Posts
    179

    Talking

    check you sqlnet.ora , you may have a problem with security
    Hisham Nagia
    IT Manager For Development
    Oracle Consultant - OCP

  7. #7
    Join Date
    Nov 2001
    Location
    Chicago
    Posts
    5
    Here you can see my sqlnet.ora. Nothing is special.
    # SQLNET.ORA Configuration File:/u02/software/oracle/ora816/network/admin/sqlnet.ora
    # Generated by Oracle configuration tools.

    #NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
    TRACE_FILE = /u02/software/oracle/ora816/network/admin/sqlnet.trc
    TRACE_DIRECTORY = /u02/software/oracle/ora816/network/admin
    trace_unique_client=true
    trace_level_client=16

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width