Tengo dos maquinas virtuales ...
1. Un Linux 7 con una base de datos Oracle 12c con la siguiente configuracion ...
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = OracleDB)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) )
================================================================
SQLNET
================================================================
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
================================================================
TNSNAMES
================================================================
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = OracleDB)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)))
================================================================
2. Por otro lado tengo otra VM en este caso con Windows 8.1 en el cual tengo instalado
un cliente 11gR2 con la siguiente configuración ...
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = OracleDB)(PORT = 1521)))
(DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))))
SID_LIST_LSN_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = C:\App\Oracle11gCliente\product\11.2.0\client_1)
(SID_NAME = ORCL)))
================================================================
TNSNAMES
================================================================
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = OracleDB)(PORT = 1521)))
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = ORCL)
(INSTANCE_NAME = ORCL)))
================================================================
Ahora bien, teniendo la base de datos online y el LISTENER activo, cuando quiero conectar desde Windows, el resultado es el siguiente ...
C:\>lsnrctl start
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 24-ABR-2015 13:18:31
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Iniciando tnslsnr: espere...
TNS-12560: TNS:error del adaptador de protocolo
TNS-00530: Error del adaptador de protocolo
C:\>tnsping ORCL
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 24-ABR-2015 13:19:27
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Archivos de parametros utilizados:
C:\App\Oracle11gCliente\product\11.2.0\client_1\NETWORK\ADMIN\sqlnet.ora
Adaptador TNSNAMES utilizado para resolver el alias
Intentando contactar con (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = OracleDB)(PORT = 1521))) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = ORCL) (INSTANCE_NAME = ORCL)))
TNS-12541: TNS:no hay ningun listener
Otros detalles ...
- Tengo declaradas las variables TNS_ADMIN, ORACLE_SID y ORACLE_HOME.
- El servicio LISTENER OracleOraClient11g_home1TNSListener; no inica por el error 3 diciendo que
El sistema no puede encontrar la ruta especificada
NO SE EN DONDE MAS MIRAR !!!!
- Versión para impresión
- Inicie sesión o registrese para enviar comentarios
Si te he entendido bien,
Subido por Carlos el 27 Abril, 2015 - 09:26