Home » RDBMS Server » Networking and Gateways » net8config
net8config [message #66432] Mon, 10 June 2002 02:30 Go to next message
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)

*******************
Re: net8config [message #66434 is a reply to message #66432] Mon, 10 June 2002 10:45 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
everything looks fine.
and
How are u connecting to the database?
try connecting as

username/password@test.world
Previous Topic: ORA-27500 error
Next Topic: Re: ORA-01861: literal does not match format string
Goto Forum:
  


Current Time: Thu Mar 28 09:37:07 CDT 2024