OraFAQ Forum: Networking and Gateways » Tns connection not established

Home » RDBMS Server » Networking and Gateways » Tns connection not established (Form 6i, oracle 10 g, Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod, windows 2003 (Server), windows xp (client), windows 7(Client))

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

Tns connection not established [message #602175]

Sat, 30 November 2013 19:01

hissam78
Messages: 194
Registered: August 2011
Location: PAKISTAN

Senior Member

Dear Respectful Experts,
when i run the form 6i and oracle db 10g on same machine it work fine. but when i install
the form 6i on client machine (on windows-7, win xp) and try to connect with server. it gives
"Tns unable to connect destination error".

please see the below server and client side tnsnames.ora configurations and help me to correct it.

-- ON ORACLE 10G DB SERVER CONFIGURATION.
# tnsnames.ora Network Configuration File: C:\OraHome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Waheed-Ahmed)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

=========================================================================================
--ON FORMs 6i TNSNAMES.ORA CONFIGURATION
# tnsnames.ora Network Configuration File C:\orant\NET80\ADMIN

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)
)
)
ORCL = # (I have manually define this configuration)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 192.168.1.98) #Server IP Address
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)

thanx

Report message to a moderator

Re: Tns connection not established [message #602176 is a reply to message #602175]

Sat, 30 November 2013 20:58

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>the form 6i on client machine (on windows-7, win xp) and try to connect with server. it gives
>"Tns unable to connect destination error".

Can client successfully ping DB Server?
Does any Firewall exist on or between client & server?

Report message to a moderator

Re: Tns connection not established [message #602189 is a reply to message #602175]

Sun, 01 December 2013 02:13

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

You probably have a names.default_domain specified in your sqlnet.ora file.

Report message to a moderator

Previous Topic:	ORA-609 : opiodr aborting process unknown ospid
Next Topic:	Connection problem with DBLINK

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 02:29:30 CDT 2025