To find the Oracle System Identifier (SID) using the service name, you can use the following steps:
1) Check the listener status:
lsnrctl status
This will display a list of all the Oracle services that are registered with the listener, along with their service names and SIDs.
Look for the service name in the list of services. The SID for the service will be listed next to the service name.
2) Alternatively, you can also use the oracle-sid-from-service-name.sh script to find the SID for a given service name.
This script can be found in the $ORACLE_HOME/bin directory, where $ORACLE_HOME is the directory where Oracle is installed.
To use the script, run the following command:
oracle-sid-from-service-name.sh
The script will output the SID for the service.
Written by Nikos Minaidis
29/12/2022
Nikos Minaidis 