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]> > > > 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>> > Kepada: [email protected] <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> [mailto: > [email protected] <indo-oracle%40yahoogroups.com>] On > Behalf Of Fahmi > Sent: Friday, July 09, 2010 9:34 PM > To: [email protected] <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> > <mailto:gcahyadi%40gmail.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> <mailto: > ffahlevi%40gmail.com <ffahlevi%2540gmail.com>> > > > Sender: [email protected] <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><mailto: > indo-oracle%40yahoogroups.com <indo-oracle%2540yahoogroups.com>> > > > Reply-To: [email protected] <indo-oracle%40yahoogroups.com> > <mailto:indo-oracle%40yahoogroups.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> > <mailto:gcahyadi%40gmail.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> > <mailto:indo-oracle-unsubscribe%40yahoogroups.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> > <mailto:indo-oracle-unsubscribe%40yahoogroups.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]
