EM 24ai: Single Instance (Multitenant) And Listener Discovery Sequence Of Operations And Output Explained
(Doc ID 3048912.1)
Last updated on DECEMBER 24, 2024
Applies to:
Enterprise Manager for Oracle Database - Version 24.1.0.0.0 and laterInformation in this document applies to any platform.
Goal
This document provides a detailed explanation of the sequence for Single Instance(Multitenant) and Listener Discovery Operations in version 24.1C
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| Overview |
| 1. Initialization of the discovery process |
| 2. Check for single host cluster discovery |
| 3. Check $ORATAB Entries |
| 4. Getting SID information |
| 5. Determine inventory.xml |
| 6. Excluding Homes from Discovery |
| 7. Get Listener Status and Version |
| 8. Initiate Database and Listener Discovery Method |
| 9. Listener Discovery Parsing Method |
| A. Parsing the listener.ora file for listener details and Determining the Listener name |
| B. Verify TCP Endpoint missing on Listener |
| C. Get Listener Port and Hostname information |
| D. Get Listener Home Details |
| E. Get LISTENER Output |
| F. Exiting Listener Parse and Get Listener Output |
| 10. Database Dynamic SID Discovery |
| A. Execute command to get Services information from Listener |
| B. Get Service Name from Lsnrctl service output |
| C. Get SID Dymanically from Listener |
| D. Get Database Parameter file (SP file) |
| E. Get FQDN and Domain Name |
| F. Verify Database is Multitenant DB or Normal DB |
| a.Execute SQL on DB to get CDB information |
| b.Execute SQL on DB to get Version information |
| c.Execute SQL on DB to get DB OPEN status |
| G. Get PDB and APPSPDB information |
| H. PDB shown as Discovered |
| 11. Final Discovery result output |
| 12. End Discovery |
| References |