Error while upgrading the database from 11.2.0.4 to 19.3.0.0:- REASON: ERRORS FOUND: During Upgrade FILENAME: /u01/app/oracle/product/19c/cfgtoollogs/test19C/upgrade20200127132925/catupgrd0.log AT LINE NUMBER: 801192 —————————————————— Identifier CATJAVA 20-01-27 02:09:14 SCRIPT = [/u01/app/oracle/product/19c/rdbms/admin/initjms.sql] ERROR =…
Read MoreTo 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 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 MoreOracle announces that it’s Gen 2 Cloud Region is now live in Mumbai. As a result of this deployment in India, the existing, as well as new customers, can now…
Read MoreDescription: AWS Lambda is a serverless compute service that runs your code in response to events and automatically manages the underlying compute resources for you. You can use AWS Lambda to extend…
Read MoreDescription: Oracle Multitenant – an Oracle Database 12c Enterprise Edition option – introduces a new architecture that enables customers to easily consolidate multiple databases into a standardized database version that…
Read MoreIntroduction Customer asks us to generate all the DDL source code for some database objects. So I just found the little piece of code to create DDL source. Database…
Read MoreDatabases Our choice of Autonomous Transaction Processing or Autonomous Data Warehouse. 2 databases total, each with 1 OCPU and 20 GB storage. Note:-We need choose Always free while database configuration…
Read More