windows下oracle命令行启动

1、confirm oracle service and listener is running

lsnrctl status

lsnrctl stop/start

net start/stop oracleserviceorcl

    if oracle service is off, ora-12560 error occurs

 

2、sqlplus /nolog

     conn / as sysdba

     or

     sqlplus / as sysdba

 

3、shutdown immediate

     startup