Monday, November 30, 2020

Test Demantra Bounce Steps

 

Stop Demantra TEST Services:

 

Step 1:

 

http://musaib.omer.TST:7001/console

 

·         Login as weblogic/ welcome1 then ,

·         Navigate to  Servers -> Control, select TST_managedserver and click on Shutdown -> Force shutdown now.

·         Once the managed server is fully Shutdown.

·         Select AdminServer(admin) and click on Shutdown -> Force shutdown now.

Step 2:Kill Engine

     a. Login to musaib-omer-tst (putty session)

·         username:

TST            

TST

·          

     b. Check if any Engine services are running by,

ps -ef|grep -i  engine

·         If it displays any Engine processes then

Goto  /u01/app/oracle/products/Engine/bin  and run

 sh KillEngine.sh

·         Check ps -ef|grep -i  engine again ,If the process is still running kill manually by kill -9

3. Stop the Weblogic Services:

       a. Login to musaib-omer-tst server (as demprd usr)

tst    

tst

 

·         Goto /u01/app/oracle/products/oracle_home/user_projects/domains/demantra/bin and run.

              nohup ./stopWebLogic.sh &

·         Check nohup.out, it should display below :

 <Sep 2, 2017 9:25:28 AM EDT>  <Notice> <WebLogicServer> <BEA-000365> <Server state changed to force Shutdown>

<Sep 2, 2017 9:25:28 AM EDT> <Notice> <WebLogicServer> <BEA-000360> <Server started in shutdown mode>

4.Stop Node Manager on demprd servermusaib-omer-tst

      a. Goto /u01/app/oracle/products/oracle_home/user_projects/domains/demantra/bin  and run

nohup ./stopNodeManager.sh &

Starting Serives :

 

To start demantra:

1.Start weblogic services.

 a. Login to musaib-omer-tst server (as tst user)

·         goto /u01/app/oracle/products/oracle_home/user_projects/domains/demantra/bin

nohup ./startWebLogic.sh &

·         Check nohup.out, it should display below

<Sep 2, 2017 9:25:29 AM EDT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to RUNNING>

<Sep 2, 2017 9:25:29 AM EDT> <Notice> <WebLogicServer> <BEA-000360> <Server started in RUNNING mode>

2.Start NodeManger server

   b. Goto /u01/app/oracle/products/oracle_home/user_projects/domains/demantra/bin

        nohup ./startNodeManager.sh &

·         Check nohup.out, it should display below

<Sep 2, 2017 9:26:27 AM> <INFO> <Secure socket listener started on port 5556>

Sep 02, 2017 9:26:27 AM weblogic.nodemanager.server.SSLListener run

INFO: Secure socket listener started on port 5556INFO: Secure socket listener started on port 5556

3. Start Demantra

Login to http://http://musaib.omer.TST:7001/console

·         Goto WLS console Servers -> Control, select tst and click on Start

·         Goto Deployments and Check tst is showing "Active" state and Health "OK"

4. Start the demantra Engine

·         Login to musaib-omer-tst server as tst user

·         Goto /u01/app/oracle/products/Engine/bin

               nohup ./EngineStarter.sh &

·         Check nohup.out, it should display below to confirm Engine came up.

source /u01/app/oracle/product/Engine/bin/setenv.sh; ./EngineStarter DEM_CONN coldemappprd 8

2016-08-02.08:54:14 WARNING: Old eng_coldemappprd was removed from ENGINE_STARTER_LIST

2016-08-02.08:54:15 Engine Starter (ID:eng_coldemappprd, Number of Engines:8) is listening ...

·         Now run below from same Location,

                nohup ./Start_Engine2K.sh &

·         Check nohup.out, it should display like below

source /u01/app/oracle/product/Engine/bin/setenv.sh; ./EngineManager.exe 1 1

2016-08-02.08:55:22 Got notification ID: 39173648E48E009CE053C0A83310A5F8, Message: ConfirmationId=116026&command=AlivePing

2016-08-02.08:55:22 Received Ping request Request. ReplyStatus: SUCCESS

source /u01/app/oracle/product/Engine/bin/setenv.sh; ./EngineManager.exe 99 1

 

 

 

 

Wednesday, November 25, 2020

Get blocking session information

 

find out whose session is blocking whom

select l1.sid "holder",l2.sid "waiter" from v$lock l1,v$lock l2 where     l1.id1=l2.id1 and l1.id2=l2.id2 and l1.block=1 and l2.request>0 order by l1.sid;

Get the each session info using the below query

set line 150
col program for a20
col MODULE for a20
col action for a20
col user@machine 	for a30
col (SID,SERIAL#) 	for a15
set line 150
select '('||sid||','||serial#||')' "(SID,SERIAL#)",last_call_et/3600,status,username||'@'||machine as "user@machine",program,module,action
from v$session where sid=&SID;

action – will tell you the Name of the currently executing action.
Ex: concurrent request,JDBC Thin Client, FRM*- form session

status – will tell you whether the session is active or inactive

If it is an inactive form session inform the user to log off and log back. If the user has logged off and still the lock exists then you can kill the form session.

Test Demantra Bounce Steps

  Stop Demantra TEST Services:   Step 1:   http://musaib.omer.TST:7001/console   ·          Login as weblogic/ welcome1 then , ...