Windows startup shuts down Oracle snooping and Services (reprint)

Often use the database, let him start the words, the boot is too slow, so use the command to start a convenient point. 1. On: Enter CMD in the run, enter the console, Lsnrctl start Enter, prompt to start monitoring successfully after net start ORACLESERVICEORCL.
2 shut down enter CMD in the run, enter the console, Lsnrctl stop enter, prompt to start monitoring successfully after 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 S Top 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 one more common: Right-click on the desktop, create a new Notepad, and enter NETCA as "Reconfigure Oracle Listener. Bat".

Windows command starts the Oracle Monitor Listening 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 listener tns-12560:tns: Protocol Adapter Error TNS-00511: no monitoring Program 32-bit Windows error:2: No Such file or directory is connecting to (description= (address= (protocol=tcp) (HOST=ASUS-PC) (port=152 1)) Tns-12541:tns: No listener tns-12560:tns: Protocol Adapter error

TNS-00511: No listener 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 Log messages written to D:\product\10.2.0\db_1\network\log\listener.log listen: (Description= (Address= (PROTOCOL=IPC) (pipename=\\.\ PIPE\EXTPROC1IPC)) Monitor: (Description= (Address= (protocol=tcp) (HOST=ASUS-PC) (port=1521)))

SNMP OFF Listener parameter file D:\product\10.2.0\db_1\network\admin\listener.ora listener log file D:\pro   Duct\10.2.0\db_1\network\log\listener.log Monitoring Endpoint Overview ...   (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 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 (reprint)