ORA-12514: TNS:listener does not currently know of service requested in connect descriptor Like this:Like Loading... All rights reserved. Leave a Reply Cancel reply Enter your comment here... Why is this C++ code faster than my hand-written assembly for testing the Collatz conjecture?
I say to you, I certainly get annoyed while people think about worries that they just do not know about. Instance "orcl", status READY, has 1 handler(s) for this service... trcroute sales Trace Route Utility for Solaris: Version 10.1.0.2.0 on 15-NOV-2003 14:43:05 Copyright (c) 1999 Oracle Corporation. In this scenario, the client requires a connect identifier of sales.mktg.acme.jp (cn.ou.o.c). http://stackoverflow.com/questions/19966848/tnsping-ok-but-sqlplus-gives-ora-12154
Select the OracleHOME_NAMETNSListener service—the service name if you are using the default listener name LISTENER—or OracleHOME_NAMETNSListenerlsnr, where lsnr is the nondefault listener name. Oracle is running on a VM. life efforts. The server does not need to start up any new processes or deal with dummy connections.
Then try to connect with sqlplus. Browse other questions tagged oracle oracle11g sqlplus ora-12514 or ask your own question. It is working :) Jul 19 '05 #4 This discussion thread is closed Start new discussion Replies have been disabled for this discussion. Sqlplus Ora-12154 I already tried restarting and it still gives the same error.
If you can connect successfully from a client to a server (or a server to another server) using the TNSPING utility, it displays an estimate of the round trip time (in Report message to a moderator Re: TNSping ok..can't connect with sqlPlus ...just stopped working [message #334668 is a reply to message #334663] Thu, 17 July 2008 11:04 nohacks Oracle 10g Slackware 10 install 2.6.6 kernel exports ORACLE_BASE=/home/oracle ORACLE_HOME=/home/oracle/product/10g ORACLE_SID=ora9i ORACLE_TERM=xterm error in sqlplus: bash-2.05b$ sqlplus wells/[email protected] SQL*Plus: Release 10.1.0.2.0 - Production on Wed Aug 18 11:30:06 2004 Copyright (c) https://www.experts-exchange.com/questions/26705072/tnsping-is-working-but-can-not-connect-to-db.html Used parameter files: C:\oracle\product\10.2.0\network\admin\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = localhost)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME
I tried connecting to other databases on the same server and they are just working fine. Tnsping Not Working I suggest doing the following: #SQLNET.AUTHENTICATION_SERVICES= (NTS) or alternatively remove the line entirely from sqlnet.ora Report message to a moderator Re: TNSping ok..can't connect with sqlPlus ...just stopped Instance "orcl", status READY, has 1 handler(s) for this service... To define a default connect identifier, use the TWO_TASK environment variable on UNIX platforms or the LOCAL environment variable or registry entry on Windows.
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 http://www.in-oracle.com/Oracle-DBA/maintenance/ORA-12514-tnsping-works.php Action: - Wait a moment and try to connect a second time. - Check which services are currently known by the listener by executing: lsnrctl services
Please provide 2 lists. 1) Names,alias,SID,ServiceName of database to which you can connect 2) Names,alias,SID,ServiceName of database to which you can NOT connect Post results from following command: SET Last edited From the command line, enter: lsnrctl LSNRCTL> STATUS [listener_name] where listener_name is the name of the listener defined in the listener.ora file. Figure 15-2 depicts this example. For most folks, they don't know, what they don't know. Ora 12154 Tns Could Not Resolve The Connect Identifier Specified 11g
Related 3Oracle 11g Listener not working1Oracle server connection reset by peer socket write error1check listener status other than 15211Oracle 11g R2 on CentOS 6.3, and Net Configuration Assistant1Unable to create a Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account. (LogOut/Change) You are Oracle RAC Interview Question & Answer. Testing Network Connectivity from the Client To test several different clients in your network, initiate a connection to a database server from each of them by following the instructions in "Entering
If an error occurs, TRCROUTE collects error information that shows where the error occurred. Tnsping Failed To Resolve Name Handler(s): "DEDICATED" established:55 refused:0 state:ready LOCAL SERVER Service "orclXDB" has 1 instance(s). Example: Successful Trace Route The following example shows a successful Trace Route packet that traveled from a client to a listener.
Experience comes from bad judgement. To stop the listener, enter: LSNRCTL> SET PASSWORD password LSNRCTL> STOP [listener_name] SET PASSWORD is only required if the password is set in the listener.ora file. In Oracle : Oracle Oracle Applications EBS 11i, R12 Oracle Database Data Warehouse & BI Oracle Middleware PL/SQL Linux ... Oracle DBA Real Application Cluster (RAC) Oracle RAC Overview Oracle How To Check Oracle Client Version 32 Bit Or 64 Bit Windows If the listener is not running, go to Step 3.
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. -- Tns error struct: ns main err code: 12638 TNS-12638: Credential retrieval failed ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: Service "XEXDB" has 1 instance(s). http://txtbl.com/could-not/cannot-connect-to-host-port-23.html Even if the listener is running, stop the listener, and start it again before proceeding to Step 2.
The service name you have must not match a service name being listened to on the database server. 0 Message Author Closing Comment by:el1232010-12-28 Guru ... :-) 0 LVL All rights reserved. Oracle 10g Slackware 10 install 2.6.6 kernel exports ORACLE_BASE=/home/oracle ORACLE_HOME=/home/oracle/product/10g ORACLE_SID=ora9i ORACLE_TERM=xterm error in sqlplus: bash-2.05b$ sqlplus wells/[email protected] SQL*Plus: Release 10.1.0.2.0 - Production on Wed Aug 18 11:30:06 2004 Copyright (c) Create a free website or blog at WordPress.com. %d bloggers like this: Members Search Help Register Login Home Home» RDBMS Server» Server Administration» TNSping ok..can't connect with sqlPlus ...just stopped
There are about 3-4 DB's I can't connect to. JDBC Thin Drivers support absolute naming only when the complete DN is used. ORA-12154: TNS:could not resolve the connect identifier specified TNSPING works OK C:\Documents and Settings\user1>tnsping ORCL TNS Ping Utility for 64-bit Windows: Version 220.127.116.11.0 - Production on 12-NOV-2013 12:41:14 Copyright (c) 1997, This way, a connect identifier does not need to be specified in the connect string.
All rights reserved. You will need to contact the DBA's on the server to provide you with the correct entries for your tnsnames.ora file. 0 LVL 40 Overall: Level 40 Unix OS 27 Service "orcl" has 1 instance(s). Commonly used methods are described in these topics: Connecting from the Operating System to Test a Client Connecting from the Tool Logon Screen to Test a Client Connecting from 3GL to
Enter password: ERROR: ORA-12505: TNS:listener does not currently know of SID given in connect descriptor ====================================================== What did that sqlnet.auth do? This instance has been stable and working fine for a year or more until today, a Monday morning. Each of the general methods listed is briefly covered here. Testing assumes the database and listener are running.
Teenage daughter refusing to go to school Do students wear muggle clothing while not in classes at Hogwarts (like they do in the films)?