Shulou(Shulou.com)06/01 Report--

Often to use the database, let him start his own words, boot is too slow, so start with the command to facilitate points.

1. Open:

Enter cmd in operation to enter the console,lsnrctl start Enter, prompt to start monitoring successfully

net start OracleServiceORCL。

2 is closed

Enter cmd during operation to enter the console,lsnrctl stop Enter, prompt to start monitoring successfully

net stop OracleServiceORCL。

This was still inconvenient.

Right-click on the desktop, create a notepad, and type

lsnrctl start

net start OracleServiceORCL

Save as Oracle Start.bat

Similarly:

Right-click on the desktop, create a notepad, and type

lsnrctl stop

net stop OracleServiceORCL

Save as Oracle Close.bat

1. Open: Just double-click Oracle to start.bat and it will be ok.

2. Close: Just double-click Oracle to close.bat and it will be ok.

Supplement: There is also a more common one:

Right-click on the desktop, create a notepad, and type

netca

Save as Reconfigure Oracle Listen.bat.

****************************************************************************************************

Windows commands start oracle listening and services

1. Check listener status

C:\Users\Administrator>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 16-Mar-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 16-Mar-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

The system parameter file is D:\product\10.2.0\db_1\network\admin\listener.ora

Log information written to D:\product\10.2.0\db_1\network\log\listener.log

Listen: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc))(PIPENAME=\\.\ pipe\EXTPROC1ipc)))

Monitoring: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=asus-PC)(PORT=1521))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))

LISTENER STATUS

------------------------

Aliases Listener

Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ

ction

Start Date 16-Mar-2012 09:45:28

Uptime 0 days 0 hours 0 minutes 6 seconds

Tracking level off

Security ON: Local OS Authentication

SNMP OFF

Listeners parameter file D:\product\10.2.0\db_1\network\admin\listener.ora

Listeners log file D:\product\10.2.0\db_1\network\log\listener.log

Listening endpoint profiles...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\ pipe\EXTPROC1ipc)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=asus-PC)(PORT=1521)))

Service Summary..

The service "PLSExtProc" contains 1 routine.

Routine "PLSExtProc," status UNKNOWN, 1 handler containing this service...

Command executed successfully

--Monitor program started successfully

3. Start oracle service instance

C:\Users\Administrator>net start oracleServiceOrcl

OracleServiceORCL service is starting............................

OracleServiceORCL service started successfully.

4. Close oracle service instance

C:\Users\Administrator>net stop oracleServiceOrcl

OracleServiceORCL service is stopping...

OracleServiceORCL service stopped successfully.

5. Turn off listening

C:\Users\Administrator>lsnrctl stop

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 16-Mar-2012 09:5

2:12

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))

Command executed successfully

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.