TNS-12560: TNS:protocol adapter error

[Russtem]

Please help,

I have 8.1.7.4.1

I run sqlplusw from server without any problems, but if I launch svrmgrl from cmd on server - error occurs:

TNS-12560: TNSrotocol adapter error

What can be wrong???

all my oracle details see below:





tnsnames.ora:

STAT.EUR.NSROOT.NET =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = alacmesd002)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = stat)
)
)

INST1_HTTP.EUR.NSROOT.NET =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = alacmesd002)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://admin)
)
)


sqlnet.ora:

NAMES.DEFAULT_DOMAIN = eur.nsroot.net

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)




sqlnet.log

***********************************************************************
Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oraclestat)(ARGS='(DESCRIPTION=(LOCAL=YES )(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=stat)(CID=(PROGRAM=C:\oracle\ora81\bin\svrmgrl.exe)( HOST=ALACMESD002)(USER=Administrator))))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.1.7.4.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.7.4.0 - Production
Time: 14-JUL-2004 01:46:04
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12560
TNS-12560: TNSrotocol adapter error
ns secondary err code: 0
nt main err code: 530
TNS-00530: Protocol adapter error
nt secondary err code: 2
nt OS err code: 0

[Thomasps]

SET ORACLE_SID ???

[Russtem]

sure, I have set ORACLE_SID=STAT
but problem still persists

[fraze]

Why do tou need to run SVRMGRL? You can use SQLPLUS instead at 8i

[ksvenkatesh]

Hi,

Please check whether you have started the windows nt OS services for the appropriate ORACLE_SIDs.

Rgds,
K.S.Venkatesh

[Thomasps]

Originally posted by ksvenkatesh
Hi,

Please check whether you have started the windows nt OS services for the appropriate ORACLE_SIDs.

Rgds,
K.S.Venkatesh

oops... SQLPLUSW will connect without starting the services?

[reydp]

Originally posted by Russtem
Please help,

I have 8.1.7.4.1

I run sqlplusw from server without any problems, but if I launch svrmgrl from cmd on server - error occurs:

TNS-12560: TNSrotocol adapter error

What can be wrong???
nt OS err code: 0

This could be one of the reason why svrmgrl becomes obsolete in 9i
and the use of sqlplus was advised.

sqlplus /nolog
SQL>connect sys/syspass as sysdba
or
equivalent