Alter System Local_Listener

Alter System Local_Listener. To register information with another local listener: Default value (address = (protocol=tcp)(host=hostname)(port=1521)) where hostname is the network name of the local host.

Oracle configures multiple listeners from www.fatalerrors.org

Configure the listener.ora file with the protocol address of the local listener. So, after it solves, it stores all the addresses it gets and registers to them. Alter system set local_listener='(address=(protocol=tcp)(host=name1)(port=1521))','(address=(protocol=tcp)(host=name2)(port=1523))' scope=both;

Source: www.fatalerrors.org

Note that the listener registration is is only a problem if the database was created with a lister on default port. Local_listener string (address = (protocol=tcp)(host =192.168.2.210)(port=1521)) to dynamically update the local_listener parameter, use the sql statement alter system set:

Source: blog.csdn.net

Alter system set local_listener='listener_alias' if you set the parameter to null with the statement that follows, then the default local address of. Therefore my local_listener, and database, was created on port 1522.

Now I Want To Upgrade My Application Server To 11G, From 10G, And It Needs Remain On Port 1521.

And all the expected services were now listed. Alter system set remote_listener= ':1521,(address = (protocol = tcp)(host = )(port = 1521))' scope=both sid=''; As a result, the sql statement alter system set local_listener does not affect the setting of this attribute.

The Address Or Address List Is Specified In The Tnsnames.ora File Or Other Address Repository As Configured For Your System.

Alter system set local_listener='listener' * 行1でエラーが発生しました。. (address = (protocol=tcp)(host=hostname)(port=1521)) where hostname is the network name of the local host. Local_listener specifies a network name that resolves to an address or address list of oracle net local listeners (that is, listeners that run on the same system as this instance).

Local_Listener String (Address = (Protocol=Tcp)(Host =192.168.2.210)(Port=1521)) To Dynamically Update The Local_Listener Parameter, Use The Sql Statement Alter System Set:

Sql> alter system set local_listener=x1,x2 scope=both; Default value (address = (protocol=tcp)(host=hostname)(port=1521)) where hostname is the network name of the local host. Having hunted around for a while, i found the following commands that registered the listener and resolved the issue.

Local_Listener Specifies A Network Name That Resolves To An Address Or Address List Of Oracle Net Local Listeners.

If a comma appears in the string, then the entire string must be enclosed in double quotation marks. Alter system set local_listener='listener_alias' if you set the parameter to null with the statement that follows, then the default local address of. Therefore my local_listener, and database, was created on port 1522.

To Dynamically Update The Local_Listener Parameter, Use The Sql Statement Alter System As Follows:

Alter system set local listener=[] listener_address [][,.]; Set the local_listener parameter as follows: See also the alter system register.