TNS:packet writer failure

[aaf207]

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.

[molonede]

Can you post your listener.ora and tnsnames.ora?

[aaf207]

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.

[aarganesh]

Hi,
I anticipate the problem is because of your tnsnames.ora contains rtccs in lower caps instead of caps, may be because of that.

[aaf207]

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.

[hnagia]

check you sqlnet.ora , you may have a problem with security

[aaf207]

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