This post covers step by step instructions of How to Start/Stop services in Oracle Applications R12. These steps are from Online Oracle Apps DBA (11i /R12) training here (This is interactive online course over weekend with hands on exercises on installation, patching, cloning during weekdays)

If you are starting services then first start Database Tier services and then Application Tier Services.
If you are shutting down services then first stop Application Tier services and then Database Tier Services.

will everything be fine, if i simply startup the database again, or should I have to restart all application services as well.

This scenario might comes in case of any hardware cluster implemented for database node which runs on virtual IP/hostname, when everything gets mounted to failover node due to database is down, and database services will be restarted by the cluster scripts.

So what happens to the application node. should we have to restart the services there manually. (N.B – Not using RAC/TAF)

Check how much is free memory on system, check alert log and listener log of DB

padmajabodla said,

in November 15th, 2010 at 1:33 am

Hi,
I have installed R12 on windows 7 which is bought by focusthread successfully. After installation I was able to login to the application.

I am getting below error after restarting my PC. Please let me know what wrong I am doing? I have followed all steps correctly from this article.

“Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, ohs_admin@com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

i have recently installed EBS R12.1.1 on OEL 5.
i have performed express installation of EBS.
After installation i was able to login to application but after restarting my pc em not able to logged in to application.
i performed following steps:
1- cd /d01/oracle/VIS/db/tech_st/11.1.0
2- ./VIS_oel.env
after performing these steps when i run lsnrctl start it results in an error
lsnrctl command not found.
please help me out how i overcome this problem.

After executing env file see if your ORACLE_HOME & ORACLE_SID are set by
a) running “env” (without quotes)
or
b) echo $ORACLE_HOME

Saeed said,

in February 23rd, 2011 at 8:37 am

thanks a lot Atul Kumar
now its working.
can u plz tell me how to explore HR in EBS.
thanks again

Saeed

padmajabodla said,

in April 19th, 2011 at 8:59 pm

Hi,

How can I clear AME cache? We are in the UAT phase and go live is on Monday.
Whenever I compile AME custom package (which is a copy of AME_UTIL), AME displace invalid object error in ame_exceptions_log. It worked some times when we ran the utlrp.sql script with SYSDBA privilege. Can you please help me to find out the where to clear cached object.

Thanks in advance,
Padmaja

Hitesh said,

in September 19th, 2011 at 9:34 am

Atul,
I have bought the virtual machine from Focusthread some time back but never used it actively as old PC was not powerful enough. Now I have bought a new laptop and put all the files on C drive. I have followed all the steps but getting error TNS-12560: TNS:protocol adapter error.

[ovisr12@focusthreadr12 ~]$ lsnrctl start visr12

LSNRCTL for Linux: Version 11.1.0.7.0 – Production on 19-SEP-2011 14:21:18