-Summary startup command as follows:
Lsnrctl [Start|stop|status]-Start the listener, stop the listener, and view the state of the listener;
NET [Start|stop] Oracleserviceorcl
first, independent start-up:
Microsoft Windows 5.00.2195 [Version]
(C) Copyright 1985-2000 Microsoft Corp.
#########################################################
Check Listener Status:
#########################################################
e:/>lsnrctl Status
Lsnrctl for 32-bit windows:version 9.2.0.1.0-production on 2 August-June-2005 11:01:01
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to (Description= (address= (protocol=tcp) (Host=oyez) (port=1521))
Tns-12541:tns: No Listener
TNS-12560:TNS: Protocol Adapter error
TNS-00511: No Listener
32-bit Windows Error:61:unknown Error
Connecting to (Description= (address= (PROTOCOL=IPC) (KEY=EXTPROC0))
Tns-12541:tns: No Listener
TNS-12560:TNS: Protocol Adapter error
TNS-00511: No Listener
32-bit Windows error:2: No such file or directory
#########################################################
Try to log on to the local database:
#########################################################
e:/>Sqlplus/nolog
Sql*plus:release 9.2.0.1.0-production on Tuesday June 28 11:01:09 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
sql> Conn system/qqqqqq@oradb as sysdba
ERROR:
Ora-12541:tns: No listeners
-If the Oracle service is not started, the following error will appear instead of the above:
ERROR:
ORA-12560:TNS: Protocol Adapter error
#########################################################
Reason: The listener did not start, unable to resolve the "oradb" service name, so cannot log in to the database.
#########################################################
Sql> Exit
#########################################################
Start the Listener
#########################################################
E:/>lsnrctl Start
Lsnrctl for 32-bit windows:version 9.2.0.1.0-production on 2 August-June-2005 11:01:36
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Start Tnslsnr: Please wait ...
Tnslsnr for 32-bit windows:version 9.2.0.1.0-production
System parameter file is F:/oracle/ora92/network/admin/listener.ora
Write log information for F:/oracle/ora92/network/log/listener.log
Listening: (Description= (Address= (protocol=tcp) (Host=oyez) (port=1521))
Listening: (Description= (Address= (PROTOCOL=IPC) (PIPENAME=//./PIPE/EXTPROC0IPC))
Connecting to (Description= (address= (protocol=tcp) (Host=oyez) (port=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version Tnslsnr for 32-bit windows:version 9.2.0.1.0-production
Launch date 2 August-June-2005 11:01:38
Uptime 0 days 0 hours 0 minutes 2 seconds
Trace level off
Security off
SNMP off
Listener parameter File F:/oracle/ora92/network/admin/listener.ora
Listener log File F:/oracle/ora92/network/log/listener.log
Monitor Endpoint Summary ...
(Description= (address= (protocol=tcp) (Host=oyez) (port=1521))
(Description= (address= (PROTOCOL=IPC) (PIPENAME=//./PIPE/EXTPROC0IPC))
Service summary.
The service "Oemrep" contains 1 routines.
Routine "Oemrep", State UNKNOWN, contains 1 handlers for this service ...
The service "Plsextproc" contains 1 routines.
Routine "Plsextproc", State UNKNOWN, contains 1 handlers for this service ...
The service "oradb.eleaf.org" contains 1 routines.
Routine "oradb", State UNKNOWN, contains 1 handlers for this service ...
Command execution succeeded
#########################################################
If you start the Listener times "Error 3 cannot find the path to the executable file."
View the properties of the Control Panel]=[service]=oracleorahome92tnslistener and find that the executable path entry is empty. Open Registry Editor, search for the corresponding key value of the listening service, finally in Hkey_local_machine/system/currentcontrolset (ControlSet001, ControlSet002)/ Services were found under the Oracleorahome92tnslistener service. Right-click it to select New string value, name ImagePath, and double-click it to enter the path of the listener in the value, here is "F:/oracle/ora92/bin/tnslsnr." EXE ". It's normal to do it again.
Reason: system maintenance software such as "Super Bunny" and "Windows Optimizer master" mistakenly deletes the key value in the registry.
#########################################################
e:/>Sqlplus/nolog
Sql*plus:release 9.2.0.1.0-production on Tuesday June 28 11:05:27 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
sql> Conn system/qqqqqq@oradb as sysdba
ERROR:
Ora-12500:tns: The listener could not start the private server process
#########################################################
Reason: The corresponding service for the local database is not open
#########################################################
Sql> Exit
#########################################################
Open the corresponding service for the local database, or through the control Surface]=[Service, select the service and press the Start button on the toolbar to start.
#########################################################
e:/>net start oracleserviceoradb
The ORACLESERVICEORADB service is starting ..... ......... ....... ........ ...
The ORACLESERVICEORADB service has started successfully.
e:/>Sqlplus/nolog
Sql*plus:release 9.2.0.1.0-production on Tuesday June 28 11:17:53 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Sql>Connsystem/qqqqqq@oradbAs sysdba
is connected.
Sql>
Sql>desc user_views
is the name empty? Type
----------------------------------------- -------- ----------------------------
View_name not NULL VARCHAR2 (30)
Text_length number
TEXT LONG
Type_text_length number
Type_text VARCHAR2 (4000)
Oid_text_length number
Oid_text VARCHAR2 (4000)
View_type_owner VARCHAR2 (30)
View_type VARCHAR2 (30)
Superview_name VARCHAR2 (30)
Sql> Exit
From Oracle9i Enterprise Edition release 9.2.0.1.0-production
With the partitioning, OLAP and Oracle Data Mining options
Disconnect in Jserver release 9.2.0.1.0-production
e:/>Oemapp Console
E:/>
second, landing to Managerserver:
e:/>net stop Oracleserviceoemrep
Oracleserviceoemrep Service is stopping ...
The Oracleserviceoemrep service cannot be stopped.
#########################################################
Open the Data archive service, also through the [Control Surface version]=[Service], select the appropriate service, press the toolbar on the [Start] button to start.
#########################################################
e:/>net start Oracleserviceoemrep
The Oracleserviceoemrep service is starting ..... ..... ..... ....... ...... ...... ...... ..... ...
The ORACLESERVICEOEMREP service has started successfully.
On Windows, the use of the net command to start a database is also affected by a registry parameter: Ora_<sid>_autostart
For my oracle10g database, this key value is located in hkey_local_machine/software/oracle/key_ora10g, and my database SID is Eygle, and this argument is: Ora_eygle_autostart
When this parameter is set to TRUE, the Oracle database starts when we start the service, otherwise the database does not start.
When testing 1,ora_eygle_autostart=true:
C:/>net Start Oracleserviceeygle The Oracleserviceeygle service is starting ............ The Oracleserviceeygle service has started successfully. C:/>sqlplus "/As SYSDBA"
Sql*plus:release 10.2.0.1.0-production on Tuesday August 22 09:27:35 2006 Copyright (c) 1982, +, Oracle. All rights reserved. Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production With the partitioning, OLAP and Data Mining options
Sql> select instance_name from V$instance; Instance_name ---------------- Eygle |
When testing 2,ora_eygle_autostart=false:
C:/>net Start Oracleserviceeygle The Oracleserviceeygle service is starting. The Oracleserviceeygle service has started successfully. C:/>sqlplus "/As SYSDBA"
Sql*plus:release 10.2.0.1.0-production on Tuesday August 22 09:30:03 2006 Copyright (c) 1982, +, Oracle. All rights reserved. You are connected to an idle routine. Sql> |
#########################################################
Try to connect the data archive directly with Sqlplus.
#########################################################
e:/>Sqlplus/nolog
Sql*plus:release 9.2.0.1.0-production on Tuesday June 28 11:58:26 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
sql> Conn/as SYSDBA
is connected.
sql> Conn system/qqqqqq@oemrep
is connected.
Sql> exit
From Oracle9i Enterprise Edition release 9.2.0.1.0-production
With the partitioning, OLAP and Oracle Data Mining options
Disconnect in Jserver release 9.2.0.1.0-production
#########################################################
Start Agent
#########################################################
E:/>agentctl Start
Dbsnmp for 32-bit windows:version 9.2.0.1.0-production on 2 August-June-2005 11:59:51
Copyright (c) 2002 Oracle Corporation. All rights reserved.
Starting Oracle intelligent Agent ....
Agent has started
#########################################################
If the agent does not start successfully, then:
Go to%oracle_home%/network/agent/and delete all files with the suffix ". Q".
If still not, the Services.ora will also be deleted.
#########################################################
E:/>oemctl Start OMS
The Oracleorahome92managementserver service is starting ... .....
The Oracleorahome92managementserver service has started successfully.
#########################################################
Management server will require a username/password to be entered during startup, initially sysman/oem_temp
#########################################################
e:/>Oemapp Console