Yearly Archives: 2021

APEX INSTALLATION(5.1) in ORACLE12c

APEX INSTALLATION(5.1) in ORACLE12c In this blog we are going install the apex 5.1. Here, i have a database with 12c. So here i explained about this install steps at database directly. If we have a database then, follow below steps.…

Read More

Configuration changes in SetDomainEnv.sh

JAVA_PROPERTIES configuraion in SetDomainEnv.sh:-   login to particular server Go to Domain/bin Take backup of SetDomainEnv.sh vi SetDomainEnv.sh Edit SetDomainEnv.sh and replace the JAVA_PROPERTIES url as per requested save and…

Read More

Installation of weblogic in GUI Mode

Steps to install WLS by using GUI MODE:- Check the prerequisites like disk space, file permissions and compatibility 2. Execute Weblogic setup executable file 3. By default it will install…

Read More

MIGARATION FROM WINDOWS TO LINUX(12.1.0.1 TO 19.0.0)

INTRODUCTION Migration of a windows database 12.1.0.1 to linux database of version 19.0.0, below are the steps to perform the migration.   INSTALLED A DATABASE IN WINDOWS AND CHECKED THE…

Read More

Restore A Loss Of Controlfile Using Autobackup

Follow the steps to Restore A Loss Of Controlfile Using Autobackup:   Step:1 connect to RMAN and view the default parameters using SHOW ALL. Step:2 see the location of control…

Read More

BACKUP DATABASE USING RECOVERY CATALOG.

Steps in Backuping database using Recovery Catalog: What is a Recovery Catalog? RMAN metadata can be stored in either of the two places, Controlfile Recovery catalog Hence recovery catalog is…

Read More

How to Apply a Patch(Patch 30886680: DATABASE APR 2020 RELEASE UPDATE 12.2.0.1.200414)

Steps for applying the patch: Step:1 Check current version of OpatchTool Step:2 Upgrade the Opatch utility Step:3 Take the backup of ORACLE_HOME Step:4 Shutdown the Database and Listener Step:5 Apply…

Read More

Introduction to Materialised views

MATERIALISED VIEWS: Materialized views are schema objects that can be used to summarize, precompute, replicate and distribute data. In mview, the query result is cached as a concrete table that may…

Read More

Active Cloning

Steps to perform Active Cloning : Target database – RAHUL Clone database  – DOYEN 1)create the particular directories for clone database for storing datafiles,controlfiles,log files. mkdir DOYEN then create separate…

Read More

Recover a tablespace using RMAN

Recover a tablespace using RMAN: Step:1 create a tablespace Rahul. Step:2 view the tablespaces present in the database using Select tablespace_name from dba_tablespaces; Step:3 Backup the tablespace and backup the…

Read More