ORA-12514 TNS 监听程序当前无法识别连接描述符中请求服务

问题描述：服务器、本地打开plsql，报错“ORA-12514 TNS 监听程序当前无法识别连接描述符中请求服务”

刚开始试的时候，用startup mount,报错“ORACLE not available”

解决方法：

1、保证数据库服务已启动

2、startup，启动数据库。

进入cmd:

>sqlplus /nolog

SQL>connect sys/system as sysdba

SQL>startup

参考：http://www.adp-gmbh.ch/ora/sqlplus/startup.html

startup [SQL*Plus]
		startupstartup nomount startup mount startup restrict startup open recover startup pfile = /path/to/init.ora startup  starts (creates) an   Oracle instance. While the instance is created, Oracle reads   init.ora  or an   spfile. In order to startup an instance, one needs to be connected   as sysdba  or   as sysoper. An instance is terminated with   shutdown. Options startup nomount Only the   instance  is started. That is the   SGA  is allocated and the   background processes  are started. Neither   controlfiles  are mounted nor database opened. startup mount Instance is started and   controlfiles  mounted, but database not opened. startup Instance is started and   controlfiles  mounted and database opened. startup restrict startup restrict  is similar to   startup, however, Oracle then allows only users with restricted privileges to access the database. pfile The   pfile=init.ora  indicates the location and name of the   init.ora  file that the instance reads when it is started. This method is used when the init.ora file is to be taken from a non   default location  or has a non default name.