jika berkenan, bagaimana problem solving nya mas... biar kita bisa share experience kepada oracle mania yang lain.
regard, subekti ----- Original Message ----- From: bima boediman To: [email protected] Sent: Thursday, August 02, 2007 9:39 AM Subject: Re: [indo-oracle] trigger BANTUIN Lagi donk.... Problem Solved... THNX all ----- Original Message ---- From: Subekti Pranoto <[EMAIL PROTECTED]> To: [email protected] Sent: Monday, July 30, 2007 5:29:31 PM Subject: Re: [indo-oracle] trigger BANTUIN Lagi donk.... saya quote trouble shoot yang disampaikan mas Awaluddin Hamid.. '----------- --------- --------- --------- --------- --------- -- Test koneksi network dari 172.16.6.10 ke 172.17.9.36 ping 172.17.9.36 Test koneksi tns dari 172.16.6.10 ke 172.17.9.36 tnsping DATABASE_AF Test koneksi database dari 172.16.6.10 ke 172.17.9.36 sqlplus user/[EMAIL PROTECTED] AF Paste error message-nya ke sini, biar di analisa sama2. '----------- --------- --------- --------- --------- --------- -- regard, subekti ----- Original Message ----- From: bima boediman To: indo-oracle@ yahoogroups. com Sent: Monday, July 30, 2007 5:09 PM Subject: Re: [indo-oracle] trigger BANTUIN Lagi donk.... Saya sudah coba lagi...dan hasilnya: DB yang di Windows berhasil terhubung ke DB yang di SUN. Tetapi anehnya Listener yang di SUN tidak mau Connect. "error listening to 172.16.6.253" (kira2 seperti itu) Padahal Listener di Windows berhasil.... Pusssiiiinnnkkkkk dehhhhh ----- Original Message ---- From: Awaluddin Hamid <[EMAIL PROTECTED] com> To: indo-oracle@ yahoogroups. com Sent: Thursday, July 26, 2007 1:40:02 PM Subject: Re: [indo-oracle] trigger BANTUIN Lagi donk.... Test koneksi network dari 172.16.6.10 ke 172.17.9.36 ping 172.17.9.36 Test koneksi tns dari 172.16.6.10 ke 172.17.9.36 tnsping DATABASE_AF Test koneksi database dari 172.16.6.10 ke 172.17.9.36 sqlplus user/[EMAIL PROTECTED] AF Paste error message-nya ke sini, biar di analisa sama2. hth, AH bima boediman wrote: > > 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] com <mailto:awal% 40alasindah. com>> > To: indo-oracle@ yahoogroups. com <mailto:indo- oracle%40yahoogr oups.com> > 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/ > <http://autos. yahoo.com/ green_center/ > > > [Non-text portions of this message have been removed] > > <!-- #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;} --> ____________ _________ _________ _________ _________ _________ _ Got a little couch potato? Check out fun summer activities for kids. http://search. yahoo.com/ search?fr= oni_on_mail& p=summer+ activities+ for+kids& cs=bz [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] <!-- #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;} --> __________________________________________________________ Looking for a deal? Find great prices on flights and hotels with Yahoo! FareChase. http://farechase.yahoo.com/ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
