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))
Tns connection not established [message #602175] Sat, 30 November 2013 19:01 Go to next message
hissam78
Messages: 193
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
Re: Tns connection not established [message #602176 is a reply to message #602175] Sat, 30 November 2013 20:58 Go to previous messageGo to next message
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?
Re: Tns connection not established [message #602189 is a reply to message #602175] Sun, 01 December 2013 02:13 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You probably have a names.default_domain specified in your sqlnet.ora file.
Previous Topic: ORA-609 : opiodr aborting process unknown ospid
Next Topic: Connection problem with DBLINK
Goto Forum:
  


Current Time: Thu Mar 28 05:17:56 CDT 2024