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
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
Comment