• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

How to upgrade RMAN catalog SCHEMA from 11g to 12.1.0.2 without upgrading the catalog database

by admin

Question: Our rman catalog database is 11.2.0.3 right now, do I need to upgrade the database to 12.1.0.2 first, and then upgrade the catalog to 12.1.0.2?

The version of the RMAN catalog database does not need to match that of the recovery catalog. Therefore you can upgrade the RMAN catalog without upgrading the RMAN database. This is true of any version of the database, not only 12c.

If you are intending to upgrade the catalog schema to 12c then you need to run these 2 scripts:

@$ORACLE_HOME/rdbms/admin/dbmsrmansys.sql
@$ORACLE_HOME/rdbms/admin/dbmsrmanvpc.sql 

If you are only upgrading the RMAN catalog, but not the database itself you’ll need to do this:

1. set your environment to a 12.1.0.2 $ORACLE_HOME.

2. connect to the RMAN catalog via an Oracle Net alias. For example:

$ sqlplus sys@RMANDEV as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Jan 21 10:44:26 2015

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Enter password: 

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYS@RMANDEV> SELECT name from v$database;

NAME
---------
RMANDEV


SYS@RMANDEV> host echo $ORACLE_HOME
/opt/app/oracle/product/12.1.0/db_1

SYS@RMANDEV> @$ORACLE_HOME/rdbms/admin/dbmsrmansys.sql 
alter session set "_ORACLE_SCRIPT" = true
                 *
ERROR at line 1:
ORA-02248: invalid option for ALTER SESSION

PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.

alter session set "_ORACLE_SCRIPT" = false
                 *
ERROR at line 1:
ORA-02248: invalid option for ALTER SESSION

The ORA-02248 error can be ignored. This “_ORACLE_SCRIPT” is a 12c parameter and will only work in a 12c database.

Filed Under: oracle, Oracle 11g, oracle 12c, RMAN

Some more articles you might also be interested in …

  1. How To Set the Permission of the Files Created Using UTL_FILE
  2. How to Resize the Undo Tablespace in Oracle Database
  3. Oracle Interview Questions – Flash Recovery Area
  4. Managing High Availability of Services in Oracle RAC
  5. Oracle Solaris Cluster : Understanding quorum votes and quorum devices (How to avoid Failure Fencing and Amnesia)
  6. How To Setup UDEV Rules For RAC OCR And Voting Devices on Partitions
  7. How to find current SQL statement being executed by particular session in Oracle
  8. Oracle ASM 12c – New Features with examples
  9. How to reclaim entire space of an oracle database table with “Truncate Table” statement
  10. How to move ASM spfile to a shared device in RAC

You May Also Like

Primary Sidebar

Recent Posts

  • pw-cat Command Examples in Linux
  • pvs: command not found
  • pulseaudio: command not found
  • pulseaudio Command Examples in Linux

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright