Oracle学习系列—Windows下数据库进程的启动和关闭

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

具体解决办法详见。。。

ITPUB个人空间Sf&p/i2j1Y!N;LL
Microsoft Windows XP [Version 5.1.2600]
W6x$M
C+z I4K'F*?+on0(C) Copyright 1985-2001 Microsoft Corp.
S"cy4cnO0
7Y j#A$lX%m0C:/Documents and Settings/wangbao>cd/ITPUB个人空间T-Jj0Vxv(C
ITPUB个人空间p@"C
L{e;H E$Tt2F k
C:/>net stop OracleServiceWBQ
;@gK:y%Oc(B?^'L0The OracleServiceWBQ service is stopping........ITPUB个人空间6H-z%H3a1T*r/[K
The OracleServiceWBQ service could not be stopped.
q;y6LNMv0
'c%j3}6C Q
O;d_7d3q5Y0
&d B~E(cS T0C:/>net start OracleServiceWBQITPUB个人空间B(q(e` ufjA
The OracleServiceWBQ service is starting...............
p1?
s?`0The OracleServiceWBQ service was started successfully.ITPUB个人空间?2ed(N [\

5P6@c,K9R3Vp0ITPUB个人空间y"S9d'MB&U |
C:/>lsnrctl stop
,K
dOAx X0
4f?+vcW`xL0LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 15-MAR-2007 13:19:
v'NE;V0Z,z,t X017ITPUB个人空间"i2g9gUik0\WyZ'c

|2M8BG&Q$Dk(n `'|0Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
9x)|A7S$[0
r\5NQ Dp+A0Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))ITPUB个人空间S&h qBN
The command completed successfullyITPUB个人空间6o+BT_ |
ITPUB个人空间cs FYz-K"VL{"\:@+H
C:/>lsnrctl startITPUB个人空间*b"j!EJ!L+|
ITPUB个人空间$Rh5G {&y)}8Ui,i
LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 15-MAR-2007 13:19:ITPUB个人空间_~#X*@)op!i2U
20
Tj,geSB%\#M0ITPUB个人空间8A+I+J.wg-m qpL
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.ITPUB个人空间`6}/tfUu'{
ITPUB个人空间x]G T(z-`A7ST2mB
Starting tnslsnr: please wait...ITPUB个人空间%A#sP\!jj-W

1{4pjM1?5P0TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - ProductionITPUB个人空间 uaU.Y }p/~
System parameter file is C:/UserDefine/oracle/ora92/network/admin/listener.ora
b/Y[){l$V$oLl#s0Log messages written to C:/UserDefine/oracle/ora92/network/log/listener.log
WxN,V7hyJ.M%F0Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=//./pipe/EXTPROC0ipcITPUB个人空间1@"~(NwO,G-xJN
)))
Yym"j r&D0A&r\
q0Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=scn3089.asiapacific.hpqcITPUB个人空间,{KuSc'xST F;G
orp.net)(PORT=1521)))ITPUB个人空间N tg+lT0r~QNW
ITPUB个人空间.XLyA5J Z
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))ITPUB个人空间'Jw(R-X'P5KM
STATUS of the LISTENER
6uq t3k0L0------------------------
YVt!eb\0Alias LISTENERITPUB个人空间W f*RZ+E M*B
Version TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - ProducITPUB个人空间%IoS/{3WOQ
tion
o"]Th!L3M:e0Start Date 15-MAR-2007 13:19:22
/C4rs)Tj*YjE _0Uptime 0 days 0 hr. 0 min. 2 sec
f}'V1`;i0Trace Level off
m7[5l/p P P0Security OFFITPUB个人空间u{)Qe0qzF
SNMP OFFITPUB个人空间
R2F.i&yL
Listener Parameter File C:/UserDefine/oracle/ora92/network/admin/listener.oraITPUB个人空间K|"b*J9M
Listener Log File C:/UserDefine/oracle/ora92/network/log/listener.log
B5k"Z U]BBC0Listening Endpoints Summary...
{d!xS5OI5Vn0(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=//./pipe/EXTPROC0ipc)))
3AC8{lz0(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=scn3089.asiapacific.hpqcorp.net)(POR
4U\^%T)WcgZ'P0T=1521)))

nJ&MDHG&S(hq0Services Summary...
\;PXx*Q4l6\*R w g$Y0Service "PLSExtProc" has 1 instance(s).
)^KnaMA(Y` \/u0Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Gti!~*Jjh0Service "wbq" has 1 instance(s).ITPUB个人空间9Sz8`%n G9a([Wb
Instance "wbq", status UNKNOWN, has 1 handler(s) for this service...ITPUB个人空间Ow f2XG(G.A ~+}i:a
The command completed successfully
M v?D*K&S({W0ITPUB个人空间`{3y't7C&P4o
C:/>sqlplus /nologITPUB个人空间0?;EJ-R3k\]4l_

8C%?LyZ0SQL*Plus: Release 9.2.0.1.0 - Production on Thu Mar 15 13:19:28 2007
'EVI1M
Vn^3Ev0ITPUB个人空间 p(BT)aR,dN7_
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.ITPUB个人空间STdFw,Ve|5C`-p~5?
ITPUB个人空间yK-D#g)uI
B]
SQL> connect sys/change_on_install as sysdba
+df%m1X/u0Connected.ITPUB个人空间'n A&Z3K2Yz+]
SQL>