Alter System Set Local_Listener

Alter System Set Local_Listener. Configure the listener.ora file with the protocol address of the local listener. To dynamically update the local_listener parameter, use the sql statement alter system as follows:

Oracle配置多个监听_forever_riversCSDN博客 from blog.csdn.net

On single node instance all you need to do. Alter system set local_listener=' (address= (protocol=tcp) (host=192.168.201.142) (port=1521))' scope=memory sid='orcl'; 4) set the remote_listener parameter to listeners_myracdb across all instances.

Source: www.fatalerrors.org

Alter system set local_listener=[] listener_address [][,.] if you set the parameter to null using the following statement, then the default local address of tcp/ip, port 1521 is assumed: The database agent (previously known as racgimon) set the local_listener parameter to the node vip and the default listener configured in the ocr.

Source: blog.csdn.net

If listener is not running properly, you can create a static listener and start it as follows. Next, we should take care about the initialization parameters related to listener.

Sql> Alter System Set Local_Listener=' (Address_List= (Address= (Protocol=Tcp) (Host=Localhost) (Port=1521)) (Address= (Protocol=Tcp) (Host=Localhost) (Port=1522)) (Address= (Protocol=Tcp) (Host=Localhost) (Port=1523)) )';

This can be set to a tns alias that resolves to the correct. Tnsname1 = (address_list = (address = (protocol = tcp)(host = host1)(port = 1521)) (address = (protocol = tcp)(host = host1)(port = 6000)) ) if the listeners are not local use alter system set remote_listener='tnsname2'; For example, if you add a tnsnames.ora entry like:

6) You Should Be Able To Start The Listener On Each Node Now.

For example, if the listener is configured to listen on port 1421 rather than port 1521, you can set the local_listener parameter in the initialization parameter file as follows: An on, when a shutdown is issued (on container level), the database closes all of the pluggable databases and then shuts down the container database. There are occasions, in which when a database gets shut down, the default listener automatically unregisters the databases from it.

Sql> Alter System Set Local_Listener=X1,X2 Scope=Both;

Alter system set local_listener='' example in local host. For shared server connections, set the listener attribute as follows: Generally there is no requirement to set local_listener for a rac one node database because whenever an instance is started, the crs agent will automatically set the local_listener parameter to the node vip and the default listener configured in the ocr.

4) Set The Remote_Listener Parameter To Listeners_Myracdb Across All Instances.

Add the database fields as shown below: Having hunted around for a while, i found the following commands that registered the listener and resolved the issue. Alter system set local_listener='(address=(protocol=tcp)(host=localhost)(port=1521))' scope=both;

You Can Also Create A Static Listener And Start It As Follows.

You might want to create a custom template referencing a.sql script with the command alter session set local_listener. To register information with another local listener: On single node instance all you need to do.