Hello Ade, Thursday, March 1, 2007, 1:12:44 PM, you wrote:
Iyah bener.. kalo mau koneksi database tuh tnsnames-nya kok. Btw tujuan merubah listener tuh apa ya ? soalnya di email anda tidak menyebutkan tujuannya apa, anda cuma menyebutkan merubah listener dan error aja. Kalo karena dua versi oracle, pake aja salah satu listenernya bergantung instalasi oracle anda (bisa ditambahkan ke tnsnames-nya). Misal ora92 yang terakhir ya untuk mudahnya pake listener 92 untuk konek ke db ora10g. Sebenarnya dua-duanya aktif juga bisa kok > mungkin klo ingin buat new connection bukan file listener.ora yang d rubah, > tapi tnsnames.ora dns kita bisa tambahin new SID ato Service Name > Thanks And Regards, > ============================ > Ade Veria Octora > Email : [EMAIL PROTECTED] > ----- Original Message ---- > From: wida widiastuti <[EMAIL PROTECTED]> > To: [email protected] > Sent: Thursday, March 1, 2007 10:52:54 AM > Subject: [indo-oracle] help listener eror > hi all, > saya mencoba merubah LISTENER.ORA dengan menambah service orcl. > berikut isi listerner.ora yang saya ubah : > SID_LIST_LISTENER = > (SID_LIST = > (SID_DESC = > (SID_NAME = PLSExtProc) > (ORACLE_HOME = E:\oracle\product\ 10.2.0\db_ 1) > (PROGRAM = extproc) > ) > ) > (SID_DESC = > (SID_DESC = > (GLOBAL_DNAME = ORCL) > (ORACLE_HOME = E:\oracle\product\ 10.2.0\db_ 1) > (SID_NAME = ORCL) > ) > ) > LISTENER = > (DESCRIPTION_ LIST = > (DESCRIPTION = > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) > (ADDRESS = (PROTOCOL = TCP)(HOST = wida)(PORT = 1522)) > ) > ) > tapi, waktu saya coba merestart kembali listener tersebut. muncul eror > berikut : > Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL= TCP)(HOST= wida)(PORT= > 1522))) > TNS-12541: TNS:no listener > TNS-12560: TNS:protocol adapter error > TNS-00511: No listener > 32-bit Windows Error: 61: Unknown error > kira2 apa penyebabnya? .. > saya menggunakan 10g dan 9i dalam 1 os, apakah berpengaruh? > tolong saya dibantu untuk mencari solusinya > trims > wida > ____________ _________ _________ _________ _________ ____ > Yahoo! Singapore Answers > Real people. Real questions. Real answers. Share what you know at > http://answers. yahoo.com. sg > [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;} -->> > __________________________________________________________ > Do you Yahoo!? > Everyone is raving about the all-new Yahoo! Mail beta. > http://new.mail.yahoo.com > [Non-text portions of this message have been removed] > -- Best regards, Ronevic ------------------------ Yahoo! Groups Sponsor --------------------~--> Something is new at Yahoo! Groups. Check out the enhanced email design. http://us.click.yahoo.com/kOt0.A/gOaOAA/yQLSAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! 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: mailto:[EMAIL PROTECTED] mailto:[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/
