blocks|key|2881035|text|检查数据库是否已启动。登录到服务器，将SQL环境变量设置为您的数据库SID，并将ORACLE_SID+*Plus作为本地连接运行。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2881036|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Check to see the database is up. Log onto the server, set the ORACLE_SID environment variable to your database SID, and run SQL*Plus as a local connection.

blocks|key|223715|text|当应用程序为每个数据库交互建立新连接或连接未正确关闭时，可能会发生此错误。Oracle+Sql+developer是监视和确认这一点的免费工具之一(尽管这不是您可以用来监视数据库会话的唯一工具)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|223716|您可以从oracle站点Sql+Developer下载该工具。|offset|length|223717|以下是如何监控会话的屏幕截图。(如果您在看到ORA-12514错误时看到应用程序用户的许多会话堆积起来，那么这很好地表明您可能存在连接池问题)。|223718|​|223719|📷|atomic|223720|223721|entityMap|0|LINK|mutability|MUTABLE|url|http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html|1|IMAGE|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/037b75340821ccf04dec6dccc69986fb.png|imageAlt^0|0|C|D|0|0|0|0|0|1|1|0|0^^$0|@$1|2|3|4|5|6|7|11|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|12|8|@]|9|@$D|13|E|14|1|15]]|A|$]]|$1|F|3|G|5|6|7|16|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|17|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|18|8|@]|9|@$D|19|E|1A|1|1B]]|A|$]]|$1|M|3|I|5|6|7|1C|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]]|O|$P|$5|Q|R|S|A|$T|U]]|V|$5|W|R|X|A|$Y|Z|10|-4]]]]

This error can occur when an application makes a new connection for every database interaction or the connections are not closed properly. One of the free tools to monitor and confirm this is Oracle Sql developer (although this is not the only tool you can use to monitor DB sessions).

you can download the tool from oracle site <a href="http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html" rel="nofollow noreferrer">Sql Developer</a>

here is a screenshot of how to monitor you sessions. (if you see many sessions piling up for your application user during when you see the ORA-12514 error then it's a good indication that you may have connection pool problem).

<img src="https://i.stack.imgur.com/qId5o.png" alt="enter image description here">

blocks|key|227104|text|我遇到了这个问题，修复方法是确保tnsnames.ora中的SERVICE_NAME是数据库中的有效服务名称。要查找有效的服务名，可以在oracle中使用以下查询：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|227105|select+value+from+v$parameter+where+name='service_names'|code-block|syntax|javascript|227106|一旦我将tnsnames.ora更新为：|227107|TEST+=
+++(DESCRIPTION+=
++++(ADDRESS_LIST+=
++++++(ADDRESS+=+(PROTOCOL+=+TCP)(HOST+=+*<validhost>*)(PORT+=+*<validport>*))
++++)
++++(CONNECT_DATA+=
++++++(SERVER+=+DEDICATED)
++++++(SERVICE_NAME+=+*<servicenamefromDB>*)
++++)
)|227108|然后我运行：|227109|sqlplus+user@TEST|227110|成功！监听程序基本上是在告诉您，根据DB，无论您使用的是什么service_name，都不是有效的服务。|227111|(*我从Win7客户端工作站到远程数据库运行sqlplus，并责怪DBA+;)+*)|227112|entityMap^0|G|C|U|C|0|0|4|C|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@$9|Z|A|10|B|C]|$9|11|A|12|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|13|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|14|8|@$9|15|A|16|B|C]]|D|@]|E|$]]|$1|M|3|N|5|H|7|17|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|18|8|@]|D|@]|E|$]]|$1|Q|3|R|5|H|7|19|8|@]|D|@]|E|$I|J]]|$1|S|3|T|5|6|7|1A|8|@]|D|@]|E|$]]|$1|U|3|V|5|6|7|1B|8|@]|D|@]|E|$]]|$1|W|3|-4|5|6|7|1C|8|@]|D|@]|E|$]]]|X|$]]

I had this issue and the fix was to make sure in <code>tnsnames.ora</code> the <code>SERVICE_NAME</code> is a valid service name in your database. To find out valid service names, you can use the following query in oracle:

<pre><code>select value from v$parameter where name='service_names'
</code></pre>

Once I updated <code>tnsnames.ora</code> to:

<pre><code>TEST =
 (DESCRIPTION =
 (ADDRESS_LIST =
 (ADDRESS = (PROTOCOL = TCP)(HOST = *&lt;validhost&gt;*)(PORT = *&lt;validport&gt;*))
 )
 (CONNECT_DATA =
 (SERVER = DEDICATED)
 (SERVICE_NAME = *&lt;servicenamefromDB&gt;*)
 )
)
</code></pre>

then I ran:

<pre><code>sqlplus user@TEST
</code></pre>

Success! 
The listener is basically telling you that whatever service_name you are using isn't a valid service according to the DB. 

(*I was running sqlplus from Win7 client workstation to remote DB and blame the DBAs ;) *)

blocks|key|3095137|text|我在Windows+server+2008+R2和Oracle11g上遇到了此问题|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|3095138|3095139|转到网络管理器>监听程序>从组合框中选择数据库服务>“全局数据库名”必须与"SID“相同，并且"Oracle主目录”必须正确。|blockquote|3095140|3095141|3095142|如果您没有任何数据库服务条目，请创建一个条目并设置正确的全局数据库、sid和oracle+home。|CODE|3095143|entityMap^0|2|M|P|9|0|0|0|0|0|Y|3|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]|$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|V|8|@]|D|@]|E|$]]|$1|G|3|H|5|I|7|W|8|@]|D|@]|E|$]]|$1|J|3|-4|5|6|7|X|8|@]|D|@]|E|$]]|$1|K|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]|$1|L|3|M|5|6|7|Z|8|@$9|10|A|11|B|N]]|D|@]|E|$]]|$1|O|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|P|$]]

I had this issue at Windows server 2008 R2 and Oracle 11g

<blockquote>
 go to Net Manager > Listener > select database services form the combox > "Global Database Name" must be same as "SID" and "Oracle Home Directory" must be correct.
</blockquote>

If you don't have any entry for database services, create one and set correct global database , <code>sid</code> and oracle home.

blocks|key|3095165|text|我知道这是一个老问题，但仍然没有答案。我花了一天的时间研究，但我找到了最简单的解决方案，至少在我的案例中(Windows2008+R2上的Oracle11.2)，我想分享一下。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3095166|如果直接查看该错误，则表明侦听器无法识别服务名称。但是它将服务名称保存在哪里呢？在%25ORACLE_HOME%25\NETWORK\ADMIN\listener.ora中|offset|length|style|CODE|3095167|"SID_LIST“只是SID和服务名称的列表，它们以您可以复制或查找的格式配对。|3095168|我添加了有问题的服务名称，然后在Windows“服务”控制面板中，我对Oracle侦听器服务进行了“重新启动”。现在一切都好了。|3095169|3095170|例如，您的listener.ora文件最初可能如下所示：|3095171|#+listener.ora+Network+Configuration+File:+C:\app\oracle_user\product\12.1.0\dbhome_1\network\admin\listener.ora
#+Generated+by+Oracle+configuration+tools.

SID_LIST_LISTENER+=
++(SID_LIST+=
++++(SID_DESC+=
++++++(SID_NAME+=+CLRExtProc)
++++++(ORACLE_HOME+=+C:\app\oracle_user\product\12.1.0\dbhome_1)
++++++(PROGRAM+=+extproc)
++++++(ENVS+=+"EXTPROC_DLLS=ONLY:C:\app\oracle_user\product\12.1.0\dbhome_1\bin\oraclr12.dll")
++++)
++)

LISTENER+=
++(DESCRIPTION_LIST+=
++++(DESCRIPTION+=
++++++(ADDRESS+=+(PROTOCOL+=+TCP)(HOST+=+localhost)(PORT+=+1521))
++++++(ADDRESS+=+(PROTOCOL+=+IPC)(KEY+=+EXTPROC1521))
++++)
++)|code-block|syntax|javascript|3095172|..。要使其识别orcl的服务名称，您可以将其更改为：|3095173|#+listener.ora+Network+Configuration+File:+C:\app\oracle_user\product\12.1.0\dbhome_1\network\admin\listener.ora
#+Generated+by+Oracle+configuration+tools.

SID_LIST_LISTENER+=
++(SID_LIST+=
++++(SID_DESC+=
++++++(SID_NAME+=+CLRExtProc)
++++++(ORACLE_HOME+=+C:\app\oracle_user\product\12.1.0\dbhome_1)
++++++(PROGRAM+=+extproc)
++++++(ENVS+=+"EXTPROC_DLLS=ONLY:C:\app\oracle_user\product\12.1.0\dbhome_1\bin\oraclr12.dll")
++++)
++++(SID_DESC+=+
++++++++(GLOBAL_DBNAME+=+orcl)
++++++++(ORACLE_HOME+=+C:\app\oracle_user\product\12.1.0\dbhome_1)
++++++++(SID_NAME+=+orcl)
++++)
++)

LISTENER+=
++(DESCRIPTION_LIST+=
++++(DESCRIPTION+=
++++++(ADDRESS+=+(PROTOCOL+=+TCP)(HOST+=+localhost)(PORT+=+1521))
++++++(ADDRESS+=+(PROTOCOL+=+IPC)(KEY+=+EXTPROC1521))
++++)
++)|3095174|entityMap^0|0|15|14|0|0|0|0|0|0|8|4|0|0^^$0|@$1|2|3|4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|10|8|@$D|11|E|12|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|13|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|14|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|15|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|16|8|@]|9|@]|A|$]]|$1|O|3|P|5|Q|7|17|8|@]|9|@]|A|$R|S]]|$1|T|3|U|5|6|7|18|8|@$D|19|E|1A|F|G]]|9|@]|A|$]]|$1|V|3|W|5|Q|7|1B|8|@]|9|@]|A|$R|S]]|$1|X|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]]|Y|$]]

I know this is an old question, but still unanswered. It took me a day of research, but I found the simplest solution, at least in my case (Oracle 11.2 on Windows 2008 R2) and wanted to share.

The error, if looked at directly, indicates that the listener does not recognize the service name. But where does it keep service names? In <code>%ORACLE_HOME%\NETWORK\ADMIN\listener.ora</code>

The "SID_LIST" is just that, a list of SIDs and service names paired up in a format you can copy or lookup.

I added the problem Service Name, then in Windows "Services" control panel, I did a "Restart" on the Oracle listener service. Now all is well.

<hr>

For example, your listener.ora file might initially look like:

<pre><code># listener.ora Network Configuration File: C:\app\oracle_user\product\12.1.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
 (SID_LIST =
 (SID_DESC =
 (SID_NAME = CLRExtProc)
 (ORACLE_HOME = C:\app\oracle_user\product\12.1.0\dbhome_1)
 (PROGRAM = extproc)
 (ENVS = "EXTPROC_DLLS=ONLY:C:\app\oracle_user\product\12.1.0\dbhome_1\bin\oraclr12.dll")
 )
 )

LISTENER =
 (DESCRIPTION_LIST =
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
 (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
 )
 )
</code></pre>

... And to make it recognize a service name of <code>orcl</code>, you might change it to:

<pre><code># listener.ora Network Configuration File: C:\app\oracle_user\product\12.1.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
 (SID_LIST =
 (SID_DESC =
 (SID_NAME = CLRExtProc)
 (ORACLE_HOME = C:\app\oracle_user\product\12.1.0\dbhome_1)
 (PROGRAM = extproc)
 (ENVS = "EXTPROC_DLLS=ONLY:C:\app\oracle_user\product\12.1.0\dbhome_1\bin\oraclr12.dll")
 )
 (SID_DESC = 
 (GLOBAL_DBNAME = orcl)
 (ORACLE_HOME = C:\app\oracle_user\product\12.1.0\dbhome_1)
 (SID_NAME = orcl)
 )
 )

LISTENER =
 (DESCRIPTION_LIST =
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
 (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
 )
 )
</code></pre>

blocks|key|223752|text|在我的例子中，数据库已经用完了磁盘空间。这导致它没有反应。一旦我弄清楚了这个问题，一切都会恢复正常。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|223753|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

In my case the database had ran out of disk space. Which caused it to not respond. Once I cleared up that issue everything worked again.

blocks|key|3095212|text|我也曾面临过同样的问题，花了3天时间才把它找出来。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3095213|这是由于您的TNS服务输入错误造成的。|3095214|首先检查是否能够使用sql+>+sqlplus++sys@orastand+as+sysdba从主数据库连接到备用数据库(orastand是备用数据库)。|offset|length|style|CODE|3095215|如果您不能连接，那么这是服务的问题。更正主端TNS文件中的服务名称条目。|3095216|用同样的方法检查备用数据库。如果需要，也可以在此处进行更改。|3095217|确保log_archive_dest_2参数具有正确的服务名称。|3095218|entityMap^0|0|0|G|V|1P|8|0|0|0|2|I|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|T|8|@$F|U|G|V|H|I]|$F|W|G|X|H|I]]|9|@]|A|$]]|$1|J|3|K|5|6|7|Y|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|Z|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|10|8|@$F|11|G|12|H|I]]|9|@]|A|$]]|$1|P|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|Q|$]]

I had also faced the same problem and spent 3 days to dig it out. 

This happens because of your wrong TNS service entry. 

First check whether you are able to connect to standby database from primary database using sql > <code>sqlplus sys@orastand as sysdba</code> (<code>orastand</code> is a standby database). 

If you are not able to connect then it is a problem with the service. Correct the entry of service name in TNS file at primary end. 

Check standby database the same way. Make the changes here too if required. 

Make sure the <code>log_archive_dest_2</code> parameter has the correct service name.

blocks|key|227123|text|我在我的linux环境中解决了这个问题，在/etc/hosts文件中更新了我机器的IP。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|227124|您可以验证您的网络IP+(+network。)通过以下方式：|227125|$ifconfig|code-block|syntax|javascript|227126|查看您的IP是否与/etc/hosts文件匹配：|227127|$cat+/etc/hosts|227128|编辑/etc/hosts文件(如果需要)：|227129|$sudo+gedit+/etc/hosts|227130|再见。|227131|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|Y|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|Z|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|10|8|@]|9|@]|A|$G|H]]|$1|Q|3|R|5|6|7|11|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

I resolved this issue in my linux enviroment updating the IP of my machine in /etc/hosts file.

You can verify your network IP (inet end.) with:

<pre><code>$ifconfig
</code></pre>

See if your IP matches with /etc/hosts file:

<pre><code>$cat /etc/hosts
</code></pre>

Edit your /etc/hosts file, if nedded:

<pre><code>$sudo gedit /etc/hosts
</code></pre>

Bye.

blocks|key|3095258|text|我也有同样的问题。对我来说，只是写作|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3095259|sqlplus+myusername/mypassword@localhost|code-block|syntax|javascript|3095260|我想，这样做可以让它连接到默认的服务名称。|3095261|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I had the same problem. For me, just writing 

<pre><code>sqlplus myusername/mypassword@localhost
</code></pre>

did the trick, doing so makes it connect to the default service name, I guess.

blocks|key|223786|text|在Windows中，从services.msc启动OracleServiceXXX对我来说很有效。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|223787|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Starting the OracleServiceXXX from the services.msc worked for me in Windows.

blocks|key|227159|text|对于那些可能在VM中运行Oracle的人(比如我)，我看到了这个问题，因为我的VM内存不足，这似乎阻止了OracleDB的正确启动/运行。增加我的VM内存并重新启动解决了这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|227160|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

For those that may be running Oracle in a VM (like me) I saw this issue because my VM was running out of memory, which seems to have prevented OracleDB from starting up/running correctly. Increasing my VM memory and restarting fixed the issue.

blocks|key|227166|text|对我有效的方法非常简单，我只需要在"Windows+Services“(+cmd+trompt中的services.msc)中手动启动服务即可。我的服务名称是:+OracleServiceXXXXX。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|227167|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

what worked for me was really simple, I just needed to initiate the service manually in the "Windows Services" (services.msc in cmd trompt).
my service name is: OracleServiceXXXXX.

blocks|key|227169|text|对我来说，这是由使用动态ipadress的安装引起的。我使用静态ipadress重新安装了Oracle，然后一切正常|type|unstyled|depth|inlineStyleRanges|entityRanges|data|227170|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

For me this was caused by using a dynamic ipadress using installation. I reinstalled Oracle using a static ipadress and then everything was fine

blocks|key|223830|text|这真的应该是对Brad+Rippe的回答的一个评论，但遗憾的是，这还不够。这个答案让我走了90%25的路。在我的例子中，数据库的安装和配置将我正在运行的数据库的条目放在了tnsnames.ora文件中。首先，我能够通过设置环境变量(Windows)连接到数据库：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|223831|set+ORACLE_SID=mydatabase
set+ORACLE_HOME=C:\Oracle\product\11.2.0\dbhome_1|code-block|syntax|javascript|223832|，然后使用|223833|sqlplus+/+as+sysdba|223834|接下来，根据Brad+Rippe的回答运行命令：|223835|select+value+from+v$parameter+where+name='service_names';|223836|显示这些名字并不完全匹配。使用Oracle的Database+Configuration+Assistant创建的条目最初位于以下位置：|223837|MYDATABASE+=
++(DESCRIPTION+=
++++(ADDRESS+=+(PROTOCOL+=+TCP)(HOST+=+mylaptop.mydomain.com)(PORT+=+1521))
++++(CONNECT_DATA+=
++++++(SERVER+=+DEDICATED)
++++++(SERVICE_NAME+=+mydatabase.mydomain.com)
++++)
++)+|223838|查询中的服务名称只是mydatabase而不是mydatabase.mydomain.com。我将tnsnames.ora文件编辑为只包含基本名称而不包含域部分，因此它们看起来如下所示：|style|CODE|223839|MYDATABASE+=
++(DESCRIPTION+=
++++(ADDRESS+=+(PROTOCOL+=+TCP)(HOST+=+mylaptop.mydomain.com)(PORT+=+1521))
++++(CONNECT_DATA+=
++++++(SERVER+=+DEDICATED)
++++++(SERVICE_NAME+=+mydatabase)
++++)
++)+|223840|我重新启动了TNS+Listener服务(我经常从管理员命令窗口或Windows+Powershell使用lsnrctl+stop和lsnrctl+start，而不是从服务控制面板，但两者都可以工作。)在那之后，我就能联系上了。|223841|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/users/979521/brad-rippe^0|7|A|0|0|0|0|0|0|0|0|0|A|A|N|N|0|0|1H|C|1U|D|0^^$0|@$1|2|3|4|5|6|7|1A|8|@]|9|@$A|1B|B|1C|1|1D]]|C|$]]|$1|D|3|E|5|F|7|1E|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|1F|8|@]|9|@]|C|$]]|$1|K|3|L|5|F|7|1G|8|@]|9|@]|C|$G|H]]|$1|M|3|N|5|6|7|1H|8|@]|9|@]|C|$]]|$1|O|3|P|5|F|7|1I|8|@]|9|@]|C|$G|H]]|$1|Q|3|R|5|6|7|1J|8|@]|9|@]|C|$]]|$1|S|3|T|5|F|7|1K|8|@]|9|@]|C|$G|H]]|$1|U|3|V|5|6|7|1L|8|@$A|1M|B|1N|W|X]|$A|1O|B|1P|W|X]]|9|@]|C|$]]|$1|Y|3|Z|5|F|7|1Q|8|@]|9|@]|C|$G|H]]|$1|10|3|11|5|6|7|1R|8|@$A|1S|B|1T|W|X]|$A|1U|B|1V|W|X]]|9|@]|C|$]]|$1|12|3|-4|5|6|7|1W|8|@]|9|@]|C|$]]]|13|$14|$5|15|16|17|C|$18|19]]]]

This really should be a comment to <a href="https://stackoverflow.com/users/979521/brad-rippe">Brad Rippe</a>'s answer, but alas, not enough rep. That answer got me 90% of the way there. In my case, the installation and configuration of the databases put entries in the tnsnames.ora file for the databases I was running. First, I was able to connect to the database by setting the environment variables (Windows):

<pre><code>set ORACLE_SID=mydatabase
set ORACLE_HOME=C:\Oracle\product\11.2.0\dbhome_1
</code></pre>

and then connecting using

<pre><code>sqlplus / as sysdba
</code></pre>

Next, running the command from Brad Rippe's answer:

<pre><code>select value from v$parameter where name='service_names';
</code></pre>

showed that the names didn't match exactly. The entries as created using Oracle's Database Configuration Assistant where originally:

<pre><code>MYDATABASE =
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = mylaptop.mydomain.com)(PORT = 1521))
 (CONNECT_DATA =
 (SERVER = DEDICATED)
 (SERVICE_NAME = mydatabase.mydomain.com)
 )
 ) 
</code></pre>

The service name from the query was just <code>mydatabase</code> rather than <code>mydatabase.mydomain.com</code>. I edited the tnsnames.ora file to just the base name without the domain portion so they looked like this:

<pre><code>MYDATABASE =
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = mylaptop.mydomain.com)(PORT = 1521))
 (CONNECT_DATA =
 (SERVER = DEDICATED)
 (SERVICE_NAME = mydatabase)
 )
 ) 
</code></pre>

I restarted the TNS Listener service (I often use <code>lsnrctl stop</code> and <code>lsnrctl start</code> from an administrator command window [or Windows Powershell] instead of the Services control panel, but both work.) After that, I was able to connect.

blocks|key|226687|text|在我的情况下，错误是由于监听器没有注册数据库的服务。我通过注册服务解决了这个问题。示例：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|226688|我在tnsnames.ora中的描述符|offset|length|style|CODE|226689|LOCALDB+=
++(DESCRIPTION+=
++++(ADDRESS+=+(PROTOCOL+=+TCP)(HOST+=+localhost)(PORT+=+1521))
++++(CONNECT_DATA+=
++++++(SERVER+=+DEDICATED)
++++++(SERVICE_NAME+=+LOCALDB)
++++)
++)|code-block|syntax|javascript|226690|因此，我继续在listener.ora中手动注册服务：|226691|SID_LIST_LISTENER+=
++++(SID_DESC+=
++++++(GLOBAL_DBNAME+=+LOCALDB)
++++++(ORACLE_HOME+=+C:\Oracle\product\11.2.0\dbhome_1)
++++++(SID_NAME+=+LOCALDB)
++++)|226692|最后，通过命令重新启动监听器：|226693|>+lsnrctl+stop
>+lsnrctl+start|226694|完成了！|226695|entityMap^0|0|2|C|0|0|7|C|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@$D|10|E|11|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|12|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|13|8|@$D|14|E|15|F|G]]|9|@]|A|$]]|$1|O|3|P|5|J|7|16|8|@]|9|@]|A|$K|L]]|$1|Q|3|R|5|6|7|17|8|@]|9|@]|A|$]]|$1|S|3|T|5|J|7|18|8|@]|9|@]|A|$K|L]]|$1|U|3|V|5|6|7|19|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]]|X|$]]

In my circumstances the error was due to the fact the listener did not have the db's service registered. I solved this by registering the services. Example:

My descriptor in <code>tnsnames.ora</code>:

<pre><code>LOCALDB =
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
 (CONNECT_DATA =
 (SERVER = DEDICATED)
 (SERVICE_NAME = LOCALDB)
 )
 )
</code></pre>

So, I proceed to register the service in the <code>listener.ora</code> manually:

<pre><code>SID_LIST_LISTENER =
 (SID_DESC =
 (GLOBAL_DBNAME = LOCALDB)
 (ORACLE_HOME = C:\Oracle\product\11.2.0\dbhome_1)
 (SID_NAME = LOCALDB)
 )
</code></pre>

Finally, restart the listener by command:

<pre><code>&gt; lsnrctl stop
&gt; lsnrctl start
</code></pre>

Done!

blocks|key|2881418|text|我收到了相同的错误，因为指定的远程SID是错误的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2881419|+>+sqlplus+$DATASOURCE_USERNAME/$DATASOURCE_PASSWORD@$DB_SERVER_URL/$REMOTE_SID+|code-block|syntax|javascript|2881420|我查询了系统数据库：|2881421|select+*+from+global_name；|2881422|找到了我的远程SID+("XE")。|2881423|然后我就可以毫无问题地进行连接了。|2881424|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

I got the same error because the remote SID specified was wrong:

<pre><code> &gt; sqlplus $DATASOURCE_USERNAME/$DATASOURCE_PASSWORD@$DB_SERVER_URL/$REMOTE_SID 
</code></pre>

I queried the system database:

select * from global_name;

and found my remote SID ("XE").

Then I could connect without any problem.

blocks|key|228983|text|我已经实现了下面的解决方法来解决这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|228984|我已使用命令提示符设置了ORACLE_HOME+(右键单击cmd.exe并以系统administrator).|228985|Used身份运行下面的命令|unordered-list-item|228986|228987|从下拉列表中选择set+oracle_home="path+to+the+oracle+home"|offset|length|style|CODE|228988|Go+to+Listener|BOLD|228989|
|228990|Select+All+programs+-->+Oracle+-ora+home1+-->+Configuration+migration+tools+-->+Net+Manager+-->+Oracle数据库服务。全局数据库名称和SID都设置为相同(在我的示例中为ORCL)。设置Oracle主目录。|228991|228992|Oracle文档中的oracle+Net+Manager窗口示例：|228993|📷|atomic|228994|​|228995|单击文件并保存网络configuration.，然后保存|228996|ordered-list-item|228997|228998|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/208f48da83fb5466ce3f9ec474d3749d.gif|imageAlt^0|0|0|0|0|8|15|0|6|8|0|0|7|C|1A|T|28|B|0|0|0|0|1|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1G|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1H|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|1I|8|@]|9|@]|A|$]]|$1|G|3|-4|5|6|7|1J|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|1K|8|@$J|1L|K|1M|L|M]]|9|@]|A|$]]|$1|N|3|O|5|F|7|1N|8|@$J|1O|K|1P|L|P]]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1Q|8|@]|9|@]|A|$]]|$1|S|3|T|5|F|7|1R|8|@$J|1S|K|1T|L|P]|$J|1U|K|1V|L|P]|$J|1W|K|1X|L|P]]|9|@]|A|$]]|$1|U|3|-4|5|6|7|1Y|8|@]|9|@]|A|$]]|$1|V|3|W|5|6|7|1Z|8|@]|9|@]|A|$]]|$1|X|3|Y|5|Z|7|20|8|@]|9|@$J|21|K|22|1|23]]|A|$]]|$1|10|3|11|5|6|7|24|8|@]|9|@]|A|$]]|$1|12|3|13|5|6|7|25|8|@]|9|@]|A|$]]|$1|14|3|-4|5|15|7|26|8|@]|9|@]|A|$]]|$1|16|3|-4|5|6|7|27|8|@]|9|@]|A|$]]|$1|17|3|-4|5|6|7|28|8|@]|9|@]|A|$]]]|18|$19|$5|1A|1B|1C|A|$1D|1E|1F|-4]]]]

I have implemented below workaround to resolve this issue.

<ol>
<li>I have set the ORACLE_HOME using command prompt
(right click cmd.exe and Run as System administrator).</li>
<li>Used below command

<code>set oracle_home="path to the oracle home"</code></li>
<li>Go to All programs --> Oracle -ora home1 --> Configuration migration tools --> Net Manager --> Listener</li>
<li>Select Database Services from dropdown. 
Both Global database name and SID are set to the same (ORCL in my case).
Set Oracle Home Directory.</li>
</ol>

Oracle Net Manager window example from oracle documentation:
<a href="https://docs.oracle.com/cd/A91202_01/901_doc/network.901/a90154/listenea.gif" rel="nofollow noreferrer"><img src="https://docs.oracle.com/cd/A91202_01/901_doc/network.901/a90154/listenea.gif" alt="Oracle Net Manager example"></a>

<ol start="5">
<li>Click on File and save network configuration.</li>
</ol>

blocks|key|227339|text|重新启动虚拟机对我很有效|type|unstyled|depth|inlineStyleRanges|entityRanges|data|227340|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

blocks|key|229019|text|我的问题已通过将URL中的“‘SID”替换为“服务名称”和正确的主机来解决。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|229020|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

My issue was resolved by replacing the'SID' in URL with 'service name' and correct host.

blocks|key|3095608|text|tnslsnr已启动，但数据库已关闭。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3095609|对于oracle新手来说，当连接被接受时，数据库可能会关闭并不明显。|3095610|我不得不像那样手动启动数据库|3095611|su+-+oracle
export+ORACLE_SID=XE
sqlplus+sys+as+sysdba|code-block|syntax|javascript|3095612|然后在sql控制台中|3095613|startup|3095614|在我的例子中，我无法启动，但得到了另一条错误消息，并找到了问题的根源-我必须更改主机名，然后数据库自动启动又可以工作了。|3095615|entityMap^0|0|7|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|Z|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|10|8|@]|D|@]|E|$]]|$1|J|3|K|5|L|7|11|8|@]|D|@]|E|$M|N]]|$1|O|3|P|5|6|7|12|8|@]|D|@]|E|$]]|$1|Q|3|R|5|L|7|13|8|@]|D|@]|E|$M|N]]|$1|S|3|T|5|6|7|14|8|@]|D|@]|E|$]]|$1|U|3|-4|5|6|7|15|8|@]|D|@]|E|$]]]|V|$]]

<code>tnslsnr</code> is up but database is down.

For oracle novice it is not obvious that database may be down while connections are accepted.

I had to start up database manually like that

<pre><code>su - oracle
export ORACLE_SID=XE
sqlplus sys as sysdba
</code></pre>

And then in sql console

<pre><code>startup
</code></pre>

In my case i failed to startup but got another error message and found the source of a problem - i had to change host name and then database auto startup was functional again.

blocks|key|3095650|text|问题是我的连接字符串url包含数据库名称，而不是SID。用oracle数据库连接SID代替数据库名解决了这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3095651|要了解您的oracle+SID，可以浏览tnsnames.ora文件。|offset|length|style|CODE|3095652|XE是实际的SID，所以这是我的tomcat连接字符串现在的样子：|3095653|++++<Resource
+++++++name="jdbc/my_db_conn"
+++++++auth="Container"
+++++++type="javax.sql.DataSource"
+++++++driverClassName="oracle.jdbc.driver.OracleDriver"
+++++++url="jdbc:oracle:thin:@//127.0.0.1:1521/XE"
+++++++username="test_user"
+++++++password="test"+/>|code-block|syntax|javascript|3095654|我的服务器版本是“Oracle11.2Express”，但解决方案也应该适用于其他版本。|3095655|entityMap^0|0|K|C|0|0|2|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@$D|U|E|V|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|W|8|@$D|X|E|Y|F|G]]|9|@]|A|$]]|$1|J|3|K|5|L|7|Z|8|@]|9|@]|A|$M|N]]|$1|O|3|P|5|6|7|10|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|R|$]]

The problem was that my connection string url contained database name instead of SID.
Replacing database name with oracle database connection SID solved this problem.

To know your oracle SID's you can browse <code>tnsnames.ora</code> file.

<code>XE</code> was the actual SID, so this is how my tomcat connection string looks like now:

<pre><code> &lt;Resource
 name="jdbc/my_db_conn"
 auth="Container"
 type="javax.sql.DataSource"
 driverClassName="oracle.jdbc.driver.OracleDriver"
 url="jdbc:oracle:thin:@//127.0.0.1:1521/XE"
 username="test_user"
 password="test" /&gt;
</code></pre>

My server version was "Oracle 11.2 Express", but solution should work on other versions too.

blocks|key|3095672|text|在我的例子中，tnsnames.ora文件中缺少SERVICE_NAME周围的圆括号。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3095673|<DBNAME>+=
++(DESCRIPTION+=
++++(ADDRESS_LIST+=
+++++(ADDRESS+=+(PROTOCOL=TCP)(HOST+=+nupark-cnvr-ora+)(PORT=1521))
++++)
++++(CONNECT_DATA+=
++++(SERVER+=+DEDICATED)
++++(SERVICE_NAME+=+<DBNAME>+***CLOSING+ROUND+BRACKET+WAS+MISSING+HERE***
++++)
++)

LISTENER_<DBNAME>+=

++(ADDRESS+=+(PROTOCOL+=+TCP)(HOST+=+nupark-cnvr-ora)(PORT+=+1521))|code-block|syntax|javascript|3095674|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

In my case, round brackets around the SERVICE_NAME was missing in the tnsnames.ora file.

<pre><code>&lt;DBNAME&gt; =
 (DESCRIPTION =
 (ADDRESS_LIST =
 (ADDRESS = (PROTOCOL=TCP)(HOST = nupark-cnvr-ora )(PORT=1521))
 )
 (CONNECT_DATA =
 (SERVER = DEDICATED)
 (SERVICE_NAME = &lt;DBNAME&gt; ***CLOSING ROUND BRACKET WAS MISSING HERE***
 )
 )

LISTENER_&lt;DBNAME&gt; =

 (ADDRESS = (PROTOCOL = TCP)(HOST = nupark-cnvr-ora)(PORT = 1521))
</code></pre>

blocks|key|2881674|text|适用于那些使用spring-boot和jdbc进行连接的用户。在用application.properties编写jdbcUrl时必须小心|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2881675|在数据库连接中使用SID+-+source.datasource.jdbcUrl+=+jdbc:oracle:thin:@[HOST][:PORT]:SID|offset|length|style|CODE|2881676|使用db连接globe.datasource.jdbcUrl+=+jdbc:oracle:thin:@//[HOST][:PORT]/SERVICE中的服务名|2881677|这对我很有效:)|2881678|entityMap^0|0|F|1R|0|6|1W|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@$D|P|E|Q|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@$D|S|E|T|F|G]]|9|@]|A|$]]|$1|J|3|K|5|6|7|U|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|M|$]]

For thoses Who are using spring-boot and jdbc for connection.
You have to be careful while writing jdbcUrl in application.properties 

With SID in Database connection - 
 <code>source.datasource.jdbcUrl = jdbc:oracle:thin:@[HOST][:PORT]:SID</code>

With Service name in db connection
 <code>globe.datasource.jdbcUrl = jdbc:oracle:thin:@//[HOST][:PORT]/SERVICE</code>

This worked for me :)

blocks|key|2881692|text|我有一个使用DBMS的案例，我必须填写一个数据库连接表。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2881693|我将SID放入Database字段，在字段旁边的下拉列表中，我使用的是'Service+Name‘值，而不是'SID’值。|2881694|(通常我不使用Oracle数据库，所以我没有意识到其中的区别)|2881695|这就是我收到错误消息的原因。|2881696|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

I had a case that I used DBMS where I had to fulfill a db connection form.
I put SID into the Database field and in the dropdown, next to the field, I had had 'Service Name' value instead of 'SID' value. 
(normally I don't use Oracle database so I've not been aware of the difference)
That was the reason I got the error message.

blocks|key|224026|text|问题可能出在错误的URL中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|224027|例如，我正在使用Oracle数据库(在VM内部)和Spring框架，并且遇到了这个问题。|224028|我的application.properties文件中有：|224029|spring.datasource.url=jdbc:oracle:thin:@//localhost:1521/orcl12c|code-block|syntax|javascript|224030|但是db版本是不同的：|224031|spring.datasource.url=jdbc:oracle:thin:@//localhost:1521/orclcdb|224032|可以在Oracle+tnsnames.ora文件中找到正确的URL+(该文件可在服务器上找到，因此如果您使用VM，则应在主机VM内查找该文件)。例如，对于VirtualBox中的Oracle，查看此文件的命令为：|offset|length|style|BOLD|224033|nano+/u01/app/oracle/product/version/db_1/network/admin/tnsnames.ora|224034|entityMap^0|0|0|0|0|0|0|14|1U|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|10|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|11|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|12|8|@]|9|@]|A|$]]|$1|M|3|N|5|H|7|13|8|@]|9|@]|A|$I|J]]|$1|O|3|P|5|6|7|14|8|@$Q|15|R|16|S|T]]|9|@]|A|$]]|$1|U|3|V|5|H|7|17|8|@]|9|@]|A|$I|J]]|$1|W|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|X|$]]

The problem can be in the incorrect URL.
For example, I'm using Oracle database (inside VM) with Spring framework and having this issue.
I had in my application.properties file:
<pre><code>spring.datasource.url=jdbc:oracle:thin:@//localhost:1521/orcl12c
</code></pre>
But the db version was defferent:
<pre><code>spring.datasource.url=jdbc:oracle:thin:@//localhost:1521/orclcdb
</code></pre>
The correct URL can be found in the tnsnames.ora file (this file would be available where the Oracle server, so if you using VM, you should look for this file inside your host VM).
For example for Oracle in the VirtualBox the command to see this file is:
<pre><code>nano /u01/app/oracle/product/version/db_1/network/admin/tnsnames.ora
</code></pre>

blocks|key|2881877|text|在我的Linux环境中，ORACLE_HOME/bin中的oracle文件以"Red“的颜色突出显示，具有不同的权限，如下所示：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|CODE|entityRanges|data|2881878|📷|atomic|2881879|​|2881880|我更改了该文件的权限，如下所示：|2881881|1)停止+->+sudo+systemctl+stop+oracle.service|2881882|2)修改oracle文件在ORACLE_HOME/bin目录下的权限为"sudo+chmod777+oracle“|2881883|3)启动->+sudo+systemctl+start+oracle.service|2881884|然后，在此更改之后，我使用lsnrctl+status.Here检查了listener的状态，我可以看到db实例已成功加载。|2881885|但是，我只能使用sqldeveloper连接，使用sqlplus命令行时，我收到了ORA-12547:+TNS+Lost+Contact错误。因此，这可以为使用sqldeveloper提供一个快速的解决方案。|2881886|注意：在更改权限之前备份oracle文件。|2881887|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/05e416ac62ff174d8ff731dee56bedb7.jpeg|imageAlt^0|3|5|13|3|C|F|0|0|1|0|0|0|0|0|4|8|Y|0|0|2|10|K|D|F|0|0|2|7|Z|0|D|E|0|8|C|2R|5|15|R|0|0|L|0^^$0|@$1|2|3|4|5|6|7|18|8|@$9|19|A|1A|B|C]|$9|1B|A|1C|B|C]|$9|1D|A|1E|B|D]]|E|@]|F|$]]|$1|G|3|H|5|I|7|1F|8|@]|E|@$9|1G|A|1H|1|1I]]|F|$]]|$1|J|3|K|5|6|7|1J|8|@]|E|@]|F|$]]|$1|L|3|M|5|6|7|1K|8|@]|E|@]|F|$]]|$1|N|3|O|5|6|7|1L|8|@$9|1M|A|1N|B|C]|$9|1O|A|1P|B|D]]|E|@]|F|$]]|$1|P|3|Q|5|6|7|1Q|8|@$9|1R|A|1S|B|C]|$9|1T|A|1U|B|C]|$9|1V|A|1W|B|D]]|E|@]|F|$]]|$1|R|3|S|5|6|7|1X|8|@$9|1Y|A|1Z|B|C]|$9|20|A|21|B|D]]|E|@]|F|$]]|$1|T|3|U|5|6|7|22|8|@$9|23|A|24|B|C]]|E|@]|F|$]]|$1|V|3|W|5|6|7|25|8|@$9|26|A|27|B|C]|$9|28|A|29|B|C]|$9|2A|A|2B|B|D]]|E|@]|F|$]]|$1|X|3|Y|5|6|7|2C|8|@$9|2D|A|2E|B|C]]|E|@]|F|$]]|$1|Z|3|-4|5|6|7|2F|8|@]|E|@]|F|$]]]|10|$11|$5|12|13|14|F|$15|16|17|-4]]]]

In my case for Linux environment, the oracle file at <code>ORACLE_HOME/bin</code> was highlighted in &quot;Red&quot; color with different permissions as below: 
<a href="https://i.stack.imgur.com/GJsVS.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/GJsVS.jpg" alt="enter image description here" /></a>
I changed the permissions of this file as below:
1) Stop Oracle -&gt; <code>sudo systemctl stop oracle.service</code> 
2) Change the permission of oracle file at <code>ORACLE_HOME/bin</code> directory as &quot;sudo chmod 777 oracle&quot; 
3) Start Oracle -&gt; <code>sudo systemctl start oracle.service</code>
Then after this change, I checked the status of listener using lsnrctl status.Here, I can see the db instances loaded successfully.
However, I can connect using sqldeveloper only, with sqlplus command line I'm getting <code>ORA-12547: TNS Lost Contact</code> error. So, this can a quick workaround to use sqldeveloper.
Note: Take a backup of oracle file before changing the permissions.

blocks|key|3095900|text|对于Dbeaver用户:尝试在连接设置中选择"SID“而不是”服务名称“。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3095901|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

For Dbeaver users: try selecting &quot;SID&quot; instead of &quot;Service name&quot; in connection settings.

We have an application running locally where we're experiencing the following error:

<blockquote>
 ORA-12514: TNS:listener does not currently know of service requested
 in connect descriptor
</blockquote>

I've tested the connection using <code>TNSPing</code> which resolved correctly and
I tried <code>SQLPlus</code> to try connecting, which failed with the same error as above. I used this syntax for <code>SQLPlus</code>:

<pre><code>sqlplus username/password@addressname[or host name]
</code></pre>

We have verified that:

<ul>
<li>the TNS Listener on the server is running. </li>
<li>Oracle itself on the server is running. </li>
</ul>

We don't know of any changes that were made to this environment. 
Anything else we can test?

ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

我们有一个应用程序在本地运行，我们遇到了以下错误： ORA-12514: TNS:侦听器当前不知道连接描述符中请求的服务我已经使用正确解析的TNSPing测试了连接，并且我尝试了SQLPlus来尝试连接，但失败了，出现了与上面相同的错误。我在SQLPlus中使用了以下语法sqlplus username/passwor...

问ORA-12514 TNS:侦听器当前不知道连接描述符中请求的服务
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问ORA-12514 TNS:侦听器当前不知道连接描述符中请求的服务EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问ORA-12514 TNS:侦听器当前不知道连接描述符中请求的服务
EN