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.

 

1 comments:

If you want your ex-girlfriend or ex-boyfriend to come crawling back to you on their knees (no matter why you broke up) you got to watch this video
right away...

(VIDEO) Have your ex CRAWLING back to you...?

 

You Might Also Like

Related Posts with Thumbnails

Pages