Ameer Khan

Oracle Application Express 20.1 Installation Steps  Before installing Oracle Application Express, you must verify your configuration meets the minimum installation requirements. • Oracle Database Requirements Oracle Application Express release 20.1 requires an Oracle Database release 11.2.0.4 or later, including Enterprise Edition and Express Edition (Oracle Database XE). Oracle Application Express can be installed in single-instance… Continue Reading

 How to find out which Enterprise Edition features are being used in your oracle database ? I have seen many customer uses Enterprise Edition features unknowingly. They fall into trouble when Oracle performs an audit into their database and find out what are features they have using without their knowledge. As many of those features… Continue Reading

What is autonomous database:-  An Oracle Autonomous Database is a cloud-based technology designed to automate many of the routine tasks required to manage Oracle databases which is mostly done by DBA’s. It uses machine learning to automate database performance tuning, backups, securing database , patching etc. Types of autonomous database based on workload :- To… Continue Reading

Oracle WebLogic Server 12cR2 (12.2.1.4) Installation on Oracle Linux 6 Assumptions It is assumed that you have an existing server with either Oracle Linux 6.x or 7.x installed on it.   Software Download the Weblogic Server 12c software from Oracle Technology Network. Oracle Fusion Middleware 12c Infrastructure 12.2.1.4.0 We would use the fustion middleware infrastructure pack as… Continue Reading

Oracle Autonomous Database Schema Advisor The ADB Schema Advisor is a light-weight utility that analyzes your on-premise or cloud Oracle Database schemas for the suitability of migration to the Oracle Autonomous Database. The Advisor discovers the schema objects and performs deep analysis to highlight the differences when the object gets created on Oracle Autonomous Data… Continue Reading

A single script to gather various information’s of your database. Save the following code as .sql file and run it from sql prompt. This will generate a .lst file with the datetime. This script has been tested on 11gR2, 12cR1, 12cR2, 19c  column tm new_value file_time noprint select to_char(sysdate,’DDMMYYYY’)tm from dual; spool &file_time.lst set lines… Continue Reading

How to Create Compute Instance in Oracle Cloud Infrastructure(OCI) First , lets login to oracle cloud www.oracle.com/cloud Provide cloud account name and user id & password to authenticate. Step:-1 To create a new compute instance,  click Compute, then select Instances. Step 2. Click on “Create Instance” Step 3. In Create Compute Instance page, provide instance… Continue Reading

Oracle database can be upgraded directly to the new release from the following releases: If your current Oracle Database is a release earlier than 11.2.0.4, then you cannot directly upgrade your Oracle Database to the latest release. In this case, you are required to upgrade to an intermediate release before upgrading to Oracle Database 19c.… Continue Reading

What is a Compartment:- Compartment is a logical collection of related cloud resources. It is used to isolate resources. Users who have privilege to use the compartment, can only access or manage it. First , lets login to oracle cloudwww.oracle.com/cloud Provide cloud account name and user id & password to authenticate. The screen should look… Continue Reading

Oracle database can be upgraded directly to the new release from the following releases: If your current Oracle Database is a release earlier than 11.2.0.4, then you cannot directly upgrade your Oracle Database to the latest release. In this case, you are required to upgrade to an intermediate release before upgrading to  Oracle Database 19c.… Continue Reading