Monday, January 3, 2011

Start/Stop Net Services Listener

When Rapid Install sets up and configures the server processes during installation, it stores a script for the Net Services listener process in the Oracle 11g database server $ORACLE_ HOME/appsutil/scripts/<CONTEXT_NAME> directory. You use this script to start or stop the Net Services listener process for the database.

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\inam>cd C:\oracle\PROD\db\tech_st\11.1.0\appsutil\scripts\PROD_p-hq-sv-or-01

C:\oracle\PROD\db\tech_st\11.1.0\appsutil\scripts\PROD_p-hq-sv-or-01>addlnctl status
ECHO is off.
ECHO is off.
Tue 01/04/2011 09:58 AM
Usage:
   addlnctl.cmd {start|stop|status} {listener}
ECHO is off.
   In general, available listeners are
      Database Net8 listener : <ORACLE_SID>
                               ( PROD )
addlnctl.cmd exiting with status 0

C:\oracle\PROD\db\tech_st\11.1.0\appsutil\scripts\PROD_p-hq-sv-or-01>addlnctl status PROD
ECHO is off.
ECHO is off.
Tue 01/04/2011 09:59 AM
ECHO is off.
ECHO is off.
Tue 01/04/2011 09:59 AM
PROD_p-hq-sv-or-01.cmd exiting with status 0
ECHO is off.
The environment settings are as follows ...
ECHO is off.
ORACLE_HOME : C:\oracle\PROD\db\tech_st\11.1.0
LOCAL : PROD
ORACLE_SID :
PATH : C:\oracle\PROD\db\tech_st\11.1.0\perl\5.8.3\bin\MSWin32-x86-multi-thread\;C:\oracle\PROD\db\tech_st\11.1.0\bin;C:
\oracle\PROD\db\tech_st\11.1.0\appsutil\jre\bin;C:\oracle\PROD\db\tech_st\11.1.0\appsutil\jre\bin;C:\oracle\PROD\apps\te
ch_st\10.1.2\jdk\jre\bin\classic;C:\oracle\PROD\apps\tech_st\10.1.2\jdk\jre\bin;C:\oracle\PROD\apps\tech_st\10.1.2\bin;C
:\oracle\PROD\apps\tech_st\10.1.2\jlib;C:\oracle\PROD\apps\tech_st\10.1.3\bin;C:\oracle\PROD\db\tech_st\11.1.0\bin;C:\WI
NDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Windows Imaging\;c:\Program Files\Microsoft SQL Serv
er\90\Tools\binn\;c:\cygwin\bin;
LD_LIBRARY_PATH : C:\oracle\PROD\db\tech_st\11.1.0\lib
ECHO is off.
ECHO is off.
The log information will be written to
        "C:\oracle\PROD\db\tech_st\11.1.0\appsutil\log\PROD_p-hq-sv-or-01\addlnctl.txt"
ECHO is off.
ECHO is off.
Finding status of listener process PROD ...
ECHO is off.

LSNRCTL for 32-bit Windows: Version 11.1.0.7.0 - Production on 04-JAN-2011 09:59:15

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=p-hq-sv-or-01.mohe.gov.sa)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     PROD
Version                   TNSLSNR for 32-bit Windows: Version 11.1.0.7.0 - Production
Start Date                01-JAN-2011 15:06:33
Uptime                    2 days 18 hr. 52 min. 43 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\oracle\PROD\db\tech_st\11.1.0\network\admin\PROD_p-hq-sv-or-01\listener.ora
Listener Log File         c:\oracle\prod\db\tech_st\11.1.0\log\diag\tnslsnr\p-hq-sv-or-01\prod\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=p-hq-sv-or-01.mohe.gov.sa)(PORT=1521)))
Services Summary...
Service "PROD" has 2 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  Instance "prod", status READY, has 1 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "prod", status READY, has 1 handler(s) for this service...
The command completed successfully
addlnctl.cmd exiting with status 0

C:\oracle\PROD\db\tech_st\11.1.0\appsutil\scripts\PROD_p-hq-sv-or-01>

Note: use start/stop instead of status as per your needs, you can used windows control panel to start/stop listener service

No comments:

Post a Comment