That’s Me

Gavin Soorma
  • Oracle Certified Professional
    • 7.3, 8i, 9i,10g, 11g
  • 11i Apps DBA OCP
    •
  • 10g RAC OCE
    •
  • Certified GoldenGate Implementation Specialist
    •
  • 10g OCM
    •
  • 11g OCM
    •

    Feedback

    1,650,000 hits

    Thanks A MILLION for your support!

    Please send me your valuable feedback and suggestions

    Installing Oracle 10.2.0.5 Enterprise Manager Grid Control on Linux and upgrading the repository database to 10.2.0.5

    This note explains the procedure used to install 10.2.0.5 Grid Control on a Linux operating system (64 bit Red Hat Enterprise Linux Server release 5.6) as well as the steps taken to upgrade the repository database from the default 10.1.0.4 version to 10.2.0.5.

    We will be using the silent installation method and not doing the installation using the OUI in interactive mode.

    The steps can be broadly outlined as follows:

    • Install any missing RPM’s especially the 32 bit RPM’s needed for OEM
    • Create the users and groups
    • Configure kernel parameters and hosts file
    • Edit the response files needed for the silent installation
    • Install Grid Control 10.2.0.3 (OMS and Agent) using response files
    • Upgrade Grid Control to 10.2.0.5 using response files
    • Configure database repository (10.1.0.4) and OMS using response files
    • Upgrade repository database to 10g Release 2 (10.2.0.1) using DBUA
    • Apply 10.2.0.5 patch to database software and upgrade repository database to 10.2.0.5

    Download the software

    Download the Grid Control software from the following

    Continue reading Installing Oracle 10.2.0.5 Enterprise Manager Grid Control on Linux and upgrading the repository database to 10.2.0.5

    July 29th, 2011 | Category: Administration, EM Grid Control | Leave a comment

    Changing the database characterset from US7ASCII to WE8MSWIN1252

    This note looks at the procedure for changing the characterset of a 10g database from US7ASCII to WE8MSWIN1252. Keep this in mind that in Oracle 11g, the DBCA does not show US7ASCII as one of the ‘recommended’ charactersets.

    All characters included in the US7ASCII character set are defined in WE8MSWIN1252 with the same code point, which means that WE8MSWIN1252 is a binary or “strict” superset of US7ASCII.

    Remember – we cannot go the opposite way and change the characterset from WE8MSWIN1252 to US7ASCII.

    There are a number of Metalink notes which discuss in a lot of detail what I have mentioned below, but I had quite a tough time understanding clearly what had been mentioned in those notes which are quite detailed with too many sections and sub-sections, so I thought I’d try to hopefully make things a bit more clear and concise.

    Note: 555823.1 – Changing US7ASCII or WE8ISO8859P1 to WE8MSWIN1252
    Note: 444701.1

    Continue reading Changing the database characterset from US7ASCII to WE8MSWIN1252

    July 20th, 2011 | Category: Administration | Leave a comment