Oracle DBA Solution !!

 Printer can be checked /or started using root access: ---------------------------------------------------- Types of printers: ---------------- Lexmark (Pasta) --os driver install Zebra printer - /ebsprint --picked by bartender software --opp lpstat -p <PrinterName> Printer not responding! lpq -P <Printer Name> cancel -a <PrinterName> lpq -P <printerName> cupsenable <printerName> lpq -P  <printerName> Hello Team, Umesh has scheduled new alert. Whenever there is any printer in disabled state in Prod(x1ebsa01/x1ebsa02) we will get this alert. Action: To check disabled printer: lpstat -p | grep disable To check printer is installed on server: lpstat -p| grep -i SL_SITEST7_HP_M506 Check the queue on server: lpq -P SL_SITEST7_HP_M506 If there is a long queue, cancel the request Cancel the request: lpq -P SL_RMA_01_HP_M506 cancel -a SL_RMA_01_HP_M506 cupsenable SL_RMA_01_HP_M506 lpq -P SL_RMA_01_HP_M506 Few additional commands just for FYI: To che...

  select name from v$database; REM  Jobs already on hold select count(1) from  apps.fnd_concurrent_requests  where phase_code='P' and hold_flag='Y'; create table xxbkp.fnd_conc_reqs_hold_03dec20 as select  * from  apps.fnd_concurrent_requests  where phase_code='P' and hold_flag='Y'; select count(1)  from  xxbkp.fnd_conc_reqs_hold_03dec20; REM putting all pending jobs  (which are NOT on hold) to hold select count(1) from  apps.fnd_concurrent_requests  where phase_code='P' and hold_flag='N'; create table xxbkp.fnd_concurrent_reqs_03dec20 as select * from  apps.fnd_concurrent_requests  where phase_code='P' and hold_flag='N'; select count(1)  from  xxbkp.fnd_concurrent_reqs_03dec20; REM  Putting pending jobs on hold REM  if the above  records match run update statement as below to put pending jobs on hold update apps.fnd_concurrent_requests  set hold_flag='Y'  where phase_code='P' and re...

Oracle Database 11.1.0.7 upgrade to 11.2.0.4       Section 1: Upgrading an R12 Database to Oracle Database 11g Release 2 (11.2.0) Verify software versions:-   The following software component versions must exist in your environment. Software Minimum Version Tier Details Oracle Database Enterprise Edition N/A Database Read the "Determine the Upgrade Path" subsection in Chapter 2 of the Oracle Database Upgrade Guide 11g Release 2 (11.2) . Make sure that direct upgrade is supported from your current release. Oracle E-Business Suite 12.0.4 or 12.1.1 Application If you are on E-Business Suite Release 12.0, apply Patch 6435000  - Oracle E-Business Suite 12.0.4 Patch 8623536  - 11g Release 2 interoperability patch for Release 12.0.4 Patch 9868229 If you are on E-Business Suite Release 12.1, apply ...