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


Wednesday, July 20, 2022

 A typical connect attempt from a database client to an Oracle RAC database instance can be summarized, as follows:


The database client connects to SCAN (which includes a SCAN VIP on a public network), 

providing the SCAN listener with a valid service name.


The SCAN listener then determines which database instance hosts this service and routes 

the client to the local or node listener on the respective node.


The node listener, listening on a node VIP and a given port, retrieves the connection 

request and connects the client to the an instance on the local node.