介绍Windows/Linux下Oracle数据库进程如何启动和关闭

本文来自http://www.jzxue.com/shujuku/oracle/201101/10-5556.html

 

Windows:

 

C:/>net stop OracleServiceWBQ

 

The OracleServiceWBQ service is stopping........

 

The OracleServiceWBQ service could not be stopped.

 

 

 

 

C:/>net start OracleServiceWBQ

 

The OracleServiceWBQ service is starting...............

 

The OracleServiceWBQ service was started successfully.

 

 

 

 

C:/>lsnrctl stop

 

LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 15-MAR-2007 13:19:17

 

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

 

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

 

The command completed successfully

 

 

 

C:/>lsnrctl start

 

The command completed successfully

 

 

 

C:/>sqlplus /nolog

 

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Mar 15 13:19:28 2007

 

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

 

SQL> connect sys/change_on_install as sysdba

 

Connected.

 

 

 

Linux

 

1、启动ORACLE监听

 

首先要登录用户oracle：su - oracle

 

[oracle@localhost ~]$ cd product/10.2.0/db_1/bin/                --找到oracle安装bin下

[oracle@localhost bin]$ lsnrctl                                  --启动oracle监听命令

 

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-OCT-2010 19:36:02

 

Copyright (c) 1991, 2005, Oracle. All rights reserved.

 

Welcome to LSNRCTL, type "help" for information.

 

LSNRCTL> help                                                     --查看lsnrctl有哪些参数    

The following operations are available

An asterisk (*) denotes a modifier or extended command:

 

start               stop                status              

services            version             reload              

save_config         trace               spawn               

change_password     quit                exit                

set*                show*              

 

 

LSNRCTL>start

Starting /home/oracle/product/10.2.0/db_1//bin/tnslsnr: please wait...

 

TNSLSNR for Linux: Version 10.2.0.1.0 - Production

System parameter file is /home/oracle/product/10.2.0/db_1/network/admin/listener.ora

Log messages written to /home/oracle/product/10.2.0/db_1/network/log/listener.log

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

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))

 

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

STATUS of the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production

Start Date                09-JUN-2010 10:26:45

Uptime                    0 days 0 hr. 0 min. 0 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /home/oracle/product/10.2.0/db_1/network/admin/listener.ora

Listener Log File         /home/oracle/product/10.2.0/db_1/network/log/listener.log

Listening Endpoints Summary...

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

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

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

The command completed successfully

 

（至此监听启动完成）；

 

LSNRCTL> exit

 

 

 

2、启动数据库

 

[oracle@localhost bin]$ sqlplus /nolog;

 

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jun 9 10:27:18 2010

 

Copyright (c) 1982, 2005, Oracle. All rights reserved.

 

SQL> conn / as sysdba;

Connected to an idle instance.

SQL> startup

ORACLE instance started.

 

Total System Global Area 2147483648 bytes

Fixed Size                  1220432 bytes

Variable Size             335544496 bytes

Database Buffers         1795162112 bytes

Redo Buffers               15556608 bytes

Database mounted.

Database opened.

 

（至此数据库启动）

 

SQL> exit