Oracle Listeners by Shell Job

This job triggers on Oracle databases that have RAC related processes. The job:

1. Connects to the remote host by Shell.

2. Checks for the ORACLE_HOME environment variable.

3. If the variable is not defined, the job takes the ORACLE_HOME value from the job adapter (if defined).

4. Reads the Oracle TNS listener configuration file, stored in $ORACLE_HOME/network/admin/listener.ora, and performs further parsing.

5. Retrieves a full list of IP addresses to which this particular listener is listening.

6. Checks for listener status using the $ORACLE_HOME/bin/lsnrctl status.

7. Retrieves known services and listener status from the output.

This job uses the Oracle_Listeners_by_Shell adapter.

• Input Query

  

• Used Scripts

  • oracle_shell_utils.py
  • oracle_listeners_by_shell.py

• Triggered CI Data

  Name	Value
  Protocol	${SOURCE.root_class}
  connected_os_credentials_id	${SOURCE.connected_os_credentials_id:NA}
  credentialsId	${SOURCE.credentials_id}
  ip_address	${SOURCE.application_ip}
  listener_names	${LISTENER.name}
  listener_process_path	${PROCESS.process_path}

• Adapter Parameters

  OracleHomes

  Used when no ORACLE_HOME environment variable is defined. This value must be the same as the parameter in the Oracle RAC Topology by Shell job.

• Composition

• Containment

• IpAddress

• Node

• Oracle TNS Listener