Download Patch Check the database name and current version Sql> select name from v$database; Sql> select * from v$version; Make dir new oracle home for $mkdir -P /u02/app/oracle/product/ Install patch (p10404530) su – oracle cd /mnt/database $ ./runinstaller -silent -force -responsefile <response file location> Pre upgrade Step /u02/app/oracle/product/ * Change to the directory

Blocking Session which is stuck and cannot remove from the blocking list, even you kill it again and again.

Run Environment file — to connect to the correct database [oracle@erpdb ~]$ . env.sh Launch SQLPLUS as sysdba user [oracle@erpdb ~]$ sqlplus / as sysdba <SQL> select substr(a.spid,1,9) pid, substr(b.sid,1,5) sid, substr(b.serial#,1,5) ser#, substr(b.machine,1,6) box, substr(b.username,1,10) username, — b.server, substr(b.osuser,1,8) os_user, substr(b.program,1,30) program from v$session b, v$process a where b.paddr = a.addr and type=’USER’ and