Thx all skrg sudah bisa. Entah lupa diapain. Kyknya kalau gak salah tambahin script di listener 10g nya
-GnC-® -----Original Message----- From: gugukerz <[email protected]> Sender: [email protected] Date: Wed, 14 Jul 2010 14:17:38 To: <[email protected]> Reply-To: [email protected] Subject: Re: Bls: [indo-oracle] Dblink 10G dan 9i errornya apa dulu? baru bisa tau apa yang di cek 2010/7/12 <[email protected]> > > > Tapi create dblink tetap tidak bisa. Maksudnya proses pembuatan initial > dblink bisa, tpi begitu menjalankan > > Select * from d...@dblink9i > > Error. > > Ada hal lain yg harus saya cek tidak? > > -GnC-® > > > -----Original Message----- > From: Faridh Wisanggeni > <[email protected]<faridh_wisanggeni%40yahoo.com>> > > Sender: [email protected] <indo-oracle%40yahoogroups.com> > Date: Mon, 12 Jul 2010 17:57:29 > To: <[email protected] <indo-oracle%40yahoogroups.com>> > Reply-To: [email protected] <indo-oracle%40yahoogroups.com> > Subject: Bls: [indo-oracle] Dblink 10G dan 9i > > kalau port bolehlah, itu tergantung dari networking yang ada. > > > > > >________________________________ > Dari: Gunawan Cahyadi <[email protected] <gcahyadi%40gmail.com>> > Kepada: [email protected] <indo-oracle%40yahoogroups.com> > Terkirim: Sen, 12 Juli, 2010 09:53:06 > Judul: Re: [indo-oracle] Dblink 10G dan 9i > > > thx mr faridh, > > untuk masalah ping sudah tidak ada masalah. saya bisa connect terpisah ke > dua database 9i(server) dan 10g (local) > > mau tanya untuk port apakah boleh berbeda? 1522 dan 1521 ? > > kalau tidak boleh, bagaimana cara mengubah port numbernya ya? > > thx in advance > > regards, > GnC > > 2010/7/12 Faridh Wisanggeni > <[email protected]<faridh_wisanggeni%40yahoo.com>> > > > > > > > > untuk connection_string itu maksudnya TNS yang kamu buat di oracle > > lokasinya tergantung kamu installnya > > contoh sederhana misalkan > > D:\DevSuiteHome_1\NETWORK\ADMIN > > di folder tersebut sudah ada TNSNAMES.ORA > > > > yang berisi connection seperti : > > > > MFIN_DBASE = > > (DESCRIPTION = > > (ADDRESS_LIST = > > (ADDRESS = > > (PROTOCOL = TCP) > > (HOST = 172.17.17.252) > > (PORT = 1521) > > ) > > ) > > (CONNECT_DATA = > > (SERVICE_NAME = dbfsystem) > > ) > > ) > > > > kamu harus sesuaikan dahulu TNS kamu dengan > > server 9i, baik SERVICE_NAME dan HOSTnya > > apakah statuskan ketika di PING sudah OK? > > > > nah untuk home yang berbeda misalkan > > > > ----------------------------------------------------- > > MFIN_APP = > > (DESCRIPTION = > > (ADDRESS_LIST = > > (ADDRESS = > > (PROTOCOL = TCP) > > (HOST = 182.15.15.200) > > (PORT = 1521) > > ) > > ) > > (CONNECT_DATA = > > (SERVICE_NAME = ORCL) > > ) > > ) > > > > ---------------------------------------------------------- > > > > MFIN_DBASE = > > (DESCRIPTION = > > (ADDRESS_LIST = > > (ADDRESS = > > (PROTOCOL = TCP) > > (HOST = 182.15.15.201) > > (PORT = 1521) > > ) > > ) > > (CONNECT_DATA = > > (SERVICE_NAME = dbfsystem) > > ) > > ) > > > > MFIN_APP (saya gunakan untuk server applikasi) > > MFIN_DBASE (saya gunakan untuk server database) > > dengan HOST dan SERVICE_NAME yang berbeda > > > > nah kalau contoh DBLINKnya > > > > CREATE DATABASE LINK "TESTING.................................." > > CONNECT TO MIS > > IDENTIFIED BY <PWD> > > USING 'MFIN_DBASE > > > > pengalaman saya sederhananya seperti itu > > > > ' > > > >________________________________ > > Dari: Gunawan Cahyadi <[email protected] <gcahyadi%40gmail.com><gcahyadi% > 40gmail.com>> > > Kepada: [email protected] > > <indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com> > > Terkirim: Jum, 9 Juli, 2010 19:35:10 > > Judul: RE: [indo-oracle] Dblink 10G dan 9i > > > > > > Mr.fahmi thx lagi.. > > > > Sudah bisa skrg, > > > > Tapi masalahnya tidak bisa buat dblink. Saya curiga karena tidak di > > identify > > home oracle 9i. > > > > Nah untuk connection_string bisa kasih contoh seperti apa untuk home yang > > > berbeda.? > > > > Regards, > > > > GnC > > > >_____ > > > > From: [email protected] > > <indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com> [mailto: > > [email protected] <indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com>] On > > Behalf Of Fahmi > > Sent: Friday, July 09, 2010 9:34 PM > > To: [email protected] <indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com> > > Subject: Re: [indo-oracle] Dblink 10G dan 9i > > > > sudah coba : tnsping <connection_string_9i>? > > > > On Fri, Jul 9, 2010 at 7:44 AM, > > <[email protected]<gcahyadi%40gmail.com><gcahyadi% > 40gmail.com> > > <mailto:gcahyadi%40gmail.com <gcahyadi%2540gmail.com> <gcahyadi% > 2540gmail.com>> > wrote: > > > > > Mr fahmi. Thanx a lot. > > > > > > Saya install 10g di pc, lalu pakai toad, saya coba konek ke 9i yang di > > > server kenapa tdk bisa ya? Sudah saya add tns names yg di server. > > Tulisnya > > > unable resolve host. > > > > > > > > > -GnC-R > > > > > > > > > > > -----Original Message----- > > > From: Fahmi <[email protected] <ffahlevi%40gmail.com> <ffahlevi% > 40gmail.com> <mailto: > > ffahlevi%40gmail.com <ffahlevi%2540gmail.com>> > > > > Sender: [email protected] > > > <indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com><mailto: > > indo-oracle%40yahoogroups.com <indo-oracle%2540yahoogroups.com>> > > > > > Date: Fri, 9 Jul 2010 00:08:11 > > > To: <[email protected] > > > <indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com><mailto: > > indo-oracle%40yahoogroups.com <indo-oracle%2540yahoogroups.com>> > > > > Reply-To: [email protected] > > > <indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com> > > <mailto:indo-oracle%40yahoogroups.com > > <indo-oracle%2540yahoogroups.com><indo-oracle% > 2540yahoogroups.com>> > > > Subject: Re: [indo-oracle] Dblink 10G dan 9i > > > > > > Kita bs dblink oracle 10G dan 9i ga ya? > > > - Bisa > > > > > > Kalau bisa bagaimana caranya? > > > - Sama spt buat dblink dari 9i-9i atau 10g-10g > > > create database link dblink_name connect to username_target identified > by > > > password_target using connection_string; > > > > > > On Thu, Jul 8, 2010 at 9:35 PM, <[email protected]<gcahyadi%40gmail.com> > <gcahyadi%40gmail.com> > > <mailto:gcahyadi%40gmail.com <gcahyadi%2540gmail.com> <gcahyadi% > 2540gmail.com>> > wrote: > > > > > > > Suhu2 mau tanya > > > > > > > > Kita bs dblink oracle 10G dan 9i ga ya? Kalau bisa bagaimana caranya? > > > > > > > > > Lalu 10G dan 9i apa bisa di install di 1 server tanpa partisi? > > > > > > > > Thanks > > > > > > > > -GnC-R > > > > > > > > > > > > > > ------------------------------------ > > > > > > > > -- > > > > -----------I.N.D.O - O.R.A.C.L.E--------------- > > > > Keluar: > >[email protected]<indo-oracle-unsubscribe%40yahoogroups.com> > <indo-oracle-unsubscribe%40yahoogroups.com> > > > ><mailto:indo-oracle-unsubscribe%40yahoogroups.com<indo-oracle-unsubscribe%2540yahoogroups.com> > <indo-oracle-unsubscribe%2540yahoogroups.com>> > >> > > > > > > Website: http://indooracle.wordpress.com > > > > http://www.facebook.com/group.php?gid=51973053515 > > > > ----------------------------------------------- > > > > > > > > Bergabung dengan Indonesia Thin Client User Groups, > > > > Terminal Server, Citrix, New Moon Caneveral, di: > > > > http://indo-thin.blogspot.comYahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > ------------------------------------ > > > > > > -- > > > -----------I.N.D.O - O.R.A.C.L.E--------------- > > > Keluar: > >[email protected]<indo-oracle-unsubscribe%40yahoogroups.com> > <indo-oracle-unsubscribe%40yahoogroups.com> > > > ><mailto:indo-oracle-unsubscribe%40yahoogroups.com<indo-oracle-unsubscribe%2540yahoogroups.com> > <indo-oracle-unsubscribe%2540yahoogroups.com>> > >> > > > > > Website: http://indooracle.wordpress.com > > > http://www.facebook.com/group.php?gid=51973053515 > > > ----------------------------------------------- > > > > > > Bergabung dengan Indonesia Thin Client User Groups, > > > Terminal Server, Citrix, New Moon Caneveral, di: > > > http://indo-thin.blogspot.comYahoo! Groups Links > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > No virus found in this incoming message. > > Checked by AVG - www.avg.com > > Version: 9.0.830 / Virus Database: 271.1.1/2991 - Release Date: 07/09/10 > > 13:36:00 > > > > [Non-text portions of this message have been removed] > > > > [Non-text portions of this message have been removed] > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > [Non-text portions of this message have been removed] > > > > [Non-text portions of this message have been removed] > > > -- silahkan kunjungi alamat berikut : http://irvan.site90.net http://www.suzuki-2wheels.or.id/forum [Non-text portions of this message have been removed] ------------------------------------ -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [email protected] Website: http://indooracle.wordpress.com http://www.facebook.com/group.php?gid=51973053515 ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.comYahoo! Groups Links ------------------------------------ -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [email protected] Website: http://indooracle.wordpress.com http://www.facebook.com/group.php?gid=51973053515 ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.comYahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> 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/
