首页 > 代码库 > How to start/stop DB instance of Oracle under Linux
How to start/stop DB instance of Oracle under Linux
All below actions should be executed with "oracle" user account
1. Check the status of listener
$ lsnrctl status
2. If the listener isn‘t be started, start it
$ lsnrctl start
3. Set the "ORACLE_SID" environment to the DB instance‘s SID which you want to start, for example
$ export ORACLE_SID=PC855
4. Start sqlplus and start the DB instance
$ sqlplus "/as sysdba"
SQL> startup
5. If you want to stop the DB instance
$ sqlplus "/as sysdba"
SQL> shutdown immediate
6. Check the DB instance status again
$ lsnrctl status
Notes:
1. Make sure the listener be started before starting the DB instance2. Make sure the ORACLE_SID environment has been set correctly
3. To configure the listener
$ netca
or
$ netmgr
4. To configure the DB instance
$ dbca
How to start/stop DB instance of Oracle under Linux
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。