Error DBLINK entre Oracle enterprise y oracle XE
Publicado por Daniel Rodas (1 intervención) el 16/07/2020 21:37:46
Saludos
Mi problema es el siguiente
Tengo una base de datos de producción con Oracle Enterprise 11G R2 en un servidor como tal, y otra Oracle XE tambien 11g R2 en mi laptop.
En mi oracle enterprise cree el siguiente DBLINK:
CREATE PUBLIC DATABASE LINK XEDB
CONNECT TO ADMINISTRATOR
IDENTIFIED BY <PWD>
USING '(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.12)(PORT = 1521)) (CONNECT_DATA = (SID = XE)))';
Originalmente lo habia creado de tal forma que en el parametro HOST le habia puesto el nombre de mi laptop, pensando que ese era el problema.
El error que me presenta al darle test es el siguiente:
*********************************************************************
Link : "XEDB"
Error : ORA-12170: TNS:Se ha producido un timeout de conexión
*********************************************************************
La base de XE está levantada y corriendo, lo compruebe porque entro por SQL Plus de XE y sin problemas.
El resultado de lsnrctl status es:
C:\oraclexe\app\oracle\product\11.2.0\server\bin>lsnrctl status
LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 16-JUL-2020 13:35
:17
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.2.0 - Produ
ction
Start Date 15-JUL-2020 07:22:21
Uptime 1 days 6 hr. 12 min. 57 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\oraclexe\app\oracle\product\11.2.0\server\network\a
dmin\listener.ora
Listener Log File C:\oraclexe\app\oracle\diag\tnslsnr\MIXRODASDA0001\lis
tener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MIXRODASDA0001.sa.avonet.net)(PORT=1
521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MIXRODASDA0001.sa.avonet.net)(PORT=8
080))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Service "xe" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
The command completed successfully
C:\oraclexe\app\oracle\product\11.2.0\server\bin>
¿Alguna idea?
Gracias
Mi problema es el siguiente
Tengo una base de datos de producción con Oracle Enterprise 11G R2 en un servidor como tal, y otra Oracle XE tambien 11g R2 en mi laptop.
En mi oracle enterprise cree el siguiente DBLINK:
CREATE PUBLIC DATABASE LINK XEDB
CONNECT TO ADMINISTRATOR
IDENTIFIED BY <PWD>
USING '(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.12)(PORT = 1521)) (CONNECT_DATA = (SID = XE)))';
Originalmente lo habia creado de tal forma que en el parametro HOST le habia puesto el nombre de mi laptop, pensando que ese era el problema.
El error que me presenta al darle test es el siguiente:
*********************************************************************
Link : "XEDB"
Error : ORA-12170: TNS:Se ha producido un timeout de conexión
*********************************************************************
La base de XE está levantada y corriendo, lo compruebe porque entro por SQL Plus de XE y sin problemas.
El resultado de lsnrctl status es:
C:\oraclexe\app\oracle\product\11.2.0\server\bin>lsnrctl status
LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 16-JUL-2020 13:35
:17
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.2.0 - Produ
ction
Start Date 15-JUL-2020 07:22:21
Uptime 1 days 6 hr. 12 min. 57 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\oraclexe\app\oracle\product\11.2.0\server\network\a
dmin\listener.ora
Listener Log File C:\oraclexe\app\oracle\diag\tnslsnr\MIXRODASDA0001\lis
tener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MIXRODASDA0001.sa.avonet.net)(PORT=1
521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MIXRODASDA0001.sa.avonet.net)(PORT=8
080))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Service "xe" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
The command completed successfully
C:\oraclexe\app\oracle\product\11.2.0\server\bin>
¿Alguna idea?
Gracias
Valora esta pregunta
0