473,513 Members | 2,266 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

integerated heterogeneous database(Mysql and oracle)

2 New Member
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"@link2db;
select * from "ss"@link2db
*
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)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

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

ORACLR_CONNECTION_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=TSTLINK)
(SERVER=DEDICATED)
)
(HS=OK)
)

my listener.ora

SID_LIST_LISTENER =
(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_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = tst)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
(PROGRAM = dg4odbc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = SWARNALATHA)(PORT = 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.AUTHENTICATION_SERVICES = (NTS)

NAMES.DIRECTORY_PATH=(TNSNAMES,EZCONNECT)


Plzzz help me
Thanks in advance
Mar 29 '17 #1
1 4242
swarnalath
2 New Member
Plzzz help me as soon as possible
Mar 30 '17 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
2138
by: Shawn Spiars | last post by:
dbWidget is a heterogeneous database development tool. It works with most relational databases, including Oracle, SQL Server, MySQL, and Sybase. dbWidget comes with a free, fully functional 30-day...
1
2549
by: Eric de Redelijkheid | last post by:
I am trying to establish a database link to a MS SQL server on an Oracle database. I am almost there, but there is one file missing: the heterogeneous services ODBC agent: hsodbc. It does not...
11
4493
by: Sudhesh Nayak | last post by:
Hi, I have an Oracle (8.1) & a SQL Server 2000 database with Production data. There are situations when I need data from both the databases. My first choice was to link Oracle to SQL and run DTS...
3
7164
by: Gianfranco Poli | last post by:
I need to insert row in a sybase's table from Oracle. Sybase is on a Unix machie and Oracle is on a Win2000Server o the same network. I tried with Transparent gateway but nothig, I have problem to...
6
3091
by: shaun.mostashari | last post by:
Hello all, I am curious to know if anyone has done a trade study on DB2, SQL Server, and Oracle databases. Basically I am trying to identify which one to chose based on "Ease of implementation",...
10
3492
by: Andrea M. Segovia | last post by:
Hello, I am a newbie to Oracle databases.... We have a visualization front-end tool connected to an Oracle back-end database on a Tru64 UNIX server. We also have clients with MS access...
0
1991
by: sandeepl | last post by:
Hi i am trying to connect a Ms access database from Oracle 8i. but getting following error. Pls help me in the same.. ERROR at line 1: ORA-28500: connection from ORACLE to a non-Oracle [ODBC...
19
4008
by: Gregor =?UTF-8?B?S292YcSN?= | last post by:
Hi! I'm using DB2 database on one server and ORACLE database on the second one. I want to move some data from ORACLE database to DB2 database and update some columns on ORACLE database so I know...
2
14208
by: Vinod Sadanandan | last post by:
All, Below listed are the new features in Oracle 11g ,please join me in this discussion to generate a testcase and analyze each of the listed features . Precompilers:...
1
2535
by: Chris Hohmann | last post by:
"Mujahid" <mujahid@iqura.netwrote in message news:OuhAYozFAHA.271@cppssbbsa04... me Oracle Database Utilities (Data Pump/SQL Loader) http://otn.oracle.com/products/database/utilities/index.html...
0
7265
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7171
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7388
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7539
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
1
5095
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
3240
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3228
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
807
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
461
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.