blocks|key|2309152|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2309153|转到承载Oracle数据库服务器的Windows机器上，|ordered-list-item|2309154|转到windows中启动->+Run+->+Services.msc。定位OracleService+<+SID+>(此处为OracleServiceORCL)，并单击Start启动oracle数据库服务(如果尚未运行)+|offset|length|style|CODE|2309155|2309156|📷|atomic|2309157|​|2309158|2309159|一旦启动并运行，在命令提示符下运行以下命令：|2309160|2309161|tnsping+<+tnsalias+>|2309162|(tnsalias条目可以在tnsnames.ora文件中找到)|2309163|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/a2b8973bad5efd8b79d8248264ce6697.png|imageAlt^0|0|0|1Q|H|2C|5|0|0|0|1|0|0|0|0|0|0|0|E|C|0^^$0|@$1|2|3|-4|4|5|6|16|7|@]|8|@]|9|$]]|$1|A|3|B|4|C|6|17|7|@]|8|@]|9|$]]|$1|D|3|E|4|C|6|18|7|@$F|19|G|1A|H|I]|$F|1B|G|1C|H|I]]|8|@]|9|$]]|$1|J|3|-4|4|5|6|1D|7|@]|8|@]|9|$]]|$1|K|3|L|4|M|6|1E|7|@]|8|@$F|1F|G|1G|1|1H]]|9|$]]|$1|N|3|O|4|5|6|1I|7|@]|8|@]|9|$]]|$1|P|3|-4|4|5|6|1J|7|@]|8|@]|9|$]]|$1|Q|3|R|4|C|6|1K|7|@]|8|@]|9|$]]|$1|S|3|-4|4|5|6|1L|7|@]|8|@]|9|$]]|$1|T|3|U|4|5|6|1M|7|@]|8|@]|9|$]]|$1|V|3|W|4|5|6|1N|7|@$F|1O|G|1P|H|I]]|8|@]|9|$]]|$1|X|3|-4|4|5|6|1Q|7|@]|8|@]|9|$]]]|Y|$Z|$4|10|11|12|9|$13|14|15|-4]]]]

<ol>
<li>Go to the windows machine that hosts the Oracle database server </li>
<li>Go to Start -> Run -> Services.msc in Windows.
Locate OracleService &lt; SID > (here <code>OracleServiceORCL</code>) and click on <code>Start</code> to start the oracle database service (if not already running)
<img src="https://i.stack.imgur.com/AEjdq.png" alt="Services"></li>
<li>Once it is up and running, from the command prompt run the following: 

<pre><code>tnsping &lt; tnsalias &gt; 
</code></pre>

(tnsalias entry you can find it in <code>tnsnames.ora</code> file)</li>
</ol>

blocks|key|2309260|text|在我的例子中，我在WindowsServices.msc中没有OracleService+(OracleServiceORCL)，正如Bharathi's+answer所描述的那样。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2309261|我执行了以下命令：|2309262|C:\>+ORADIM+-NEW+-SID+ORCL|code-block|syntax|javascript|2309263|然后，名为OracleService的OracleServiceORCL出现了，并在Services.msc启动。真的很好。|2309264|2309265|来源：https://forums.oracle.com/forums/message.jspa?messageID=4044655#4044655|2309266|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/6904462/114029|1|https://forums.oracle.com/forums/message.jspa?messageID=4044655#4044655^0|G|C|V|D|1V|H|0|0|0|0|5|D|0|0|3|1Z|1|0^^$0|@$1|2|3|4|5|6|7|11|8|@$9|12|A|13|B|C]|$9|14|A|15|B|C]]|D|@$9|16|A|17|1|18]]|E|$]]|$1|F|3|G|5|6|7|19|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|1A|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|1B|8|@$9|1C|A|1D|B|C]]|D|@]|E|$]]|$1|O|3|-4|5|6|7|1E|8|@]|D|@]|E|$]]|$1|P|3|Q|5|6|7|1F|8|@]|D|@$9|1G|A|1H|1|1I]]|E|$]]|$1|R|3|-4|5|6|7|1J|8|@]|D|@]|E|$]]]|S|$T|$5|U|V|W|E|$X|Y]]|Z|$5|U|V|W|E|$X|10]]]]

In my case I didn't have an <code>OracleService</code> (OracleServiceORCL) in Windows <code>Services.msc</code> as described in <a href="https://stackoverflow.com/a/6904462/114029">Bharathi's answer</a>.

I executed this command:

<pre><code>C:\&gt; ORADIM -NEW -SID ORCL
</code></pre>

and then the <code>OracleService</code> called OracleServiceORCL just showed up and got started in Services.msc. Really nice.

<hr>

Source: <a href="https://forums.oracle.com/forums/message.jspa?messageID=4044655#4044655" rel="noreferrer">https://forums.oracle.com/forums/message.jspa?messageID=4044655#4044655</a>

blocks|key|2309222|text|好像数据库还没打开。这可能是因为重新启动机器，并且实例没有被设置为自动启动，并且在从服务屏幕启动之后也没有以普通方式启动。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2309223|只是去命令提示符|2309224|oracle_sid=ORCL|2309225|Now+|unordered-list-item|2309226|设置Oracle+C:>set运行Net+命令。oracleserviceORCL|ordered-list-item|offset|length|style|BOLD|2309227|+C:>net+start|2309228|2309229|entityMap^0|0|0|0|0|9|W|0|1|C|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|6|7|W|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@]|A|$]]|$1|I|3|J|5|K|7|Y|8|@$L|Z|M|10|N|O]]|9|@]|A|$]]|$1|P|3|Q|5|6|7|11|8|@$L|12|M|13|N|O]]|9|@]|A|$]]|$1|R|3|-4|5|6|7|14|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|T|$]]

Seems like database is not up. It might be due to restarting machine and the instance is not set to autostart and it so not started munually after starting from services Screen.

Just goto Command prompt

<ol>
<li>Set Oracle SID
C:>set oracle_sid=ORCL</li>
<li>Now run Net start command.
C:>net start oracleserviceORCL</li>
</ol>

blocks|key|2309355|text|在命令控制台上，如果收到此错误，可以通过键入|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2309356|c:\>+sqlplus+/nolog|code-block|syntax|javascript|2309357|然后你就可以连接|2309358|SQL>+conn+user/pass+@host:port/service|2309359|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

from command console, if you get this error you can avoid it by typing
<pre><code>c:\&gt; sqlplus /nolog
</code></pre>
then you can connect
<pre><code>SQL&gt; conn user/pass @host:port/service
</code></pre>

blocks|key|637833|text|向环境中添加以下变量和值，以标识tnsnames.ora文件的位置：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|637834|TNS_ADMIN|637835|C:\oracle\product\10.2.0\client_1\network\admin|637836|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

Add to the enviroment vars the following varibale and value to identify the place of the tnsnames.ora file:

TNS_ADMIN

C:\oracle\product\10.2.0\client_1\network\admin

blocks|key|639791|text|在我的例子中(对于OracleExpress)，服务正在运行，但是当我试图通过sqlplus访问数据库时，没有连接标识符时，我遇到了这个问题：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|639792|sqlplus+sys/mypassword+as+sysdba++|code-block|syntax|javascript|639793|为了使其工作，我需要添加连接标识符(用于Oracle+Express的XE)，因此下面的命令工作正常：|639794|sqlplus+sys/mypassword@XE+as+sysdba|639795|如果您仍然得到ORA-12560，请确保您可以ping+XE服务。使用：|639796|tnsping+XE|639797|您应该获得OK消息以及完整连接字符串(tnsping命令位于oracle的安装dir:+oracle速成安装dir\app\oracle\product\11.2.0\server\bin)中。如果您不能ping，请确保您的tnsnames.ora文件可访问sqlplus。您可能需要设置指向文件所在的管理目录的TNS_ADMIN环境变量，例如：|offset|length|style|CODE|639798|TNS_ADMIN=[oracle+express+installation+dir]\app\oracle\product\11.2.0\server\network\ADMIN|639799|entityMap^0|0|0|0|0|0|0|34|C|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|10|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|12|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|14|8|@$Q|15|R|16|S|T]]|9|@]|A|$]]|$1|U|3|V|5|D|7|17|8|@]|9|@]|A|$E|F]]|$1|W|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|X|$]]

In my case (for OracleExpress) the service was running, but I got this issue when trying to access the database via sqlplus without connection identifier:

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

To make it work I needed to add the connection identifier (XE for Oracle Express), so following command worked ok:

<pre><code>sqlplus sys/mypassword@XE as sysdba
</code></pre>

If you still get ORA-12560, make sure you can ping the XE service. Use:

<pre><code>tnsping XE
</code></pre>

And you should get OK message along with full connection string (tnsping command is located in oracle's installation dir: [oracle express installation dir]\app\oracle\product\11.2.0\server\bin). If you can not ping make sure your <code>tnsnames.ora</code> file is reachable for sqlplus. You might need to set TNS_ADMIN environment variable pointing to your ADMIN directory, where the file is located, for example:

<pre><code>TNS_ADMIN=[oracle express installation dir]\app\oracle\product\11.2.0\server\network\ADMIN
</code></pre>

blocks|key|2309312|text|经过大量的搜索，得到了一个简单的解决方法。跟着台阶走。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2309313|2309314|检查侦听器的状态。类型为lsnrctl+status|ordered-list-item|offset|length|style|CODE|2309315|You的|2309316|打开命令提示符将不会得到listener.|2309317|2309318|2309319|​|2309320|现在，C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN+|2309321|打开listener.ora文件，该文件位于以下目录中：|unordered-list-item|2309322|2309323|1.+Open+that+file+and+change+the+host+parameter+with+you+computer+name
2.+You+can+get+your+computer+name+by+right+click+on+`My+Computer`+and+check+you+computer+name,+and+replace+host+parameter+with+your+computer+name+as+follows:|code-block|syntax|javascript|2309324|LISTENER+=++++++(DESCRIPTION_LIST+=++++++++++(DESCRIPTION+=++++++++++++++(ADDRESS+=+(PROTOCOL+=+IPC)(KEY+=+EXTPROC1))++++++++++++++(ADDRESS+=+(PROTOCOL+=+TCP)(HOST+=+Electron-PC)(PORT+=+1521)++++++++++)++++++)+)|2309325|所以在这里你可以观察到HOST+=+Electron-PC，这是我的计算机名。|2309326|3.保存listener.ora文件并再次返回到cammand|2309327|3.在命令提示符lsnrctl+start中键入以下内容|2309328|这将启动OracleTNSListner。|2309329|您可以通过打开任务管理器的“服务”选项卡在服务中检查它。如果没有自动启动，您可以启动它。|2309330|只要这么多，你就准备好再一次在甲骨文上工作。|2309331|最好的运气。|2309332|entityMap^0|0|0|C|E|0|1|1|0|0|0|3|1M|0|2|C|0|0|0|0|5V|0|B|I|0|0|8|D|0|4|G|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1K|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|1L|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|1M|8|@$F|1N|G|1O|H|I]]|9|@]|A|$]]|$1|J|3|K|5|E|7|1P|8|@]|9|@]|A|$]]|$1|L|3|M|5|E|7|1Q|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|1R|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|1S|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1T|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|1U|8|@$F|1V|G|1W|H|I]]|9|@]|A|$]]|$1|T|3|U|5|V|7|1X|8|@$F|1Y|G|1Z|H|I]]|9|@]|A|$]]|$1|W|3|-4|5|6|7|20|8|@]|9|@]|A|$]]|$1|X|3|Y|5|Z|7|21|8|@]|9|@]|A|$10|11]]|$1|12|3|13|5|6|7|22|8|@$F|23|G|24|H|I]]|9|@]|A|$]]|$1|14|3|15|5|6|7|25|8|@$F|26|G|27|H|I]]|9|@]|A|$]]|$1|16|3|17|5|6|7|28|8|@]|9|@]|A|$]]|$1|18|3|19|5|6|7|29|8|@$F|2A|G|2B|H|I]]|9|@]|A|$]]|$1|1A|3|1B|5|6|7|2C|8|@$F|2D|G|2E|H|I]]|9|@]|A|$]]|$1|1C|3|1D|5|6|7|2F|8|@]|9|@]|A|$]]|$1|1E|3|1F|5|6|7|2G|8|@]|9|@]|A|$]]|$1|1G|3|1H|5|6|7|2H|8|@]|9|@]|A|$]]|$1|1I|3|-4|5|6|7|2I|8|@]|9|@]|A|$]]]|1J|$]]

After searching alot got a simple way to solve it.
Just follow the steps.

<ol>
<li>Check status of your listener.

<ol>
<li>open command prompt and type <code>lsnrctl status</code></li>
<li>You will get no listener.</li>
</ol></li>
<li>Now open <code>listener.ora</code> file which is present in following directory: <code>C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN</code>

<ol>
<li>Open that file and change the host parameter with you computer name</li>
<li>You can get your computer name by right click on <code>My Computer</code> and check you computer name, and replace host parameter with your computer name as follows:

<code>LISTENER =
 (DESCRIPTION_LIST =
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
 (ADDRESS = (PROTOCOL = TCP)(HOST = Electron-PC)(PORT = 1521)
 )
 )
)</code>

So here you can observe <code>HOST = Electron-PC</code>, which is my computer name.</li>
<li>Save the listener.ora file and again return to cammand propt</li>
</ol>

3.Type the following in command prompt <code>lsnrctl start</code></li>
</ol>

This will start the <code>OracleTNSListner</code>.

you can check it in the service by opening services tab of Task Manager. if not started automatically you can start it.

Just this much and you are ready to work again on oracle.

Best of Luck.

blocks|key|637801|text|这通常意味着侦听器还没有启动。检查服务面板。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|637802|在Windows上，另一个常见的原因是注册表中没有定义ORACLE_SID。要么编辑注册表，要么在CMD框中设置ORACLE_SID。(因为您想运行sqlplusw.exe，所以建议您编辑注册表。)|637803|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Quite often this means that the listener hasn't started. Check the Services panel. 

On Windows (as you are) another common cause is that the ORACLE_SID is not defined in the registry. Either edit the registry or set the ORACLE_SID in a CMD box. (Because you want to run sqlplusw.exe I suggest you edit the registry.)

blocks|key|2289554|text|我用简单的方法解决了这个问题。我的神谕过去运行得很好。安装之后，我注意到了这个问题。我刚刚在我的机器上卸载了MS，问题就解决了。请确保在此之后重新启动计算机。现在，我可以通过SQLPlus再次连接到Oracle数据库。我猜这两个人之间有冲突。希望这能有所帮助。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2289555|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|$]]

I have solved the problem the easy way. My oracle was running just fine in the past. After I installed MS SQL Server was when I noticed this problem. I just uninstalled MS SQL Server on my machine then the problem was gone. Make sure you restart your computer after that. Now I can connect to Oracle database through SQLPlus again. My guess is that there's some conflict between the two. Hope this helps.

blocks|key|2309377|text|另一个可能适用于me...considering的解决方案是使用本地登录作为dba权限。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2309378|按照步骤到达服务。右键单击实例并转到“登录”？(可能不是名称，但它是包含权限的选项卡之一)。更改设置以使用本地设置。|2309379|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Another possible solution that just worked for me...considering I was using my local login as the dba permissions. 

Follow the steps to get to Services. Right click on the instance and go to 'Log On'? (might not be the name but it's one of the tabs containing permissions). Change the settings to use LOCAL.

blocks|key|2309289|text|如果没有上述工作，那么尝试以下操作:修改LISTENER.ora+(在：oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora中可以找到我的)+==>添加一个指向数据库(+SID+)的自定义侦听器，例如my是XZ0301，因此：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2309290|##+Base+XZ03001

SID_LIST_LISTENER_XZ03001=(SID_LIST=(SID_DESC=(ORACLE_HOME+=
E:\oracle\product\11.2.0\dbhome_1)(SID_NAME=+XZ03001)))

LISTENER_XZ03001=(DESCRIPTION_LIST=(ADDRESS=(PROTOCOL+=
TCP)(HOST=MyComputerName)(PORT=+1521)))

DIAG_ADR_ENABLED_LISTENER_XZ03001=ON

ADR_BASE_LISTENER_XZ03001=E:\oracle|code-block|syntax|javascript|2309291|重新启动机器|2309292|对于Windows7，请使用以下内容修改LISTENER.ora：-+Go+to+Start+>+All+Program>+as右键单击记事本，然后单击。-+File>open并导航到tnsnames.ora文件。-进行更改，然后它将允许您保存|2309293|entityMap^0|K|C|10|1L|0|0|0|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|G|5|H|7|V|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|W|8|@]|D|@]|E|$]]|$1|M|3|N|5|6|7|X|8|@]|D|@]|E|$]]|$1|O|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]]|P|$]]

If none the above work, then try this :
Modify the <code>LISTENER.ora</code> (mine is found in : <code>oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora</code>) ==> add a custom listener that points to your database(SID), example my SID is XZ0301, so :

<pre><code>## Base XZ03001

SID_LIST_LISTENER_XZ03001=(SID_LIST=(SID_DESC=(ORACLE_HOME =
E:\oracle\product\11.2.0\dbhome_1)(SID_NAME= XZ03001)))

LISTENER_XZ03001=(DESCRIPTION_LIST=(ADDRESS=(PROTOCOL =
TCP)(HOST=MyComputerName)(PORT= 1521)))

DIAG_ADR_ENABLED_LISTENER_XZ03001=ON

ADR_BASE_LISTENER_XZ03001=E:\oracle
</code></pre>

Restart your machine

For Windows 7, use the following to modify the LISTENER.ora:
 - Go to Start > All Programs > Accessories
 - Right click Notepad and then click Run as Administrator .
 - File>open and navigate to the tnsnames.ora file.
 - Make the changes then it should allow you to save

blocks|key|639756|text|它真的在我的机器上工作了。但我没有找到OracleServiceORCL，而是找到了OracleServiceXE。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|639757|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|$]]

It really has worked on my machine. But instead of OracleServiceORCL I found OracleServiceXE.

blocks|key|2309444|text|流动的台阶：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2309445|$Oracle_home\product\11.2.0\client_1\NETWORK\ADMIN位置中的|2309446|编辑listener.ora和tnsnames.ora文件|ordered-list-item|2309447|2309448|a.添加listener.ora文件|2309449|侦听器=+(DESCRIPTION_LIST+=+(DESCRIPTION+=+(ADDRESS+=+(PROTOCOL+=+IPC)(KEY+=+EXTPROC1521))+(ADDRESS+=+(PROTOCOL+=TCP)(主机=127.0.0.1)(端口=+1521))|2309450|)|2309451|ADR_BASE_LISTENER+=+C:这里c是oralce主目录|2309452|b.添加tnsnames.ora文件|2309453|++++SCHEMADEV+=
++++++++++++(DESCRIPTION+=
+++++++++++++++++++++(ADDRESS_LIST+=
+++++++++++++++++++++(ADDRESS+=+(PROTOCOL+=+TCP)(HOST+=+dabase_ip)(PORT+=+1521))
++++)
++++(CONNECT_DATA+=
++++++(SERVICE_NAME+=+SCHEMADEV)
++++)
++)|code-block|syntax|javascript|2309454|2309455|打开命令提示符并键入|2309456|2309457|sqlplus+username/passowrd@oracle_connection_alias|2309458|例子：|2309459|用户名:+your_database_username|2309460|+++++++password+:+Your\_database\_password|2309461|+++++++oracle\_connection\_alias+:+SCHEMADEV++for+above+example.|2309462|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1C|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1D|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|1E|8|@]|9|@]|A|$]]|$1|G|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|1G|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|1H|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|1I|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1J|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1K|8|@]|9|@]|A|$]]|$1|R|3|S|5|T|7|1L|8|@]|9|@]|A|$U|V]]|$1|W|3|-4|5|6|7|1M|8|@]|9|@]|A|$]]|$1|X|3|Y|5|F|7|1N|8|@]|9|@]|A|$]]|$1|Z|3|-4|5|6|7|1O|8|@]|9|@]|A|$]]|$1|10|3|11|5|6|7|1P|8|@]|9|@]|A|$]]|$1|12|3|13|5|6|7|1Q|8|@]|9|@]|A|$]]|$1|14|3|15|5|6|7|1R|8|@]|9|@]|A|$]]|$1|16|3|17|5|T|7|1S|8|@]|9|@]|A|$U|V]]|$1|18|3|19|5|T|7|1T|8|@]|9|@]|A|$U|V]]|$1|1A|3|-4|5|6|7|1U|8|@]|9|@]|A|$]]]|1B|$]]

Flow the flowing steps :

<ol>
<li>Edit your listener.ora and tnsnames.ora file in 
$Oracle_home\product\11.2.0\client_1\NETWORK\ADMIN location

a. add listener.ora file

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

)</li>
</ol>

ADR_BASE_LISTENER = C: [here c is oralce home directory]

b. add in tnsnames.ora file

<pre><code> SCHEMADEV =
 (DESCRIPTION =
 (ADDRESS_LIST =
 (ADDRESS = (PROTOCOL = TCP)(HOST = dabase_ip)(PORT = 1521))
 )
 (CONNECT_DATA =
 (SERVICE_NAME = SCHEMADEV)
 )
 )
</code></pre>

<ol start="2">
<li>Open command prompt and type 
sqlplus username/passowrd@oracle_connection_alias</li>
</ol>

Example : username : your_database_username 
 password : Your_database_password 
 oracle_connection_alias : SCHEMADEV for above example.

blocks|key|639882|text|只要加起来，按照屏幕截图，选择本地帐户启动，如果没有选择。那就开始服务吧。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|639883|​|639884|📷|atomic|offset|length|639885|639886|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/ff14e8c73de1900c84bf928c1be9923a.png|imageAlt^0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@$G|V|H|W|1|X]]|A|$]]|$1|I|3|C|5|6|7|Y|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q|R|-4]]]]

Just to add up, follow the screenshot and choose local account to start if not selected. Then start the service.
<a href="https://i.stack.imgur.com/gIChA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gIChA.png" alt="enter image description here" /></a>

blocks|key|637791|text|您需要告诉SQLPlus您想要登录到哪个数据库。主机字符串需要是连接字符串或在TNSNames.ora文件中配置的别名。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|637792|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|$]]

You need to tell SQLPlus which database you want to log on to. Host String needs to be either a connection string or an alias configured in your TNSNames.ora file.

blocks|key|2289813|text|ORA-12560:+TNS:erro+de+adaptador+de+protocolo|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2289814|ORACLE_SID|2289815|make+|unordered-list-item|2289816|set+Environment变量:+ORACLE_BASE、ORACLE_HOME、|ordered-list-item|2289817|，确保您的用户是ORACLE_GROUP_NAME+(ORACLE_HOME)|2289818|的一部分，确保当您添加新的Oracle客户端:向路径env添加新路径时，确保文件ORACLE_HOME/network/admin/sqlnet.ora是:+SQLNET.AUTHENTICATION_SERVICES+=+(NTS)|2289819|(Windows)是小心的。变量会把事情搞砸。这个变量中的第一个条目产生了差异:证明ORACLE_HOME+(ORACLE_HOME/bin)中的sqlplus可执行文件位于路径env中的第一位。变量.|2289820|2289821|2289822|entityMap^0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|V|8|@]|9|@]|A|$]]|$1|G|3|H|5|I|7|W|8|@]|9|@]|A|$]]|$1|J|3|K|5|I|7|X|8|@]|9|@]|A|$]]|$1|L|3|M|5|I|7|Y|8|@]|9|@]|A|$]]|$1|N|3|O|5|I|7|Z|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|10|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|11|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|S|$]]

ORA-12560: TNS:erro de adaptador de protocolo

<ol>
<li>set Environment Variables: ORACLE_BASE, ORACLE_HOME, ORACLE_SID</li>
<li>make sure your user is part of ORACLE_GROUP_NAME (Windows)</li>
<li>make sure the file ORACLE_HOME/network/admin/sqlnet.ora is:
SQLNET.AUTHENTICATION_SERVICES = (NTS)</li>
<li>(Windows) Be carefull when you add a new Oracle client: adding a new path to the PATH env. variable can mess things up. The first entry in this variable makes a difference: certify that the sqlplus executable in the ORACLE_HOME (ORACLE_HOME/bin) comes first in the PATH env. variable.</li>
</ol>

blocks|key|2309595|text|我尝试两种选择：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2309596|使用cmd命令:+sqlplus+user_+name+/pass_word@orcl12C注释:运行在您的膝上型计算机|2309597|unordered-list-item|2309598|
中的OracleService名称的orcle12c+->名称|2309599|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|-4|5|E|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 try 2 option:
<ol>
<li>You change service OracleService in Service Tab -&gt; Running</li>
<li>Login with cmd command: sqlplus user_name/pass_word@orcl12C
Note: orcle12c -&gt; name of OracleService name run in you laptop</li>
</ol>

blocks|key|2289966|text|可以应用下面的修复来解决TNS+12560错误|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2289967|如果网络存在防火墙问题<代码>H+215<服务>H+116检查以下链接，|2289968|获取SQL*NET客户端软件|ordered-list-item|2289969|Set+$ORACLE_HOME和$PATH变量的最新修补程序(系统用户应该可以访问)|2289970|检查PC客户端H+210H+111检查<代码>D12>+|2289971|>D12如果网络存在防火墙或防病毒问题<代码>H+215H+116>检查windows服务是否有OracleXE或OracleORCL服务运行检查：H+217G+218|2289972|2289973|http://dba-oracle.com/t_sql_net_tracing.htm|2289974|entityMap|0|LINK|mutability|MUTABLE|url^0|C|9|0|1|2|7|1|4|C|H|5|1|7|A|1|S|5|22|A|1|0|0|17|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@$9|11|A|12|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|13|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|14|8|@$9|15|A|16|B|C]]|D|@]|E|$]]|$1|K|3|L|5|J|7|17|8|@$9|18|A|19|B|C]|$9|1A|A|1B|B|C]]|D|@]|E|$]]|$1|M|3|N|5|J|7|1C|8|@$9|1D|A|1E|B|C]]|D|@]|E|$]]|$1|O|3|P|5|J|7|1F|8|@$9|1G|A|1H|B|C]|$9|1I|A|1J|B|C]]|D|@]|E|$]]|$1|Q|3|-4|5|6|7|1K|8|@]|D|@]|E|$]]|$1|R|3|S|5|6|7|1L|8|@]|D|@$9|1M|A|1N|1|1O]]|E|$]]|$1|T|3|-4|5|6|7|1P|8|@]|D|@]|E|$]]]|U|$V|$5|W|X|Y|E|$Z|S]]]]

Below fixes can be applied to resolve <code>TNS 12560</code> error
<ol>
<li>Get Latest patch for <code>SQL*NET</code> client software</li>
<li>Set <code>$ORACLE_HOME</code> and <code>$PATH</code> variable (should be accessible for System user)</li>
<li>Check permissions on PC client</li>
<li>Check <code>$TNS_ADMIN</code> variable</li>
<li>Check if network has firewall or antivirus issues</li>
<li>Check if windows services Run &gt;&gt; Services.msc has OracleXE or OracleORCL service running
Check below link in case of net tracing error:</li>
</ol>
<a href="http://dba-oracle.com/t_sql_net_tracing.htm" rel="nofollow noreferrer">http://dba-oracle.com/t_sql_net_tracing.htm</a>

blocks|key|2309404|text|在我的例子中，(ORA-12560:+TNS协议适配器错误)会引发数据库连接问题，如数据库、用户名和密码。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2309405|一旦你解决了问题。最初，您必须检查连接详细信息，然后检查oracle服务和更多内容。|2309406|我漏掉了一些连接细节，所以只有我得到了TNS协议适配器错误，我会更改连接细节，它会很好地工作。|2309407|entityMap^0|8|L|0|H|6|0|J|A|U|G|0^^$0|@$1|2|3|4|5|6|7|L|8|@$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|R|8|@$9|S|A|T|B|C]|$9|U|A|V|B|C]]|D|@]|E|$]]|$1|J|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|K|$]]

In my case, (ORA-12560: TNS protocol adapter error)Issue cause of database connection issue like database, user name and password.

Once you got the issue. Initially you have to check connection details, after check the oracle service and further more.

I missed some connection details, So only i got TNS protocol adapter error, 
I will changed the connection details, It would be working fine.

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

I Google[d] for this error ORA-12560: TNS:protocol adaptor error but not able to find the actual reason and how to solve this error ?

Can anyone tell me a perfect solution to solve login problem.

ORA-12560: TNS:protocol adaptor error

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

​​我谷歌了这个错误ORA-12560: TNS:协议适配器错误，但无法找到实际原因，以及如何解决这个错误？有人能告诉我一个解决登录问题的完美解决方案吗？

问ORA-12560: TNS:协议适配器错误
EN

回答 19

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问ORA-12560: TNS:协议适配器错误EN

回答 19

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问ORA-12560: TNS:协议适配器错误
EN