怎么关oracle数据库,Oracle数据库启动和关闭

使用Oracle 9i 数据库

安装完毕后Oracle数据库会自动启动，下面我们用实际超作来说明一下Oracle 9i数据库的启动和关闭。

以Oracle用户登陆数据库，开个控制台窗口；

关闭Oracle 9i 数据库

-------------强制关闭数据库

-------------shutdown abort

[Oracle@wing /Oracle]$ sqlplus " / as sysdba" //以sysdba用户登陆数据库

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

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

Connected to:

Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production

With the Partitioning option

JServer Release 9.0.1.0.0 - Production

运行shudown命令关闭数据库

SQL> shutdown

Database closed.

Database dismounted.

Oracle instance shut down.

SQL>

启动Oracle 9i 数据库

[Oracle@wing bin]$ sqlplus " / as sysdba"

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

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

Connected to an idle instance.

SQL> startup

Oracle instance started.

Total System Global Area 336356520 bytes

Fixed Size 279720 bytes

Variable Size 268435456 bytes

Database Buffers 67108864 bytes

Redo Buffers 532480 bytes

Database mounted.

Database opened.

SQL>

启动Oracle 9i监听程序

Oracle的监听程序主要是为客户端的连接提供接口

[Oracle@wing bin]$ lsnrctl

LSNRCTL for Linux: Version 9.0.1.0.0 - Production on 11-JUL-2001 16:12:17

Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> start

Starting /Oracle/product/9.0.1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 9.0.1.0.0 - Production

System parameter file is /Oracle/product/9.0.1/network/admin/listener.ora

Log messages written to /Oracle/product/9.0.1/network/log/listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=wing)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)