Oracle commands in windows

Oracle commands in windows

It is often necessary to use a database. If you want him to start the database on his own, it will be too slow to start the database.

1. enable:

Enter cmd in the running state, enter the console, and press lsnrctl start to enter, prompting that the listener is successfully started.

Net start OracleServiceORCL.

2 close

Enter cmd in the running state, enter the console, lsnrctl stop and press enter, prompting you to start the listener successfully

Net stop OracleServiceORCL.

This is still inconvenient.

Right-click the desktop, create a notebook, and enter

Lsnrctl start

Net start OracleServiceORCL

Save as "Oracle startup. bat"

Likewise:

Right-click the desktop, create a notebook, and enter

Lsnrctl stop

Net stop OracleServiceORCL

Save as "Oracle close. bat"

1. Enable: Simply double-click Oracle to start. bat,

2. Close: Simply double-click Oracle to close. bat,

Supplement: there is also a commonly used:

Right-click the desktop, create a notebook, and enter

Netca

Save as "reconfigure Oracle listener. bat ".

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

Run commands in windows to start oracle listeners and services

1. Check the listener status

C: \ Users \ Administrator> lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0-Production on 16-3 months-2012 09:

0: 59

Copyright (c) 1991,200 5, Oracle. All rights reserved.

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

TNS-12541: TNS: no listeners

TNS-12560: TNS: protocol adapter error.

TNS-00511: no listeners

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 listeners

TNS-12560: TNS: protocol adapter error.

TNS-00511: no listeners

32-bit Windows Error: 61: Unknown error

-- The preceding message indicates that the oracle listener is not enabled.

2. Start the listener

C: \ Users \ Administrator> lsnrctl start

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0-Production on 16-3 months-2012

Copyright (c) 1991,200 5, 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.

Write the log information of D: \ product \ 10.2.0 \ db_1 \ network \ log \ listener. log

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

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

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

LISTENER STATUS

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

Alias LISTENER

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

Ction

Start Date: 16-3 months-2012 09:45:28

Normal operation time 0 days 0 hours 0 minutes 6 seconds

Tracking 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 overview...

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

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

Service summary ..

The Service "PLSExtProc" contains one routine.

Routine "PLSExtProc", status UNKNOWN, contains one handler of this service...

Command executed successfully

-- Listener started successfully

3. Start an oracle service instance

C: \ Users \ Administrator> net start oracleServiceOrcl

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

The OracleServiceORCL service has been started successfully.

4. Disable oracle service instances

C: \ Users \ Administrator> net stop oracleServiceOrcl

OracleServiceORCL service is stopping ......

The OracleServiceORCL service has been stopped successfully.

5. Disable listening

C: \ Users \ Administrator> lsnrctl stop

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0-Production on 16-3 months-2012

2: 12

Copyright (c) 1991,200 5, Oracle. All rights reserved.

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

Command executed successfully