| connection of client pcs with server oracle database [message #665212] |
Sat, 26 August 2017 01:55  |
 |
adil shakeel
Messages: 47
Registered: August 2017
|
Member |
|
|
Asalamualaikum.
Will any one please guide me how could I connect client pc with the oracle database onto server pc.
I have a shared folder and have wired netwrok.
i PICKED THE transnames.ora file from the server pc and put it into the client pc into the following path.
C:\orant\NET80\ADMIN\
But its not connected
The error message is coming TNS:...........
SO PLEASE GUIDE ME ONTO THIS MATTER
Adil Shakeel
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: connection of client pcs with server oracle database [message #665237 is a reply to message #665236] |
Sun, 27 August 2017 01:52  |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
You must try to be more precise. You will never get anywhere in computing if you are not precise. For example, you said that you were using PL/SQL Developer. But now you talk about a .fmx file, which would be the Forms client.
You had better start again, with a simple SQL*Plus connection and move on to more complicated tools when you have that working. Start like this, and use copy/paste to show the result:
C:\Users\john>
C:\Users\john>tnsping orclz
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 27-AUG-2017 07:48:21
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
C:\app\oracle\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (description = (address = (protocol = tcp)(host = 192.168.1.65)(port = 1521)) (connect_data = (service_name = orclz)))
OK (0 msec)
C:\Users\john>sqlplus system/oracle@orclz
SQL*Plus: Release 12.1.0.2.0 Production on Sun Aug 27 07:48:23 2017
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Last Successful login time: Sun Aug 27 2017 07:48:12 +01:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics, Real Application Testing
and Unified Auditing options
orclz>
Please use [code] tags to format your posts as described here How to use [code] tags and make your code easier to read and another point: using religious greetings on a professional forum is usually viewed as serious a breach of etiquette.
|
|
|
|
|
|
| Re: connection of client pcs with server oracle database [message #665246 is a reply to message #665236] |
Sun, 27 August 2017 13:59 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
adil shakeel wrote on Sun, 27 August 2017 07:55
But when I access the same login file shortcut from the shared folder of server then it shows the login form but given following error.
TNS-12203: TNS:unable to connect to destination
What is that "same login file shortcut"? Where does it point to? What is the contents of the target file? How do you run it (clicking on it in the shared folder which is mapped on your PC or did you first copy it to your PC and then click on it)?
Furthermore, it seems that you have Forms on your PC, and Forms can connect to the database. Is that correct? If so, it - obviously - uses information that is correct.
Note that every (as far as I can tell) Oracle product has its own TNSNAMES.ORA. It means that Forms, somewhere in its tree, also has and uses yet another copy of the TNSNAMES.ORA file. Search for it. Once you locate it, I'd suggest you to create an environment variable named TNS_ADMIN which will point to that directory. Or, maybe even better, put that file (TNSNAMES.ORA), as well as SQLNET.ORA into a new folder (such as c:\oralib) and let TNS_ADMIN point to it (here's how). Doing so, you'll instruct Oracle to check that directory first and use TNSNAMES.ORA file it finds in there. Also, you'll have to maintain only that single copy of the file (when adding new databases you connect to), instead of multiple ones.
Once you're done, all Oracle software you use (Forms, SQL*Plus, PL/SQL Developer, ...) should be able to establish connection.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
