Coba test koneksi dblink via OEM kalo sudah sip? berarti masalahnya bukan di
dblink
kalo dblinknya gak connect coba setting NET MANAGENYA khususnya service
naming. mungkin bisa via Net Manager. pengalaman saya, harus hati2 dalam
mendefinisikan setiap parameter2nya.
good luck bro
henriap <[EMAIL PROTECTED]> wrote:
dear tjhondro
Di server database cek dulu tnsnams nya udah ada atau belom.
kalau udah ada cek pake tnsping (db name alias)
database link nya sudah di buat belom mas..
coba cek database link nya
ok
----- Original Message -----
From: "cyuniart" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Monday, June 19, 2006 8:28 PM
Subject: [indo-oracle] help me - connection database for remote database not
found
> Dear all,
> Mohon bantuannya,
>
> ada 3 DB (X, Y, Z)
>
> dari user A di DB X dgn memakai dblink saya membuat view 'test_v'
> untuk tabel yang ada di DB Y dan view 'test2_v' untuk tabel di DB Z.
>
> ketika saya coba insert dari user B(X)
>
> insert into test_v
> select * from test2_v
>
> muncul error
>
> ORA-02019: connection description for remote database not found
> ORA-02063: preceding line from X
> ORA-02063: preceding 2 lines from Z
>
> tapi saat perintah itu dijalankan di user A (X), ternyata sukses.
> padahal synonym dan grant yg diperlukan oleh B(X) sudah diberikan.
>
> mohon bantuannya,
> o ya, saya memakai oracle 10g rilis 1.
>
> Thx sebelumnya,
> tjhondro
>
>
>
>
>
>
> --
> -----------I.N.D.O - O.R.A.C.L.E---------------
> Keluar: [EMAIL PROTECTED]
> Website: http://indo-oracle.blogspot.com
> Mirror: http://indooracle.wordpress.com
> -----------------------------------------------
>
> Bergabung dengan Indonesia Thin Client User Groups,
> Terminal Server, Citrix, New Moon Caneveral, di:
> http://indo-thin.blogspot.com
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
---------------------------------
Yahoo! Sports Fantasy Football 06 - Go with the leader. Start your league
today!
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
See what's inside the new Yahoo! Groups email.
http://us.click.yahoo.com/2pRQfA/bOaOAA/yQLSAA/PhFolB/TM
--------------------------------------------------------------------~->
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
Mirror: http://indooracle.wordpress.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.blogspot.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
