This discussion is archived
1 2 Previous Next 24 Replies Latest reply: Nov 7, 2012 11:54 PM by kgronau Go to original post RSS
  • 15. Re: SP2-0640: Not connected -- Create database link error Gateway
    mkirtley-Oracle Expert
    Currently Being Moderated
    Hi,
    In initdg4msql.ora you have -

    HS_FDS_CONNECT_INFO=sqlserverip,port//PMDB

    but do you get an error with the format -

    HS_FDS_CONNECT_INFO=sqlserverip:port//PMDB

    I assume in the file on your system you have put in the actual IP address and port number ?
    If you still have problems could you set up gateway 255 level tracing -
    HS_FDS_TRACE_LEVEL=255
    and selelct from a new SQLPLUS session.
    Either post the trace to somewhere off site we can view it or post any obvious looking errors in the thread if the complete file is too large to post here.

    This note available in My Oracle Support has more setup details -
    How to Configure DG4MSQL (Database Gateway for MS SQL Server) on Windows 32bit post install (Doc ID 466267.1)

    Regards,
    Mike
  • 16. Re: SP2-0640: Not connected -- Create database link error Gateway
    kgronau Guru
    Currently Being Moderated
    ORA-28545 is a configuration issue - what has changes as above it was already working?

    You also only mentioned that the listener service summary shows a service, but to diagnose I need the full listener status output. Could you please post it (lsnrctl status)?
  • 17. Re: SP2-0640: Not connected -- Create database link error Gateway
    887834 Newbie
    Currently Being Moderated
    please find the lsnrctl status output below:


    Connessione a (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.176.111.127)(PORT=152
    1)))
    STATO del LISTENER
    ------------------------
    Alias LISTENER
    Versione TNSLSNR for 64-bit Windows: Version 11.2.0.2.0 - Produ
    ction
    Data di inizio 08-NOV-2012 06:08:42
    Tempo di attivitÓ 0 giorni 0 ore 0 min. 9 sec.
    Livello trace off
    Sicurezza ON: Local OS Authentication
    SNMP OFF
    File di parametri listenerC:\product\11.2.0\tg_1\network\admin\listener.ora
    File di log listener C:\product\11.2.0\tg_1\diag\tnslsnr\w2k8r2it-lk03\list
    ener\alert\log.xml
    Summary table degli endpoint di ascolto...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.176.111.127)(PORT=1521)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
    Summary table dei servizi...
    Il servizio "dg4msql" ha 1 istanze.
    L'istanza "dg4msql", stato UNKNOWN, ha 1 handler per questo servizio...
    Il comando Þ stato eseguito

    Above changes couldn't help me in resolving the issue.
  • 18. Re: SP2-0640: Not connected -- Create database link error Gateway
    kgronau Guru
    Currently Being Moderated
    Looks good - could you please provide the output of calling the following command in a Dos command line window:
    C:\product\11.2.0\tg_1\bin\dg4msql
  • 19. Re: SP2-0640: Not connected -- Create database link error Gateway
    887834 Newbie
    Currently Being Moderated
    Here is it

    C:\product\11.2.0\tg_1\BIN>dg4msql.exe


    Oracle Corporation --- GIOVEDâ•  NOV 08 2012 06:51:20.156

    Heterogeneous Agent Release 11.2.0.2.0 - 64bit Production Built with
    Oracle Database Gateway for MSSQL
  • 20. Re: SP2-0640: Not connected -- Create database link error Gateway
    kgronau Guru
    Currently Being Moderated
    The tns alias dg4msql you posted above as your tnsnames.ora entry, is that the tns entry from the gateway or from the database home?

    The reason why I'm asking is, that the tnsping output you posted earlier:
    output of tnsping

    Parameter file used:
    C: \ product \ 11.2.0 \ tg_1 \ network \ admin \ sqlnet.ora

    was used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 10.176.111.127) (PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = dg4msql)) (HS = OK))
    OK (20 msec)

    indicates you tested the tnsping from the gateway home (C: \ product \ 11.2.0 \ tg_1). But as the Oracle database is calling the gateway listener, you have to test the tnsping from the Oracle database home. Could you please clarify if C: \ product \ 11.2.0 \ tg_1 also contains an Oracle database and if not, please call tnsping from the <Oracle database home>/bin directory.
  • 21. Re: SP2-0640: Not connected -- Create database link error Gateway
    887834 Newbie
    Currently Being Moderated
    There is only gateway installed on that machine. There is no oracle db installed.
    My oracle_home points to the oracle gateway home which is C: \ product \ 11.2.0 \ tg_1 \

    so, tnsping which i am using is from gateway home only
  • 22. Re: SP2-0640: Not connected -- Create database link error Gateway
    kgronau Guru
    Currently Being Moderated
    You're Oracle database can't connect to the gateway listener, so you need to check the connection from the Oracle database that causes the ORA-28545 error message when you try to use the gtaeway. On the machine with the Oracle database, please check with tnsping the gateway connectivity.
  • 23. Re: SP2-0640: Not connected -- Create database link error Gateway
    887834 Newbie
    Currently Being Moderated
    On the machine where oracle client is isntalled, i am able to connect to sql db through gateway. All the queries are getting executed. But, on Gateway machine, it is throwing error.

    Is there anything specific that i should do on gateway machine?
  • 24. Re: SP2-0640: Not connected -- Create database link error Gateway
    kgronau Guru
    Currently Being Moderated
    Please explain your last comment.
    The Oracle gateway can never be used directly - it always needs an Oracle database.
    Let me copy the posting from above:
    C:\Users\Administrator>sqlplus /nolog

    SQL*Plus: Release 11.2.0.2.0 Production on Mer Nov 7 13:11:35 2012

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

    SQL> conn system/Manager1@obiee
    Connesso.
    SQL> create public database link dblink connect to "sa" identified by "Manager1"
    using 'dg4msql';

    Creato database link.

    SQL> select count(*) from "prefer"@dblink;
    select count(*) from "prefer"@dblink
    *
    ERRORE alla riga 1:
    ORA-28545: errore diagnosticato da Net8 durante la connessione a un agente
    Unable to retrieve text of NETWORK/NCR message 65535
    ORA-02063: precedente 2 lines da DBLINK


    So you're here using a certain Oracle database, where is this database located (machine and Oracle_Home dircetory). In the OH of this Oracle database there's a network/admin directory and in this directory a tnsnames.ora file must exist which contains the tns alias dg4msql which refers to the gateway.
    So from this certain database home, please execute the tnsping using the gateway alias you defined in this database home for the gateway connection.
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points