• All
  • Data Guard
  • Oracle
  • Oracle Golden Gate
  • Performance Tuning
  • Training
  • Upgrade Oracle

Oracle DBA Training

REGISTER ONLINE FOR ORIENTATION SEMINARS Oracle Core DBA Training … Placement … plus Support. Please register for our upcoming Orientation/Overview Seminar, We’ll be covering the basics, also will share the Vision behind this training efforts. No restrictions … any & all are welcome to join the seminar, it’ll be highly appreciated if you register: https://superoracle.com/training/

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

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

Data Guard Physical Standby configuration in Oracle Database 11g R2

Data Guard Physical Standby configuration in Oracle Database 11g R2 =================================================================== Machine setup ————- We have two servers (physical or VMs) with Linux OS and Oracle installed on them. In this case I’ve used Oracle Linux 5.5 and Oracle Database 11.2.0.1.0. – The primary server has a running database instance. – The standby server has

Oracle Golden Gate Step by Step

step 1. Database_preReq.txt step 2. GG_setup.txt step 3. 01_CDC.txt step 4. NOW start the EXTRACT & PUMP @SOURCE only, but NOT REPLICAT, should NOT start REPLICAT now step 5. RECORD CURRENT_SCN @SOURCE database: select current_scn from v$database;    – orcl database step 6. RECORD this SCN number, you’ll be needing this at the time of starting the