当前所在位置:珠峰网资料 >> 计算机 >> Oracle认证 >> 正文
oracle服务启动和关闭一
发布时间:2010/10/7 9:29:27 来源:www.xue.net 编辑:城市总裁吧
     默认在登录root权限下,转到oracle用户权限下

  1[root@localhost /]#

  2[root@localhost /]# su - oracle

  3[oracle@localhost ~]$

  注意,在su的时候,中间一定要加横杠,否则实际上面没有真实切换掉用户,

  关闭Oracle 9i 数据库

  打印 <http://alipaytech.info/index.php/archives/66>帮助

  1[oracle@localhost ~]$ sqlplus "/ as sysdba" //以sysdba用户登陆数据库

  2SQL*Plus: Release 9.0.1.0.0 - Production on Wed Jul 11 15:35:31 2001

  3(c) Copyright 2001 Oracle Corporation. All rights reserved.

  4

  5Connected to:

  6Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production

  7With the Partitioning option

  8JServer Release 9.0.1.0.0 - Production

  运行shudown命令关闭数据库

  1SQL> shutdown

  2Database closed.

  3Database di***ounted.

  4Oracle instance shut down.

  5SQL>

  启动Oracle 9i 数据库

  01[oracle@localhost ~]$ sqlplus " / as sysdba"

  02SQL*Plus: Release 9.0.1.0.0 - Production on Wed Jul 11 16:00:59 2001

  03(c) Copyright 2001 Oracle Corporation. All rights reserved.

  04Connected to an idle instance.

  05SQL> startup

  06Oracle instance started.

  07Total System Global Area 336356520 bytes

  08Fixed Size 279720 bytes

  09Variable Size 268435456 bytes

  10Database Buffers 67108864 bytes

  11Redo Buffers 532480 bytes

  12Database mounted.

  13Database opened.

  14SQL>

广告合作:400-664-0084 全国热线:400-664-0084
Copyright 2010 - 2017 www.my8848.com 珠峰网 粤ICP备15066211号
珠峰网 版权所有 All Rights Reserved