We have a requirement for our customer like below and we have commands for that as specified:
1. Want to extract the database patch level for Oracle database running in the Linux server
command: sudo /usr/local/oracle/bin/os-l-ora-info.sh <DB Instance SID> get_patch_level
2. Want to extract the Oracle Home for Oracle database running in the Linux server
command: sudo /usr/local/oracle/bin/os-l-ora-info.sh<DB Instance SID> get_oracle_home
3. Want to extract the database TCP listener Port for Oracle database running in the Linux server
command: sudo /usr/local/oracle/bin/os-l-ora-info.sh<DB Instance SID> get_listener_port TCP
4. Want to extract the database TCPs listener Port for Oracle database running in the Linux server
command: sudo /usr/local/oracle/bin/os-l-ora-info.sh<DB Instance SID> get_listener_port TCPS
Here our requirement is on few linux servers there might be multiple databases running, so in this scenario, we want to know can we use the above commands if multiple database running on server. And want to know how can we pass the SID value dynamically so that based on the SID it will retrieve the following details.
