Apps DBA Questions
1. What is a snapshot? In which table we get Information?
2. How will check Apache is working in Front-end and Back End
3. Write down the methods to identify whether the application is in maintenance mode or not
4. What is the result of unsetting APPLCSF
5. How are the AOL Developers Environment variables set
6. How do we get access to the initial sigon to application?
7. From where are the Report files picked up for execution
8. Where are the Reports plsql files located
9. Which ORACLE HOME is used by ad utilities
10. Which file contains the product dependencies information
11. When apps password is given wrong for adstpall.sh, what is the effect on the services
12. What are the Various Statuses...
Migrating an Oracle Database From Solaris to Linux
on Tuesday, 5 June 2012
Migrating an Oracle Database From Solaris to Linux
There has been a general move over the last couple of years for a number of our clients to migrate their Oracle environments off Solaris/SPARC and onto Linux/x86, normally Red Hat Linux. The reasons typically given are cost savings and performance improvements. I had assumed that the takeover of Sun by Oracle would slow these migrations down as people waited to see the roadmap from Oracle but so far there's been no indication of that.
The migration process is reasonably well described in the Oracle documentation (Transporting Tablespaces Between Databases), but I'll give a summary of the process here so you can see what's involved, we're using the 'power of RMAN' (I think...
Oracle Database Platform Migration From CentOS (RHEL) Linux 4.5 to Solaris 10 Contents
on Tuesday, 5 June 2012
Oracle Database Platform Migration From CentOS (RHEL) Linux 4.5 to Solaris 10
Contents
Pre-migration Steps
Verify TDB support for target platform
Target system software version
Identify external files and directories
Start the database in READ ONLY mode
Verify the database is ready for migration
Prepare database on target server
Migration Steps
Run RMAN CONVERT DATABASE on Target
Move necessary files to target system
Complete the migration
Post Migration Steps
Pre-migration Steps
Verify TDB support for target platform
Before attempting a platform migration with TDB, verify the target platform is supported for TDB by your source platform. Query the view V$DB_TRANSPORTABLE_PLATFORM for the target platform name. Here is...
How to Enable Maintance Mode In R12 APPS?
on Tuesday, 5 June 2012
How to Enable Maintance Mode In R12 APPS?
During a patch application the recommended option is to Enable Maintenance node.When adsetmmd.sql runs, it sets the Profile Option ‘Applications Maintenance Mode’ (APPS_MAINTENANCE_MODE) to ‘MAINT’ to Enable ‘Maintenance Mode’ and to ‘NORMAL’ to Disable it.When you Enable or Disable ‘Maintenance Mode’, adadmin will execute the script.
sqlplus -S apps/*****
@$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE
sqlplus -S apps/*****
@$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE
Determining if Maintenance Mode is Running:
A quick way to verify if the Environment is on Maintenance Mode or not, is by checking the value of this Profile Option as follows:
sqlplus apps/apps
SQL>select...
Found dead process in ICM log file
on Tuesday, 5 June 2012
Found dead process in ICM log file
There is an issue occurred on my E-Business Suite.Many concurrent mangers are not started after restarted the concurrent manger server.The Internal Manager log file shows that the following information.
Found dead process: spid=(12099), cpid=(1125806),
ORA pid=(123), manager=(0/15293)
Found dead process: spid=(12053), cpid=(1125722),
ORA pid=(104), manager=(0/14293)
This was happened due to the controlling manager was not brought down gracefully.Gracefully meaning that it was brought down when and only when, all concurrent processes are completed.I have applied the following solution to resolve this issue.
Solution:
Step1. Stop all middle tier services including the concurrent...
How To Clear The Cache Using Functional Administrator
on Tuesday, 5 June 2012
How To Clear The Cache Using Functional Administrator
In R12 we use the following steps to clear the cache and also when we do this activity make sure that the users shouldn’t connect the applications.
Step1: Log in and choose the Functional Administrator responsibility – then choose Home.
Step2:Choose the Core Services Tab – then the Caching Framework Sub-Menu .
Step3:Click Global Configuration’ from the left hand side menu that appears and – In the far right choose ‘Clear all Cache’ button
Step4: A screen prompts and confirms that the action will clear all cache on the middle tier server – choose Yes.
Step5: A confirmation message is displayed, confirming that all cache has been cleared across middle...
How To Clear Apache/iAS Cache in 11i and R12?
on Tuesday, 5 June 2012
How To Clear Apache/iAS Cache in 11i and R12?
The following steps provides how to clear cache of Apache on Oracle E-Business Suite 11i and 12.
Whenever you bounce the apache server, you need to clear the server side cache, so that those cached pages will not be used again.
On 11i Versions:
Step1:Stop the apache listener
$COMMON_TOP/admin/scripts/adapcctl.sh stop
Step2:Clear Cache
cd $COMMON_TOP/_pages/
rm -rf *
Step3:Start the apache listener
$COMMON_TOP/admin/scripts/adapcctl.sh start .
On R12 Versions:
In R12 we have two methods to clear the cache.
Method1: We can clear the cache by using Functional Administrator.Please check the this Link How To Clear The Cache Using Functional Administrator.
Method2:If...
How to cancel a concurrent request from db level?
on Tuesday, 5 June 2012
How to cancel a concurrent request from db level?
The following query returns sid” and “serial#” once you have provided “request_id” of a Concurrent Program which is currently running.
Take the values “sid” and “serial#” and kill the sessions at the database level.
Step1:Connect to SQLPLUS as the APPS user:
SQL> SELECT ses.sid, ses.serial# FROM v$session ses, v$process pro WHERE ses.paddr = pro.addr AND pro.spid IN (SELECT oracle_process_id FROM fnd_concurrent_requests WHERE request_id = &request_id);
Enter value for request_id:
Step2:Connect to SQLPLUS as the SYSTEM user:
SQL> ALTER SYSTEM KILL SESSION '&sid,&serial#'IMMEDIATE;
Enter value for sid:Enter value...
Error running SQL and EXEC commands in parallel
on Tuesday, 5 June 2012
Error running SQL and EXEC commands in parallel
This issue has occurred when we do applying the patches on the Application Tier.
The cause of this is auto patch previous sessions are still exists in the server and failing the ad workers with the following error.
Error
11 workers have quit. Waiting for 9 more.
12 workers have quit. Waiting for 8 more.
All workers have quit.
Completed: file apgtxlat.sql on worker 1 for product ap username AP.
Time is: Sat May 26 2012 21:31:09
Error running SQL and EXEC commands in parallel
You should check the file
/applprod2/uat3/appluat3/admin/DEV/log/u7023348.drv2.log for errors.
Solution:
Kill the ad patch sessions...
Upgrade of Oracle Applications Version R12.1.1 to R12.1.3
on Tuesday, 5 June 2012
Upgrade of Oracle Applications Version R12.1.1 to R12.1.3
After Installation of Oracle Applications R12.1.1,I have upgraded to R12.1.3 Successfully in my Servers.
The following patches are required and download from the Oracle Support as per their environment.
In this Note I have added some more patches for avoiding the feature errors and for avoiding invalid objects.
Before going to proceed please check the metal ink Note Oracle E-Business Suite Release 12.1.3 Readme [ID 1080973.1].
Required patches:
p9239089_R12.AD.B_R12_LINUX.zip
p10349415_R12.AD.B_R12_GENERIC.zip (Optional)
p9239090_R12_LINUX_1of6.zip
p9239090_R12_LINUX_2of6.zip
p9239090_R12_LINUX_3of6.zip
p9239090_R12_LINUX_4of6.zip
p9239090_R12_LINUX_5of6.zip
p9239090_R12_LINUX_6of6.zip
p9239095_R12_GENERIC.zip
p9822544_R12.MSC.B_R12_GENERIC.zip(Optional)
Post...
