Posts by Doyensys

Script To Monitor Concurrent Managers

#!/bin/bash ########################################################################## # Script Name :  CMStatusCheck.sh                                               …

Read More

Untitled

R12.2: OUI CLI Cloning Failed While Running adcfgclone appstier dualfs With Registration Driver regclone.drv Missing. Error:  When attempting to run command adcfgclone.pl appsTier dualfs while cloning the following error occurs. Exception…

Read More

Untitled

                                                      Forms personalization Listing…

Read More

Untitled

                                 Query to pick up the last one days logs in EBS12.2  Query:  #### Start…

Read More

Untitled

Common issue while doing Re-org in 12.1.0.2 database:- While importing the database in 12.1.0.2.. ORA-39346: data loss in character set conversion for object DATABASE_EXPORT/SCHEMA/VIEW/VIEW Processing object type DATABASE_EXPORT/SCHEMA/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object…

Read More

Untitled

Dynamic script to compile all the invalids:- SELECT CASE WHEN object_type = ‘SYNONYM’ AND owner = ‘PUBLIC’ THEN ‘alter ‘ || owner || ‘ ‘ || DECODE(object_type, ‘PACKAGE BODY’, ‘PACKAGE’,…

Read More

Untitled

Fixing dblink issue:- create database link ats_ora connect using <username> identified by <password> using ‘<dblink name>’; place the target database tns entry in source database. Accessing the dblink, we should…

Read More

Oracle 12c Common User & Local User

Common Users       Common user must be created in CDB only.      When we create a common user must give C## as prefix      The user…

Read More

Datapatch apply on 12c Databases after patch

Datapatch apply steps on 12c Databases after patch- Run the below steps to apply datapatch for all the databases running on 12C RDBMS home. Set environment . oraenv 12c_DBname Sqlplus…

Read More

Apex used to call the Oracle JOB scheduler and Java

Create the html link on apex Ajax(Application Process) used to call the DBMS_SCHEDULER then generate the job name Ajax(Application Process) used to call the DBMS_SCHEDULER .CREATE_JOB then Execute the job…

Read More