Category Archives for scripts

eBusiness 11i/R12 – Daily Checks (for Apps. DBA) – Admin Node

For daily checks ( Health Check on Admin/Concurrent Manager Node click on this link eBusiness 11i/R12 – Daily Checks (for Apps. DBA) – Admin Node . Related : For health check in 11i Click Here 

Read More

Automate SSH Authorization

I usually work on Linux machines. every time its a time taking task to generate ssh key generation between servers and copy the authorization key. i have a small script which will generate and copy the files to your desired destinations and makes your task easy Login to server A #ssh-keygen -t rsa -b 2048 […]

Read More

Troubleshoot long running Concurrent Request in Apps 11i/R12

This post covers overview of How to troubleshoot long running concurrent request in  Oracle Apps 11i/R12 Step 1 : Check Concurrent Request ID of long running concurrent request from front end Step 2 : Find SID, SERIAL# and SPID by running SQL (given below) Step 3 : Enable event 10046 trace with level 12 using oradebug ( […]

Read More

SQL to monitor (check status) of Workflow Notification Mailer (Java)

 SQL> SELECT COMPONENT_STATUS from APPS.FND_SVC_COMPONENTS where COMPONENT_ID=10006;  

Read More

Embedding SQL in Shell

Embedding a SQL inside Shell Script:- Here is a tip on how to run sqlplus scripts within a shell script. This is an example of how to pass database values into shell variables, and to make shell scripts more dynamic. This will help DBA to automate certain DBA tasks, also to setup some automation using […]

Read More

OID Quesries/ Scripts FAQ

Oracle Internet Directory (OID) is LDAP compliant directory server from Oracle. OID is part of Identity Management stack of Fusion Middleware (Infrastructure tier of Oracle Application Server)  Here is list of commonly asked questions/scripts for OID Q: How to find orasso (Single Sign-On) schema password. A: orasso password is randomly generated and stored in OID. To find password run […]

Read More

Collection of Queries/Scripts

1)How to check if the partitions of a table are set to LOGGING select partition_name, logging from dba_tab_partitions where table_name=’WF_LOCAL_ROLES’; 2)How to Correct Session Cookie Name. a)select session_cookie_name from icx_parameters; b)update icx_parameters set session_cookie_name = ‘<hostname_sid>’; c)select session_cookie_name from icx_parameters; 3) How to find database SID from a Concurrent request. column process heading “FNDLIBR PID” […]

Read More

Collection of Workflow Administration Scripts and/or Concurrent Program

Workflow Scripts: Source Oracle Documentations The below are the collection of Workflow Administration Scripts and/or Concurrent Program. 1. FNDWFPR For Oracle Workflow embedded in Oracle Applications, use the standard concurrent program FNDWFPR ”Purge Obsolete Workflow Runtime Data” to purge old data from the Oracle Workflow runtime tables regularly. Navigate to the Submit Requests form in […]

Read More