Blogs about: Dbaadmin Tips
Featured Blog
Is user equivelance really required at the OS level after RAC installation?
A wild though came to my head late this evening about the user equivelance in RAC. What will happen if i remove the user equivelance for the oracle home owner between the RAC nodes. What do you think … more →
OraclePitStop - Lets share some knowledge
Is user equivelance really required at the OS level after RAC installation?
oraclepitstop wrote 11 months ago: A wild though came to my head late this evening about the user equivelance in RAC. What will happen … more →
Single Putty Window - Multiple Tabs - for multiple server connections
— 1 comment
oraclepitstop wrote 11 months ago: Is it possible to have a tabbed putty like firefox or internet explorer? Yes you can, check out belo … more →
How to migrate PUTTY settings from one windows desktop/laptop to the other?
oraclepitstop wrote 11 months ago: Migrating putty settings from one desktop/laptop to the other box comes in handy when you had alread … more →
Oracle Apps R12 : How to find the list of responsibilities assigned to user(s)
— 1 comment
oraclepitstop wrote 11 months ago: SELECT FURGA.USER_ID , FU.USER_NAME , FURGA.RESPONSIBILITY_ID , FRTL.RESPONSIBILITY_NAME , FURGA.RES … more →
dbca - Creating RAC Database using dbca in silent mode
— 2 comments
oraclepitstop wrote 11 months ago: During the course of the DBA life, we all know how irritating it is to create a DB or to install a O … more →
Interesting enhancements in 12.0.6 - R12.ATG_PF.A.DELTA.6
— 1 comment
oraclepitstop wrote 12 months ago: Oracle Applications Technology Stack Release Update Pack 6 (R12.ATG_PF.A.DELTA.6) Autoconfig has two … more →
Unable to generate forwarding URL. Exception: oracle.apps.fnd.cache.CacheException
— 5 comments
oraclepitstop wrote 1 year ago: While trying to access the login page below error is reported. “Unable to generate forwarding … more →
How to enable trace with BIND variables and WAITs for a concurrent program?
— 1 comment
oraclepitstop wrote 1 year ago: In this link, we had mentioned about tracing a concurrent program, but the drawback of this method i … more →
How to clear cache for a specific component in R12?
— 1 comment
oraclepitstop wrote 1 year ago: As we all know the normal tendency for clearing cache in Oracle Apps is to delete the $COMMON_TOP/_p … more →
OPATCH_JAVA_ERROR : An exception of type "OPatchException" has occurred
— 2 comments
oraclepitstop wrote 1 year ago: While trying to apply a patch or listing inventory, using opatch utility (be it on the Database node … more →
How to associate / map / include / exclude a concurrent program to / from a specific concurrent manager in 11i & R12?
oraclepitstop wrote 1 year ago: Depending on the business need, at times we might have to exclude / include a concurrent program fro … more →
How to configure Workflow Mailer in 11i & R12
oraclepitstop wrote 1 year ago: One of the simple configuration in Oracle Apps is the Java Workflow Mailer configuration. The steps … more →
How to enable / generate trace for a form 11i / R12
oraclepitstop wrote 1 year ago: This step can be performed by any user who has access to the professional approach (ie., the forms n … more →
How to identify if a port is listening on a unix server
— 1 comment
oraclepitstop wrote 1 year ago: We often get into a situation wherein we have to check if a particular port is being used by some pr … more →
httpd: bad group name dba
oraclepitstop wrote 1 year ago: All were working fine on our SOA server untill we restarted the services. All the custom oc4j compon … more →
How to route / send all workflow mailer notifications to a single email id / address ?
— 2 comments
oraclepitstop wrote 1 year ago: Mostly, this option will come handy after a clone, wherein you want to retain all the production / s … more →
R12 - Responsibilities not visible to user
— 6 comments
oraclepitstop wrote 1 year ago: We recently encountered this issue on a R12 instance fully functional instance. 1) Login as sysadmin … more →
SQL Query to view sql for a OS Pid / process
— 1 comment
oraclepitstop wrote 1 year ago: Select a.sid,a.serial#,b.pid,c.sql_text,a.module, to_number(b.spid) PROCESSID, substr(a.username, 1, … more →
SQL Query to view sql of a session
— 1 comment
oraclepitstop wrote 1 year ago: SELECT T.sql_text FROM v$session S, v$sqltext_with_newlines T WHERE S.sid = &sid AND S.serial# = … more →
