Submitted Questions

  • Version Upgrade

    How would you plan for an Oracle upgrade? What are the prerequisites?

    deepak subramoniam

    • Aug 3rd, 2014

    Ensure the nls Characterset of the parent and child database are same
    Ensure the editions of both the database are same.
    Ensure UTL_SMTP,UTL_HTTP,UTL_FILE Packages are available. (for 10g to 11g se)
    wm_concat needs to be changed in the 11g because in 11g the function will not be supported by Oracle

    rohith

    • Jul 21st, 2014

    if u want to any up-gradation in oracle first we need to check version compatibility like if u want to upgrade from 10g to 11g the 10g version should be 10.2.0.4 or 10.2.0.5. then install the 11g sof...

  • RMAN - parameters when scheduling backup

    What parameters do you specify/define while scheduling back-up using RMAN?

    SIMON AYOMPE

    • Aug 13th, 2014

    RMAN attaches a character string called a tag to every backup it creates, as a way of identifying the backup. You can either accept the default tag or specify your own with the TAG parameter of the BA...