Estou enfrentando problemas de conexão após retirar servidor de banco de dados do dominio.
Efetuei alterações no arquivos de rede, porem não surtiu efeito esperado.
Tentei algumas soluçoes apresentadas em outros topicos, porem não obtive sucesso.
SQL> conn sys/pppppppp@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = V000
0857)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = orcl)) )
ORA-12514: TNS:listener nÒo tem conhecimento sobre o serviþo
O mais estranho é que faço TNSPING com sucesso:
C:\Windows\system32>tnsping orcl
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 11-OUT-2
016 17:30:02
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Arquivos de parÔmetros usados:
C:\app\x173576\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
Usado o adaptador TNSNAMES para resolver o apelido
Tentativa de contatar (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = V0000857
)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCL)))
OK (10 ms)
Abaixo configurações:
LISTERNER
# listener.ora Network Configuration File: C:\app\x173576\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\x173576\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\x173576\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = V0000857)(PORT = 1521))
)
)
ADR_BASE_LISTENER = C:\app\x173576
TNSNAMES
# tnsnames.ora Network Configuration File: C:\app\x173576\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = V0000857)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
)
)
# sqlnet.ora Network Configuration File: C:\app\x173576\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES= (NONE)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)