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

windows

windows下Oracle的启动一般是伴随windows自动启动，自动关闭的。但是如果同过任务管理器杀掉了Oracle进程，如果通过命令行方式打开Oracle就会报错误信息。

解决办法如下：

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

[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