sumber : http://en.wikipedia.org/wiki/Transparent_Network_Substrate
Gimana? pusing kan? sama gw juga pusing hehehe .... Udah lah ke intinya aja, cara membuat TNS di Windows ya ....
catatan : gw pake Oracle 10g sebagai server di windows dan akan terhubung ke Oracle 10g di komputer server UnixHP
- Buka
\product\ \ \NETWORK\ADMIN\tnsnames.ora - Defaultnya, lo bakal nemuin satu tns dengan nama ORCL, nah lo kopi aja tuh satu blok ORCL TNS nya terus lo paste di paling bawah, dah gitu lo tinggal edit host and port serta service_name nya . nih contoh nya :ODSDEV =(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.22.199.11)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = odsdev)))
- Dah gitu lo coba tnsping ke odsdev itu kalo berhasil bakal muncul kayak begini
C:\>tnsping odsdev
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 10-JUL-2009 10:21:08
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.22.199.11)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = odsdev)))
OK (0 msec)
No comments:
Post a Comment