C:\>SQLPLUS /NOLOG

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jul 9 19:03:20 2011

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

SQL> CONNECT scott/tiger@dbtest
ERROR:
ORA-12541: TNS:no listener


SQL>

SQL> exit

C:\>LSNRCTL START

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 09-JUL-2011 19:10:16

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

Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
System parameter file is C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
Log messages written to C:\oracle\product\10.2.0\db_1\network\log\listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=PC-DDD)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=PC-DDD)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Start Date                09-JUL-2011 19:10:22
Uptime                    0 days 0 hr. 0 min. 5 sec
Trace Level               off
Security                  ON: Password or Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
Listener Log File         C:\oracle\product\10.2.0\db_1\network\log\listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=PC-DDD)(PORT=1521)))
Services Summary...
Service "dbtest" has 1 instance(s).
  Instance "dbtest", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

C:\>

C:\>
C:\>NET START OracleOraDb10g_home1TNSListener
Le service OracleOraDb10g_home1TNSListener démarre.
Le service OracleOraDb10g_home1TNSListener a démarré.

C:\>