Database Blog

Script to check workflow mailer service components status and send notification if DOWN

#!/bin/bash ################################################################################### # Script Name : WorkflowStatusCheck.sh # # # # Description: # # Script to check workflow mailer service components status and # # to send alert notification if…

Read More

Script To Monitor "Gather Schema Statistics" concurrent request

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

Read More

Script to Monitor Output Post Processor (OPP) Concurrent Manager

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

Read More

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