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 ;-)