问题描述:服务器、本地打开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.
Optionsstartup 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 restrictstartup 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.
|