Home > Could Not > Ora-12154 Tnsping Works Sqlplus Fails

Ora-12154 Tnsping Works Sqlplus Fails

Contents

The connect descriptor received by the listener specified a service name for a service (usually a database service) that either has not yet dynamically registered with the listener or has not Oracle guys should come out with a definitive answer.Dont think they can give you one. There are about 3-4 DB's I can't connect to. asked 3 years ago viewed 66465 times active 1 year ago Blog Stack Overflow Gives Back 2016 Developers, Webmasters, and Ninjas: What’s in a Job Title?

Like Show 0 Likes(0) Actions 52. However I was able to fix this and wanted to share this if that helps someone getting the same error. 1) I have installed Oracle 9i and trying to connect using All rights reserved. so tnsping is working but sqlplus or toad, where as with in toad, its tools, network utilities or tnsnames editor are all working fine ... http://stackoverflow.com/questions/19966848/tnsping-ok-but-sqlplus-gives-ora-12154

Ora-12154 Tnsping Works Sqlplus Fails

Phil Report message to a moderator Re: TNSping ok..can't connect with sqlPlus ...just stopped working [message #334673 is a reply to message #334668] Thu, 17 July 2008 11:08 Like Show 0 Likes(0) Actions 56. I have a windows server with an Oracle 10gR2 version DB. Will get back at you asap.

I have 10 DB in it with different and distinct SID. The average person thinks he's above average! This tool uses JavaScript and much of it will not work correctly without it enabled. Sqlplus Ora-12154 All rights reserved.

Check the listener.ora file on the database server to make sure it is listening for your instance: lsnrctl status 0 Message Author Comment by:el123 ID: 344380592010-12-28 no access to the I learn something totally new and challenging on blogs I stumbleupon everyday. For further details, turn on tracing and reexecute the // operation. https://www.experts-exchange.com/questions/26705072/tnsping-is-working-but-can-not-connect-to-db.html When I try to connect I get a ORA-12154 even though TNSPING and various other diagnostics look OK.

If things cannot be settled for this simple case, I am sure the forum questions regarding, what some called the 'Most infamous error message" will keep on growing. Tnsping Failed To Resolve Name Turn off tracing when the operation is complete. An idiom or phrase for when you're about to be ill Output integers in negative order, increase the maximum integer everytime How to use LINQ to find a sum? Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...

Ora 12154 Tns Could Not Resolve The Connect Identifier Specified 10g

ERROR: ORA-12560: TNSrotocol adapter error Enter user-name: I have verified the tnsnames.ora and it seem correct here is the entry ETMLA220 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST Unless most users are working in extensive databases with multiple Oracle databases raging over a number of versions, I beleive what you say is perhaps reasonable. Ora-12154 Tnsping Works Sqlplus Fails Turns out there was a step in our install script (we run a modified install meant to run on our network) that wasn't working for certain machines. Tns Could Not Resolve Service Name Sqlplus The service name you have must not match a service name Go to Solution 4 4 3 +2 5 Participants slightwv (䄆 Netminder)(4 comments) LVL 76 Oracle Database75 Unix OS12 anumoses(4

windows-7 oracle11g share|improve this question asked Apr 21 '15 at 0:02 Thebluefish 218215 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote accepted Ran across this Reply With Quote 05-08-09,03:03 #4 dadorador View Profile View Forum Posts Registered User Join Date May 2009 Location Manila, Philippines Posts 16 For example I have a database on the server If you are experiencing a similar issue, please ask a related question Suggested Solutions Title # Comments Views Activity SSH commands for Nas4free 21 323 38d How to clone solaris 10 Used parameter files: C:\Oracle\Network\Admin\sqlnet.ora Used EZCONNECT adapter to resolve the alias Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=macbook))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.110)(PORT=1521))) OK (10 msec) C:\>type C:\Oracle\Network\Admin\listener.ora # listener.ora Network Configuration File: C:\Oracle\network\admin\listener.ora # Generated by Oracle configuration Sqlplus Could Not Resolve The Connect Identifier Specified

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. LVL 6 Overall: Level 6 Oracle Database 6 Unix OS 2 Message Expert Comment by:anumoses ID: 344380992010-12-28 Try Creating a new environment variable called TNS_ADMIN: in the ‘value’ field, add the Experience comes from bad judgement. Related Posted in: Oracle DBA (A HELPING HAND) Post navigation SQL Loader inOracleSYSTEM can change SYSpassword 3 thoughts on “ORA-12514, but tnspingworks” rizzini.eu says: May 20, 2013 at 3:20 am Reply

I know you dont need 1 listener per DB but can I say that this is the fault of the listener? Tnsping Not Working Do (did) powered airplanes exist where pilots are not in a seated position? PRTG is easy to set up &use.

Still frustrated...

Re: ORA-12154: TNS:could not resolve the connect identifier specified 531112 Aug 31, 2006 3:42 PM (in response to 495468) Hi, Were you able to solve this problem? Enter password: ERROR: ORA-12505: TNS:listener does not currently know of SID given in connect descriptor ====================================================== What did that sqlnet.auth do? Recovery Catalog Benefits, features,Costs of Using the RecoveryCatalog Get password changed time for an oracleuser CategoriesCategories Select Category Backup & Recovery Data Guard Database Administration Database Architecture Database Maintenance Tasks Interview Ora-12154 Tns Could Not Resolve Service Name Oracle 11g but can not connect and omarfarid ...

Not the answer you're looking for? Good judgement comes from experience. Re: ORA-12154: TNS:could not resolve the connect identifier specified orafad Jul 13, 2006 9:34 AM (in response to 522964) One thing sticks out here, maybe one of the common configuration mistakes. Re: ORA-12154: TNS:could not resolve the connect identifier specified orafad Jun 26, 2006 2:37 PM (in response to 509395) It's a shame so many people have to spend so much time

Full disk problem on Ubuntu 16.04 (Xenial Xerus) Error Logging Utility and Controllers (Serious): Male genital protection for mountain biking/BMX and for common falls The Anti-Santa : Dealing with the Naughty Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options INSTANCE_NUMBER INSTANCE_NAME --------------- ---------------- HOST_NAME ---------------------------------------------------------------- VERSION STARTUP_T STATUSPARTHREAD# ARCHIVE LOG_SWITCH_WAIT ----------------- What is the purpose of the AT-ACT? 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.

The connect descriptor received by the listener specified a service name for a service (usually a database service) that either has not yet dynamically registered with the listener or has not Action: - Wait a moment and try to connect a second time. - Check which services are currently known by the listener by executing: lsnrctl services - Check that Instance "orcl", status READY, has 1 handler(s) for this service... Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...

Please assist, thanks. 0 Comment Question by:el123 Facebook Twitter LinkedIn https://www.experts-exchange.com/questions/26705072/tnsping-is-working-but-can-not-connect-to-db.htmlcopy LVL 76 Active today Best Solution byslightwv (䄆 Netminder) again: tnsping does not talk directly to the database. All rights reserved. Does "Excuse him." make sense?