SORT

Veritas™ Services and Operations Readiness Tools (SORT)

sfora-sol_sparc-5.0MP3RP4HF1
Go to Download Center to download.

 Basic information
Release type: Hot Fix
Release date: 2010-08-09
OS update support: None
Technote: None
Documentation: None
Popularity: 1297 viewed    downloaded
Download size: 30.04 MB
Checksum: 538142135

 Applies to one or more of the following products:
Storage Foundation for DB2 5.0MP3 On Solaris 10 SPARC
Storage Foundation for DB2 5.0MP3 On Solaris 8 SPARC
Storage Foundation for DB2 5.0MP3 On Solaris 9 SPARC
Storage Foundation for Oracle 5.0MP3 On Solaris 10 SPARC
Storage Foundation for Oracle 5.0MP3 On Solaris 8 SPARC
Storage Foundation for Oracle 5.0MP3 On Solaris 9 SPARC
Storage Foundation for Oracle RAC 5.0MP3 On Solaris 10 SPARC
Storage Foundation for Oracle RAC 5.0MP3 On Solaris 8 SPARC
Storage Foundation for Oracle RAC 5.0MP3 On Solaris 9 SPARC

 Obsolete patches, incompatibilities, superseded patches, or other requirements:

This patch requires: Release date
sfha-sol_sparc-5.0MP3RP4 (obsolete) 2010-06-10

 Fixes the following incidents:
2070798

 Patch ID:
144179-01, 144178-01, 145438-01

Readme file
Date:  6st August 2010

HOTFIX: DBED SUPPORT FOR ORACLE 11g R2

OS: Solaris
OS Version: 10
Etrack Incidents:2070798

Errors/Problems Fixed: Added support for Oracle 11g R2 (2070798)


OVERVIEW
----------------
This hotfix adds support for Oracle 11g R2 for Veritas Storage Foundation for Oracle 5.0MP3RP4 on Solaris.


INSTALLING THE HOTFIX
------------------------------------
1. Stop/ Kill any dbed scripts that are running/ in use.

2. Download and copy the hotfix files to a temporary location, for example /tmp.

3. Install the hotfix patch:

    patchadd /tmp/patches/144178-01 
    patchadd /tmp/patches/144179-01
    patchadd /tmp/patches/145438-01

4. Run sfua_db_config.

5. Restart vxdbd if required:
    
    /opt/VRTS/bin/vxdbdctrl start 

UNINSTALLING THE HOTFIX
-----------------------------------
1. Stop/ Kill any dbed scripts that are running/ in use.

2. Uninstall the hotfix patch:

    patchrm 144178-01 
    patchrm 144179-01
    patchrm 145438-01

3. Run sfua_db_config again.

4. Restart vxdbd if required:

    /opt/VRTS/bin/vxdbdctrl start

ADDITIONAL NOTES
----------------
No reboot is required after installation or un-installation of these patches.
Install these patches only on top of version 5.0 MP3 RP4.

KNOWN ISSUES
----------------------
Incident: 2090213
Abstract : The dbed_clonedb command for the offline checkpoint fails with message ORA-00600 with Oracle 11gR2 when ODM is enabled
Description: If ODM is enabled, the dbed_clonedb command fails when performing offline checkpoint database cloning on Oracle 11gR2.  

Sample command output:
------------------------------------
bash-3.00$ dbed_clonedb -S OFFCLN -c Checkpoint_1279170618 -m /tmp/mnt1
Primary Oracle SID is FLAS11r2
New Oracle SID is OFFCLN
Cloning an offline Storage Checkpoint Checkpoint_1279170618.
Mounting Checkpoint_1279170618 at /tmp/mnt1.
All redo-log files found.
Creating initOFFCLN.ora
        from /tmp/vxdba.rel.tmp.8389/initFLAS11r2.ora.
Altering db_name parameter in initOFFCLN.ora.
Editing remote_login_passwordfile in initOFFCLN.ora.
Altering control file locations in initOFFCLN.ora.
Copying initOFFCLN.ora
        to /oracle/11gr2/dbs/initOFFCLN.ora.
About to start up new database and begin reconfiguration.
Database OFFCLN is being reconfigured.
Did not see error regarding database name.
Shutting down clone database.
Altering clone database archive log directory.
Updating log_archive_dest in clone database init file.
Found archive log destination at /snap_arch11r2/FLAS11r2.
Mounting clone database.
Resetting logs on new database OFFCLN.
SFORA dbed_clonedb ERROR V-81-4920 Database OFFCLN is still in recovery mode.
SFORA dbed_clonedb ERROR V-81-4881 Log file is at /tmp/oralog.out.8389.

bash-3.00$ cat /tmp/oralog.out.8389
ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [ksfdgmsn4], [ODM ERROR V-41-4-2-207-
1 Not owner], [], [], [], [], [], [], [], [], [], []
ORA-00318: log 1 of thread 1, expected file size 512 doesn't match 512
ORA-00312: online log 1 thread 1: '/tmp/mnt1/snap_data11r2/FLAS11r2/redo01.log'
------------------------------------

Workaround:
Perform the offline checkpoint cloning for 11gR2 on another ORACLE_HOME where ODM is disabled.