Hi,
I got different output about services.Please share your suggestions
What is the difference between first (dba_services) and second ( show parameter service ) and third (srvctl) when we use.
SQL> select name,SERVICE_ID,NAME_HASH,NETWORK_NAME from dba_Services;
NAME SERVICE_ID NAME_HASH NETWORK_NAME
----------------------- ---------- ---------- -----------------------
SYS$BACKGROUND 1 165959219
SYS$USERS 2 3427055676
IMON5XDB 3 4174759983 IMON5XDB
IMON57_0.IKEA.COM 4 3223100397 IMON57_0.IKEA.COM
TEMON 5 3912059091 TEMON
IMON58_1.IKEA.COM 6 3427701857 IMON58_1.IKEA.COM
6 rows selected.
SQL> show parameter service
NAME
------------------------------------
TYPE VALUE
-------------------------------------------- ------------------------------
service_names
string TEMON
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters and Automatic Storage Management options
[oracle@itm-lx26 ~]$ srvctl status service -d IMON58_1
Service TEMONis running on instance(s) IMON51,IMON52
[oracle@itm-lx26 ~]$
I often got alert SYS$BACKGROUND or SYS$USERS was down by BMC remedy.I couldn't find any info in the alert log.Where can i find it?
How to start troubleshoot when the service down?
Br,
Raj