Startup Shutdown Application Server – Bounce Services

i guess the defual port is 1810 not 1156 can you please check it.

thanks
fadi

Fadi ,
Thanks for pointing that out , I have seen both depending on Application Server versions .

In some 1156 & 1810 , I did couple of 10.1.2.0.2 AS where port was 1156
whereas in 9.0.4 AS & collaboration Suite 10.1.2.0.0 its 1810.

Hi Atul,

Can we use 9i forms and reports with oracle applications 11.5.10.2
can u please guide me on this its very urgent.

Thanks,
appsdba

No Apps DBA,
Only 806 forms are integarted & certified with 11.5.10.2 though you can configure 10g Forms & reports comes with 10g Application server with Apps

Hello Atul,

For a 10gAS Rel 1 installation supporting retek applications, we copied all the configuration and installation files to a new box(unix aix installation). I know its not supported but, can you give me the configuration files which stores the hostname as we need to change the hostname of the box. Will this work?

Regards.
Syed

Syed,
You want to change server name to old server (source from where you moved) or you want to change values in 10g AS so that it takes new server name ?

Is old server also AIX ?

hi
well that was very well said… one question , though..
you said start db…
well which db, infrastructure db.??? coz i hv another prodn db rnnning on same box as app server… any suggestions

hardik shah

Hardik,
If your portal,BI or any other product data is stored in another database in that case you have to start product database & listener as well.

So for starting applications start infastructure database and any other database associated with application tier

Hi Atul,

Can you discuss more on opmnctl and dcmctl ,on which all scenarios these utilities will be used and what is the major difference between these two utilities.

AppsDBA

Sure I’ll cover this after RAC doc in a week or two .

Hi,

Has anyone got any Windows scripts that they could send me to stop and start the Oracle 10g app server services ?

I am new to 10g and am looking for a really good script that sets environment, sleeps etc … that can be used commercially

Please send to :- rob_ford@hotmail.com

many thanks Rob

hi,

i am fresher as a apps DBA. So can u please tell me the process of how to Down and up the database and also the purpose.

Regards
Abhishek Mishra
mail : abhishek_577@yahoo.co.in

To Start Database

sqlplus “/as sysdba”
startup

To Shutdown Database
sqlplus “/as sysdba”
shutdown immediate

Hi Atul,
I followed the your script for shutdown and all services shutdown well.
But,after that i issued following statement to check if all process shutdown
$ ps -ef|grep ora10g
ora10g 8916 1 0 Nov 4 ? 0:43 /u01/ora10gias/perl/bin/perl /u01/ora10gias/bin/emwd.pl dbconsole /u01/ora10gias/cgcaprpt_appinfra/sysman/log/emdbconsole.nohup
ora10g 8923 8916 0 Nov 4 ? 6:22 /u01/ora10gias/bin/emagent
ora10g 11822 8916 0 10:34:12 ? 0:07 /u01/ora10gias/jdk/bin/IA64N/java -server -Xmx512M -XX:MaxPermSize=64m -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -XdoClos

The above process are not shutdown, how can i incorporate this in my shutdown script or should i just kill this process ?

It seems dbconsole is still running

for 10g AS R2
use
emctl stop dbconsole
emctl stop iasconsole

for 10g AS R3 use
opmnctl stopproc application=ascontrol

or you can kill above processes (Not an issue)

Hi Atul,
Normally I use OEM to manage/monitor my Application servers but since there is a separate license for Diagnostic packs I tend to manage/monitor my Application Server components using OPMNCTL. Is there a way or a tool that i’ll be notified when one of my application server components gets any problem(suddenly stop/died)?

hi,

i am fresher as a apps DBA. So can u please tell me the process of how to Down and up the database
Regards,
sanjit de

i am fresher as a apps DBA. So can u please tell me the process of how to Down and up the database
Regards,
sanjit de
de.sanjit@gmail.com

@ Sanjit

For R12 check this http://onlineappsdba.com/index.php/2007/06/10/start-up-shutdown-scripts-in-oracle-apps-r12/

for 11i check this http://onlineappsdba.com/index.php/2006/08/02/startup-shutdown-apps-services/

For database in apps

1. Ensure that middle tier services are down
2. Stop apps database and listener like standalone database

lsnrctl stop [SID]

sqlplus “/as sysdba”
SQL> shutdown immediate

problem: HTTP_Server not up/running; in ‘Stopped’ state when trying to:
opmnctl startall

any suggestion?

—– opmnctl status -l ——
C01001ADB001> opmnctl status -l

Processes in Instance: ——————-+——————–+———+———-+————+———-+———–+——
ias-component | process-type | pid | status | uid | memused | uptime | ports
——————-+——————–+———+———-+————+———-+———–+——
DSA | DSA | N/A | Down | N/A | N/A | N/A | N/A
HTTP_Server | HTTP_Server | 5799 | Init | 1642987591 | 6128 | 23:00:26 | N/A
LogLoader | logloaderd | N/A | Down | N/A | N/A | N/A | N/A
dcm-daemon | dcm-daemon | N/A | Down | N/A | N/A | N/A | N/A
OC4J | home | 29462 | Alive | 1452736599 | 59192 | 00:03:04 | ajp:12501,rmi:12401,jms:12601
OC4J | OC4J_EMPROV | 29463 | Alive | 1452736600 | 69904 | 00:03:04 | ajp:12502,rmi:12402,jms:12602
OC4J | OC4J_EM | 29464 | Alive | 1452736601 | 170904 | 00:03:04 | ajp:12503,rmi:12403,jms:12603
WebCache | WebCache | 29465 | Alive | 1452736602 | 36232 | 00:03:04 | http:7778,invalidation:9401,stati
stics:9402
WebCache | WebCacheAdmin | 29466 | Alive | 1452736603 | 12344 | 00:03:04 | administration:9400
thanks in advance.

–JN

@ JN,
Check log file related to http server in OPMN log

1. $ORACLE_HOME/opmn/logs

2. $ORACLE_HOME/ Apache/Apache/ logs/error_log

Hi Atul,
I installed Oracle 10gAS on ubuntu 12.04 LTS,but while checking the opmnctl status its showing:

Processes in Instance: ias_hns.localhost
——————-+——————–+———+———
ias-component | process-type | pid | status
——————-+——————–+———+———
DSA | DSA | N/A | Down
HTTP_Server | HTTP_Server | 16677 | Alive
LogLoader | logloaderd | N/A | Down
dcm-daemon | dcm-daemon | 16538 | Alive
OC4J | home | 16712 | Alive

plz let me know how to make DSA and LogLoader Alive(up).

Hi Atul,
I installed Oracle 10bAS on Ubuntu 12.04 LTS,the installation was successful
but when i am checking opmnctl status it is showing:

Processes in Instance: ias_hns.localhost
——————-+——————–+———+———
ias-component | process-type | pid | status
——————-+——————–+———+———
DSA | DSA | N/A | Down
HTTP_Server | HTTP_Server | 16677 | Alive
LogLoader | logloaderd | N/A | Down
dcm-daemon | dcm-daemon | 16538 | Alive
OC4J | home | 16712 | Alive

plz let me know how to make Alive(Up) DSA and LogLoader

Thank you Atul..

Hi,

My Question is that. My application server has created 3 session in ORACLE. Now the App server shutdown immediately due to any issue.
There are 3 GHOST session in ORACLE found.

Concern is

1) Do i need to Kill the session in ORACLE ?

2) When the app server up again it will use the session ? ( No need to kill session in ORACLE).