Pak Andes, Btw ini tnsnames yang dipake and error yg mana yah? IP/HostName yg Windows apa ? and IP/HostName AIX apa? Coba lampirkan juga pak listener.ora(dari AIX) and sqlnet.ora(dr server Windowsnya)
Salam, Andrew ----- Original Message ---- From: Andes Febrian <[EMAIL PROTECTED]> To: [email protected] Sent: Tuesday, 19 February 2008 4:30:00 Subject: Re: [indo-oracle] Tanya : TNS : failed to resolve name. urgent!! Halo pak andrew, makasih atas responnya, berikut tnsnames.ora 8i pada server windows dan IBM AIX. tnsping dari 8i IBM AIX ke 8i windows baik2 saja. tp dari server 8i windows ke 8i IBM AIX tidak bisa. FYI, listener 8i pada server IBM AIX menyatu pada 10g. karena saya install 2 Oracle software dalam satu server IBM AIX. saya connect dari pc maupun laptop ke server 8i dan 10g di IBM AIX bisa, pc dan laptop saya di install oracle 8i client. tnsnames.ora 8i IBM AIX # TNSNAMES.ORA Network Configuration File: /u01/app/oracle/ product/8. 1.7/network/ admin/tnsnames. ora # Generated by Oracle configuration tools. ILMS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = DB_INVENTORY) (PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ilms) ) ) INST1_HTTP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = DB_INVENTORY) (PORT = 1521)) ) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = ilms) (PRESENTATION = http://admin) ) ) EXTPROC_CONNECTION_ DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) ilms_old = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.0.30)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ilms) ) ) tnsnames.ora 8i windows # TNSNAMES.ORA Network Configuration File: C:\oracle\ora81\ network\admin\ tnsnames. ora # Generated by Oracle configuration tools. INST1_HTTP.TS. PELNI.CO. ID = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ts_inventory) (PORT = 1521)) ) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = ILMS) (PRESENTATION = http://admin) ) ) ILMS.TS.PELNI. CO.ID = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ts_inventory) (PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ILMS) ) ) EXTPROC_CONNECTION_ DATA.TS.PELNI. CO.ID = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) ILMS_NEW = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.0.31)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ilms) ) ) 2008/2/19 Andrew E.K. [EMAIL PROTECTED] com: > > > -- > Cheers, > ^_^ Andes ^_^ [Non-text portions of this message have been removed] <!-- #ygrp-mkp{ border:1px solid #d8d8d8;font-family:Arial;margin:14px 0px;padding:0px 14px;} #ygrp-mkp hr{ border:1px solid #d8d8d8;} #ygrp-mkp #hd{ color:#628c2a;font-size:85%;font-weight:bold;line-height:122%;margin:10px 0px;} #ygrp-mkp #ads{ margin-bottom:10px;} #ygrp-mkp .ad{ padding:0 0;} #ygrp-mkp .ad a{ color:#0000ff;text-decoration:none;} --> <!-- #ygrp-sponsor #ygrp-lc{ font-family:Arial;} #ygrp-sponsor #ygrp-lc #hd{ margin:10px 0px;font-weight:bold;font-size:78%;line-height:122%;} #ygrp-sponsor #ygrp-lc .ad{ margin-bottom:10px;padding:0 0;} --> <!-- #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;} --> __________________________________________________________________ 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]
