Secure PDBs using LOCKDOWN PROFILEs
Purpose: LOCKDOWN Profiles concept will be applicable for Oracle Multitenant databases. We can apply this LOCKDOWN Profiles concept to specific CDB, specific PDB or ALL PDBs. This Concept will help…
Read MoreHow to overcome ORA-01102: cannot mount database in exclusive mode?
Introduction: While starting the Oracle database in the mount stage was failed (ORA-01102: cannot mount database in exclusive mode) with the below error Error: SQL> alter database mount; alter database…
Read MoreAdop hot patch failed with unexpected Error in EBS 12.2.8
Introduction: This blog is intended for DBA’s who may pass off with the below error message on applying a patch as hot patch in the instance. While applying adop hot…
Read MoreFind unused or unnecessary Privileges of Oracle Database user
Purpose: Usually a Privilege can be treated as unused privilege if this is not being used by user or pre-running programs at database level. During new application development phase or…
Read MoreAWS – Creating a Web server with EC2 ( Virtual Server in Cloud)
Login to AWS Management Console Then Navigate to EC2 Click Launch Instance Choose an AMI Choose Instance Type Configure Security Group Launch the instance Create…
Read MoreError Running ADOP prepare – [UNEXPECTED]Error calling runSyncFS subroutine.
Description : When triggering ADOP prepare phase on 12.2.8 environment for patching got below error. Error: PROCEDURE] Calling: /RMAN/apps/JAYAN/R12apps/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl [EVENT] Log: /RMAN/apps/JAYAN/R12apps/fs_ne/EBSapps/log/adop/11/20230804_092808/prepare/Neptune [UNEXPECTED]Error occurred running “perl /RMAN/apps/JAYAN/R12apps/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=/RMAN/apps/JAYAN/R12apps/fs2/i nst/apps/JAYAN_Neptune/appl/admin/JAYAN_Neptune.xml -patchcontextfile=/RMAN/apps/JAYAN/R12apps/fs1/inst/apps/JAYAN_Neptune/appl/admin/JAYAN_Neptune.xml…
Read MoreOnline reorganization of a table using Oracle DBMS_REDEFINITION package
This blog is intended for DBA’s who would like to reorganize tables online using Oracle dbms_redefinition package. Issue: DBAs may need to reorganize tables to improve the SQL query performance…
Read MoreEbs database Custom table columns missing while running a full mode cleanup
The purpose of this blog is to assist DBAs encountering ebs database custom table column missing while running adpatching cycle. The steps shared here will help to identify the table…
Read MoreTxkADOP PreparePhaseSynchronize.pl failure in adop fsclone
This blog is intended for DBA’s who have error while running a fsclone phase run patching cycle error, we have solution for fsclone phase error. Issue: We are facing issue…
Read MoreWebLogic AdminServer Error-“unable to get file lock, will retry”
Cause: When WebLogic Server Starts,it creates a lock file with .lok extension under $DOMAIN_HOME/server/<Server_Name>/tmp location It cleans .lok file when weblogic server stops If OS or Server abnormally rebooted during…
Read More