listener.ora example

Because I always forget…this is what a lister.ora look like (example from a dataguard listener)

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) 
      (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = CDB01)
      (ORACLE_HOME = /u01/app/oracle/product/dbee/19)
      (SID_NAME = CDB01)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = CDB01_bloemkool_DGB)
      (ORACLE_HOME = /u01/app/oracle/product/dbee/19)
      (SID_NAME = CDB01)
    )

    (SID_DESC =
      (GLOBAL_DBNAME = CDB01_bloemkool_DGMGRL)
      (ORACLE_HOME = /u01/app/oracle/product/dbee/19)
      (SID_NAME = CDB01)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = CDB01_bloemkool)
      (ORACLE_HOME = /u01/app/oracle/product/dbee/19)
      (SID_NAME = CDB01)
    )
  )

Leave a Reply

Your email address will not be published. Required fields are marked *