Maap p'Agus..mudah2an membantu : Sebelum membuat database link sebaiknya buat dulu aliasname dari database target di tnsnames.ora, kemudian test koneksinya dengan menggunakan fasilitas tnsping, setelah oke baru buat database linknya. Dan pastikan pengunaan aliasname yang benar-benar sesuai antara yang 'terdaftar' di tnsnames.ora dan pada saat pembuatan database link (...using '....').
ps : Setau saya command database link creation tidak melakukan validasi apapun ( aliasname,user ataupun password ). Hatur Nuhun, -One- --- In [email protected], "Anang Rahmadyan" <[EMAIL PROTECTED]> wrote: > > Pada database yang ada database linknknya masuk ke server manager > SVRMGRL>Connect system/manager > SVRMGRL>Alter system set GLOBAL_NAMES=FALSE > > atau jika anda rela untuk shutdown database > cari di InitSID.Ora anda GLOBAL_NAMES=FALSE > ----- Original Message ----- > From: agus sulaiman > To: [email protected] > Sent: 16 February 2006 22:20 > Subject: [indo-oracle] DATABASE LINK (ORACLE DATABASE VERSI 8.05) > > > Kepada teman-teman semuanya , > Saya telah membuat database link sebagai berikut diserver a: > sql> connect scott/[EMAIL PROTECTED]; > sql> create database link SCOTT_LINK.world > connect to scott identified by tiger > using 'SCOTT_SERVICE'; > database link created > > kemudian saya tambahkan pada folder net80/admin/TNSNAMES > SCOTT_SERVICE.world = > (description = > ( address = (protocol = tcp) > (host = serverb) > (port = 1521) > ) > ( connect_data = (sid=orcl)) > ) > setelah ini saya melakukan > sql> connect scott/[EMAIL PROTECTED]; > sql> select count(*) from [EMAIL PROTECTED]; > ERROR AT LINE 1: > ORA-02085 : DATABASE LINK SKA_LINK.WORLD CONNECTS TO ORACLE.WORLD > > PERTANYAANYA ADALAH ERROR TERSEBUT MAKSUDNYA APA DAN KESALAHANNYA > ADA DIMANA YA ? > MUNGKIN TEMEN-TEMEN PERNAH MENGALAMI ERROR SEPERTI INI ? > > THANKS, > AGUS SULAIMAN > > > > --------------------------------- > Yahoo! Autos. Looking for a sweet ride? Get pricing, reviews, & more on new and used cars. > > [Non-text portions of this message have been removed] > > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED] > Website: http://indo-oracle.lizt.org (NEW) > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.vze.com > > > > SPONSORED LINKS Membership database software Database mortgage software Pda database software > Database management software Oracle database administration Oracle database management > > > -------------------------------------------------------------------- ---------- > YAHOO! GROUPS LINKS > > a.. Visit your group "indo-oracle" on the web. > > b.. To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > -------------------------------------------------------------------- ---------- > > > > > -------------------------------------------------------------------- ---------- > > > =================================================== > > This Mail Scanned By Messaging Security Suite > > ================= Provided by IT Hardware ================= > > > [Non-text portions of this message have been removed] > -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.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/
