Home » RDBMS Server » Server Administration » problem in locating the correct Host String
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 ...
Previous Topic: ora -08103 error & not able to retirive rows
Next Topic: index & DBlink
Goto Forum:
  


Current Time: Thu Jan 09 04:21:51 CST 2025