appsdbalife.wordpress.com
Just Another Day of Apps DBA's Life | notes of an oracle apps dba
Just Another Day of Apps DBA's Life. Notes of an oracle apps dba. Author – Maris Elsins. GetMOSPatch.sh – Downloading Patches From My Oracle Support. November 12, 2013. This post originally appeared at the Pythian. How to download patches from My Oracle Support (MOS) directly to the server? Then, back in 2009 my teammate John. Published a blog post on Retrieving Oracle patches with wget. I think it’s time to get rid of browser dependency. So I’ve written a shell script getMOSPatch.sh. November 4, 2013.
appsdbanew.wordpress.com
Apps DBA Concepts
Just another WordPress.com weblog. Bulk collect comes handy for plsql. Find the current SQL in the database. Important for Windows Oracle Apps customer. How to find blocking session and kill the session from database. R12 - Shortcut to access the forms URL and sysadmin Responsibility page. Applications Short Name for most of the Apps Products. To find the StartCD version - R12. How to find an AD patchset level? ARCHIVE LOG START is DEPRECATED in 11g. Naveen – Pratical Apps DBA. On November 27, 2010.
appsdbanotes.wordpress.com
Apps DBA notes | Just another WordPress.com weblog
Just another WordPress.com weblog. How Veeam backup MSSQL. July 8, 2016. I love Veeam. It is easy to use and do a nice job. Make our live easier than before. OK, What is important for DBAs here? What is the relation that DBA need to know about. How Veeam backup SQL server? This is first and most important question that I was looking for. Veeam is install service on VM during backup time and in our case is using Volume Shadow Copy Services (VSS) to backup SQL server. How this is going to be? BE CAREFUL AS...
appsdbaportal.blogspot.com
Oracle Application DBA Portal
Major changes from 11i. Compile Apps Schema invalid objects in R12. Apps Components and Architecture. Upgrade 11.5.9 to 11.5.10.2. Upgrade from 11.5.10.2 to R12. Upgrading 9i to 10g with 11i. AppsDBA System Management Utilities Guide. Identifying Long Idle Sessions. Identifying High Active Sessions. Change hostname for EBS. Oracle12c Datafile moved Online. Upgrade 10g to 11g R1. Upgrade 11.2.0.2 to 11.2.0.3. Top 99 Responsibilities of a DBA. Disk I/O,Events,Waits. Oracle AS10g null protocol issue. New an...
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;.