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