Inter v$view Q's: Set - 1

Inter v$view Q's: Set - 1

Disclaimer : Ans mentioned for some of the Q's mentioned below can be blunder mistakes . Those are best of My Knowledge. So, pls take the experts advice before U take it into mind  ;-)

1) After Cloning how will U take care of /retain Customizations?

2) Have U worked on SSL Certificates?

3) Wht will U do when an archive shipped to Standby got Corrupted ?

Ans: Corrupt Archive won't be applied to Standby, there by consecutive archives won't be applied. DBA can identify the same 4m v$archived_log view.

select seq#, applied from v$archived_log;

There will b no progress in d archives being applied.

Fix: In Standby : Note d corrupt archive name or sequence nd rename it.

      Now, copy/ ftp that particular archive 4m Primary 2 Standby. Wait 4 some time....U can see the archives being applied normally.

4) During 11i nd R12 Mullti Node installations what are the differences U noted?

5) Have U worked on PCP? How it works? What is the Pre Req's for setup?

6) How U'll reduce upgrade downtime ?

Ans : Some things which I knw is

1) V can temporarily set job_queue_processes to a higher value nd revert it back after upgrade

2) Make sure the gather schema stat's for ALL schema's ran before start of upgrade

3) Post Upgrade also I am not sure the gather schema stats runs as part of upgrade patch driver. Which we can comment or remove and we can submit d same after releasing the instance to Customer as this is online task. But this is not recommended.

7) How U'll migrate Menu's or Responsibilities across instances?

Ans : FNDLOAD 

8) As part of Cloning how U'll take care of PCP ?

9) Why Custome Mgr?

10) What is the character set supported in both 11i nd R12?

11) We have a requirement to install NLS ( a new language ) from a Customer. What is the pre req U check for?

Ans : We need to c the base character set will support the new lang or not ?

12) I've upgraded my Cluster ware to higher version. Now will I need to go for upgrading my ASM and Oracle Db SW to a higher version? or not required?

     What is the rule we need to follow?

UR's Key Run ;-) 

INTER-v$view

Topics to have a touch for Oracle Apps DBA interview ( 3+ yrs ):

Linux : Basic Commands

1.      ls

2.      ln

3.      ps ( ucx, -eaf, -fx )

4.      grep

5.      awk,sed

6.      lsof

7.      netstat

8.      find

9.      top, sar, vmstat

10.  uptime

11.  free

12.  cpuinfo, meminfo

13.  uname ( -a, -ms) ( 32 bit/64 bit )

14.  sysctl.conf

15.  hosts

16.  hostame ( -i, -f )

17.  mount/umount

Oracle DBA ( 10g/11g) :

1.      10g Architechture

2.      Installation of Oracle 10g/11g ( Kernal Parameters significance )

3.      Upgradation from 9i – 10g

4.      Tablespace management

5.      Backups ( Physical [Hot/Cold] , Logical [Exp/Imp/RMAN])

6.      Recovery Scenarios

1.      System datafile loss

2.      Non-System Datafile Loss

3.      Redo logfile loss

4.      Table loss

7.      Cloning ( Hot/RMAN )

8.      Exp/Imp Options also expdp/impdp advancements

9.      tkprof, explain plan, statspack, awr

10.  RMAN configuration and bkps

11.  Datagaurd modes/parameters/configuration

12.  ASM ( concept/RAID/how to add disk group dynamically )

13.  RAC basics ( Architechture/ Cmnds )

14.  11g New feautures

Oracle Apps DBA ( 11i/R12 ) :

         1.      Installation 11i/R12

         2.      11i/R12 Architectural differences

         3.      Apps Patching ( Types of Patches, Reduce downtime, Issues )

         4.      DB Patching ( Types, Apply/Rollback, Issues )

         5.      Inventory ( Local/Global )

         6.      Concurrent Mgr ( Types, Custom Conc Mgr, PCP, Issues )

         7.      Forms ( Servlet/Socket, In R12 how to shift bw them, Config files in 11i/R12)

         8.      Apache ( Main Config files 11i/R12, Locations, Issues like 500 Internal server Error, Blank Pg, Slow etc )

         9.      Point Release and Major Upgrades to R12

        10.  Application Cloning ( Issues, Post Steps )

        11.  Add node

        12.  Custom Top Creation

        13.  Register Conc Prog/Form

        14.  Logfiles and Config files locations

        15.  Autoconfig ( Concept/ Templates/XML files )

-          In the above listed topics some may be missing ( some are intentionally missed as they are supposed to be known to you and interviewer may not stress )

-          Please suggest any more to be added.

Thanks,

Kiran