Home » SQL & PL/SQL » Client Tools » Client / Server Connection Problem (developer 6i database 10g window xp)
Client / Server Connection Problem [message #434992] Sun, 13 December 2009 05:45 Go to next message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
Hi guys

I want to know how can i make client installation my oracle database version is Oracle database 10g (10.2.0.1.0) i install same version of database client in client system but what will be the (TNS_NAMES.ORA) file my server tns_name.ora file is

# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_3\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LIVE =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = COMPUTER1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = live.ss64.com)
    )
  )



I hope you guys help me

Thanks


Regards

Shahzaib ismail

Re: Client / Server Connection Problem [message #434993 is a reply to message #434992] Sun, 13 December 2009 05:48 Go to previous messageGo to next message
Michel Cadot
Messages: 63810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
(Assuming it is a correct one and the listener is up) The same one.

Regards
Michel

[Updated on: Sun, 13 December 2009 05:48]

Report message to a moderator

Re: Client / Server Connection Problem [message #434994 is a reply to message #434992] Sun, 13 December 2009 08:13 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
Thanks for your reply michel

If my tns_names.ora file is same in client then how can its connect with my server because

The tns admin file is

D:\oracle\product\10.2.0\db_3\network\admin\tnsnames.ora


but actual database is in
\\server\oracle\pro
duct\10.2.0\db_3\network\admin\tnsnames.ora


Regards


Shahzaib ismail
Re: Client / Server Connection Problem [message #434997 is a reply to message #434994] Sun, 13 December 2009 09:05 Go to previous messageGo to next message
Michel Cadot
Messages: 63810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is the point?
The CONTENT of the files should be the same one, not the LOCATION.

Regards
Michel
Re: Client / Server Connection Problem [message #435002 is a reply to message #434992] Sun, 13 December 2009 10:59 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
Michel i have a confusion (Tnsnames.ora file will be same in client and server system ? )

Regards


Shahzaib
Re: Client / Server Connection Problem [message #435003 is a reply to message #435002] Sun, 13 December 2009 11:05 Go to previous messageGo to next message
BlackSwan
Messages: 24912
Registered: January 2009
Senior Member
TNSNAMES.ORA file is strictly a client side file.
The client uses the content of TNSNAMES.ORA file to obtain connection details for the desired database.
Re: Client / Server Connection Problem [message #435894 is a reply to message #434992] Fri, 18 December 2009 11:33 Go to previous message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
problem solved


Thanks Guys


Regards

Shahzaib ismail
Previous Topic: readonly TOAD...and a lacy guy
Next Topic: how can i login as sysdba @ isqlplus
Goto Forum:
  


Current Time: Thu Sep 29 05:36:39 CDT 2016

Total time taken to generate the page: 0.06097 seconds