1、检查监听器状态:
lsnrctl status
2、启动停止监听器。
启动监听器:
lsnrctl start
停止监听器:
lsnrctl stop
3、打开本地数据库对应的服务:
net start OracleService数据库sid
如:
net start OracleServiceORCL
4、关闭oradb数据库服务
net stop OracleService数据库sid
5、启动iSQL*Plus
net start OracleOraDb10g_home1iSQL*Plus
Oracle服务启动和停止脚本如下:
启动oracle
net start OracleServiceORCL
net start OracleJobSchedulerORCL
net start OracleOraDb10g_home1iSQL*Plus
net start OracleOraDb10g_home1TNSListener
em:
net start OracleDBConsoleORCL
emctl start dbconsole
停止oracle
net stop OracleJobSchedulerORCL
net stop OracleOraDb10g_home1iSQL*Plus
net stop OracleOraDb10g_home1TNSListener
net stop OracleServiceORCL
net stop OracleDBConsoleORCL