appsdbaquestions.blogspot.com
Oracle Apps DBA troubleshooting
Oracle Apps DBA troubleshooting. Saturday, November 14, 2009. ORA-27047: unable to read the header block of file. Trying to clone from prod. If you noticed following error message. CREATE CONTROLFILE REUSE SET DATABASE "DEV". ERROR at line 1:. ORA-01503: CREATE CONTROLFILE failed. ORA-01565: error in identifying file. ORA-27047: unable to read the header block of file. After above error I run following command and noticed header error. System01.dbf: Header block magic number is bad. Oracle Apps DBA blog.
appsdbaref.com
Coming Soon - Future home of something quite cool
Future home of something quite cool. If you're the site owner. To launch this site. If you are a visitor. Please check back soon.
appsdbarepository.blogspot.com
Info on Oracle Apps and DB
Info on Oracle Apps and DB. Sunday, March 25, 2007. Apps - Concurrent Queries. Request Details with Status/Phase Info. Select b.user concurrent program name, cp.request id, sc.MEANING,pc.MEANING ,. To char(cp.actual start date,'dd-mon-yyyy hh24:mi'),. To char(cp.actual completion date,'dd-mon-yyyy hh24:mi'). FROM apps.fnd concurrent requests cp ,apps.fnd concurrent programs vl b, apps.fnd lookups sc , apps.fnd lookups pc. Cprequest id between = ReqId. Bapplication id = cp.program application id and.
appsdbas.blogspot.com
Oracle Apps DBA
This blog is created to put all the Apps DBA relevant information at one place. Friday, December 02, 2011. Useful Articles for Apps DBAs Oracle noteID ID 828157.1. Java- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - note 418664.1. Overview of Using Java with Oracle E-Business Suite Release 12 note 455492.1. Using Latest Update of Java 6.0 with Oracle E-Business Suite Release 12 note 384249.1. Upgrading JInitiator with Oracle E-Business Suite 11i note 11...
appsdbastuff.blogspot.com
Oracle Apps DBA stuff
Oracle Apps DBA stuff. Friday, March 13, 2015. Method to Track Oracle Schema User Password and Modification History. Find out Current, New Password. Here are the steps:. Here these objects like table, Procedure, Function are created under sys user. Only sys can query the changes. SQL conn / as sysdba. Create a tracking table with a character column. SQL create table pass track (hist varchar2(200) ;. Create a procedure with autonomous transaction to insert the records to the table. END fn track pass;.
appsdbasupport.com
This site is under development
appsdbasupport.wordpress.com
APPS DBA Support | share my expierience
11202 ‘GCR sleep’ event. And I couldn’t understand what is this sleep/wait event that occupies 15% of system resources and how I cannot see it from application performance or concurrent processing point of view . As neither MoS or google could help me SR was raised and this is what we get:. The GCR sleep event is an Idle Wait Event. This event should not be included by statspack when reporting on the Top Timed Events. So no worries, this is just a representative bug into Oracle Statspack. Is built so tha...
appsdbasworld.blogspot.com
Oracle AppsDBAs World
Http:/ appsdbasworld.blogspot.com. R12ADA.DELTA.4 Patch. Increasing the number oacore process type(JVM) and. InitSID.ora settings for release12. Creating custom top in release12. Workflow Notification Mailer Setup. Schedule downtime in R12. Enable/Disable restrict session of Apache. Opening forms from linux machine. Replacing Jinitiator with JRE for Oracle Apps 11i. Enabling SSL for E-Business suite 11i. Executing gather schema statistics at backend. How to check versions. How to find patchset level.
