To check Oracle EBS/APPS Version
Run following SQL from apps user :
select RELEASE_NAME from fnd_product_groups;
You should see output like :
RELEASE_NAME
-----------------------
11.5.10.2
Posts Tagged ‘Oracle APPs DBA’
How to check Oracle EBS/APPS Version
May 22nd, 2016, posted in Oracle QueriesKeyboard Shortcut Keys In Oracle Apps 11i
December 20th, 2015, posted in OracleBelow are keyboard shortcut keys in Oracle Apps 11i. Use these to flaunt your skills in apps..
Trust me when you do this in front of clients it works like magic 🙂
- F4 Exit
- F5 Clear Field
- F6 Clear Record
- F7 Clear Block
- F8 Clear Form
- F11 Query Enter
- F12 Count Query
- Ctrl + S Save
- Ctrl + L List of Values
- Ctrl + F11 Query Run
- Ctrl + E Edit
- Ctrl + Up Delete Record
- Ctrl + Down Insert Record
- Ctrl + P Print
- Ctrl + U Update Record
- Ctrl + B Block Menu
- Ctrl + K Display list of Keys
- Shift + F5 Duplicate Field
- Shift + F6 Duplicate Record
- Shift + F8 Next Set of Records (Same as Page Down)
- Shift + Page Down Next Block
- Shift + Tab Previous Field
- Shift + Page Up Previous Block
- Shift + Ctrl + E Display Error
- Page Down Scroll Down (Same as Shift + F8)
- Page Up Scroll Up
- Tab Next Field
- Down Arrow Next Record
- Up Arrow Previous Record
- Return Return
Oracle : Up And Down of Oracle Application And Oracle Database
December 2nd, 2015, posted in Oracle, SolarisShutdown Oracle Application :
Go to the path :
/u88/appprodinst/apps/ListenerName_ServerName/admin/scripts
Run Command from Bash
bash-3.00$ ./adstpall.sh
Shutdown Oracle Database :
Go to the path :
/u77/oraprod/prod/db/tech_st/11.1.0/appsutil/scripts/ListenerName_serverName
bash-3.00$ ./addbctl.sh stop
If its taking to much time. You can use this command on extreme cases only :
ps -ef|grep pmon
Than Stop Listener :
bash-3.00$ ./addlnctl.sh stop ListenerName
————–
Start Oracle Database :
Go to the path :
/u77/oraprod/prod/db/tech_st/11.1.0/appsutil/scripts/ListenerName_serverName
bash-3.00$ ./addbctl.sh start
bash-3.00$ ./addlnctl.sh start ListenerName
Start Oracle Application :
Go to the path :
/u88/appprodinst/apps/ListenerName_ServerName/admin/scripts
Run Command from Bash
bash-3.00$ ./adstrtal.sh
AC-00005: No write permissions for creating the Context file – /tmp/temp.xml
September 12th, 2015, posted in Oracle, SolarisProblem :
While making Oracle Application Clone :
Target System Root Service [enabled] :
Target System Web Entry Point Services [enabled] :
Target System Web Application Services [enabled] :
Target System Batch Processing Services [enabled] :
Target System Other Services [disabled] :
Do you want to preserve the Display [hooraps1:0.0] (y/n) ? : n
Target System Display [erp2:0.0] :
RC-50004: Error occurred in CloneContext:
AC-00005: No write permissions for creating the Context file – /tmp/temp.xml
Raised by oracle.apps.ad.context.AppsContext
Check Clone Context logfile /u07/appprod/apps/apps_st/comn/clone/bin/CloneContext_0908103640.log for details.
ERROR: Context creation not completed successfully.
For additional details review the file /tmp/adcfgclone_17325.err if present.
When you check log file you will get this :
StackTrace:
java.lang.Exception: AC-00005: No write permissions for creating the Context file – /tmp/temp.xml
Raised by oracle.apps.ad.context.AppsContext
at oracle.apps.ad.context.AppsContext.getOaEnabledValues(AppsContext.java:733)
at oracle.apps.ad.context.CloneContext.setConfigHome(CloneContext.java:2306)
at oracle.apps.ad.context.CloneContext.doClone(CloneContext.java:606)
at oracle.apps.ad.context.CloneContext.main(CloneContext.java:5023)
RC-50004: Error occurred in CloneContext:
AC-00005: No write permissions for creating the Context file – /tmp/temp.xml
Raised by oracle.apps.ad.context.AppsContext
Context file creation not succesful
Solution :
Simply go to this path by root user /tmp/temp.xml . Give 777 rights to temp.xl .
And now login with application user and run perl adcfgclone.pl appsTier !!
GoodLuck !! 🙂
Error : Transaction Processor error
July 28th, 2015, posted in Oracle
This is one of the generic error and there could be multiple reasons, even a bug. Mostly and commonly it is seen in Inventory Module. For example, while you perform Subinventory transfer or Mis transaction then that through “Transaction processor error” or when you perform Inter-Organization Transfer then that through “Transaction processor error“.
Solutions :
1 ) For starters you can check Tablespace, sometimes they are full due to which this kind of issue may occur.
2 ) Check Managers from System Administrator Responsibility
3 ) Check is ‘Receiving Transaction Manager‘ from system administrator responsibility is working or not.
4 ) Check RCV: Processing Mode profile option to immidiate and then restart+activate ‘Receiving Transaction Manager‘ from system administrator responsibility
5 ) Shutdown the Oracle Application & Oracle Database. After doing that start the Database again and once the database is started wait for 5 mins and than start the Application again.
Try all these solutions one by one & hopefully if might resolve the issue. But do it on your own risk !! 😀