Yearly Archives: 2021

Migrating a Normal disk group to flex disk group in ASM oracle cloud (19C)

Description: Flex Diskgroups are the new features in oracle 12c R2 for quotas, cloning and filegroups. Oracle ASM provides two-way mirroring by default for newly-created flex disk groups. We can…

Read More

Step by Step Oracle Audit Vault Installation on VMware

Introduction: This post is a guide to install Oracle Audit Vault 12.2.0.8 on VMware. High Level steps 1. Media Download 2. Prerequisites 3. Installation of Audit Vault 12.2.0.8 4. Post…

Read More

PDB is in restricted mode, datapatch puts pdb$seed to restricted mode

Container and Pluggable database  SYMPTOMS The PDB$SEED is in restricted mode. CON_ID CON_NAME OPEN MODE RESTRICTED 2 PDB$SEED READ ONLY YES When we try to open the PDB$SEED it shows…

Read More

How Oracle Cloud Infrastructure influences AI-Powered Text Analysis?

Have you ever thought of getting a doubt and going to the library and a whole process of searching in between books and referring to the pages to clarify the…

Read More

Preview an Image Before upload in Oracle Apex

Overview This document is about to preview an image before upload in oracle apex. Technologies and Tools Used The following technologies have been used to achieve this. Oracle Apex Use…

Read More

Excel Template in oracle Apex for Excel Upload Page using JavaScript and Oracle pl/sql

Objective: The Excel Upload Page in Oracle Apex Involves Excel Upload template design. Usually the templates will be stored in Shared Components Workspace File and through button click JavaScript call,…

Read More

How to setup password less ssh login in linux server

How to setup password less ssh login in linux server SSH is an open-source and most trusted network protocol that is use to login to remote server. It is use…

Read More

autoconfig failing – jtfictx.sh

ERROR: While running autoconfig i am getting below error, autoconfig failing – jtfictx.sh Solution: SQL> exec ctxsys.ctx_adm.set_parameter(‘file_access_role’, ‘public’) PL/SQL procedure successfully completed. After executing this run autoconfig.  

Read More

Perl lib version v5.8.3 doesn’t match executable version v5.10.0

Error: Perl lib version v5.8.3 doesn’t match executable version v5.10.0 Solution: export ORACLE_HOME=/u01/oracle_home/db/tech_st/12.1.0.2 export PERL5LIB=$ORACLE_HOME/perl/lib/5.10.0:$ORACLE_HOME/perl/site_perl/5.10.0:$ORACLE_HOME/appsutil/perl export PATH=$ORACLE_HOME/perl:$ORACLE_HOME/perl/lib:$ORACLE_HOME/perl/bin:$PATH check again perl version

Read More

Useful query to get user id, responsibility id and application id in EBS.

Useful query to get user id, responsibility id and application id in EBS. To know about User Id use below Query:- SQL> select user_id from fnd_user where user_name=’DOYEN’; To know…

Read More