Oracle Database Discussions

Oracle 11g r2- 64bits
Oracle Transparent Gateway - 64bits


Oracle > C:\app\admsetape\product\11.2.0\dbhome_1
Oracle Database Gateway for MS SQL Server (11.2.0.1.0) > C:\product\11.2.0\tg_1



****************************************************************************
*Configuration of file Listener.ora [gateway] >* : C:\product\11.2.0\tg_1\NETWORK\ADMIN

****************************************************************************
SID_LIST_LISTENERMSSQL =
(SID_LIST =
(SID_DESC =
(SID_NAME = dg4msql)
(ORACLE_HOME = C:\product\11.2.0\tg_1)
(PROGRAM = dg4msql)
)
)

LISTENERMSSQL =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = S015145.SETAPE.COM.BR)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
)
)






*******************************************************************************************
*Configuration of file Tnsnames.ora [oracle] >* : C:\app\admsetape\product\11.2.0\dbhome_1\NETWORK\ADMIN

*******************************************************************************************

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = S015145.SETAPE.COM.BR)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.SETAPE.COM.BR)
)
)


dg4msql=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = S015145.SETAPE.COM.BR)(PORT = 1522))
(CONNECT_DATA =
(SID=dg4msql)
)
(HS=OK)
)


************************************************************************
*Configuration of file initdg4msql.ora [Gateway] >* : C:\product\11.2.0\tg_1\dg4msql\admin

*************************************************************************
# This is a customized agent init file that contains the HS parameters
# that are needed for the Database Gateway for Microsoft SQL Server

#
# HS init parameters
#
HS_FDS_CONNECT_INFO=S015145.SETAPE.COM.BR//Teste
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER




*********************
Test file Tnsnames.ora

*********************

TNSPING ORCL

Microsoft Windows [versão 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. Todos os direitos reservados.

C:\Users\admsetape.SETAPE>TNSPING ORCL

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 18-DEZ-2
012 12:02:19

Copyright (c) 1997, 2010, Oracle. All rights reserved.

Arquivos de parÔmetros usados:
C:\app\admsetape\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 = S015145.
SETAPE.COM.BR)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME
= orcl.SETAPE.COM.BR)))
OK (0 ms)

C:\Users\admsetape.SETAPE>


TNSPING dg4msql

Microsoft Windows [versão 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. Todos os direitos reservados.

C:\Users\admsetape.SETAPE>TNSPING ORCL

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 18-DEZ-2
012 12:02:19

Copyright (c) 1997, 2010, Oracle. All rights reserved.

Arquivos de parÔmetros usados:
C:\app\admsetape\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 = S015145.
SETAPE.COM.BR)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME
= orcl.SETAPE.COM.BR)))
OK (0 ms)

C:\Users\admsetape.SETAPE>




Microsoft Windows [versão 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. Todos os direitos reservados.

C:\Users\admsetape.SETAPE>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Ter Dez 18 12:06:15 2012

Copyright (c) 1982, 2010, Oracle. All rights reserved.


********************************
Test DBLINK >

create public database link DBLINK
connect to SA identified by admsetape
* using 'dg4msql'*

*******************************

Conected :
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production

SQL> SELECT
2 * FROM x@DBLINK;
* FROM x@DBLINK
*
ERRO na linha 2:
ORA-28545: erro diagnosticado pelo Net8 ao conectar com um agente
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: precedendo 2 lines a partir de DBLINK



SQL>