saya coba googling oracle HS dan menemukan, kemudian saya ikuti step-by-stpe nya, setelah saya coba ada error di TNS nya saat saya lakukan select, untuk informasi mysql server yang saya gunakan masih versi 3 dan oracle 10 G running di windows XP. nama DNS mysql nya 'buku_mysql' untuk database link nya saya buat spt ini : create database link bk_mysql using 'BK_MYSQL'; untuk configurasi initbk_mysql.ora sbb: HS_FDS_CONNECT_INFO = buku_mysql HS_DB_NAME = buku_mysql HS_FDS_TRACE_LEVEL = ON untuk listener nya : SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = C:\oracle\product\10.2.0\db_1) (PROGRAM = extproc) ) (SID_DESC= (PROGRAM = hsodbc) (SID_NAME = bk_mysql) (ORACLE_HOME = C:\oracle\product\10.2.0\db_1) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) (ADDRESS LIST = (ADDRESS = (PROTOCOL =TCP) (HOST=192.168.1.22) (PORT=1524)) ) ) ) dan untuk TNS nya : BUKU_MYSQL= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.22)(PORT = 1524)) ) (CONNECT_DATA = (SID = bk_mysql) ) (HS=OK) ) ada kesalahan dimana ya ?? tolong pencerahannya. thx
--- On Wed, 26/11/08, bukhari yahya <[EMAIL PROTECTED]> wrote: From: bukhari yahya <[EMAIL PROTECTED]> Subject: Re: [indo-oracle] koneksi oracle ke Mysql To: [email protected] Date: Wednesday, 26 November, 2008, 10:29 AM pakai HS On 11/26/08, musisi musisi <tc2681_2006@ yahoo.com. sg> wrote: > > dear master, > > ada yang pernah sukses melakukan koneksi dari oracle ke MySQL server, klo > ada sharing dong, apa aja yang dipersiapkan and langkah apa yang harus > dilakukan. > > Thx > > New Email names for you! > Get the Email name you've always wanted on the new @ymail and > @rocketmail. > Hurry before someone else does! > http://mail. promotions. yahoo.com/ newdomains/ sg/ > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] New Email names for you! Get the Email name you've always wanted on the new @ymail and @rocketmail. Hurry before someone else does! http://mail.promotions.yahoo.com/newdomains/sg/ [Non-text portions of this message have been removed]
