create database link dblink connect to taremot identified by ta using (DESCRIPTION =
(ADDRESS_LIST= (ADDRESS = (PROTOCOL =TCP)(HOST = 10.14.13.121)(PORT=1521)) ) (CONNECT_DATA = (SID=ta1) ) ) coba itu dulu deh,bisa atau ga? kalau bisa,coba tnsping ke TA1.. apakah ok atau tidak Thanks, Caterin --- Pada Ming, 5/9/10, dedi humaedi <[email protected]> menulis: Dari: dedi humaedi <[email protected]> Judul: [indo-oracle] Tanya TNS buat DBLINK Kepada: "indo-oracle" <[email protected]> Tanggal: Minggu, 5 September, 2010, 10:58 PM Hallo semua, saya lagi jajal buat distributed db nih..Ok skrg ceritanya saya mau akses table di mesin lain (let say A). Di A ini saya buat user 'taremot' passwordnya 'ta' ipnya 10.14.13.121 nama databasenya+service= ta1 ada table mhs di tnsnames.ora mesin yang mau lakukan remote saya tambahkan kurang lebih seperti ini # tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools. TACO = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = tacoordinator)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = taco) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) #ini yang saya tambahkan TA1= (DESCRIPTION = (ADDRESS_LIST= (ADDRESS = (PROTOCOL =TCP)(HOST = 10.14.13.121)(PORT=1521)) ) (CONNECT_DATA = (SID=ta1) ) ) trus saya buat dblink sbb "create database link dblink connect to taremot identified by ta using TA1" dblinknya success.. problemnya ketika saya select * from m...@dblink gagal mulu error messagenya sbb "ORA-12154:TNS:could not resolve the connect identifier specified" mohon koreksinya jika ada yang salah dan tentu saja solusinya yaaa thx alot all -- Regards Dedi Caesar Humaedi [Non-text portions of this message have been removed]
