OSWATCHER Report Generation in Linux

-

 Perform below steps to get os watcher data:


Step 1: go to oswatcher data location /fileserver/work_area/EBSQA/oswatcher/db10182019


cd /oraqa/oracle/OSWATCHERDATA

find . -name '*19.10.18*'  -exec zip         date should be in this format (yy.mm.dd) /fileserver/work_area/EBSQA/oswatcher/db10182019/osw_`hostname`.zip {} \;

above command will generate zip file . please unzip file using below command.

[oraqa@x2ebsdb01 db10182019] unzip osw_x2ebsdb01.mnao.net.zip

[oraqa@x2ebsdb01 db10182019] find . -name "*.gz" -exec gunzip  {} \; 


Step 2:  VNC server step :[ login to server using vncserver]

         $vncserver 

password: Mazdausa1

 

Step 3:  open vncserver enter username pwd [servername:portnumber] pwd 

          open new terminal --> 

  

step 4: cd /oraqa/oracle/oswbb

cd /oraqa/oracle/oswbb

    

  Below command is used to start OS watcher menu . Run it in vnc. Used options 6,7,P and A as requires

  Run this comamnd --> java -jar oswbba.jar -i /fileserver/work_area/EBSQA/oswatcher/db10182019 -b Oct 18 01:00:00 2019 -e Oct 18 03:00:00 2019

  

  for analysis --> /oraqa/oracle/oswbb/analysis  --> give latest file which is generated

   for profile --> /oraqa/oracle/oswbb/profile  --> give latest file which is generated

 yy-mon-date--this is format of oswatcher report

plz extract 19:45 to 20:15 oswatcher report from sppprd for 14/NOV/19 



find . -name '*14.11.19*'  -exec zip /fileserver/work_area/SPPPRD/oswatcher/db14112019/osw_`hostname`.zip {} \;

find . -name '*19.11.14*'  -exec zip /fileserver/work_area/SPPPRD/oswatcher/db14112019/osw_`hostname`.zip {} \; 



find . -name '*19.11.14*'  -exec zip /fileserver/work_area/SPPPRD/oswatcher/db14112019/osw_`hostname`.zip {} \;  --Perfect

 command which work 

 

 

 

 find . -name "*.gz" -exec gunzip  {} \; ----Not working 

 find . -name "*.gz" -exec gunzip {} \; ---Perfect working 

 

 

 

 

  Run this comamnd --> java -jar oswbba.jar -i /fileserver/work_area/SPPPRD/oswatcher/db14112019 -b Nov 14 19:45:00 2019 -e Nov 14 20:15:00 2019

 



 

Comments

Post a Comment

Popular posts from this blog

Compression Tools in Linux[TAR,gzip]

-
Compression Tools: tar: to compress files compress files: ``````````````` syn: tar -cvf <tarfilename> <file(s)> ex: tar -cvf files.tar hello.txt hi.txt raj.txt -c: create -v: verbose -f: tar file name Uncompress files: ````````````````` syn: tar -xvf files.tar tar with GZIP feature: `````````````````````` compress: tar -czvf files.tar.gz file1 file2 file3 file4 uncompress: tar -xzvf files.tar.gz -------------------------------------------------------------------------- gzip & gunzip: gzip: to compress file(s) ex: gzip hello.txt gunzip: to uncompress the file(s) ex: gunzip hello.txt.gz ----------------------------------------------------------------------- Storing and Analysing Logs: What is a log file: A log file is that which have information about all activities done on a linux serer. By default log files will be available under /var/log/ folder. Files: messages: Contains most of the information about different activites secure : contains securi...
Read more

All about DataInstaller & Hrglobal.drv in Oracle Applications R12

-
All about DataInstaller & Hrglobal.drv in Oracle Applications All about DataInstaller & Hrglobal.drv in Oracle Applications This posts covers what is datainstaller & hrglobal.drv and when do we need to run them. DataInstaller and hrglobal.drv are used for installing legislative data into Oracle Applications,For example a company operates in multiple counntries and payroll and HR practices are different in each countires, So they need to have all the legislative regulations (Taxation and HR rules and regulations) of the all the countries they run their business. To achive this Oracle provides a set of patches, which need to applied to the Oracle applications. These patches are country specific, The patch matrix can be found from Latest Oracle HRMS Legislative Data Patch Available (HR Global / hrglobal) [ID 145837.1] To Install the legislative data please follow the below 4 steps: 1) PER & PAY modules need to be licenced ( This is madantory requirement) ...
Read more

PSU Patching step by step on RAC

-
OPatch utility version 12.1.0.1.7 or later to apply this patch. Grid Patch:---------------------------------------------------------------------------------------------------------------- From Oracle Home as oracle user:- /o001/home/oracle/product/12.1.0/db_1/OPatch/opatch lsinventory -detail -oh /o001/home/oracle/product/12.1.0/db_1 From Grid Home as grid user:- /o001/home/12.1.0/grid/OPatch/opatch lsinventory -detail -oh /o001/home/12.1.0/grid As root user:- /o001/home/12.1.0/grid/OPatch/opatchauto apply /o002/Oct_PSU_Patch/26635815 -analyze export PATH=/o001/home/12.1.0/grid/OPatch:$PATH opatchauto apply <UNZIPPED_PATCH_LOCATION>/27010872 Check Oracle permission $ORACLE_HOME/lib/libsqlplus.so --- Should be 644 From both oracle and grid users:- opatch lsinventory col ACTION_TIME for a30 col BUNDLE_SERIES for a15 select ACTION_TIME,PATCH_ID,PATCH_UID,VERSION,ACTION,STATUS,BUNDLE_SERIES,BUNDLE_ID from dba_registry_sqlpatch; ###################################Amar Jadhav ######...
Read more