Monday, July 25, 2022

 Remove 1532 listener and the add 1531 listener and  with srvctl 


srvctl config listener


srvctl stop listener -listener listener1532

srvctl remove listener -listener listener1532


lis

vi listener.ora


LISTENER1531=

  (DESCRIPTION=

    (ADDRESS_LIST=

      (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.12.126)(PORT=1531))

      (ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))


srvctl add listener -l listener1531 -p 1531 -k 1

srvctl start listener -listener listener1531

srvctl status listener -listener listener1531

lsnrctl status LISTENER1531

The listener supports no services

The command completed successfully


tns

vi tnsnames.ora

LISTENER1531 =

        (DESCRIPTION_LIST =

                (DESCRIPTION =

                  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.12.126)(PORT = 1531))

    )

  )


db

sql

ALTER SYSTEM SET LOCAL_LISTENER='LISTENER1531' scope=both SID='cdbrac1';

  

sqlplus sys/"SysPassword1"@CDB_PRIMARY_31 as sysdba


No comments:

Post a Comment