maaf pak gak lengkap ya, yg eror, ketika saya coba connect dari server
database 8i windows 2000 ke 8i IBM AIX.
IP database 8i windows : 10.1.0.30/ts_inventory
IP database 8i IBM AIX : 10.1.0.31/db_inventory
Listener 8i AIX
# LISTENER.ORA Network Configuration File:
/u01/app/oracle/product/8.1.7/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DB_INVENTORY)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = DB_INVENTORY)(PORT = 2481))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/8.1.7)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ilms)
(ORACLE_HOME = /u01/app/oracle/product/8.1.7)
(SID_NAME = ilms)
)
)
sqlnet.ora server windows
# SQLNET.ORA Network Configuration File:
C:\oracle\ora81\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DEFAULT_DOMAIN = ts.pelni.co.id
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
2008/2/19 Andrew E.K. <[EMAIL PROTECTED]>:
> 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] <pejantan4u%40gmail.com>>
> To: [email protected] <indo-oracle%40yahoogroups.com>
> 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 <http://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 <http://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 <http://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]
>
>
>
--
Cheers,
^_^ Andes ^_^
[Non-text portions of this message have been removed]
