To Pak Dedi, Saya coba bantu ya
TA1= (DESCRIPTION = (ADDRESS_LIST= (ADDRESS = (PROTOCOL =TCP)(HOST = 10.14.13.121)(PORT=1521)) ) (CONNECT_DATA = (SID=ta1) --> coba dibagian diganti dengan (SERVICE_NAME=ta1) ) ) Selamat mencoba, Ali Imran PT. REASURANSI NASIONAL INDONESIA CIKINI RAYA 99 JAKARTA 10330 62-021-3140009 EXT.114 0817 013 6608 http://aliimranblog.wordpress.com -----Original Message----- From: dedi humaedi <[email protected]> To: indo-oracle <[email protected]> Date: Sun, 5 Sep 2010 22:58:12 +0700 Subject: [indo-oracle] Tanya TNS buat DBLINK > 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 >
