Database - RAC/Scalability (MOSC)

MOSC Banner

Error setting remote_listener

How to set remote_listener if the entry is incorrect. I am getting following error.

SQL> show parameter remote_listener


NAME                 TYPE    VALUE

------------------------------------ ----------- ------------------------------

remote_listener           string   bos-qa-rac-scan.americanwell.c

                         om:1521


I need to change the word rac to rac3. Below command does not work.

SQL> alter system set remote_listener = 'bos-qa-rac3-scan:1521' scope=both sid='*';

alter system set remote_listener = 'bos-qa-rac3-scan:1521' scope=both sid='*'

*

ERROR at line 1:

ORA-02097: parameter cannot be modified because specified value is invalid

ORA-00119: invalid specification for system parameter REMOTE_LISTENER

ORA-00141: all addresses specified for parameter LOCAL_LISTENER are invalid

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center