To view the database components:- col COMP_ID for a15 col COMP_NAME for a45 col STATUS for a20 set lines 100 pages 100 select COMP_ID,COMP_NAME,STATUS from dba_registry; 1) Remove Oracle Application…
Read Morestep 1:- connect oem database as sysdba and change the password:- sqlplus “/as sysdba” alter user sysman identified by “oem13c_monitor”; step 2:- Stop all OMS processes:- cd /u01/app/oracle/middleware/bin/ ./emctl stop…
Read Moreset lines 288 col sample_time for a14 col CONFIGURATION head “CONFIG” for 99.99 col ADMINISTRATIVE head “ADMIN” for 99.99 col OTHER for 99.99 SELECT TO_CHAR(SAMPLE_TIME, ‘HH24:MI ‘) AS SAMPLE_TIME, ROUND(OTHER…
Read More