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 MoreThe most renowned enterprise database in the world, Oracle Database has made an eminent advancement in its history by introducing autonomous database. At the initial stages of its announcement before…
Read MoreIn today’s technologically developed world, every enterprises and organization believe in streamlining their business workflow with the assistance of next-generation application suite that is hosted on Cloud. A great invention…
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 MoreUpdate: Collaborate 2020 will not be occurring as scheduled on April 19-23, in light of the recent Coronavirus pandemic. We shall keep you posted about further developments. Please refer https://collaborate.oatug.org/coronavirus.…
Read More