Para Pakar,
Permasalahannya seperti ini :
1) 172.16.6.10 (SUN, Oracle Server 10G)
2) 172.16.6.253
3) 172.17.9.36 (Windows, Oracle Server 10G,Dummy DB)
No. 2 & No 3 adalah PC yang sama tetapi menggunakan 2 LAN card.
Saya ingin bikin Trigger di Database AC Field xxx(172.16.6.10) dimana akan
mengirim
Value yang diinput ke Database AF Field zzz(172.17.9.36)
Listener yang ada di 172.16.6.10 adalah :
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle10g)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.6.10)(PORT = 1521))
)
)
TNS yang ada di 172.16.6.10 adalah :
DATABASE AC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.6.10)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = databaseac.ap2.com)
)
)
*************Bagian Yang Saya Input*******************
DATABASE AF =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.6.253)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DATABASE AF)
(INSTANCE_NAME = DATABASE AF)
(SERVER = DEDICATED)
)
)
***************************************************
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.6.10)(PORT = 1521))
(CONNECT_DATA =
(Service Name = PLSExtproc)
)
)
Listener yang ada di 172.17.9.36 adalah:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\ora10g)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.9.36)(PORT = 1521))
)
)
TNSnya yang ada di 172.17.9.36 adalah :
DATABASE AF =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.9.36)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DATABASE AF)
(INSTANCE_NAME = DATABASE AF)
(SERVER = DEDICATED)
)
)
DATABASE AC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.6.10)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = databaseac.ap2.com)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
Saya Bikin DBLink tapi kok ada Error Message "No listener" ya??
Saya Coba Lagi dengan setting agak beda dapat Error : "TNS Cannot Resolve The
Connect Identifier Specified"
Mohon Bantuannya Para Pakar. Trims..
----- Original Message ----
From: Awaluddin Hamid <[EMAIL PROTECTED]>
To: [email protected]
Sent: Friday, July 20, 2007 6:00:15 PM
Subject: Re: [indo-oracle] trigger
Coba liat2 penggunaan database link oracle di
http://www.psoug. org/reference/ db_link.html
atau di
http://download. oracle.com/ docs/cd/B12037_ 01/server. 101/b10759/ statements_
5005.htm
hth,
AH
bimaboediman2 wrote:
>
> Para Pakar,
>
> Bisa gak ya saya bikin trigger yang kira2 logikanya seperti ini :
>
> Pada saat nilai suatu field di insert/hapus maka akan insert/hapus
> value yang sama di DATABASE berbeda. (nama Field n table sama)
>
> Database yang berbeda tersebut berada di mesin yang berbeda juga.
> (satu pake windows satu lagi pake sun solaris)
>
> Kalo ada yang bisa bantu..... saya akan sangat berterima kasih :P
>
> Bima Boediman
>
>
<!--
#ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean,
sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;}
#ygrp-vitnav{
padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
#ygrp-vitnav a{
padding:0 1px;}
#ygrp-actbar{
clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;}
#ygrp-actbar .left{
float:left;white-space:nowrap;}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;font-size:77%;padding:15px 0;}
#ygrp-ft{
font-family:verdana;font-size:77%;border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;}
#ygrp-vital{
background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
#ygrp-vital #vithd{
font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;}
#ygrp-vital ul{
padding:0;margin:2px 0;}
#ygrp-vital ul li{
list-style-type:none;clear:both;border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;}
#ygrp-vital ul li .cat{
font-weight:bold;}
#ygrp-vital a {
text-decoration:none;}
#ygrp-vital a:hover{
text-decoration:underline;}
#ygrp-sponsor #hd{
color:#999;font-size:77%;}
#ygrp-sponsor #ov{
padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;margin:0;}
#ygrp-sponsor #ov li{
list-style-type:square;padding:6px 0;font-size:77%;}
#ygrp-sponsor #ov li a{
text-decoration:none;font-size:130%;}
#ygrp-sponsor #nc {
background-color:#eee;margin-bottom:20px;padding:0 8px;}
#ygrp-sponsor .ad{
padding:8px 0;}
#ygrp-sponsor .ad #hd1{
font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;}
#ygrp-sponsor .ad a{
text-decoration:none;}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;}
#ygrp-sponsor .ad p{
margin:0;}
o {font-size:0;}
.MsoNormal {
margin:0 0 0 0;}
#ygrp-text tt{
font-size:120%;}
blockquote{margin:0 0 0 4px;}
.replbq {margin:4;}
-->
____________________________________________________________________________________
Park yourself in front of a world of choices in alternative vehicles. Visit the
Yahoo! Auto Green Center.
http://autos.yahoo.com/green_center/
[Non-text portions of this message have been removed]
