- 论坛徽章:
- 0
|
1 启动数据库监听<br /> <br /> su -Oracle——切换Oracle用户(如果使用su oracle ,则启动时不运行.profile用户环境配置文件)<br /> <br /> $ lsnrctl start——启动监听<br /> <br /> 2 启动数据库<br /> <br /> $ sqlplus "/ as sysdba"——用sys用户登陆sqlplus<br /> <br /> SQL*Plus: Release 9.2.0.5.0 - ProdUCtion on Thu Oct 9 15:06:11 2003<br /> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.<br /> Connected to an idle instance.<br /> <br /> SQL> startup——启动数据库<br /> <br /> ORACLE instance started.<br /> Total System Global Area 538412728 bytes<br /> Fixed Size 743096 bytes<br /> Variable Size 268435456 bytes<br /> Database Buffers 268435456 bytes<br /> Redo Buffers 798720 bytes<br /> Database mounted.<br /> Database opened.<br /> <br /> SQL> exit——退出sqlplus<br /> <br /> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production<br /> With the Partitioning option<br /> JServer Release 9.2.0.5.0 - Production<br /> <br /> 或者<br /> <br /> $dbstart<br /> <br /> 3 查看数据库进程<br /> <br /> $ ps -efgrep ora_——查看oracle进程<br /> <br /> oracle 688322 1 0 15:06:20 - 0:00 ora_smon_bxmis<br /> oracle 696534 704704 0 15:06:35 pts/4 0:00 grep ora_<br /> oracle 729224 1 0 15:06:20 - 0:00 ora_dbw0_bxmis<br /> oracle 745618 1 0 15:06:20 - 0:00 ora_reco_bxmis<br /> oracle 770216 1 0 15:06:20 - 0:00 ora_ckpt_bxmis<br /> oracle 778394 1 0 15:06:20 - 0:00 ora_pmon_bxmis<br /> oracle 843876 1 0 15:06:20 - 0:00 ora_qmn0_bxmis<br /> oracle 901342 1 0 15:06:20 - 0:00 ora_lgwr_bxmis<br /> oracle 925704 1 0 15:06:20 - 0:00 ora_cjq0_bxmis<br /> <br /> $ ps -efgrep lsnr——查看oracle监听进程<br /> <br /> 4 关闭数据库<br /> <br /> $ sqlplus "/ as sysdba"<br /> <br /> SQL*Plus: Release 9.2.0.5.0 - Production on Thu Oct 9 15:07:04 2003<br /> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.<br /> Connected to:<br /> Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production<br /> With the Partitioning option<br /> JServer Release 9.2.0.5.0 - Production<br /> <br /> SQL> shutdown immediate——关闭数据库<br /> <br /> Database closed.<br /> Database dismounted.<br /> ORACLE instance shut down.<br /> <br /> SQL> exit<br /> <br /> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production<br /> With the Partitioning option<br /> JServer Release 9.2.0.5.0 - Production<br /> <br /> 或者<br /> <br /> $dbshut<br /> <br /> 5 停止数据库监听 |
|