It's All About ORACLE

Oracle - The number one Database Management System. Hope this Blog will teach a lot about oracle.

Oracle listener lsnrctl tips

Here we see the lsnrctl command in action:
$ lsnrctl
LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 30-JAN-2003 11:54:13
(c) Copyright 1998 Oracle Corporation.  All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> help

The following lsnrctl operations are available
An asterisk (*) denotes a modifier or extended command:
start               stop                status
services            version             reload
save_config         trace               spawn
dbsnmp_start        dbsnmp_stop         dbsnmp_status
change_password     quit                exit
set*                show*
  


The following commands are used to manage the listener: 
·     start – Starts the listener with the name specified, otherwise LISTENER will be used.  For Windows systems, the listener can also be started from the Control Panel.
·     stop – Stops the listener.  For Windows systems, the listener can also be stopped from the Control Panel.
·     status – Provides status information about the listener, including start date, uptime, and trace level.
·     services – Displays each service available, along with the connection history.
·     version – Displays the version information of the listener.
·     reload – Forces a read of the configuration file in order for new settings to take effect without stopping and starting the listener.
·     save_config – Creates a backup of the existing listener.ora file and saves changes to the current version.
·     trace – Sets the trace level to one of the following – OFF, USER, ADMIN, or SUPPORT.
·     spawn – Spawns a program that runs with an alias in the listener.ora file.
·     dbsnmp_start – Starts the DBSNMP subagent. 
 ·     dbsnmp_stop – Stops the DBSNMP subagent.
·     dbsnmp_status – Displays the status of the DBSNMP subagent.
·     change_password – Sets a new password for the listener.
·     quit and exit – Exits the utility.
·     set – Changes the value of any parameter.  Everything that can be shown can be set.
show – Displays current parameter settings.

 

0 comments:

You Might Also Like

Related Posts with Thumbnails

Pages