How to start/stop DB instance of Oracle under Linux
来源:互联网 发布:福彩双色球预测软件 编辑:程序博客网 时间:2024/05/08 16:02
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
0 0
- How to start/stop DB instance of Oracle under Linux
- How to stop&start Oracle EBS Server(DB Server&Apps Server)
- How to start and stop exe
- Oracle 11g Data Guard: How to start and stop Redo Apply
- how to logon Oracle DB
- How to use "chmod" under linux
- How to run scripts under Linux
- how to debug MudOS under linux
- How to start/restart/stop apache server on ubuntu
- How To Start / Restart / Stop Network and Routing Service
- how to start and stop android service by using adb
- How to start stop restart mysql on Mac
- Oracle: How to stop a (MTS) dispatcher process – mad behaviour of ALTER SYSTEM
- How to stop linux sendmail service
- How to stop 'uninterruptible' process on Linux?
- An instance of “(null)” is already running. Choose “Stop” to terminate and launch a new instance.
- How to start a DB job by batch file
- How to Remote Access Oracle DB
- IMP同库Type对象导入报错ORA-02304
- iOS 修改搜索控件canel
- 使用jQuery获取窗口高和宽
- Python核心编程学习笔记(七)
- su与sudo的区别
- How to start/stop DB instance of Oracle under Linux
- js 防复制
- Java加密技术(四)——非对称加密算法RSA
- 一次渗透录
- java.sql.BatchUpdateException: Field 'id' doesn't have a default value
- 非ARC中添加ARC的设置
- compute关键字
- android 语音识别程序
- S3C2416裸机开发系列十五_GCC下uCOS的移植(2)