| TNSPing anwsers ok but sqlplus can't connect [message #189943] |
Mon, 28 August 2006 12:39  |
mauricio@tecnologica
Messages: 4
Registered: August 2006
|
Junior Member |
|
|
Hello List,
this strange behavior is happening on a Windows Server 2003 Standard Edition running an Oracle 9iR2 (9.2.0.5) version. The name of the instance (quality9) is also the name of the tns string. When it is issued a tnsping quality9, it returns ok:
---------
C:\Documents and Settings\Administrador.BTRS0041>tnsping quality9
TNS Ping Utility for 32-bit Windows: Version 9.2.0.5.0 - Production on 28-AGO-20
06 14:23:43
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Arquivos de parÔmetros usados:
Usado o adaptador TNSNAMES para resolver o apelido
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = btrs0041)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = QUALITY9)))
OK (20 ms)
----------
Now, when it is issued an sqlplus user/pass@quality9, it returns an error:
----------
C:\Documents and Settings\Administrador.BTRS0041>sqlplus system/XXXXXXX@quality9
SQL*Plus: Release 9.2.0.5.0 - Production on Seg Ago 28 14:34:48 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-12514: TNS:listener nÒo p¶de resolver o SERVICE NAME fornecido no descritor
de conexÒo
Informe o nome do usußrio:
-------------
For other client applications as dba studio, the same happens. The file sqlnet.ora was moved to sqlnet.ora.bk in order not to be used but it did not help. Also commenting its unique parameter, SQLNET.AUTHENTICATION_SERVICES = (NTS), did not help. Tried, as a third workaround, create a regedit value USE_SHARED_SOCKETS=TRUE but again the same.
Can you help me? Thanks in advance. Mauricio.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
