Setting set ORACLE_SID=ORCL
orcl--Instance Name
--Stop Oracle Instance Services
C:\users\administrator>net Stop ORACLESERVICEORCL
The ORACLESERVICEORCL service is stopping ...
The ORACLESERVICEORCL service has stopped successfully.
--Start the Oracle Instance service c:\users\administrator>net start ORACLESERVICEORCL ORACLESERVICEORCL service is starting ... The ORACLESERVICEORCL service has started successfully.
--Start Oracle Listening service C:\users\administrator>lsnrctl start
Lsnrctl for 32-bit windows:version 10.2.0.1.0-production on June-May-2011 11:2 0:27
Copyright (c) 1991, +, Oracle. All rights reserved.
Start Tnslsnr: Please wait ...
Tnslsnr for 32-bit windows:version 10.2.0.1.0-production system parameter file is H:\oracle\product\10.2.0\db_1\network\admin\ Listener.ora Write H:\oracle\product\10.2.0\db_1\network\log\listener.log log information listening: (Description= address= (protocol= IPC) (PIPENAME=\\.\PIPE\EXTPROC1IPC)) Listens: (Description= (Address= (protocol=tcp) (HOST=OUDH8N52JSGDDZG) (PORT=1521)) )
Connecting to (Description= (PROTOCOL=IPC) (Key=extproc1)) LISTENER STATUS------------------------Alias LISTENER version Tnslsnr for 32-bit windows:version 10.2.0.1.0-produ ction Start date 06 -May-2011 11:20:34 Normal running time 0 days 0 hours 0 Minutes 6 sec track level off security on:local OS Auth Entication SNMP off listener parameter file H:\ORACLE\PRODUCT\10.2.0\DB_1\NETWORK\ADMIN\LISTENER.O RA Listener Day Log file H:\oracle\product\10.2.0\db_1\network\log\listener.log
Monitor Endpoint Summary ... (Description= (address= (PROTOCOL=IPC) (PIPENAME=\\.\PIPE\EXTPROC1IPC)) (Description= (address= (protocol=tcp) (HOST=OUDH8N52JSGDDZG) (port=1521)) Service summary. The service "Plsextproc" contains 1 routines. Routine "Plsextproc", State UNKNOWN, contains 1 handlers for this service ... Command execution succeeded
--Stop Oracle Listening service
C:\users\administrator>lsnrctl stop
Lsnrctl for 32-bit windows:version 10.2.0.1.0-production on June-May-2011 11:1 4:30
Copyright (c) 1991, +, Oracle. All rights reserved.
Connecting to (Description= (address= (PROTOCOL=IPC) (key=extproc1)) command executed successfully
--Start Oracle Console service c:\users\administrator>emctl start dbconsole Oracle Enterprise Manager 10g Database Control Release 10 .2.0.1.0 Copyright (c) 1996, Oracle Corporation. All rights reserved. Http://OUDH8N52JSGDDZG:1158/em/console/aboutApplication starting Oracle Enterprise Manager 10g Database Control ... The ORACLEDBCONSOLEORCL service is starting ........ The ORACLEDBCONSOLEORCL service has started successfully.
--Stop Oracle Console service C:\USERS\ADMINISTRATOR>EMCTL stop dbconsole Oracle Enterprise Manager 10g Database control release 10. 2.0.1.0 Copyright (c) 1996, Oracle Corporation. All rights reserved. Http://OUDH8N52JSGDDZG:1158/em/console/aboutApplication ORACLEDBCONSOLEORCL service is stopping .... The ORACLEDBCONSOLEORCL service has stopped successfully. Setting set ORACLE_SID=ORCL
orcl--Instance Name
--Stop Oracle Instance Services
C:\users\administrator>net Stop ORACLESERVICEORCL
The ORACLESERVICEORCL service is stopping ...
The ORACLESERVICEORCL service has stopped successfully.
--Start Oracle Instance Service
C:\users\administrator>net Start ORACLESERVICEORCL
ORACLESERVICEORCL Service is starting ...
The ORACLESERVICEORCL service has started successfully.
--Start the Oracle listening service
C:\users\administrator>lsnrctl start
Lsnrctl for 32-bit windows:version 10.2.0.1.0-production on June-May-2011 11:2
0:27
Copyright (c) 1991, +, Oracle. All rights reserved.
Start Tnslsnr: Please wait ...
Tnslsnr for 32-bit windows:version 10.2.0.1.0-production
System parameter file is H:\oracle\product\10.2.0\db_1\network\admin\listener.ora
Write log information for H:\oracle\product\10.2.0\db_1\network\log\listener.log
Listening: (Description= (Address= (PROTOCOL=IPC) (PIPENAME=\\.\PIPE\EXTPROC1IPC))
Listening: (Description= (Address= (protocol=tcp) (HOST=OUDH8N52JSGDDZG) (port=1521))
Connecting to (Description= (address= (PROTOCOL=IPC) (Key=extproc1))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version Tnslsnr for 32-bit windows:version 10.2.0.1.0-produ
Ction
Launch date June-May-2011 11:20:34
Uptime 0 days 0 hours 0 minutes 6 seconds
Trace level off
Security On:local OS Authentication
SNMP off
Listener parameter File H:\ORACLE\PRODUCT\10.2.0\DB_1\NETWORK\ADMIN\LISTENER.O
Ra
Listener log File H:\oracle\product\10.2.0\db_1\network\log\listener.log
Monitor Endpoint Summary ...
(Description= (address= (PROTOCOL=IPC) (PIPENAME=\\.\PIPE\EXTPROC1IPC))
(Description= (address= (protocol=tcp) (HOST=OUDH8N52JSGDDZG) (port=1521))
Service summary.
The service "Plsextproc" contains 1 routines.
Routine "Plsextproc", State UNKNOWN, contains 1 handlers for this service ...
Command execution succeeded
--Stop Oracle Listening service
C:\users\administrator>lsnrctl stop
Lsnrctl for 32-bit windows:version 10.2.0.1.0-production on June-May-2011 11:1
4:30
Copyright (c) 1991, +, Oracle. All rights reserved.
Connecting to (Description= (address= (PROTOCOL=IPC) (Key=extproc1))
Command execution succeeded
--Start Oracle Console service
C:\users\administrator>emctl Start Dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, Oracle Corporation. All rights reserved.
Http://OUDH8N52JSGDDZG:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ... Oracledbconsoleorcl
The service is starting .........
The ORACLEDBCONSOLEORCL service has started successfully.
--Stop Oracle Console service
C:\users\administrator>emctl Stop Dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, Oracle Corporation. All rights reserved.
Http://OUDH8N52JSGDDZG:1158/em/console/aboutApplication
ORACLEDBCONSOLEORCL service is stopping ....
The ORACLEDBCONSOLEORCL service has stopped successfully.