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

Ora-12154 Tnsping Works Sqlplus Fails

Contents

The command completed successfully C:\>type C:\query.sql select * from v$instance; exit C:\>sqlplus / as sysdba @C:\query.sql SQL*Plus: Release 10.2.0.1.0 - Production on Fri Oct 19 11:07:53 2007 Copyright (c) 1982, 2005, Well, as you can see above, the connection did not work. Help anyone? more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed

There is also no ORACLE_HOME or TNS_ADMIN environment variables set. Get 1:1 Help Now Advertise Here Enjoyed your answer? All rights reserved. Your database doesn't register with the default listener for some reason.

Ora-12154 Tnsping Works Sqlplus Fails

more hot questions question feed lang-sql about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Interview question "How long will you stay with us?" Explain it to me like I'm a physics grad: Global Warming Why is this 'Proof' by induction not valid? Instance "orcl", status READY, has 1 handler(s) for this service...

Added oracle express. With the updated 'local_listener' parameter now shows extra information: Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=machine.domain.com)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))) Services Summary... What change in history would I have to make to stop Christmas from happening? Sqlplus Ora-12154 Linked 0 ORA-12154 cannot connect to the database from sqlplus 2 sqlplus gets ORA-12504 when using EZCONNECT syntax Related 4ORA-12154: TNS:could not resolve the connect identifier specified83ORA-12514 TNS:listener does not currently

When I run a tnsping in command prompt, it instantly resolves and connects. Ora 12154 Tns Could Not Resolve The Connect Identifier Specified 10g Reply With Quote 05-09-09,12:33 #8 dadorador View Profile View Forum Posts Registered User Join Date May 2009 Location Manila, Philippines Posts 16 to anadecent: I'll try to attend to your request Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. this website And as I'm using the instant client, there's also no Windows service that could be restarted.

But a large number of people are using, or trying to learn the usability of the prodcut with Windows XP or Windows 2003 machines, especially the much advertised XE. Tnsping Failed To Resolve Name 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 All rights reserved. Do I need that for security??

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

DB Reporting Tools Oracle Database Basic RMAN Backup Configuration Video by: Steve Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a The listener on the machine does not know about the instance you are trying to connect to. Ora-12154 Tnsping Works Sqlplus Fails According to the Instant Client documentation, ORACLE_HOME and ORACLE_SID do not need to be set - I also tried setting those variables, but this didn't change anything. Tns Could Not Resolve Service Name Sqlplus Browse other questions tagged oracle oracle-11g listener or ask your own question.

Its kinda weird. Please turn JavaScript back on and reload this page. I've restarted the service and the listener several times, the listener log doesn't give any clues. Like Show 0 Likes(0) Actions 56. Sqlplus Could Not Resolve The Connect Identifier Specified

Instance "oracle10gr2", status READY, has 1 handler(s) for this service... more hot questions question feed about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Science Is it possible to have 3 real numbers that have both their sum and product equal to 1? Service "orcl" has 1 instance(s).

Notify me of new posts via email. Tnsping Not Working Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... Instance "xe", status READY, has 1 handler(s) for this service...

share|improve this answer answered Jun 14 at 21:50 Thebluefish 218215 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up

Try to issue alter system register; and then re-connect to to the database. –Yasir Arsanukaev Mar 11 '13 at 14:03 @YasirArsanukaev instance_name is 'xe' (lower case if that is I even used the tnsping utility and it returned successful results however when I use SQLPLUS to connect to the database its returns an ORA-12560: Tns: protocol adapter error. Update with requested information: SQL> show parameter service_names NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ service_names string XE SQL> show parameter local_listener NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ local_listener string Update2: as Ora-12154 Tns Could Not Resolve Service Name Oracle 11g 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

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 Service "PLSExtProc" has 1 instance(s). Like Show 0 Likes(0) Actions 53. I can TNSPing ok...I just can't connect with toad or sqlplus anymore from another computer..

I learn something totally new and challenging on blogs I stumbleupon everyday. Linked 10 How to configure an Oracle Listener without SID_LIST_LISTENER in listener.ora? 0 How can I launch SQL Developer? I have 10 DB in it with different and distinct SID. Just that a listener is listening on the database server.

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. If that works, then my guess is you maybe installed the Oracle client software too, and when you run sqlplus, it looks for the tnsnames.ora file in your client home. -- Results 1 to 8 of 8 Thread: Cannot connect to DB using sqlplus but can tnsping the database Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Just that a listener is listening on the database server.

I have a windows server with an Oracle 10gR2 version DB. 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