介紹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
