Linux mpstat Command

What is mpstat? mpstat is used to monitor cpu utilization on your system. It will be more useful if your system has multiple processors. The first processors will signed as CPU 0. The second one will be signed CPU 1 and so on. The mpstat command writes to standard output activities for each available processor,…

EM 12c, 13c: Enterprise Manager Cloud Control Agent Install Fails at Initialization Step With Error: SSH daemon (sshd) is not running on port 22

This error can occur due to one of the following reasons: 1. SSH port 22 is blocked by proxy / firewall on the Target machine 2. SSH is not running on the Target machine 3. SSH daemon is running on non-default port (other than 22) 1. Verify that the SSH port 22 is not blocked…

Installing SQLcl

SQLcl is the new command line tool from Oracle, more specifically from the SQL Developer team. It is currently an Early Adopter (EA) release and you can download it from: http://www.oracle.com/technet Source: Installing SQLcl  

Patch EM13c

After installing EM13c, you may want to install the latest patches as well. We’ll start with OPatch and OMSPatcher. Download the following patches from Oracle Support: p6880880_139000_Generic.zip => OPatch p19999993_132000_Generic.zip => OMSPatch Go to your patching staging area: cd /app/oracle/media/patches unzip p6880880_139000_Generic.zip Check the existing versions: [oracle@oms13c]$ $OMS_HOME/OMSPatcher/omspatcher version OMSPatcher Version: 13.8.0.0.0 OPlan Version: 12.1.0.2.2 OsysModel…

Install EM13c in silent mode

Suppose you have already the server created. As root user install the necessary packages for EM13c: yum install make -y yum install binutils -y yum install gcc -y yum install libaio -y yum install glibc-common -y yum install libstdc++ -y yum install libXtst -y yum install sysstat -y yum install glibc -y yum install glibc-devel…

How to get the response file for a silent install of EM13c

[oracle@oms13c]$  ./em13200_linux64.bin -J-Djava.io.tmpdir=/app/em13-temp -getResponseFileTemplates -outputLoc /app/oracle/media 0%……………………………………………………………….100% Launcher log file is /app/em13-temp/OraInstall2018-05-23_10-10-54AM/launcher2018-05-23_10-10-54AM.log. Copying response file template(s) to /app2/oracle/media …   Copying response file template software_only.rsp   Copying response file template new_install.rsp   Copying response file template upgrade.rsp Finished copying response file template(s) The log(s) can be found here: /app/em13-temp/OraInstall2018-05-23_10-10-54AM.

X11 connection rejected because of wrong authentication.

This is a nice one, while you’re configuring the ssh port forwarding to get your display from the source server onto destination server using SUDO. In case you don’t know the oracle user’s password on the destination server, but you have sudo privilege, you’re going to do something like this: On the source: Change the…

List all running jobs

SET PAUSE ON SET PAUSE ‘Press Return to Continue’ SET PAGESIZE 60 SET LINESIZE 300 SET VERIFY OFF SELECT a.job “Job”, a.sid, a.failures “Failures”, Substr(To_Char(a.last_date,’DD-Mon-YYYY HH24:MI:SS’),1,20) “Last Date”, Substr(To_Char(a.this_date,’DD-Mon-YYYY HH24:MI:SS’),1,20) “This Date” FROM dba_jobs_running a /