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