oracle如何关闭edition功能,启动和关闭

使用Oracle 9i 数据库

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

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

关闭Oracle 9i 数据库

[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)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 9.0.1.0.0 - Production

Start Date 11-JUL-2001 16:12:58

Uptime 0 days 0 hr. 0 min. 0 sec

Trace Level off

Security OFF

SNMP OFF

Listener Parameter File /Oracle/product/9.0.1/network/admin/listener.ora

Listener Log File /Oracle/product/9.0.1/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=wing)(PORT=1521)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "Oracle" has 1 instance(s).

Instance "Oracle", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

LSNRCTL>

关闭Oracle 9i监听程序

[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> stop

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

The command completed successfully

LSNRCTL>

关闭Oracle Web Server

cd $Oracle_HOME/Apache/Apache/bin

./stopJServ.sh

/Oracle/product/9.0.1/Apache/Apache/bin/apachectl stop: httpd stopped

启动Oracle Web Server

cd $Oracle_HOME/Apache/Apache/bin

[Oracle@wing bin]$ ./startJServ.sh

/Oracle/product/9.0.1/Apache/Apache/bin/apachectl start: httpd started

启动Oracle Web Server后默认的端口号是7777

在客户端浏览器地址栏输入

如果浏览器出现以下界面则表示Oracle Web Server运行正常[@more@]