Startup & Shutdown process in Oracle Apps in R12. STARTUP PROCESS 1.Start Database Tier Services –Start Database Listener $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addlnctl.sh start <listener_name> –Start Database $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addbctl.sh start or alternatively you can use lsnrctl start/stop <listener_name > sqlplus “/as sysdba” SQL> startup Then 2.Start Application/Middle Tier Services… Read More
How To Kill runaway processes After Terminating Concurrent Request Every concurrent Request uses some resources for running. If we decided and terminate the conc request which is taking long time and not progress any more further. after terminate it from front end,… Read More
Performance issue with particular form in EBS: Its common issue which reports by end user that they have a performance problem with particular form or form is slow responding Have the user show DBA exactly which form runs slow by select Help->Diagnostics->Trace and click in the… Read More
Role of APPLSYS & APPS schema in Oracle Applications: Applsys schema contains all the tables required for administarative purpose and is same as other oracle users like AP, AR, GL etc which hold their set of tables, views etc. In the same way APPLSYS Account… Read More
URL to access E-Business Suite : http://<web server host name>.<domain>:<port number> SSL enabled URL to access E-Business Suite : https://<web server host name>.<domain>:<port number> which is more secure How to find above URL in databasesqlplus apps/appsQUERY : SELECT home_url FROM icx_parameters; Usually data transmitted… Read More
What is Oracle Applications/Oracle E-Business Suite ?To facilitate big businesses, Oracle Corporation have created collection of software inthe category of ERP (Enterprise Resource Planning) known as modules, that areintegrated to talk to each other and known as Oracle Applications or E-BusinessSuite. Oracle E-Business Suite Releases:10.7… Read More
