Skip to main content

For Group Target availability report. (OEM 12 C)


for Group Target availability report.


 select TARGET_NAME,TARGET_TYPE,START_TIMESTAMP,AVAILABILITY_STATUS,AVAILABILITY_STATUS_CODE,TYPE_DISPLAY_NAME from mgmt$availability_current where AVAILABILITY_STATUS not like '%Up%'  and target_name  in ( select MEMBER_TARGET_NAME from mgmt$target_flat_members  where AGGREGATE_TARGET_GUID='2D063F91D5E72C284CA8F36604402DA7')
 

select TARGET_TYPE, count(TARGET_NAME) from sysman.mgmt$availability_current where target_name  in ( select MEMBER_TARGET_NAME from sysman.mgmt$target_flat_members   where AGGREGATE_TARGET_GUID='xxxxxxxxxx') group by TARGET_TYPE;

select TARGET_TYPE, count(TARGET_NAME) from sysman.mgmt$availability_current where AVAILABILITY_STATUS not like '%Up%'  and target_name  in ( select MEMBER_TARGET_NAME from sysman.mgmt$target_flat_members   where AGGREGATE_TARGET_GUID='xxxxxxxxx') group by TARGET_TYPE;

 select TARGET_TYPE,AVAILABILITY_STATUS,count(TARGET_NAME) from sysman.mgmt$availability_current where AVAILABILITY_STATUS not like '%Up%' and target_name  in ( select MEMBER_TARGET_NAME from sysman.mgmt$target_flat_members   where AGGREGATE_TARGET_GUID='xxxxxxx') group by TARGET_TYPE,AVAILABILITY_STATUS;

Comments

Post a Comment

Popular posts from this blog

Hard dependency with ip address Oracle RAC Cluster.

Command error out due to hard dependency with ip address [-Node1]/app/grid/oracle/product/11.2.0/grid/bin>./crsctl relocate resource RDBMS_DB -n Node2 CRS-2527: Unable to start 'RDBMS_DB' because it has a 'hard' dependency on 'sDB' CRS-2525: All instances of the resource 'sDB' are already running; relocate is not allowed because the force option was not specified CRS-4000: Command Relocate failed, or completed with errors. [-Node1]/app/grid/oracle/product/11.2.0/grid/bin>./crsctl relocate resource sDB  -n Node2 CRS-2529: Unable to act on 'DB' because that would require stopping or relocating 'LISTENER_DB', but the force option was not specified CRS-4000: Command Relocate failed, or completed with errors. [-Node1]/app/grid/oracle/product/11.2.0/grid/bin>./crsctl relocate resource LISTENER_DB  -n Node2 CRS-2527: Unable to start 'LISTENER_DB' because it has a 'hard' dependency on 'sD...
Post a Comment
Read more

19C NID ( Rename Database)

 [oracle@localhost ~]$ nid DBNEWID: Release 19.0.0.0.0 - Production on Thu Dec 23 00:05:36 2021 Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved. Keyword     Description                    (Default) ---------------------------------------------------- TARGET      Username/Password              (NONE) DBNAME      New database name              (NONE) LOGFILE     Output Log                     (NONE) REVERT      Revert failed change           NO SETNAME     Set a new database name only   NO APPEND      Append to output log           NO HELP        Displays these messages    ...
Post a Comment
Read more

ORA-01017/ORA-28000 with AUDIT_TRAIL

With default profile in Oracle 11g, accounts are automatically locked 1 day ( PASSWORD_LOCK_TIME ) after 10 failed login attempt ( FAILED_LOGIN_ATTEMPTS ): SQL > SET lines 200 SQL > SET pages 200 SQL > SELECT * FROM dba_profiles WHERE PROFILE = 'DEFAULT' ORDER BY resource_name; PROFILE                         RESOURCE_NAME                      RESOURCE LIMIT ------------------------------ -------------------------------- -------- ---------------------------------------- DEFAULT                         COMPOSITE_LIMIT                 ...
Post a Comment
Read more