problem in locating the correct Host String [message #62288] |
Mon, 12 July 2004 20:55 |
syed umair ali shah
Messages: 8 Registered: July 2004
|
Junior Member |
|
|
hi there ... the reply from one of the friend here was right and i located the tnsnames file but the problem is where is the correct host string ... i have pasted down the file enteries ... kindly suggest me where is the right host string ...
# C:ORANTNET80ADMINTNSNAMES.ORA Configuration File:C:orantnet80admintnsnames.ora
# Generated by Oracle Net8 Assistant
CMEXAMPLE.WORLD=(DESCRIPTION=(address_list=(ADDRESS=(PROTOCOL=tcp)(PORT=1610)(HOST=CM_SERVER))(ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=LSNR_SERVER)))(CONNECT_DATA=(SID=ORCL))(SOURCE_ROUTE=yes))
TCPEXAMPLE.WORLD=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(Host=Production1)(Port=1521)))(CONNECT_DATA=(SID=ORCL)))
NMPEXAMPLE.WORLD=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=NMP)(Server=FinanceServer1)(Pipe=ORAPIPE)))(CONNECT_DATA=(SID=ORCL)))
EXTPROC_CONNECTION_DATA.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))(CONNECT_DATA=(SID=extproc)))
BEQ-LOCAL.WORLD=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)))
SPXEXAMPLE.WORLD=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=SPX)(Service=Server_lsnr)))(CONNECT_DATA=(SID=ORCL)))
TCP-LOOPBACK.WORLD=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(Host=127.0.0.1)(Port=1521)))(CONNECT_DATA=(SID=ORCL)))
thanx laot inadvance plzzz reply me soon ...
|
|
|