Oracle Error 12514 Listener
Contents |
incorrectly. Action: Turn on tracing at the ADMIN level and reexecute the operation. Verify that the ORACLE Server executable is present and ora-12514 error in oracle 11g has execute permissions enabled. Ensure that the ORACLE environment is specified
Listener Refused The Connection With The Following Error Ora-12514
correctly in LISTENER.ORA. The Oracle Protocol Adapter that is being called may not be installed on the local ora-12514 solution hard drive. Please check that the correct Protocol Adapter are successfully linked. If error persists, contact Oracle Customer Support. ORA-12502: TNS:listener received no CONNECT_DATA from client Cause: No CONNECT_DATA ora-12514 oracle 12c was passed to the listener. Action: Check that the service name resolved from TNSNAMES.ORA has the CONNECT_DATA component of the connect descriptor. ORA-12504: TNS:listener was not given the SID in CONNECT_DATA Cause: The SID was missing from the CONNECT_DATA. Action: Check that the connect descriptor corresponding to the service name in TNSNAMES.ORA has an SID component in the CONNECT_DATA.
Ora-12514 Linux
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor Cause: The listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener specified a SID for an instance (usually a database instance) that either has not yet dynamically registered with the listener or has not been statically configured for the listener. This may be a temporary condition such as after the listener has started, but before the database instance has registered with the listener. Action: - Wait a moment and try to connect a second time. - Check which instances are currently known by the listener by executing: lsnrctl services
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
ora-12514 sql developer ORA-12514: TNS: listener could not resolve SERVICE_NAME Question: Here's my ora-12505 tns listener does not currently know of sid issue, causing a ORA-12514: TNS: listener could not resolve SERVICE_NAME error: CODE SQL> shutdown immediate Database closed. Database dismounted. ORACLE instanceTns-12514
shut down. SQL> startup mount ORACLE instance started. ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor I'm using Oracle 10g on Windows 2000. What's cause of this error and how to resolve it? Answer https://docs.oracle.com/cd/B19306_01/server.102/b14219/net12500.htm by Edward Stoever: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor Cause: The listener received a request to establish a connection to a database or other service. 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 been statically configured for the listener. This may be a http://www.dba-oracle.com/t_ora_12514_tns_listener_service_name.htm temporary condition such as after the listener has started, but before the database instance has registered with the listener. Action: - Wait a moment and try to connect a second time. - Check which services are currently known by the listener by executing: lsnrctl services
anOracleDB: 2012-10-17 15:59:55,818 WARN [http-7990-17] stash 959x29x1 1m1q59y 10.11.44.156 "POST /admin/db/edit HTTP/1.1" c.a.s.i.m.DefaultMigrationService A connection https://confluence.atlassian.com/stashkb/ora-12514-tns-listener-does-not-currently-know-of-service-requested-in-connect-descriptor-307038528.html could not be opened with the DataSource java.sql.SQLException: Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor ... Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently oracle error know of service requested in connect descriptor Cause Stash does not support connecting toOracle servers using a TNS Aliasor SID for identification - BSERV-4148 - Support connecting to Oracle with SID or TNS name Open . Resolution As currently Stash supportsconnecting to an Oracle DBonly oracle error 12514 using a Service Name (refer to the "Database Name" parameter on the table you'll see on this link) you'll need toconfigure a Service Name for your database and specify that as a connection parameter on the "Database Name" field. For more information what Service Name is, please refer to Defining Database Services. Was this helpful? Yes No Thanks for your feedback! Why was this unhelpful? It wasn't accurate It wasn't clear It wasn't relevant Submit feedback Cancel Have a question about this article? See questions about this article Powered by Confluence and Scroll Viewport Atlassian Support Ask the community Provide product feedback Contact technical support Atlassian Privacy Policy Terms of use Security Copyright © 2016 Atlassian Except where otherwise noted, content in this space is licensed under a Creative Commons Attribution 2.5 Australia License.