Linux oracle listener oracle
This chapter describes the commands and associated syntax of the Listener Control utility. The terms «SQL*Net» and «Net Services» are used interchangeably throughout Oracle documentation and both these terms refer to the same functionality.
- Listener Control Utility Overview
To perform basic management functions on one or more listeners, you can use the Listener Control utility commands. You can also view and change parameter settings. - SET and SHOW Commands of the Listener Control utility
The SET and SHOW commands enable you to alter and view listener configuration parameters. - Distributed Operations
The Listener Control utility can perform operations on a local or a remote listener. - Oracle Net Listener Security
Authentication for listener administration depends on whether you access the listener locally, or remotely. - Listener Control Utility Commands
Use the Listener Control utility commands to manage and configure listeners.
1.1 Listener Control Utility Overview
The Listener Control utility enables you to administer listeners . To perform basic management functions on one or more listeners, you can use the Listener Control utility commands. You can also view and change parameter settings.
The basic syntax of Listener Control utility commands is as follows:
lsnrctl command listener_name
In the preceding command, listener_name is the name of the listener that you want to administer. If you do not specify a specific listener in the command string, then the command is directed to the default listener name, LISTENER .
You can also issue Listener Control utility commands at the LSNRCTL> program prompt. To obtain the prompt, enter lsnrctl with no arguments at the operating system command line. When you run lsnrctl , the program is started. You can then enter the necessary commands from the program prompt. The basic syntax of issuing commands from LSNRCTL> program prompt is as follows:
lsnrctl LSNRCTL> command listener_name
You can combine commands in a standard text file, and then run them as a sequence of commands. To run in batch mode, use the following format:
To identify comments in the batch script, you can use either REM or #. All other lines are considered commands. Any commands that typically require confirmation do not require confirmation during batch processing.
For most commands, the Listener Control utility establishes an Oracle Net connection with the listener that is used to transmit the command. To initiate an Oracle Net connection to the listener, the Listener Control utility must obtain the protocol addresses for the named listener or a listener named LISTENER . This is done by resolving the listener name with one of the following mechanisms:
- listener.ora file in the directory specified by the TNS_ADMIN environment variable.
- listener.ora file in the ORACLE_HOME /network/admin directory.
- Naming method; for example, a tnsnames.ora file.
If none of the preceding mechanisms resolve the listener name, then the Listener Control utility uses the default listener name LISTENER , resolves the host name IP address, and uses port 1521.
The Listener Control utility supports the following types of commands:
- Operational commands, such as START , and STOP .
- Modifier commands, such as SET TRC_LEVEL .
- Informational commands, such as STATUS , and SHOW LOG_FILE .
Related Topics
Linux oracle listener oracle
This chapter describes the Listener Control Utility commands and syntax. The terms SQL*Net and Net Services are used interchangeably throughout Oracle documentation.
- Listener Control Utility Overview
To perform basic management functions on one or more listeners, you can use the Listener Control utility commands. You can also use these commands to view and change parameter settings. - SET and SHOW Listener Control Utility Commands
The SET and SHOW commands enable you to alter and view listener configuration parameters. - Understanding Distributed Operations
Listener Control utility can perform operations on local or remote listeners. - Understanding Oracle Net Listener Security
Authentication for listener administration depends on whether you access the listener locally or remotely. - Listener Control Utility Commands
Use Listener Control Utility commands to manage and configure your listeners.
1.1 Listener Control Utility Overview
To perform basic management functions on one or more listeners, you can use the Listener Control utility commands. You can also use these commands to view and change parameter settings.
The Listener Control utility enables you to administer listeners. The syntax of Listener Control utility commands is as follows:
lsnrctl command listener_name In the preceding command, listener_name is the name of the listener that you want to administer. If you do not specify a specific listener in the command string, then the command is directed to the default listener name, LISTENER .
You can also issue Listener Control utility commands at the LSNRCTL> program prompt. To obtain the prompt, enter lsnrctl with no arguments at the operating system command line. When you run lsnrctl , the program is started. You can then enter the commands from the program prompt. The basic syntax of issuing commands from LSNRCTL> program prompt is:
lsnrctl LSNRCTL> command listener_name
You can combine commands in a standard text file and then run them as a sequence of commands. To run in batch mode, use this format:
To identify comments in the batch script, you can use either REM or # . All other lines are considered commands. Commands that require confirmation do not require confirmation during batch processing.
For most commands, Listener Control utility establishes an Oracle Net connection with the listener that transmits the command. To initiate an Oracle Net connection to the listener, Listener Control utility must obtain the protocol addresses for the named listener or a listener named LISTENER . This is done by resolving the listener name with one of the following:
- listener.ora file in the directory specified by the TNS_ADMIN environment variable.
- listener.ora file in the ORACLE_HOME /network/admin directory.
- Naming method; for example, a tnsnames.ora file.
If none of the preceding mechanisms resolve the listener name, then Listener Control utility uses the default listener name LISTENER , resolves the host name IP address, and uses port 1521.
The Listener Control utility supports the following types of commands:
- Operational commands, such as START , and STOP .
- Modifier commands, such as SET TRC_LEVEL .
- Informational commands, such as STATUS , and SHOW LOG_FILE .
1.2 SET and SHOW Listener Control Utility Commands
The SET and SHOW commands enable you to alter and view listener configuration parameters.
Use the SET command to alter parameter values for a specified listener. You set the name of the listener to administer using the SET CURRENT_LISTENER command. Parameter values remain in effect until the listener is shut down. If you want these settings to persist, then use the SAVE_CONFIG command to save changes to the listener.ora file.
You can use the SHOW command to display the current value of a configuration setting.
1.3 Understanding Distributed Operations
Listener Control utility can perform operations on local or remote listeners.
This example explains how to configure listeners for remote administration.
Set Up a Computer to Remotely Administer a Listener
Ensure that the Listener Control utility ( lsnrctl ) executable is installed in the ORACLE_HOME /bin directory. You can resolve the name of the listener that you want to administer either through a listener.ora file, or by a naming method.
When you administer a listener remotely, you can issue all of the commands except START . However, Listener Control utility only starts the listener on the same computer from which the utility runs.
When issuing commands, specify the listener name as an argument. If you omit the listener name in the command, then the listener name set with the command SET CURRENT_LISTENER is used. If you do not set the listener name with that command, then the command is directed to the default listener name, LISTENER .
Example 1-1 Issuing Commands Using the Listener Control Utility