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
