Oracle World

Application startup and shutdown scripts [sreenidba@sreenidba scripts]$  cd $ADMIN_SCRIPTS_HOME 1.adalnctl.sh   2.adautocfg.sh         3.adformsctl.sh    4.adoacorectl.sh   5.adopmnctl.sh    6.adstpall.sh  7.adapcctl.sh   8.adcmctl.sh      9.adformsrvctl.sh  10.adoafmctl.sh     11.adpreclone.pl   12.adstrtal.sh  1.adalnctl.sh  : script used to start the application listener services. logfile located in LOG_HOME or INST_TOP/admin/log adalnctl.txt To know the status of apps listner  [sreenidba@sreenidba log]$ adalnctl.sh status adalnctl.sh version 120.3 Checking status for listener process APPS_UAT. LSNRCTL for Linux: Version 10.1.0.5.0 - Production on 30-AUG-2017 12:47:58 Copyright (c) 1991, 2004, Oracle.  All rights reserved. Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=sreenidba)(Port=1600)) STATUS of the ...

Query to find running concurrent programs SQL>SELECT vs.username,  vs.osuser,  vh.sid locking_sid,  vs.status status,  vs.module module,  vs.program program_holding,  jrh.job_name,  vsw.username,  vsw.osuser,  vw.sid waiter_sid,  vsw.program program_waiting,  jrw.job_name,  'alter system kill session ' || ''''|| vh.sid || ',' || vs.serial# || ''';'  "Kill_Command" FROM v$lock vh,  v$lock vw,  v$session vs,  v$session vsw,  dba_scheduler_running_jobs jrh,  dba_scheduler_running_jobs jrw WHERE     (vh.id1, vh.id2) IN (SELECT id1, id2  FROM v$lock  WHERE request = 0  INTERSECT  SELECT id1, id2  FROM v$lock  WHERE lmode = 0)  AND vh.id1 = vw.id1  AND vh.id2 = vw.id2  AND vh.request = 0  AND vw.lmode = 0  AND vh.sid = vs.sid  AND vw.sid = vsw.sid  AND vh.sid = jrh.session_id(+)  AND vw.s...

Query to find table locks SQL>SELECT vs.username,  vs.osuser,  vh.sid locking_sid,  vs.status status,  vs.module module,  vs.program program_holding,  jrh.job_name,  vsw.username,  vsw.osuser,  vw.sid waiter_sid,  vsw.program program_waiting,  jrw.job_name,  'alter system kill session ' || ''''|| vh.sid || ',' || vs.serial# || ''';'  "Kill_Command" FROM v$lock vh,  v$lock vw,  v$session vs,  v$session vsw,  dba_scheduler_running_jobs jrh,  dba_scheduler_running_jobs jrw WHERE     (vh.id1, vh.id2) IN (SELECT id1, id2  FROM v$lock  WHERE request = 0  INTERSECT  SELECT id1, id2  FROM v$lock  WHERE lmode = 0)  AND vh.id1 = vw.id1  AND vh.id2 = vw.id2  AND vh.request = 0  AND vw.lmode = 0  AND vh.sid = vs.sid  AND vw.sid = vsw.sid  AND vh.sid = jrh.session_id(+)  AND vw.sid = jrw.session...

in Linux: --------------------------------- take the backup of jsp files in COMMON_TOP/_pages cd $COMMON_TOP/ [sreenidba@sreenidba comn]$ ls admin  clone  cz  exclude.xml  java  mvtaglib  _pages  temp  _TldCache  util  webapps [sreenidba@sreenidba comn]$ mv _pages _pages_backup create ne directory under common_top [sreenidba@sreenidba comn]$ mkdir _pages Now run the ojspCompile.pl script from FND_TOP/patch/115/bin cd $FND_TOP/patch/115/bin [sreenidba@sreenidba bin]$ pwd /d04/sreenidba/apps/apps_st/appl/fnd/12.0.0/patch/115/bin [sreenidba@sreenidba bin]$ ls ojspCompile.pl ojspCompile.pl [sreenidba@sreenidba bin]$ perl ojspCompile.pl -compile -flush -p 2 perl ojspCompile.pl –compile –flush -p 2(here "P" represents number of processes) Now check the new jsp files created or not in COMMON_TOP/_jsppages [sreenidba@sreenidba _pages]$ pwd /d04/sreenidba/apps/apps_st/comn/_pages [sreenidba@sreenidba _pages]$ csfwAddr.class...

[appldev@sreendba admin]$ sqlplus apps/apps SQL*Plus: Release 10.1.0.5.0 - Production on Tue Aug 29 11:21:19 2017 Copyright (c) 1982, 2005, Oracle.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select (case length(address) when 16 then '64-bit Oracle' when 8 then '32-bit Oracle' when 32 then '128-bit Oracle' end) Wordsize from v$sql where rownum <2 /   2    3    4    5    6    7 WORDSIZE ------------------------------------------ 64-bit Oracle SQL>

findout number of user process [sreenidba@sreenidba ~]$ ps -ef|grep sreenidba|wc -l 456 [sreenidba@sreenidba ~]$ ps -ef|grep sreenidba|wc -l 266 [sreenidba@sreenidba ~]$ find the disk space [root@sreenidba ~]# df -h Filesystem                         Size  Used Avail Use% Mounted on sreeni/sda2                           25G   17G  7.0G  71% / tmpfs                               32G  283M   32G   1% sreeni/shm sreeni/sda1                          788M   46M  702M   7% /boot sreeni/sda6                          6.9G  224M  6.4G   4% /tmp sreeni/sda5           ...

Query to find schema size in GB SQL>select    owner,    sum(bytes)/1024/1024/1024 schema_size_gig from    dba_segments group by    owner; --------------------------------------------------------------------------- OWNER                          SCHEMA_SIZE_GIG ------------------------------ --------------- APPLSYS                             111.531372 AK                                   .35546875 BSC                                 .297851563 CRP                                 .071289063 IGS                 ...