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 
Popularity: 8% [?]Share This

Popularity: 8% [?]

read more from this topic.....

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
follow the instructions […]

Popularity: 7% [?]

read more from this topic.....

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 ( for 15-20 minute)
Step […]

Popularity: 8% [?]

read more from this topic.....

 SQL> SELECT COMPONENT_STATUS from APPS.FND_SVC_COMPONENTS
where COMPONENT_ID=10006;
 
Previous in series Related Posts for Workflow Oracle Workflow Notification MailerWorkflow Notification Mailer Setup in Oracle Apps R12/12iOracle Workflow Notification Mailer Outbound ProcessingHow to update Workflow Administrator Role in Oracle Applications 11i/R12SQL to monitor (check status) of Workflow Notification Mailer (Java)Popularity: 7% [?]Share This

Popularity: 7% [?]

read more from this topic.....

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 cron.
#!/bin/sh
VAR1=`sqlplus -s […]

Popularity: 5% [?]

read more from this topic.....

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 below query
$ORACLE_HOME/bin/ldapsearch -h […]

Popularity: 16% [?]

read more from this topic.....

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”
SELECT a.request_id, d.sid, d.serial# ,d.osuser,d.process , c.SPID
FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_processes b,
v$process […]

Popularity: 10% [?]

read more from this topic.....