Home » RDBMS Server » Networking and Gateways » still tns name failure.... urgent please
still tns name failure.... urgent please [message #18654] Sat, 09 February 2002 00:05 Go to next message
krahuman
Messages: 18
Registered: January 2002
Junior Member
hai ora 8i experts !

i am having problems with ora 8i database config.

i want to config. a database
named : mydatabase
in the host : myhost

this is my whole tnsname file.
please help me in configuring mydatabase.
it is urgent

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

the following lines i written as instructed by one of you.
mydatabase =
( description =
( address_list =
( address = (protocol = tcp)
( host = myhost)
( port = 1521)
)
)
( connect_data =
( service_name = mydatabase)
)
)
Re: still tns name failure.... urgent please [message #18658 is a reply to message #18654] Sat, 09 February 2002 08:21 Go to previous message
robert malikian
Messages: 18
Registered: October 2001
Junior Member
is your Listener up!
check it first
type "lsnrctl status" if you see error(s) then
lsnrctl start
now do ORACLE_SID=mydatabase or
sqlplus sys/****@mydatabase
Previous Topic: Re: Connecting to two different databases
Next Topic: Re: Can't Install 8i Client on Pentium 4 , NT 4 machine??
Goto Forum:
  


Current Time: Mon Mar 04 00:04:52 CST 2024