Windows startup shuts down Oracle snooping and services

Often use the database, let him start the words, the boot is too slow, so use the command to start a convenient point.

1. Open:
Enter CMD in the run, enter the console, Lsnrctl start Enter, prompt to start monitoring after successful
net start ORACLESERVICEORCL.

2 Close
Enter CMD in the run, enter the console, Lsnrctl stop enter, prompt to start monitoring after successful
net stop ORACLESERVICEORCL.

This is still not very convenient.
Right-click on the desktop, create a new Notepad, enter
Lsnrctl start
net start ORACLESERVICEORCL
Save As "Oracle Startup. Bat"
Similarly:
Right-click on the desktop, create a new Notepad, enter
Lsnrctl stop
net stop ORACLESERVICEORCL
Save as "Oracle off. Bat"

1. On: Just double-click Oracle Boot. BAT is OK,

2, close: Just double-click Oracle Shutdown. BAT is OK,

Add: There is a more commonly used:
Right-click on the desktop, create a new Notepad, enter
Netca
Save as "Reconfigure Oracle Listener. Bat".

****************************************************************************************************
Windows commands start Oracle Monitoring and service

1. Check the Listener status

C:\users\administrator>lsnrctl status

Lsnrctl for 32-bit windows:version 10.2.0.1.0-production on 1 June-March-2012 09:
0:59

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

Connecting to (Description= (address= (PROTOCOL=IPC) (Key=extproc1))
Tns-12541:tns: No listening program
TNS-12560:TNS: Protocol Adapter error
TNS-00511: No listening program
32-bit Windows error:2: No such file or directory
Connecting to (Description= (address= (protocol=tcp) (HOST=ASUS-PC) (port=1521))
Tns-12541:tns: No listening program
TNS-12560:TNS: Protocol Adapter error

TNS-00511: No listening program
32-bit Windows Error:61:unknown Error

--The above message indicates that the Oracle listener is not open

2. Start the Listener

C:\users\administrator>lsnrctl start

Lsnrctl for 32-bit windows:version 10.2.0.1.0-production on 1 June-March-2012 09:4
5:22

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

Start Tnslsnr: Please wait ...

tnslsnr for 32-bit windows:version 10.2.0.1.0-production
System parameter file is D:\product\10.2.0\ Db_1\network\admin\listener.ora
Write D:\product\10.2.0\db_1\network\log\listener.log log information
Listener: (description= ( Address= (PROTOCOL=IPC) (PIPENAME=\\.\PIPE\EXTPROC1IPC))
Monitoring: (description= (Address= (protocol=tcp) (HOST= ASUS-PC) (port=1521)))

Key=extproc1 STATUS
- -----------------------
Aliases                        LISTENER
Version                        Tnslsnr for 32-bit windows:version 10.2.0.1.0-produ
ction
Start date                    1 June-March -2012 09:45:28
Uptime                0 days, 0 hours, 0 minutes, 6 seconds
Trace level                    off
Security                      on:local OS Authentication

SNMP OFF
Listener parameter File D:\product\10.2.0\db_1\network\admin\listener.ora
Listener log File D:\product\10.2.0\db_1\network\log\listener.log
Listener Endpoint Summary ...
(Description= (address= (PROTOCOL=IPC) (PIPENAME=\\.\PIPE\EXTPROC1IPC)))
(Description= (address= (protocol=tcp) (HOST=ASUS-PC) (port=1521)))
Service Summary:
The service "Plsextproc" consists of 1 routines.
Routine "Plsextproc", State UNKNOWN, contains 1 handlers for this service ...
Command execution succeeded

--The listener started successfully

3. Start an Oracle service instance

C:\users\administrator>net Start ORACLESERVICEORCL
The ORACLESERVICEORCL service is starting ...
The ORACLESERVICEORCL service has started successfully.

4. Turn off Oracle Service instances

C:\users\administrator>net Stop ORACLESERVICEORCL
ORACLESERVICEORCL Service is stopping ...
The ORACLESERVICEORCL service has stopped successfully.

5. Turn off monitoring

C:\users\administrator>lsnrctl stop

Lsnrctl for 32-bit windows:version 10.2.0.1.0-production on 1 June-March-2012 09:5
2:12

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

Connecting to (Description= (address= (PROTOCOL=IPC) (Key=extproc1))
Command execution succeeded

Windows startup shuts down Oracle snooping and services