OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » net8config

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

net8config [message #66432]

Mon, 10 June 2002 02:30

shaju
Messages: 2
Registered: June 2002

Junior Member

i have oracle8 client installed in my system. With the help of ORACLE NET8EASY CONFIG I could connect to the main server and access the database. The connecting string is 'TEST' and the host name is 'DBSERVER'. However, when I try to create the host name for a remote server, with an IP address,(as SALAL) i am not able to create it.
i asm sending the file - tnsnames.ora and sqlnet.ora

**********************
# TNSNAMES.ORA Configuration file: C:ORANTNET80ADMINtnsnames.ora
# Generated by Oracle Net8 Assistant

Example1.world =
(DESCRIPTION =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = Production1)
(Port = 1521)
)
(CONNECT_DATA = (SID = SID1)
)
)
Example2.world =
(DESCRIPTION =
(ADDRESS =
(COMMUNITY = spx.world)
(PROTOCOL = SPX)
(Service = Server_lsnr)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Example3.world =
(DESCRIPTION =
(ADDRESS =
(COMMUNITY = nmp.world)
(PROTOCOL = NMP)
(Server = FinanceServer1)
(Pipe = ORAPIPE)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Tcp-loopback.world =
(DESCRIPTION =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Beq-Local.world =
(DESCRIPTION =
(ADDRESS =
(COMMUNITY = beq.world)
(PROTOCOL = BEQ)
(PROGRAM = oracle73)
(ARGV0 = oracle73ORCL)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
)
(CONNECT_DATA = (SID = ORCL)
)
)
TEST.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = dbserver)
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = dbserver)
(Port = 1526)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
salal.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 10.3.0.1)
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 10.3.0.1)
(Port = 1526)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
********************

*******************
# C:ORANTNET80ADMINSQLNET.ORA Configuration File:C:ORANTNET80ADMINsqlnet.ora
# Generated by Oracle Net8 Assistant

NAME.DEFAULT_ZONE=world

NAMES.DEFAULT_DOMAIN=world

SQLNET.AUTHENTICATION_SERVICES= (NTS)

SQLNET.EXPIRE_TIME=0

SQLNET.ENCRYPTION_SERVER=requested

SQLNET.ENCRYPTION_CLIENT=requested

NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME)

*******************

Report message to a moderator