The key is not that file, as it is nothing but a names resolution file. And sqlplus is nothing but a CLI application. If you want to connect to an Oracle database or ANY database you must have, at a minimum, the client software for that particular database product. For oracle you need to download and install the Oracle client. If you want the full "Admin" or "Runtime" client, download from edelivery. Pay attention to the license terms. Sign up to join this community.
The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more. Asked 5 years, 8 months ago. Active 3 years, 2 months ago. Viewed 12k times. Improve this question. Community Bot 1. There are examples of tnsnames. If you type: sqlplus someuser somedb from the above command prompt, what does it tell you?
If not, what does which sqlplus tell you? DCookie DCookie 2, 17 17 silver badges 18 18 bronze badges. Michael Grazebrook Michael Grazebrook 1 1 bronze badge. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses.
Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Related 7. September 30, - am UTC. Thank you for you help. October 15, - am UTC. I am not able to find the document Is the no. January 07, - pm UTC. Just cut and pasted the number into the search field and it popped right up. I don't think it is protected. Dave, January 07, - pm UTC. I can't - it doesn't pops up neither with "all sources" nor with "document id knowledge base, forum, or bug " - tried with and without the trailing ".
I get "Your search returned no hits! Alberto - In the quick find list of values you select "All Sources" and then the search works returns the said document Ciao. January 08, - am UTC. The note is January 09, - am UTC. January 10, - am UTC. Does this always work? January 10, - pm UTC. You need the listener to be up February 03, - pm UTC.
Hi Tom In your first answer you said March 09, - pm UTC. Can I replace only part of tnsnames. Hi Tom, If I am having entry defined in tnsnames. September 28, - am UTC. Hi tom, I can connect to sqlplus without entry in tnsnames.
You can put this entry in a tnsnames. Why do Oracle clients need to use such complicated connect strings to reach a server?
Other brands of DBs only need to know the hostname of the server and optionally port number , username, password, and name of the database. It would be nice if the modern Oracle libraries would allow connections with this information alone, instead of requiring a TNS-formatted string with lots of field names, parenthesis, and equal signs.
December 14, - pm UTC. A reader, December 14, - pm UTC. As tom said, from 10g release 2 sqlplus client, "easy connect" works dandy. I already have tnsnames. All Rights Reserved. I found the answer on Metalink. In the sqlnet. I learned something new. Thank you very much for this segment: I need to run EXP and IMP from my Java widget and use either the workstation-specific tnsNameKey, or the server-port-instance derived description format discussed above.
It is a pity that this valuable tip is hidden in your archive; I found it via google. I really appreciate the answers sent by you. I have some similar question. Please let me know how can I contact it? May 08, - am UTC. It works for me. You must be making some mistake on your operating system as far as escaping special characters go and it might be single quotes you need. Very nice way to connecting. May 12, - am UTC. Hi Tom We have just upgraded from Pre-upgrade both of the following commands were successfull.
Although I don't think the problem is related to the upgrade itself. Note:IP addresses changed for security. A side-effect is our Web Server could no longer connect to the database. It had PlsqlDatabaseConnectString localhostdb in its dads. We have altered it to PlsqlDatabaseConnectString However we are at a loss as to why localhost connections don't work, and how to resolve the issue.
Any advice would be very much appreciated. This file is actually generated by netca. But if customers choose to install "Software Only", this file wont exist and without the native authentication, they will not be able to connect to the database on NT. Regards Steve. I doubt this has anything to do with oracle I think this has everything to do with a network configuration you have - were you really using localhost?
Was mod plsql running on the same machine as the database? What did localhost resolve to, what DOES localhost resolve to now. Your ping shows Tom: 1. Is there a way for all clients to use one common tnsnames. September 22, - pm UTC. Not highly recommended. Tom: Do you mean ldap is a lot of work? September 24, - pm UTC. However, if the decreased work you would have by not maintaining multiple tnsnames.
That is: as with all things, it depends. You sort of need to analyze this in the CONTEXT of who you are, what you do, what your needs are, etc etc etc the same thing I keep saying to you smk The 'simple file' thing is called a file server. You would have to mount that simple file to everyone - it would have to always be available, it is not easy to make redundant, it too requires work setting up the file share, making sure it is available, etc.
The site shutdownabort. It acts as an Oracle Internet Directory with a very simple setup. Tom: If you are upgrading from 9i to 11g, what would be the easiest way to implement TNS and oracle client. We have 50 machines with Power builder client on it. Do we need to install the oracle 11g client on each machine. We can use EZ connect instead of TNS file but do we still need to install remove the 9i client and install 11g client on every machine.
October 08, - pm UTC. You will not be able to take advantage of any new 11g stuff - but since powerbuilder doesn't use anything special that is probably OK.
Tom: Thanks for the info. But is there also another alternative. Like not having oracle client on each machine but rather on a server that everyone uses for easier maintenance OR use EZ connect or that is only for connection strings. October 09, - am UTC.
Like not having oracle client on each machine but rather on a server that everyone uses for easier maintenance OR use EZ connect or that is only for connection strings. You can use the "instant client" - just the networking libraries - that is available, but that means upgrading the clients. Maybe you are thinking about the type-4 JDBC thin drivers, you can install them and have connection to Oracle assuming you install the Oracle type-4 drivers because the type-4 drivers have the Oracle client burned into them already.
Tom: I think what you saying is for any client machine that has some software application regardless what language it is developed with PB, VB, Java that needs to talk to an Oracle database, i need to install something called "oracle Client" software.
There is no way around this.
0コメント