UPGRADE ORACLE 11.2.0.3 TO 11.2.0.4

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

Leave a commentUpgrade Oracle

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

Leave a commentPerformance Tuning