integerated heterogeneous database(Mysql and oracle)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • swarnalath
    New Member
    • Mar 2017
    • 2

    integerated heterogeneous database(Mysql and oracle)

    i am able to create database link at oracle. but i am getting error as
    SQL> create public database link link2db connect to "swarna" identified by "root" using 'TSTLINK';

    Database link created.

    SQL> select * from "ss"@link2d b;
    select * from "ss"@link2d b
    *
    ERROR at line 1:
    ORA-28545: error diagnosed by Net8 when connecting to an agent
    Unable to retrieve text of NETWORK/NCR message 65535
    ORA-02063: preceding 2 lines from LINK2DB
    my tnsnames.ora

    XE =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = SWARNALATHA)(PO RT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = XE)
    )
    )

    EXTPROC_CONNECT ION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE) )
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

    ORACLR_CONNECTI ON_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE) )
    )
    (CONNECT_DATA =
    (SID = CLRExtProc)
    (PRESENTATION = RO)
    )
    )
    TSTLINK=
    (DESCRIPTION=
    (ADDRESS=
    (PROTOCOL=TCP)
    (HOST=LOCALHOST )
    (port=1521)
    )
    (CONNECT_DATA=
    (SID=tst)
    (SERVICE_NAME=T STLINK)
    (SERVER=DEDICAT ED)
    )
    (HS=OK)
    )

    my listener.ora

    SID_LIST_LISTEN ER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc
    (ORACLE_HOME = C:\oraclexe\app \oracle\product \10.2.0\server)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (SID_NAME = CLRExtProc)
    (ORACLE_HOME = C:\oraclexe\app \oracle\product \10.2.0\server)
    (PROGRAM = extproc
    )
    )

    SID_LIST_LISTEN ER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = tst)
    (ORACLE_HOME = C:\oraclexe\app \oracle\product \10.2.0\server)
    (PROGRAM = dg4odbc)
    )
    )

    LISTENER =
    (DESCRIPTION_LI ST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE) )
    (ADDRESS = (PROTOCOL = TCP)(HOST = SWARNALATHA)(PO RT = 1521))
    )
    )

    DEFAULT_SERVICE _LISTENER = (XE)



    my sqlnet.ora

    n# 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.AUTHENTI CATION_SERVICES = (NTS)

    NAMES.DIRECTORY _PATH=(TNSNAMES ,EZCONNECT)


    Plzzz help me
    Thanks in advance
  • swarnalath
    New Member
    • Mar 2017
    • 2

    #2
    Plzzz help me as soon as possible

    Comment

    Working...