-
TNS-12560: TNS:protocol adapter error
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
-
-
I have set ORACLE_SID=STAT
sure, I have set ORACLE_SID=STAT
but problem still persists
-
Why do tou need to run SVRMGRL? You can use SQLPLUS instead at 8i
-
Hi,
Please check whether you have started the windows nt OS services for the appropriate ORACLE_SIDs.
Rgds,
K.S.Venkatesh
-
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?
Last edited by Thomasps; 07-14-2004 at 07:48 AM.
-
Re: TNS-12560: TNS:protocol adapter error
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|